SAP table TWKG (Sales Price Calculation: Pricing Type)

SAP table TWKG has 2 primary key fields being MANDT,KALGR.

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
KALGR Pricing type CHAR 4 0 KALGR
VKALS Sales Pricing: Sales Price Calculation Schema CHAR 6 0 T683 VKALS
KZKAB Pricing document creation CHAR 1 0 KZKAB
0 Do not create pricing document
1 Pricing document without document adjustment
2 Pricing document with adjustment if conditions change
3 Pricing doc. with adjustment if conds./master data change
KZBKA ID: Background price calculation CHAR 1 0 KZBKA
KBART Pricing document type CHAR 4 0 KBART
0001 Sales price calculations
0002 Automatic price recalculation
EGKAL Data held when basic purchase price changes CHAR 1 0 EGKAL
1 Markup is held
2 Final price is held
3 Use planned markup
KWAER Sales Pricing: Pricing Currency CUKY 5 0 TCURC KAWAER
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
AVWAE SP Calc.: Alternative Sales Currency CUKY 5 0 TCURC AVWAE

TWKG foreign key relationships

Table Field Check Table Check Field
0 TWKG AVWAE TCURC Currency Codes MANDT
0 TWKG AVWAE TCURC Currency Codes WAERS
1 TWKG KURST TCURV Exchange rate types for currency translation MANDT
1 TWKG KURST TCURV Exchange rate types for currency translation KURST
0 TWKG KWAER TCURC Currency Codes MANDT
0 TWKG KWAER TCURC Currency Codes WAERS
1 TWKG VKALS T683 Pricing procedures KAPPL
1 TWKG VKALS T683 Pricing procedures KALSM