SAP table A144 (Sales Deal Basic Data)

SAP table A144 has 11 primary key fields being MANDT,KAPPL,KSCHL,KNUMA_AG,VKORG,KONDM,PRODH1,PRODH2,PRODH3,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
KNUMA_AG Sales Deal CHAR 10 0 KONA KNUMA_AG
VKORG Sales Organization CHAR 4 0 TVKO VKORG
KONDM Material Price Group CHAR 2 0 T178 KONDM_V
PRODH1 Standard data element PRODH1 CHAR 5 0 PRODH1
PRODH2 Standard data element PRODH2 CHAR 5 0 PRODH2
PRODH3 Standard data element PRODH3 CHAR 8 0 PRODH3
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
KDATU Condition Pricing Date DATS 8 0 KDATU
PLTYP Price List Type CHAR 2 0 T189 PLTYP
KSTAF Condition Scale Base Value NUMC 7 0 KSTAF
KNUMH Number of the Condition Record CHAR 10 0 KNUMH

A144 foreign key relationships

Table Field Check Table Check Field
0 A144 KAPPL T681A Conditions: Applications KAPPL
1 A144 KNUMA_AG KONA Agreements MANDT
1 A144 KNUMA_AG KONA Agreements KNUMA
0 A144 KONDM T178 Conditions: Groups for Materials MANDT
0 A144 KONDM T178 Conditions: Groups for Materials KONDM
1 A144 KSCHL T685 Conditions: Types KAPPL
1 A144 KSCHL T685 Conditions: Types KSCHL
0 A144 MANDT T000 Clients MANDT
1 A144 MATNR MARA General Material Data MANDT
1 A144 MATNR MARA General Material Data MATNR
0 A144 PLTYP T189 Conditions: Price List Types MANDT
0 A144 PLTYP T189 Conditions: Price List Types PLTYP
1 A144 VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 A144 VKORG TVKO Organizational Unit: Sales Organizations VKORG