SAP Table A130 (Service agent/tariff zone dep./tariff zone targ/shipping mat)

SAP table A130 has 8 primary key fields being MANDT,KAPPL,KSCHL,TDLNR,TRFZNA,TRFZNZ,VHILM,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
TDLNR Number of forwarding agent in the shipment stage CHAR 10 0 LFA1 TDLNRS
TRFZNA Tariff zone of point of departure CHAR 10 0 TVFTZ TRFZNA
TRFZNZ Tariff zone of point of destination CHAR 10 0 TVFTZ TRFZNZ
VHILM Packaging Materials CHAR 40 0 MARA VHILM
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

A130 foreign key relationships

Table Field Check Table Check Field
0 A130 KAPPL T681A Conditions: Applications KAPPL
1 A130 KSCHL T685 Conditions: Types KAPPL
1 A130 KSCHL T685 Conditions: Types KSCHL
0 A130 MANDT T000 Clients MANDT
1 A130 TDLNR LFA1 Supplier Master (General Section) MANDT
1 A130 TDLNR LFA1 Supplier Master (General Section) LIFNR
0 A130 TRFZNA TVFTZ Tariff Zones for Shipment Costs MANDT
0 A130 TRFZNA TVFTZ Tariff Zones for Shipment Costs TRFZN
1 A130 TRFZNZ TVFTZ Tariff Zones for Shipment Costs MANDT
1 A130 TRFZNZ TVFTZ Tariff Zones for Shipment Costs TRFZN
0 A130 VHILM MARA General Material Data MANDT
0 A130 VHILM MARA General Material Data MATNR