SAP table J_1BTXSDC (SD tax codes)

SAP table J_1BTXSDC has 2 primary key fields being MANDT,TAXCODE.

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
TAXCODE SD tax code CHAR 2 0 J_1BTXSDC_
CUSTUSAGE SD tax code: Usage CHAR 1 0 J_1BTXSDU
1 Production/sales
2 Consumption
ICMS SD tax code: Calculate ICMS CHAR 1 0 J_1BTXSDIC
IPI SD tax code: Calculate IPI CHAR 1 0 J_1BTXSDIP
SUBTRIB SD tax code: Calculate Sub.Trib. CHAR 1 0 J_1BTXSDST
ISS SD tax code: Calculate ISS CHAR 1 0 J_1BTXSDIS
ICMS_EX ICMS Stored as "Exempt" Instead of "Other Basis" CHAR 1 0 J_1BTXICEX
IPI_EX IPI Stored as "Exempt" Instead of "Other Basis" CHAR 1 0 J_1BTXIPEX
ICMS_FR SD tax code: Calculate ICMS on freight CHAR 1 0 J_1BTXSDFR
ICMS_FS SD tax code: Calculate ICMS Sub.Trib. on freight CHAR 1 0 J_1BTXSDFS
PIS SD tax code: Calculate PIS CHAR 1 0 J_1BTXSDPIS
COFINS SD tax code: Calculate PIS CHAR 1 0 J_1BTXSDCOFINS
WHT SD tax code: Calculate PIS CHAR 1 0 J_1BTXSDWHT

J_1BTXSDC foreign key relationships

Table Field Check Table Check Field
0 J_1BTXSDC MANDT T000 Clients MANDT