SAP Logistics Brazil Tables
Are you looking for the right table related to SAP Logistics Brazil Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Logistics Brazil (FI-LOC-LO-BR) module.
Top 10 tables in Logistics Brazil
| Table | Description |
|---|---|
| J_1BSDTL2 | Tax Law IPI |
| J_1BECD_CUST07 | Inter-Company Relationship Codes |
| J_1BCFOPVERT | CFOP Version Text Table |
| J_1BATL1 | Tax Law ICMS |
| J_1BNFDOC | Nota Fiscal Header |
| J_1BB2DYNAMIC | Nota Fiscal Print Configuration dependent on dynamic key |
| J_1BNFE_EVEGRPT | Text Table for Event Group |
| J_1BMODTEXT | Texts for Modelo 1 and 2 |
| J_1BFIFOOUT | Outgoing FIFO relevant Consignment movements (BRAZIL) |
| J_1BSERVASSIGN2 | Assign Service Type to Material Number |
List of tables in Logistics Brazil
| Table | Description |
|---|---|
| J_1BSDTL2 | Tax Law IPI |
| J_1BECD_CUST07 | Inter-Company Relationship Codes |
| J_1BCFOPVERT | CFOP Version Text Table |
| J_1BATL1 | Tax Law ICMS |
| J_1BNFDOC | Nota Fiscal Header |
| J_1BB2DYNAMIC | Nota Fiscal Print Configuration dependent on dynamic key |
| J_1BNFE_EVEGRPT | Text Table for Event Group |
| J_1BMODTEXT | Texts for Modelo 1 and 2 |
| J_1BFIFOOUT | Outgoing FIFO relevant Consignment movements (BRAZIL) |
| J_1BSERVASSIGN2 | Assign Service Type to Material Number |
| J_1BNFW_SCGITT | Description of Group for Tabs and Subscreens (Item) |
| J_1BNFE_PAR_MAP | Mapping to NF-e Partner Function |
| J_1BTAXSITPIS | Tax situation PIS |
| J_1BIMPXLSMAP | Map MS Excel Columns to Data Structure Fields |
| J_1BAP | CFOP determination for outgoing movements and their return |
| J_1BNFTXCOND | Tax Condition Interface for Notas Fiscais |
| J_1BTXSDC | SD tax codes |
| J_1BAR | Sub-object for number Nota Fiscal |
| J_1BTPARTILHA | ICMS Partilha |
| J_1BECD_CUST03 | ECD Person Responsible |
| J_1BSWITCH | Table for Brazilian switches |
| J_1BNFW_SCCITT | Description of Screen Control for Tabs and Subscreens (Item) |
| J_1BNFNAD | Nota Fiscal partners |
| J_1BNFEPARKLIN | Nota fiscal electronica: Invoice create failed |
| J_1BTSPEC_CFOP | Nota Fiscal Special Case for CFOP Determination table |
| J_1BMODFRETE_DET | Freight Mode Determination |
| J_1BATL4T | Tax Laws COFINS - Texts |
| J_1BNFE_CB_ICMST | Benefit Code for ICMS Tax Description |
| J_1BNFW_SCGT | Screen Group Description |
| J_1BTINDTYPT | Industry Main Type Description |
| J_1BAJ | Tax types |
| FIWTBRC_TDS_THR | Store daily threshold amount for Brazil withholding tax |
| J_1BNFENUMGAP | NF-e Numbering Gaps |
| J_1BINCO2 | Instruction code 2 |
| J_1BTAXSITCOFT | Tax situation COFINS - Description |
| J_1BAGNT | CFOP with Versions: Description |
| J_1BITEMTYPEST | Description of Nota Fiscal Record Types |
| J_1BNFVEHICLE | Nota Fiscal: Vehicle Details |
| J_1BB2 | Nota Fiscal print configuration |
| J_1BTCNAET | CNAE Description |
| J_1BEFD_MAT_TYPE | Equivalence of custom material types to standard types |
| J_1BNFE_INVALID | Electronic Nota Fiscal: Invalid Status Actions |
| J_1BAKIT | Assignment of Field to Field Group (Item) |
| J_1BNFSTX | Nota Fiscal tax per item |
| J_1BAMHT | Screen control groups header description |
| J_1BSERVASSIGN1 | Assignment of Official to Generic Service Types |
| J_1BSERVTYPES1T | Texts For Official Brazilian Service Types - Incoming |
| J_1BTREGXT | Tax region description |
| J_1BATL4A | Tax Laws COFINS |
| J_1BTAXSITCOF | Tax situation COFINS |
| J_1BAOX | CFOP det. for incoming mov. and their return (exceptions) |
| J_1BTXCODESEQ | Sequence for Tax Code Determination |
| J_1BSERVTYPES2T | Texts For Official Brazilian Service Types - Outgoing |
| J_1BNFREFPROC | Additional Information: Referenced Processes |
| J_1BECD_CUST09 | Accounts for Summary Postings from Subledgers |
| J_1BTREG_CITY | Tax Jurisdiction Codes by Range of Postal Codes |
| J_1BART | Sub-object for number Nota Fiscal Description |
| J_1BATL2T | Tax Law IPI - Texts |
| J_1BAON | CFOP Determination Incoming and their Returns (versioned) |
| J_1BPOSREDUCTION | POS-Database Reduction (Brazilian) |
| J_1BSTSCODET | NFe Status Code Description |
| J_1BAK | Field assignment |
| J_1BNFE_JOBLOCK | Table for locking jobs (Deprecated) |
| J_1BNFE_UOM_MAP | Units of Measurement |
| J_1BINCO2T | Instruction code 2 description |
| J_1BNFE_INTEV | Entity Table for Internal Events |
| J_1BNFE_MAP_TYPE | NF-e: Mapping of Inbound Msg Types to Internal Status Codes |
| J_1BNFE_HISTORY | Electronic Nota Fiscal - History |
| J_1BSDTL1 | Tax Law ICMS |
| J_1BTMAN_TC_RSNT | Manual Tax Code Reason table - Texts |
| J_1BAO | CFOP determination for incoming movements and their return |
| A322 | Country/Tax Jur./Key 1/Key 2/Key 3/Tax Group |
| J_1BAEIT | Field group (Item) |
| J_1BAMH_CT | Screen control groups header description |
| J_1BLPP | Average Tax Rates for Reimbursement |
| J_1BSDIC | NF relevant Item Categories |
| J_1BNFTYPEREDMM | Nota Fiscal type determination for NFe |
| J_1BTICMSTAXPAY | ICMS Taxpayer |
| J_1BNFEPAYMENT | Payment Information table |
| FIAPBRD_ISPB | Brazil: Febraban Bank Identification at SPB (ISPB code) |
| J_1BMMNFX | MM: Argument used in automatic creation of NF header texts |
| J_1BEFD_INDX | J_1BEFD_INDX - Serialization of the obj. in Ato Cotepe 82 |
| J_1BNFE_EXTEVT | Text For External Events |
| J_1BNFW_SCGIT | Group for Tabs and Subscreens (Item) |
| J_1BTREGC | Tax regions for foreign countries |
| J_1BNFE_CONTINR | NFe: Reason for Contingency |
| J_1BPIS_C_CFOP2 | Indicates if a CFOP is revenue or credit and its situation |
| J_1BLB08 | Registro de ApuraâÂșâĂșo do IPI: List control additional accts |
| A374 | Country/Sales org./Region/PlntRegion/TaxCl3Cust/TaxCl.3Mat |
| J_1BMWSKZKALSM | Assign Alternative Calculation Procedure per FI/MM Tax Code |
| J_1BTLEGALNAT | Legal Nature |
| J_1BTXIS3 | Grouped ISS |
| J_1BCUST_SCFSEL | Field Selection for Customer Master Data |
| J_1BTNBS | Nomenclature services table |
| J_1BATL5T | Tax Laws PIS - Texts |
| J_1BNFE_D_CCEFLD | CC-e Event Corr Letter Fields |
| J_1BNFFTX | Nota Fiscal header message |
| J_1BTAXSITISS | Tax situation ISS |
| J_1BAEHT | Field groups header description |
| J_1BIMPCONDAS | Assign Tax Types to Tax Groups for Import Data Upload |
| J_1BAM | Screen control groups |
| J_1BTXJUR | Tax Jurisdiction Codes For Brazilian Tax Calculation |
| J_1BTXGRUOP | Dynamic Determination of Tax-Related Master Data |
| J_1BIV05 | BUZID with special handling for NF |
| J_1BAPN | CFOP Determination Outgoing and their Returns (versioned) |
| J_1BNFE_EVEGROUP | Grouping Table for allowed internal Events |
| J_1BVIEWMAP | Map Tax Rate Tables to Condition Tables |
| J_1BAET | Field groups description |
| J_1BTXIC1 | Tax calc.: ICMS general rules |
| J_1BTAXSITPIST | Tax situation PIS - Description |
| J_1BAIT | NCM Code Description |
| J_1BKON1 | Brazilian Tax Groups Included in Price Conditions |
| J_1BSERVTYPES1 | Official Brazilian Service Types - Incoming |
| J_1BTDECREGPCT | Declaration Regimen for PIS/COFINS Description |
| J_1BTXCOND | Map Internal Codes for Tax Conditions to Condition Types |
| J_1BTCEST | ICMS ST Legal Classification Code |
| J_1BNFPHARMACEUT | [OBSOLETE] Medicines and Pharmaceutical Raw Material |
| J_1BNFE_CANCELR | NF-e: Reason for Cancel / Skip |
| J_1BIMPLAYOUTT | Text Table for Layout Descriptions |
| J_1BTAXGRPCD | Assign Tax Group to SD Internal Codes |
| LOGBR_FT_BPTINID | Assign TIN Tax Number Categories to Country Codes |
| J_1BTICMSTAXPAYT | ICMS Taxpayer Description |
| J_1BNFE_CONTIN | NF-e: Contingency Control |
| J_1BATL3 | Tax Laws ISS |
| J_1BNFIMPORT_DI | Nota Fiscal Data for Import Documents |
| J_1BNFERFCBATCH | NF-e documents to be send via Report J_1BRFCBATCH |
| J_1BAGN | CFOP with Version Number |
| J_1BCONDTAXACT | Activate Condition-Based Tax Calculation |
| J_1BSDNFA | Relatn. symb. arg. - arg.field (creation of NF header texts) |
| LOGBR_ACC_PROCD | Define Procedure for Account Determination in Billing |
| J_1BAQT | Form description |
| J_1BATL3T | Tax Laws ISS - Texts |
| LOGBR_WHT_CUST | Define Withholding Tax Accumulation for Customers (SD) |
| J_1B_CBT_CHECKS | Condition-Based Tax Calculation Brazil: Checks |
| J_1BTXISS | Tax Calculation: ISS |
| J_1BNFW_SCCIT | Screen Control for Tabs and Subscreens (Item) |
| J_1BNFFUEL | Nota Fiscal: Fuel Details |
| J_1BTMAN_TC_RSN | Manual Tax Code Reason table |
| LOGBR_OTC_SCC | Screen Control for OTC fields |
| J_1BTLEGALNATT | Legal Nature Description |
| J_1BNFLIN | Nota Fiscal line items |
| J_1BAST | Tax situation IPI - Description |
| J_1BTCNAE | CNAE |
| J_1BTINDTYP | Industry Main Type |
| J_1BECD_CUST05 | ECD Register Category |
| J_1BNFEPARKDOC | Nota fiscal electronica: Invoice create failed |
| LOGBR_ISSTAXSIT | CST for ISS defined by Municipality |
| LOGBR_ABRASF_DET | LC 116 Service Type Determination |
| J_1BMMNFXT | MM:Text used in automatic creation of NF header texts? |
| J_1BTCOMSIZE | Company Size |
| LOGBR_CNAE_MATL | (Deprecated) Define Plant's Material CNAE (Sales) |
| J_1BAMT | Screen control groups description |
| J_1BECD_CUST07T | Texts for Inter-Company Relationship Codes |
| J_1BAPX | CFOP det. for outgoing mov. and their return (exceptions) |
| IDSDTXNUMVIS | SD Document Screen Control for CPD Partner Tax Numbers |
| J_1BLFA1_REC55 | Information for generating record type 55 referred to GNRE |
| J_1BNFREF | Nota Fiscal reference to header message |
| J_1BAMH | Screen Control for Fields (Header) |
| J_1BCTE_PAR_MAP | CT-e: Mapping to NF-e Partner Function |
| J_1BTXJURT | Text Table For Brazilian Tax Jurisdiction Codes |
| J_1BSTAST | Reg. Tax code for Sub.Trib. |
| J_1B_NFTYPEREG | Nota Fiscal Type Redetermination per Region for SD |
| J_1BNFADD_INFO | Free Usage Fields for Additional Information |
| J_1BMMNFTT | MM: Allowed automatic texts |
| LOGBR_NF_DUE | Export Declaration Data |
| J_1BTXST3 | Dynamic Calculation of SubstituiâÂșâĂșo TributâĂria |
| J_1BSDTXC | SD Tax code determination |
| J_1BAMIT_C | Screen Control for Fields (Item) |
| J_1BMMNFTU | MM: Allowed automatic text key description |
| J_1BTXCOF | Tax Calculation: COFINS |
| J_1BECD_CUST01 | ECD: Government Entity Codes |
| J_1BMMNFA | Relatn. symb. arg. - arg.field (creation of NF header texts) |
| J_1BAMIT | Screen Control for Fields (Item) |
| J_1BT007 | Tax Codes (Brazil) |
| J_1BTXCI1 | Tax calc.: Complement of ICMS rules |
| J_1B_NFTYPEBRCH | Nota Fiscal Type Redetermination per Branch for SD |
| J_1BSDNFX | Argument used in automatic creation of NF header texts |
| J_1BNFE_CONTINRT | NFe: Reason for Contingency # Description |
| J_1BTXDEF | Tax calc.: Default rates |
| J_1BIMPLAYOUT | Record MS Excel Layouts for Import Data |
| J_1BNFLWCOND | Tax Law Conditions Interface for Notas Fiscais |
| J_1BTTAXDET | Tax Determination - Validity |
| J_1BCFOPVER | CFOP Version Numbers |
| LOGBR_ABRASF | LC 116 Service Types |
| J_1BAAT | Nota Fiscal type text |
| J_1BTXIC3 | Grouped ICMS |
| J_1BSERVTYPES2 | Official Brazilian Service Types - Outgoing |
| J1B_ERROR_DDA | Master Table for DDA_Brazil (Segment G) |
| J_1BTFISC_ID_SD | Tax Incentive ID (Incentive ID) for SD table |
| J_1BMMNFAT | Symbolic arg. texts (creation of NF header texts) |
| J_1BTTDT | TDT |
| J_1BTXIP3 | Grouped IPI |
| J_1BTXLAWSEQ | Sequence for Tax Law Determination |
| J_1BECD_CUST06 | ECD Intercompany Data |
| J_1BTXST2 | Tax calc.: Sub.Trib. rules (general) |
| J_1BNFE_C_CCECFG | CC-e Event Correction Letter Fields Configuration |
| J_1BAS | Tax situation IPI |
| J_1BNFSUGARSUPPL | Daily Supply of Sugarcane |
| J_1BNFE_EVENT | NF-e Events Table |
| J_1BINCOT | Instruction code description |
| J_1BAD | Partner function ID |
| J_1BNFNVE | NVE table |
| J_1BTXIC2 | Tax calc.: ICMS rules |
| LOGBR_WHT_PLNT | Define Cumulative Withholding Tax for Plants (MM) |
| J_1BAGT | CFOP description |
| J_1BNFE_CB_ICMS | Benefit Code for ICMS Tax |
| J_1BECD_CUST08 | Subledgers |
| J_1BNFW_SCCIT_CT | Description of Screen Control for Tabs and Subscreens (Item) |
| J_1BAKH | Assignment of Field to Field Group (Header) |
| J_1BVEND_SCFSEL | Field Selection for Vendor Master Data |
| J_1BSTSCODE | NFe Status code |
| J_1BAJT | Tax types - Description |
| J_1BNFE_ACTIVE | Electronic Nota Fiscal: Actual Status |
| J_1BNFE_MATORG | Mapping of material origin out/in |
| J_1BPIS_C_CFOP | Indicate if a CFOP is revenue or credit and its situation |
| J_1BFIFOIN | Incoming FIFO relevant Consignment movements (BRAZIL) |
| J_1BNFW_SCCIT_C | Screen Control for Tabs and Subscreens (Item) |
| J_1BTFISC_INCT | Tax Incentive Type table |
| J_1BNFEPARKTAX | Nota fiscal electronica: Invoice create failed |
| J_1BATL1T | Tax Law ICMS - Texts |
| J_1BIV04 | Goods Receipts Passed to Notas Fiscais via Inv. Verification |
| J_1BEFD_COUNTRY | BCB Country Code for Brazil |
| J_1BCTE_CFOP_DET | CT-e CFOP Determination Law |
| J_1BAE | Field groups |
| J_1BPRODCOD | Product Code |
| J_1BTREGX | Tax region |
| J_1BTXWITH | Withholding Tax Calculation: Rates and Collection Codes |
| J_1BNFE_EXTEV | Entity Table for External Events |
| J_1BNFE_CANCELRT | NF-e: Reason for Cancel / Skip - Description |
| J_1BATL5 | PIS Tax Law |
| J_1BSDKON0 | SD: Value transfer from pricing to Nota Fiscal |
| J_1BTCOMSIZET | Company Size Description |
| J_1BFORMULA_MAP | Brazil: Formula Determination |
| J_1BEFD_LOG | Electronic fiscal file log |
| J_1BNFW_SCCT | Screen Control Description |
| J_1BADT | Partner function description |
| J_1BTCESTT | ICMS ST Legal Classification Code Description |
| J_1BPOSCOUPONS | POS-Database Coupons (Brazilian) |
| J_1BTFISC_ID | Tax Incentive ID (Incentive ID) table |
| J_1BNFCPD | Nota Fiscal one-time accounts |
| J_1BNFTRANSVOL | Transported Volumes |
| J_1BNF_PLANTS | Plants of same Bus. Place for which Nota Fiscal is created |
| J_1BAMITT | Screen control groups item description |
| J_1BAMDATASEL | Field Selection at Master Data |
| J_1BNFW_SCGA | Assignment of Tabs/Subscreens to Group (Header) |
| J_1BAB | Reference type |
| J_1BTXST1 | Tax calc.: Sub.Trib. rules |
| J_1BNFIMPORT_ADI | Nota Fiscal Data for Additions to Import Documents |
| J_1BECD_CUST08T | Texts for Purpose of Subledger |
| J_1BAC | Partner type |
| J_1BNFETRACE | Product Traceability |
| J_1BNFW_SCG | Group for Tabs and Subscreens (Header) |
| J_1BTANPT | ANP Description |
| J_1BPISCOF_BASE | Definition of a configurable base for PIS / COFINS |
| J_1BECD_HISTORY | Electronic-Accounting-File History |
| J_1BITEMTYPES | Nota Fiscal Record Types |
| J_1BNFE_EXPORT | Exportation Control |
| J_1BSDNFAT | Symbolic arg. texts (creation of NF header texts) |
| J_1BAEH | Field group (Header) |
| J_1BTCESTDET | ICMS ST Legal Classification Code Determination |
| J_1B_PO_TAX_MAP | Mapping from pricing condition to tax condition |
| J_1BPRODCODT | Product Code Text |
| J_1BECD_CUST02 | ECD: Qualification Codes of Person Responsible |
| J_1BTXIP2 | Tax calc.: IPI rules (material dependent) |
| J_1BTXSTG | Tax calc.: Sub.Trib. customer group |
| J_1BNFE_TEC_RESP | Technical Responsible Data |
| J_1BNFDANG_GOODS | Control derivation of automatic NF texts for dangerous goods |
| J_1BTXSTGT | Tax calc.: Sub.Trib. customer group - Description |
| J_1BNFENUMCHECK | NF-e Number Range - Last checked Number |
| LOGBR_REINF | EFD-REINF Service Types |
| J_1BATL2 | Tax Law IPI |
| J_1BSDICA | Sales Document Item Category table |
| LOGBR_SIT_ACCDET | Stock in transit account determination |
| J_1BNFE_CCE | NF-e CCe Table |
| J_1BINCO | Instruction codes |
| J_1BNFE_C_CCECFT | Descriptions CC-e Event Correc. Letter Fields Configuration |
| LOGBR_CPOM_VNDR | Define CPOM for Service Provider (MM) |
| J_1BAL | Screen control group assignment |
| J_1BNFE_EVEGRP | Entity Table for Event Group |
| LOGBR_CPOM_PLNT | Define CPOM for Plants (SD) |
| J_1BTXIP1 | Tax calc.: IPI rules |
| J_1BLFA1_MATNR | Mapping table for material numbers (for brasil. Sintegra) |
| J_1BNFTRADENOTES | Trade Notes |
| LOGBR_REINFT | EFD-REINF Service Types Descriptions |
| J_1BNFE_EVEMAP | Link Table for Internal & external Events |
| J_1BTCENQT | CENQ Description |
| J_1BSDNFXT | Text used in automatic creation of NF header texts |
| J_1BLB09 | Registro de ApuraâÂșâĂșo do ICMS: List control additional acct |
| J_1BNFE_PROC | Settings for NF-e Business Processes |
| J_1BTANP | ANP Code |
| J_1BSERVASSIGN3 | Assignment of Official Service Types to Service Numbers |
| J_1BNFITMRULE | Rules for Nota Fiscal Item Type |
| J_1BAQ | Form |
| J_1BABT | Reference type text |
| LOGBR_ISSTAXSITT | CST for ISS defined by Municipality - Text |
| J_1BAMIT_CT | Screen control groups item description |
| LOGBR_TAX_CLFN | Material/Service Fiscal Tax Classification |
| J_1BAN | Status control |
| J_1BTXIS1 | Tax calc.: ISS rules for sales |
| LOGBR_CNAE_SRVC | (Deprecated) Define Plant's Service CNAE (Sales) |
| J_1BTXSDCT | SD tax codes - description |
| J_1BTDECREGPC | Declaration Regimen for PIS/COFINS |
| J_1BNFEPHARMA | Medicines and Pharmaceutical Raw Material |
| J_1BIMFI | Movement Types for Vendor Invoices (Brazil) |
| J_1BNFW_SCGAIT | Assignment of Tabs/Subscreens to Group (Item) |
| J_1BCONDMAP | Internal Codes for Tax Conditions |
| J_1BCFOP_XREGN | Regions with differing CFOP version and extension |
| J_1BNFTYPEREDLF | Nota Fiscal type determination for NFe by Vendor |
| J_1BTCENQ | IPI Legal Classification Code |
| J_1BTAXSITISST | Tax situation ISS - Description |
| J_1BNFTRAILER | Trailer Information |
| J_1BNFE_PROC_CT | Process Attributes Display Control |
| J_1BCBTAXPROC | Calculation Procedures for Condition Based Tax Calculation |
| J_1BEFD_BADI | BAdIs available for Ato Cotepe 82 |
| J_1BMMKON0 | MM: Value transfer from pricing to Nota Fiscal |
| J_1BIM01 | MM-IM: Tax posting strings for inventory management |
| J_1BNFW_SCC_C | Screen Control for Tabs and Subscreens (Header) |
| J_1BCTE_D_RES | Information about resource |
| J_1BCFOP_XREG | Regions with CFOP extension |
| J_1BCTE_D_DOCREF | Reference to the NF-e being transported |
| J_1BNFW_SCC_CT | Screen Control Description |
| J_1BCONDMAPT | Description of Internal Codes for Tax Conditions |
| J_1BAI | NCM Codes |
| J_1BTXPIS | Tax Calculation: PIS |
| J_1BDF_STAT_TAX | Set Tax Type as Statistical for Specific Scenarios |
| J_1BAEITT | Field groups item description |
| J_1BNFSUGARDEDUC | Taxes and Contributions on Sugarcane |
| J_1BDOCTYPES | Nota Fiscal Document Types |
| J_1BAG | CFOP |
| LOGBR_ABRASFT | LC 116 Service Types Descriptions |
| J_1BDOCTYPEST | Description of Nota Fiscal Document Types |
| J_1BAA | Nota Fiscal type |
| LOGBR_REINF_DET | EFD-REINF Service Type Determination |
| J_1BAMH_C | Screen Control for Fields (Header) |
| J_1BECD_CUST02T | Texts for Qualification Codes of Person Responsible |
| J_1BTSPEC_CFOPT | Nota Fiscal Special Case for CFOP Determination Texts Table |
| J_1BTTDTT | TDT Description |
| J_1BNFW_SCC | Screen Control for Tabs and Subscreens (Header) |