SAP Table J_1BTXSDC
SD tax codes
J_1BTXSDC (SD tax codes) 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_1BTXSDC to other SAP tables.
J_1BTXSDC table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
TAXCODE
SD tax code
|
J_1BTXSDC_ |
CHAR
|
2 | 0 | ||||||||
|
CUSTUSAGE
SD tax code: Usage
|
J_1BTXSDU |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ICMS
SD tax code: Calculate ICMS
|
J_1BTXSDIC |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
IPI
SD tax code: Calculate IPI
|
J_1BTXSDIP |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SUBTRIB
SD tax code: Calculate Sub.Trib.
|
J_1BTXSDST |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ISS
SD tax code: Calculate ISS
|
J_1BTXSDIS |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ICMS_EX
ICMS Stored as "Exempt" Instead of "Other Basis"
|
J_1BTXICEX |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
IPI_EX
IPI Stored as "Exempt" Instead of "Other Basis"
|
J_1BTXIPEX |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ICMS_FR
SD tax code: Calculate ICMS on freight
|
J_1BTXSDFR |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ICMS_FS
SD tax code: Calculate ICMS Sub.Trib. on freight
|
J_1BTXSDFS |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
PIS
SD tax code: Calculate PIS
|
J_1BTXSDPIS |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
COFINS
SD tax code: Calculate PIS
|
J_1BTXSDCOFINS |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
WHT
SD tax code: Calculate PIS
|
J_1BTXSDWHT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
J_1BTXSDC foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| J_1BTXSDC | MANDT | J_1BTXSDC | MANDT |
T000
Clients
|
MANDT |