SAP table PBUSINESSPLACE (Generated Table for View)

SAP table PBUSINESSPLACE has 3 primary key fields being MANDT,BUKRS,BRANCH.

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_
ADRNR Address CHAR 10 0 ADRNR
NAME Name CHAR 30 0 NAME1
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
VKBUR CHAR 1 0
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
KR_TAXOFF District Tax Office CHAR 3 0 TAXOFFICE TAXOFF
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
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
NFDEC Decimal Places in Price Inclusive of ICMS NUMC 1 0 J_1BNFDEC
2
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
IPICONTRIBUTOR IPI contributor CHAR 1 0 J_1BIPICONTRIBUTOR
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
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
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
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
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
BRANCH_LONG Business Place CHAR 5 0 FITH_BUPLA
GSTIN Tax Number 3 CHAR 18 0 J_1IGSTCD3
IDSIGN Signer of the Tax Invoice CHAR 30 0 IDSIGN

PBUSINESSPLACE foreign key relationships

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