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 | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
SINGLE
Nota Fiscal Printed on Single Page
|
J_1BSINGLE |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
ADRNR
Address
|
ADRNR |
CHAR
|
10 | 0 | ||||||||||||||||||
|
NFDEC
Decimal Places in Price Inclusive of ICMS
|
J_1BNFDEC |
NUMC
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 |