SAP Table
J_1BTXSDC SD tax codes
SAP table J_1BTXSDC has 2 primary key fields being MANDT,TAXCODE.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
J_1BTXSDC columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||
| KeyTAXCODE | SD tax code | CHAR | 2 | 0 | J_1BTXSDC_ | ||||||
| CUSTUSAGE | SD tax code: Usage | CHAR | 1 | 0 | J_1BTXSDU | ||||||
|
|||||||||||
| 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 | ||||||
/ Relationships
J_1BTXSDC foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| J_1BTXSDC | MANDT | T000 | Clients | MANDT |