SAP table J_1BBRANCH (Business Place)

SAP table J_1BBRANCH has 4 primary key fields being MANDT,BUKRS,BRANCH,BUPLA_TYPE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
BRANCH Business Place CHAR 4 0 J_1BBRANC_
BUPLA_TYPE Globalization Service: Code of Business Place Type CHAR 2 0 GLO_BUPLA_TYPE_CODE
NAME Name CHAR 30 0 NAME1
CGC_BRANCH CNPJ Business Place NUMC 4 0 J_1BCGCBRA
STATE_INSC State Tax Number CHAR 18 0 J_1BSTAINS
MUNIC_INSC Municipal Tax Number CHAR 20 0 J_1BMUNINS
INDUSTRY Business Place CFOP Category CHAR 2 0 J_1BINDUS2
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 CHAR 1 0 J_1BSINGLE
ADRNR Address CHAR 10 0 ADRNR
NFDEC Decimal Places in Price Inclusive of ICMS NUMC 1 0 J_1BNFDEC
2
KR_REPRES Name of Representative CHAR 10 0 REPRES
KR_BUSTYPE Type of Business CHAR 30 0 BUSTYPE GESTYP
KR_INDTYPE Type of Industry CHAR 30 0 INDUSTYPE INDTYP
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
KR_TAXOFF District Tax Office CHAR 3 0 TAXOFFICE TAXOFF
PAC01 Print Authorization Code CHAR 14 0 J_1APAC
VDP01 Print Authorization Code: Valid-To Date DATS 8 0 J_1APACVD
PAC02 Print Authorization Code CHAR 14 0 J_1APAC
VDP02 Print Authorization Code: Valid-To Date DATS 8 0 J_1APACVD
IPICONTRIBUTOR IPI contributor CHAR 1 0 J_1BIPICONTRIBUTOR
IDSIGN Signer of the Tax Invoice CHAR 30 0 IDSIGN
SOURE_DANGERGOOD Nota Fiscal: Source of Dangerous Goods Data CHAR 1 0 J_1B_SOURCE_DANGER_GOODS_DATA
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 CHAR 9 0 * J_1BSUFRAMA
NIRE NIRE ID NUMC 11 0 J_1BNIRE
NIREDT NIRE Date DATS 8 0 J_1BNIREDT
SPEDACTIND SPED Activity Indicator CHAR 1 0 J_1BSPEDACTIND
0 Industrial ou equiparado a industrial
1 Outros
CNAE CNAE CHAR 7 0 J_1BTCNAE J_1BCNAE
LEGALNAT Legal Nature NUMC 4 0 J_1BTLEGALNAT J_1BLEGALNAT
CRTN CRT Number CHAR 1 0 J_1BCRTN
1 Simples Nacional
2 Simples Nacional # excesso de sublimite da receita bruta
3 Regime Normal (não simples)
4 Simples Nacional - Microempreendedor Individual - MEI
ICMSTAXPAY ICMS Taxpayer CHAR 2 0 J_1BTICMSTAXPAY J_1BICMSTAXPAY
INDTYP Industry Main Type CHAR 2 0 J_1BTINDTYP J_1BINDTYP
TDT Tax Declaration Type CHAR 2 0 J_1BTTDT J_1BTDT
COMSIZE Company Size CHAR 2 0 J_1BTCOMSIZE J_1BCOMSIZE
DECREGPC Declaration Regimen for PIS/COFINS CHAR 2 0 J_1BTDECREGPC J_1BDECREGPC
AUT_ADD_DATA_IMP Automatic BAdI call determination in J1B1N CHAR 1 0 J_1BNFE_AUT_ADD_DATA_IMP
False
X True
PISCONTRIBUTOR PIS Contributor CHAR 1 0 J_1BPISCONTRIBUTOR
COFINSCONTRIBUTOR COFINS Contributor CHAR 1 0 J_1BCOFINSCONTRIBUTOR
ICMSCONTRIBUTOR ICMS Contributor CHAR 1 0 J_1BICMSCONTRIBUTOR
ICMSSTCONTRIBUTOR ICMS ST Contributor CHAR 1 0 J_1BICMSSTCONTRIBUTOR
ISSCONTRIBUTOR ISS Contributor CHAR 1 0 J_1BISSCONTRIBUTOR
PREFIX Prefix for Fiscal Branch CHAR 1 0 J_1AFSCBRCH
BRANCH_LONG Business Place CHAR 5 0 FITH_BUPLA
GSTIN Tax Number 3 CHAR 18 0 J_1IGSTCD3
GSTTDSN GST TDS Registration CHAR 18 0 J_1IGSTTDS
GSTSEZ SEZ Indicator CHAR 1 0 J_1IGSTSEZ
BUPLA_CLASS Business Place Classification CHAR 3 0 J_1IBUPLACLASS
SZD SEZ Developer
SZU SEZ Unit
DEPARTMENT_NAME Responsible Department Name for Electronic Tax Invoice CHAR 100 0 RDEPNAME
PERSON_NAME Responsible Person Name for Electronic Tax Invoice CHAR 100 0 RPERNAME
PERSON_EMAIL1 Responsible Person’s E-mail Address CHAR 100 0 RPERMAIL1
REPRESN Name of Representative CHAR 100 0 REPRESN
INDTYPN Type of Industry CHAR 100 0 * INDTYPN
GESTYP Type of Business CHAR 100 0 * GESTYPN
NTSNUMBER National Tax Service Registration Number NUMC 8 0 NTSNUMBER
VALID_FROM China Business Place Valid From DATS 8 0 FICNTAX_ENTY_VALID_FROM
VALID_TO China Business Place Valid To DATS 8 0 FICNTAX_ENTY_VALID_TO
DECLN_PERD_VAR China Tax Invoice Declaration Timeline Variant CHAR 4 0 TXI_DECLN_OPPV FICNTAXDECLN_OP_PERD_VAR
CNBP_ENABLED China Business Place Enabled CHAR 1 0 FICNTAX_ENTITY_ENABLED
TAX_REG_NMBR China Tax Unified Social Credit Code CHAR 20 0 FICNTAX_REG_NMBR
BUPLA_H_DUMMY_PS Single-Character Flag CHAR 1 0 CHAR1

J_1BBRANCH foreign key relationships

Table Field Check Table Check Field
0 J_1BBRANCH BUKRS T001 Company Codes BUKRS
1 J_1BBRANCH COMSIZE J_1BTCOMSIZE Company Size J_1BCOMSIZE
0 J_1BBRANCH DECLN_PERD_VAR TXI_DECLN_OPPV China Tax Invoice Confirmation Period Variant MANDT
0 J_1BBRANCH DECLN_PERD_VAR TXI_DECLN_OPPV China Tax Invoice Confirmation Period Variant OP_PERD_VAR
1 J_1BBRANCH DECREGPC J_1BTDECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC
0 J_1BBRANCH ICMSTAXPAY J_1BTICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY
1 J_1BBRANCH INDTYP J_1BTINDTYP Industry Main Type J_1BINDTYP
0 J_1BBRANCH KR_BUSTYPE BUSTYPE Type of Business GESTYP
1 J_1BBRANCH KR_INDTYPE INDUSTYPE Type of Industry MANDT
1 J_1BBRANCH KR_INDTYPE INDUSTYPE Type of Industry INDTYPE
0 J_1BBRANCH KR_TAXOFF TAXOFFICE District Tax Offices MANDT
1 J_1BBRANCH MANDT T000 Clients MANDT
0 J_1BBRANCH TDT J_1BTTDT TDT J_1BTDT