SAP Table J_1BBRANCH

Business Place

J_1BBRANCH (Business Place) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J_1BBRANCH to other SAP tables.

J_1BBRANCH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BRANCH Business Place J_1BBRANC_ CHAR 4 0
NAME Name NAME1 CHAR 30 0
CGC_BRANCH CNPJ Business Place J_1BCGCBRA NUMC 4 0
STATE_INSC State Tax Number J_1BSTAINS CHAR 18 0
MUNIC_INSC Municipal Tax Number J_1BMUNINS CHAR 20 0
INDUSTRY Business Place CFOP Category J_1BINDUS2 CHAR 2 0
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 rural
SINGLE Nota Fiscal Printed on Single Page J_1BSINGLE CHAR 1 0
X Yes
NULL No
ADRNR Address ADRNR CHAR 10 0
NFDEC Decimal Places in Price Inclusive of ICMS J_1BNFDEC NUMC 1 0
2
KR_REPRES Name of Representative REPRES CHAR 10 0
KR_BUSTYPE Type of Business GESTYP BUSTYPE CHAR 30 0
KR_INDTYPE Type of Industry INDTYP INDUSTYPE CHAR 30 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
KR_TAXOFF District Tax Office TAXOFF TAXOFFICE CHAR 3 0
PAC01 Print Authorization Code J_1APAC CHAR 14 0
VDP01 Print Authorization Code: Valid-To Date J_1APACVD DATS 8 0
PAC02 Print Authorization Code J_1APAC CHAR 14 0
VDP02 Print Authorization Code: Valid-To Date J_1APACVD DATS 8 0
IPICONTRIBUTOR IPI contributor J_1BIPICONTRIBUTOR CHAR 1 0
X Yes
NULL No
IDSIGN Signer of the Tax Invoice IDSIGN CHAR 30 0
SOURE_DANGERGOOD Nota Fiscal: Source of Dangerous Goods Data J_1B_SOURCE_DANGER_GOODS_DATA CHAR 1 0
NULL Hazardous Material Data and Internal Comment (Default)
1 Hazardous Material Data Only
2 Dangerous Goods Master Data and Internal Comment
3 Dangerous Goods Master Data Only
4 Internal Comment Only
9 No Nota Fiscal Texts for Dangerous Goods Needed
SUFRAMA Suframa Code J_1BSUFRAMA CHAR 9 0
NIRE NIRE ID J_1BNIRE NUMC 11 0
NIREDT NIRE Date J_1BNIREDT DATS 8 0
SPEDACTIND SPED Activity Indicator J_1BSPEDACTIND CHAR 1 0
0 Industrial ou equiparado a industrial
1 Outros
CNAE CNAE J_1BCNAE J_1BTCNAE CHAR 7 0
LEGALNAT Legal Nature J_1BLEGALNAT J_1BTLEGALNAT NUMC 4 0
CRTN CRT Number J_1BCRTN CHAR 1 0
1 Simples Nacional
2 Simples Nacional � excesso de sublimite da receita bruta
3 Regime Normal (n�o simples)
ICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY J_1BTICMSTAXPAY CHAR 2 0
INDTYP Industry Main Type J_1BINDTYP J_1BTINDTYP CHAR 2 0
TDT Tax Declaration Type J_1BTDT J_1BTTDT CHAR 2 0
COMSIZE Company Size J_1BCOMSIZE J_1BTCOMSIZE CHAR 2 0
DECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC J_1BTDECREGPC CHAR 2 0

J_1BBRANCH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1BBRANCH BUKRS J_1BBRANCH MANDT T001 Company Codes MANDT
J_1BBRANCH BUKRS J_1BBRANCH BUKRS T001 Company Codes BUKRS
J_1BBRANCH CNAE SYST MANDT J_1BTCNAE CNAE MANDT
J_1BBRANCH CNAE J_1BBRANCH CNAE J_1BTCNAE CNAE J_1BCNAE
J_1BBRANCH COMSIZE SYST MANDT J_1BTCOMSIZE Company Size MANDT
J_1BBRANCH COMSIZE J_1BBRANCH COMSIZE J_1BTCOMSIZE Company Size J_1BCOMSIZE
J_1BBRANCH DECREGPC SYST MANDT J_1BTDECREGPC Declaration Regimen for PIS/COFINS MANDT
J_1BBRANCH DECREGPC J_1BBRANCH DECREGPC J_1BTDECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC
J_1BBRANCH ICMSTAXPAY J_1BBRANCH ICMSTAXPAY J_1BTICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY
J_1BBRANCH ICMSTAXPAY SYST MANDT J_1BTICMSTAXPAY ICMS Taxpayer MANDT
J_1BBRANCH INDTYP SYST MANDT J_1BTINDTYP Industry Main Type MANDT
J_1BBRANCH INDTYP J_1BBRANCH INDTYP J_1BTINDTYP Industry Main Type J_1BINDTYP
J_1BBRANCH KR_BUSTYPE J_1BBRANCH MANDT BUSTYPE Type of Business MANDT
J_1BBRANCH KR_BUSTYPE J_1BBRANCH KR_BUSTYPE BUSTYPE Type of Business GESTYP
J_1BBRANCH KR_INDTYPE J_1BBRANCH MANDT INDUSTYPE Type of Industry MANDT
J_1BBRANCH KR_INDTYPE J_1BBRANCH KR_INDTYPE INDUSTYPE Type of Industry INDTYPE
J_1BBRANCH KR_TAXOFF J_1BBRANCH KR_TAXOFF TAXOFFICE District Tax Offices TAXOFFICE
J_1BBRANCH KR_TAXOFF J_1BBRANCH MANDT TAXOFFICE District Tax Offices MANDT
J_1BBRANCH LEGALNAT SYST MANDT J_1BTLEGALNAT Legal Nature MANDT
J_1BBRANCH LEGALNAT J_1BBRANCH LEGALNAT J_1BTLEGALNAT Legal Nature J_1BLEGALNAT
J_1BBRANCH MANDT J_1BBRANCH MANDT T000 Clients MANDT
J_1BBRANCH TDT SYST MANDT J_1BTTDT TDT MANDT
J_1BBRANCH TDT J_1BBRANCH TDT J_1BTTDT TDT J_1BTDT