SAP table A006 (Price List Type/Currency/Material)

SAP table A006 has 9 primary key fields being MANDT,KAPPL,KSCHL,VKORG,VTWEG,PLTYP,WAERK,MATNR,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
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
PLTYP Price List Type CHAR 2 0 T189 PLTYP
WAERK SD Document Currency CUKY 5 0 TCURC WAERK
MATNR Material Number CHAR 40 0 MARA MATNR
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

A006 foreign key relationships

Table Field Check Table Check Field
0 A006 KAPPL T681A Conditions: Applications KAPPL
1 A006 KSCHL T685 Conditions: Types KAPPL
1 A006 KSCHL T685 Conditions: Types KSCHL
0 A006 MANDT T000 Clients MANDT
1 A006 MATNR MARA General Material Data MATNR
0 A006 PLTYP T189 Conditions: Price List Types MANDT
0 A006 PLTYP T189 Conditions: Price List Types PLTYP
1 A006 VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 A006 VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 A006 VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 A006 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 A006 WAERK TCURC Currency Codes MANDT
1 A006 WAERK TCURC Currency Codes WAERS