SAP table TMKL (Scope of List for Conditions in Purchasing)

SAP table TMKL has 2 primary key fields being MANDT,KOLIU.

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
KOLIU Scope of List for Conditions in Purchasing CHAR 4 0 KOLIU
KOPSA Display condition items CHAR 1 0 KPOSA
KOPSL Display inactive items CHAR 1 0 KALLE
KOFUL Only condition records with filled key CHAR 1 0 KTABF
KOAUF Derive other fields from input CHAR 1 0 AUFKO
WALLE List all plant conditions CHAR 1 0 WALLE
KOSOR Sort type for conditions CHAR 1 0 KOSOR
A Condition type/condition table
B Condition table/condition type
KOREI Sequence rule type CHAR 2 0 KOREI
KOALL Display all possible conditions CHAR 1 0 KONUV

TMKL foreign key relationships

Table Field Check Table Check Field
0 TMKL MANDT T000 Clients MANDT