SAP table A053 (Taxes Using Jurisdiction Code)

SAP table A053 has 7 primary key fields being MANDT,KAPPL,KSCHL,ALAND,MWSKZ,TXJCD,DATBI.

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
KAPPL Application CHAR 2 0 T681A KAPPL
KSCHL Condition Type CHAR 4 0 T685 KSCHA
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
DATBI Validity end date of the condition record DATS 8 0 KODATBI
DATAB Validity start date of the condition record DATS 8 0 KODATAB
KNUMH Number of the Condition Record CHAR 10 0 KNUMH

A053 foreign key relationships

Table Field Check Table Check Field
0 A053 ALAND T005 Countries MANDT
0 A053 ALAND T005 Countries LAND1
1 A053 KAPPL T681A Conditions: Applications KAPPL
0 A053 KSCHL T685 Conditions: Types KAPPL
0 A053 KSCHL T685 Conditions: Types KSCHL
1 A053 MANDT T000 Clients MANDT
0 A053 TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 A053 TXJCD TTXJ Check Table for Tax Jurisdiction KALSM