SAP table TWLFE (Sales price calculation: schema/list field)

SAP table TWLFE has 3 primary key fields being MANDT,VKALS,LIFEL.

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
VKALS Sales Pricing: Sales Price Calculation Schema CHAR 6 0 T683 VKALS
LIFEL Sales Pricing: List Field for Determining Sales Price CHAR 5 0 TWLF LIFELD
KOFEL Subtotal in sales price calculation schema CHAR 5 0 KOFEL
KZWI1 Condition subtotal 1
KZWI2 Condition subtotal 2
KZWI3 Condition subtotal 3
KZWI4 Condition subtotal 4
KZWI5 Condition subtotal 5
KZWI6 Condition subtotal 6
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KAPPL Application CHAR 2 0 T681A KAPPL
KSCHL Condition Type CHAR 4 0 T685 KSCHL
AKSCH Promotion condition type CHAR 4 0 T685 AKSCH
KKSCH Condition type in the sales price calculation schema CHAR 4 0 T685 KKSCH
WRSKZ Sales Price Calculation: Default currency for conditions CHAR 1 0 WRSKZ
Local currency
A Supplier currency
B Pricing currency
C Alternative Sales Currency
D Sales currency
KOAER Pricing: Type of condition type determination CHAR 1 0 KOAER
Specify condition types explicitly in control data
A Determine condition types from calculation schema at runtime
KOSER Pricing: Condition record determination type CHAR 1 0 KOSER
Determine condition record using pricing table
A Determine condition record using price determination
UEBNA Pricing: method of adoption from calc. schema --> list field CHAR 1 0 UEBNA
Adopt directly using condition type or subtotal
A Adopt indirectly using pr. strategy from competitor prices

TWLFE foreign key relationships

Table Field Check Table Check Field
0 TWLFE AKSCH T685 Conditions: Types KAPPL
0 TWLFE AKSCH T685 Conditions: Types KSCHL
1 TWLFE KAPPL T681A Conditions: Applications KAPPL
0 TWLFE KKSCH T685 Conditions: Types KAPPL
0 TWLFE KKSCH T685 Conditions: Types KSCHL
1 TWLFE KSCHL T685 Conditions: Types KAPPL
1 TWLFE KSCHL T685 Conditions: Types KSCHL
0 TWLFE KVEWE T681V Conditions: Usages KVEWE
1 TWLFE LIFEL TWLF Sales Price Calculation: List Fields MANDT
0 TWLFE VKALS T683 Pricing procedures KAPPL
0 TWLFE VKALS T683 Pricing procedures KALSM