SAP table J_1BATL1 (Tax Law ICMS)

SAP table J_1BATL1 has 2 primary key fields being MANDT,TAXLAW.

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
TAXLAW Tax law: ICMS CHAR 3 0 J_1BTAXLW1
TAXSIT Tax situation ICMS CHAR 1 0 J_1BTAXSIT
0 Liable to ICMS
1 Liable to ICMS + substituição tributária
2 Liable to ICMS (reduced tax base)
3 Exempt or nontaxable + substituição tributária
4 Exempt
5 Suspended
6 ICMS already levied by substituição tributária
7 Liable to ICMS (reduced tax base) + substituição tributária
9 Other
A Nontaxable
B Deferred
CBENEF State Fiscal Benefit Code CHAR 10 0 J_1BNFE_CB_ICMS J_1BNFE_CBENEF

J_1BATL1 foreign key relationships

Table Field Check Table Check Field
0 J_1BATL1 CBENEF J_1BNFE_CB_ICMS Benefit Code for ICMS Tax REGIO
1 J_1BATL1 MANDT T000 Clients MANDT