SAP table A161 (Info Record: Variants)

SAP table A161 has 9 primary key fields being MANDT,KAPPL,KSCHL,LIFNR,EKORG,ESOKZ,MATNR,VARCOND,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
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
EKORG Purchasing organization CHAR 4 0 T024E EKORG
ESOKZ Purchasing info record category CHAR 1 0 ESOKZ
0 Standard
1 Chargeable
2 Consignment
3 Subcontracting
P Pipeline
MATNR Material Number CHAR 40 0 MARA MATNR
VARCOND Variant Condition Key CHAR 26 0 TVARC VARCOND
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

A161 foreign key relationships

Table Field Check Table Check Field
0 A161 EKORG T024E Purchasing Organizations EKORG
1 A161 KAPPL T681A Conditions: Applications KAPPL
0 A161 KSCHL T685 Conditions: Types KAPPL
0 A161 KSCHL T685 Conditions: Types KSCHL
1 A161 LIFNR LFA1 Supplier Master (General Section) MANDT
1 A161 LIFNR LFA1 Supplier Master (General Section) LIFNR
0 A161 MANDT T000 Clients MANDT
1 A161 MATNR MARA General Material Data MANDT
1 A161 MATNR MARA General Material Data MATNR
0 A161 VARCOND TVARC Variant conditions MANDT