SAP Table

TWAA Promotion Type, IS-R

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

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

TWAA columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyAKART 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
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
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
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
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
/ Relationships

TWAA foreign keys.

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