SAP table TWAA (Promotion Type, IS-R)

SAP table TWAA has 2 primary key fields being MANDT,AKART.

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
AKART Promotion Type CHAR 4 0 W_AKART
AKTYP Promotion Category CHAR 4 0 TWTY W_AKTYP
VKONB Validity of purch. cond. lead time before promotion start NUMC 3 0 W_VKONB
VKONE Follow-on time of purchasing conditions after promotion end NUMC 3 0 W_VKONE
EKKON Create purchase price condition records CHAR 1 0 W_EKKON
VKKON Create sales price condition records CHAR 1 0 W_VKKON
VLISB Leadtime listing NUMC 3 0 W_VLISB
VLISE Listing follow-up time NUMC 3 0 W_VLISE
VBEKB Lead time, announcement of promotion start NUMC 3 0 W_VBEKB
VWEFI Lead time goods receipt in store before start of promotion NUMC 3 0 W_VWEFI
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
NUMKE Number Range of External Number Assignment CHAR 2 0 NUMKE
KOBOG Group of condition types/tables for purchasing conditions CHAR 4 0 W_KOBOG
KOPGR Screen sequence group for document header & item CHAR 4 0 TVHB BIFGR
FELDK Field selection group for document header CHAR 4 0 TVHF FELDK
AUFAR Allocation Table Type CHAR 4 0 T620 AUFAR
BEKTY Promotion announcement category CHAR 4 0 T626 W_BEKTY
KAPPL Application for output conditions CHAR 2 0 T681A NA_KAPPL
KSBEK Message Schema CHAR 6 0 T683 W_NACHSM
KOBVK Group of condition types/tables for sales price conditions CHAR 4 0 W_KOBVK
SPVKO Sales Organization for Suggested Sales Price CHAR 4 0 TVKO W_SPVKO
SPVTW Distribution Channel for Suggested Sales Price CHAR 2 0 TVTW W_SPVTW
SPKNR Plant-Based Customer no. for Suggested Sales Price CHAR 10 0 KNA1 W_SPKNR
LIGRU List group CHAR 1 0 LIGRU
A Org. Levels Collective Calculation for Materials
B Material Collective Calculation for Org. Levels
C Display ALV - Org. Levels Collective Calculation for Matls
D Display ALV - Material Collective Calculation for Org.Levels
KALKE Activation type for sales prices CHAR 1 0 W_AKTARTH
VZKON Create DC condition records CHAR 1 0 W_VZKON
LIVAR List variant for sales price calculation CHAR 2 0 TWST LIVAR
EKERV Promotion: Purchase price determination sequence CHAR 2 0 TWEV W_EKERV
KSCHL_PERC Condition Type Percentage Discount CHAR 4 0 T685 KSCHL_PERC
KSCHL_VAL Condition Type Absolute Discount CHAR 4 0 T685 KSCHL_VAL
NO_KALK Price Activation w/o Price Calculation CHAR 1 0 NO_KALK
LCHECK Check Against Listing Rules/Listing Conditions CHAR 1 0 W_LCHECK
No check against listing rules/listing conditions
X Check against listing rules
Y Check against listing conditions
SPPLT Price List of Default Sales Price CHAR 2 0 T189 W_SPPLT
FIELDCAT Archive Information System Field Catalog CHAR 15 0 AIND_STR1 AIND_FCAT
MEDIA_TYPE Media Type CHAR 4 0 RDMT_MED_TYPE RDM_MEDIA_TYPE
CUSTOMER_TYPE Customer Type CHAR 4 0 RDMT_CUST_TYPE RDM_CUSTOMER_TYPE
FORMTYPE Form Type CHAR 1 0 NA_FORMTYPE
1 SmartForm
2 PDF
WAELA Currency Current Promotion - Planning CUKY 5 0 TCURC W_WAELA
ALLOW_PMAT_IGNO Variant Price Allowed (for Promotion Type) CHAR 1 0 WPM_ALLOW_PMAT_IGNO_PROMO
ITEMS_4_BBY Control of Subsequent Processing of Bonus Buy Materials CHAR 1 0 WPM_ITEMS_4_BBYS
No subsequent processing
1 Manual Processing of articles of selected BBY
2 Automatic Processing of all BBY articles
ALLOW_DISP_MAT Addition of Display Materials Allowed CHAR 1 0 WPM_ALLOW_DISP_MAT
INIT_SLS_PRICE Allow Initial Sales Price in Price Activation CHAR 1 0 WPM_ALLOW_INITIAL_SLS_PRICE
DUELI Leadtime Listing Due NUMC 3 0 DUELI
DUEPP Leadtime Purchase Price Activation Due NUMC 3 0 DUEPP
DUESP Leadtime Sales Price Activation Due NUMC 3 0 DUESP
ODUSP Leadtime Sales Price Activation NUMC 3 0 ODUSP
DUEAL Leadtime Allocation Table Generation Due NUMC 3 0 DUEAL
ODUAL Leadtime Allocation Table Generation NUMC 3 0 ODUAL
ODUAN Leadtime Annoucement Overdue NUMC 3 0 ODUAN
BPROF Bonus Buy: Bonus buy profile CHAR 4 0 RDMT_BBY_PROF RDM_BBY_BPROF

TWAA foreign key relationships

Table Field Check Table Check Field
0 TWAA AKTYP TWTY Promotion category, IS-R MANDT
0 TWAA AKTYP TWTY Promotion category, IS-R AKTYP
1 TWAA AUFAR T620 Allocation Table Document Types MANDT
0 TWAA BEKTY T626 Allocation Table Notification Categories MANDT
0 TWAA BEKTY T626 Allocation Table Notification Categories AAVIT
1 TWAA BPROF RDMT_BBY_PROF Bonus Buy: Bonus Buy Profiles MANDT
0 TWAA CUSTOMER_TYPE RDMT_CUST_TYPE Customer Types MANDT
0 TWAA CUSTOMER_TYPE RDMT_CUST_TYPE Customer Types CUSTOMER_TYPE
1 TWAA EKERV TWEV Pricing: Determination procedure MANDT
1 TWAA EKERV TWEV Pricing: Determination procedure KAPPL
0 TWAA FELDK TVHF Sales Document: Field Selection Groups MANDT
0 TWAA FELDK TVHF Sales Document: Field Selection Groups OBJEKT
0 TWAA FELDK TVHF Sales Document: Field Selection Groups FAWGR
1 TWAA FIELDCAT AIND_STR1 Archive Info Structures ITYPE
0 TWAA KAPPL T681A Conditions: Applications KAPPL
1 TWAA KOPGR TVHB Sales Document: Screen Sequence Group MANDT
1 TWAA KOPGR TVHB Sales Document: Screen Sequence Group OBJEKT
1 TWAA KOPGR TVHB Sales Document: Screen Sequence Group BIFGR
0 TWAA KSBEK T683 Pricing procedures KAPPL
0 TWAA KSBEK T683 Pricing procedures KALSM
1 TWAA KSCHL_PERC T685 Conditions: Types KAPPL
1 TWAA KSCHL_PERC T685 Conditions: Types KSCHL
0 TWAA KSCHL_VAL T685 Conditions: Types KAPPL
0 TWAA KSCHL_VAL T685 Conditions: Types KSCHL
1 TWAA LIVAR TWST Sales Price Calculation: List Variants MANDT
1 TWAA LIVAR TWST Sales Price Calculation: List Variants LIVAR
0 TWAA MEDIA_TYPE RDMT_MED_TYPE Media Types MANDT
0 TWAA MEDIA_TYPE RDMT_MED_TYPE Media Types MEDIA_TYPE
1 TWAA SPKNR KNA1 General Data in Customer Master MANDT
1 TWAA SPKNR KNA1 General Data in Customer Master KUNNR
0 TWAA SPPLT T189 Conditions: Price List Types MANDT
0 TWAA SPPLT T189 Conditions: Price List Types PLTYP
1 TWAA SPVKO TVKO Organizational Unit: Sales Organizations MANDT
1 TWAA SPVKO TVKO Organizational Unit: Sales Organizations VKORG
0 TWAA SPVTW TVTW Organizational Unit: Distribution Channels MANDT
0 TWAA SPVTW TVTW Organizational Unit: Distribution Channels VTWEG
1 TWAA WAELA TCURC Currency Codes MANDT
1 TWAA WAELA TCURC Currency Codes WAERS