TWAA (Promotion Type, IS-R) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TWAA to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
AKART
Promotion Type
|
W_AKART |
CHAR
|
4 | 0 | ||||||||||||||
|
AKTYP
Promotion Category
|
W_AKTYP | TWTY |
CHAR
|
4 | 0 | |||||||||||||
|
VKONB
Validity of purch. cond. lead time before promotion start
|
W_VKONB |
NUMC
|
3 | 0 | ||||||||||||||
|
VKONE
Follow-on time of purchasing conditions after promotion end
|
W_VKONE |
NUMC
|
3 | 0 | ||||||||||||||
|
EKKON
Create purchase price condition records
|
W_EKKON |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
VKKON
Create sales price condition records
|
W_VKKON |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
VLISB
Leadtime listing
|
W_VLISB |
NUMC
|
3 | 0 | ||||||||||||||
|
VLISE
Listing follow-up time
|
W_VLISE |
NUMC
|
3 | 0 | ||||||||||||||
|
VBEKB
Lead time, announcement of promotion start
|
W_VBEKB |
NUMC
|
3 | 0 | ||||||||||||||
|
VWEFI
Lead time goods receipt in store before start of promotion
|
W_VWEFI |
NUMC
|
3 | 0 | ||||||||||||||
|
NUMKI
Number range in the case of internal number assignment
|
NUMKI |
CHAR
|
2 | 0 | ||||||||||||||
|
NUMKE
Number range in the case of external number assignment
|
NUMKE |
CHAR
|
2 | 0 | ||||||||||||||
|
KOBOG
Group of condition types/tables for purchasing conditions
|
W_KOBOG |
CHAR
|
4 | 0 | ||||||||||||||
|
KOPGR
Screen sequence group for document header & item
|
BIFGR | TVHB |
CHAR
|
4 | 0 | |||||||||||||
|
FELDK
Field selection group for document header
|
FELDK | TVHF |
CHAR
|
4 | 0 | |||||||||||||
|
AUFAR
Allocation Table Type
|
AUFAR | T620 |
CHAR
|
4 | 0 | |||||||||||||
|
BEKTY
Promotion announcement category
|
W_BEKTY | T626 |
CHAR
|
4 | 0 | |||||||||||||
|
KAPPL
Application for output conditions
|
NA_KAPPL | T681A |
CHAR
|
2 | 0 | |||||||||||||
|
KSBEK
Message Schema
|
W_NACHSM | T683 |
CHAR
|
6 | 0 | |||||||||||||
|
KOBVK
Group of condition types/tables for sales price conditions
|
W_KOBVK |
CHAR
|
4 | 0 | ||||||||||||||
|
SPVKO
Sales Organization for Suggested Sales Price
|
W_SPVKO | TVKO |
CHAR
|
4 | 0 | |||||||||||||
|
SPVTW
Distribution Channel for Suggested Sales Price
|
W_SPVTW | TVTW |
CHAR
|
2 | 0 | |||||||||||||
|
SPKNR
Plant-Based Customer no. for Suggested Sales Price
|
W_SPKNR | KNA1 |
CHAR
|
10 | 0 | |||||||||||||
|
LIGRU
List group
|
LIGRU |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KALKE
Activation type for sales prices
|
W_AKTARTH |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
VZKON
Create DC condition records
|
W_VZKON |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LIVAR
List variant for sales price calculation
|
LIVAR | TWST |
CHAR
|
2 | 0 | |||||||||||||
|
EKERV
Promotion: Purchase price determination sequence
|
W_EKERV | TWEV |
CHAR
|
2 | 0 | |||||||||||||
|
KSCHL_PERC
Condition Type Percentage Discount
|
KSCHL_PERC | T685 |
CHAR
|
4 | 0 | |||||||||||||
|
KSCHL_VAL
Condition Type Absolute Discount
|
KSCHL_VAL | T685 |
CHAR
|
4 | 0 | |||||||||||||
|
NO_KALK
Price Activation w/o Price Calculation
|
NO_KALK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LCHECK
Check Against Listing Rules/Listing Conditions
|
W_LCHECK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
SPPLT
Price List of Default Sales Price
|
W_SPPLT | T189 |
CHAR
|
2 | 0 | |||||||||||||
|
FIELDCAT
Archive Information System Field Catalog
|
AIND_FCAT | AIND_STR1 |
CHAR
|
15 | 0 | |||||||||||||
|
MEDIA_TYPE
Media Type
|
RDM_MEDIA_TYPE | RDMT_MED_TYPE |
CHAR
|
4 | 0 | |||||||||||||
|
CUSTOMER_TYPE
Customer Type
|
RDM_CUSTOMER_TYPE | RDMT_CUST_TYPE |
CHAR
|
4 | 0 | |||||||||||||
|
FORMTYPE
Form Type
|
NA_FORMTYPE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
WAELA
Currency current promotion - planning
|
W_WAELA | TCURC |
CUKY
|
5 | 0 | |||||||||||||
|
ALLOW_PMAT_IGNO
Variant Price Allowed (for Promotion Type)
|
WPM_ALLOW_PMAT_IGNO_PROMO |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ITEMS_4_BBY
Control of Subsequent Processing of Bonus Buy Materials
|
WPM_ITEMS_4_BBYS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ALLOW_DISP_MAT
Addition of Display Materials Allowed
|
WPM_ALLOW_DISP_MAT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
INIT_SLS_PRICE
Allow Initial Sales Price in Price Activation
|
WPM_ALLOW_INITIAL_SLS_PRICE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XPROMOTION_MEDIA
IS-M: Allowed Promotion Types for Contract Interface
|
XPROMOTION_MEDIA |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BPROF
Bonus Buy: Bonus buy profile
|
RDM_BBY_BPROF | RDMT_BBY_PROF |
CHAR
|
4 | 0 | |||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TWAA | AKTYP | TWAA | AKTYP |
TWTY
Promotion category, IS-R
|
AKTYP |
| TWAA | AKTYP | TWAA | MANDT |
TWTY
Promotion category, IS-R
|
MANDT |
| TWAA | AUFAR | TWAA | MANDT |
T620
Allocation Table Document Types
|
MANDT |
| TWAA | AUFAR | TWAA | AUFAR |
T620
Allocation Table Document Types
|
AUFAR |
| TWAA | BEKTY | TWAA | BEKTY |
T626
Allocation Table Notification Categories
|
AAVIT |
| TWAA | BEKTY | TWAA | MANDT |
T626
Allocation Table Notification Categories
|
MANDT |
| TWAA | BPROF | TWAA | MANDT |
RDMT_BBY_PROF
Bonus Buy: Bonus Buy Profiles
|
MANDT |
| TWAA | BPROF | TWAA | BPROF |
RDMT_BBY_PROF
Bonus Buy: Bonus Buy Profiles
|
BPROF |
| TWAA | CUSTOMER_TYPE | TWAA | MANDT |
RDMT_CUST_TYPE
Customer Types
|
MANDT |
| TWAA | CUSTOMER_TYPE | TWAA | CUSTOMER_TYPE |
RDMT_CUST_TYPE
Customer Types
|
CUSTOMER_TYPE |
| TWAA | EKERV | 'M' |
TWEV
Pricing: Determination procedure
|
KAPPL | |
| TWAA | EKERV | TWAA | EKERV |
TWEV
Pricing: Determination procedure
|
EKERV |
| TWAA | EKERV | TWAA | MANDT |
TWEV
Pricing: Determination procedure
|
MANDT |
| TWAA | FELDK | TWAA | MANDT |
TVHF
Sales Document: Field Selection Groups
|
MANDT |
| TWAA | FELDK | TTAB | OBJEKT_BCF |
TVHF
Sales Document: Field Selection Groups
|
OBJEKT |
| TWAA | FELDK | TWAA | FELDK |
TVHF
Sales Document: Field Selection Groups
|
FAWGR |
| TWAA | FIELDCAT | TWAA | FIELDCAT |
AIND_STR1
Archive Info Structures
|
ARCHINDEX |
| TWAA | FIELDCAT | * |
AIND_STR1
Archive Info Structures
|
ITYPE | |
| TWAA | KAPPL | TWAA | KAPPL |
T681A
Conditions: Applications
|
KAPPL |
| TWAA | KOPGR | TWAA | MANDT |
TVHB
Sales Document: Screen Sequence Group
|
MANDT |
| TWAA | KOPGR | TTAB | OBJEKT_BCF |
TVHB
Sales Document: Screen Sequence Group
|
OBJEKT |
| TWAA | KOPGR | TWAA | KOPGR |
TVHB
Sales Document: Screen Sequence Group
|
BIFGR |
| TWAA | KSBEK | TWAA | MANDT |
T683
Pricing procedures
|
MANDT |
| TWAA | KSBEK | 'B' |
T683
Pricing procedures
|
KVEWE | |
| TWAA | KSBEK | 'WB' |
T683
Pricing procedures
|
KAPPL | |
| TWAA | KSBEK | TWAA | KSBEK |
T683
Pricing procedures
|
KALSM |
| TWAA | KSCHL_PERC | TWAA | MANDT |
T685
Conditions: Types
|
MANDT |
| TWAA | KSCHL_PERC | 'A' |
T685
Conditions: Types
|
KVEWE | |
| TWAA | KSCHL_PERC | 'V' |
T685
Conditions: Types
|
KAPPL | |
| TWAA | KSCHL_PERC | TWAA | KSCHL_PERC |
T685
Conditions: Types
|
KSCHL |
| TWAA | KSCHL_VAL | 'A' |
T685
Conditions: Types
|
KVEWE | |
| TWAA | KSCHL_VAL | 'V' |
T685
Conditions: Types
|
KAPPL | |
| TWAA | KSCHL_VAL | TWAA | KSCHL_VAL |
T685
Conditions: Types
|
KSCHL |
| TWAA | KSCHL_VAL | TWAA | MANDT |
T685
Conditions: Types
|
MANDT |
| TWAA | LIVAR | TWAA | MANDT |
TWST
Sales Price Calculation: List Variants
|
MANDT |
| TWAA | LIVAR | TWAA | LIVAR |
TWST
Sales Price Calculation: List Variants
|
LIVAR |
| TWAA | MANDT | TWAA | MANDT |
T000
Clients
|
MANDT |
| TWAA | MEDIA_TYPE | TWAA | MANDT |
RDMT_MED_TYPE
Media Types
|
MANDT |
| TWAA | MEDIA_TYPE | TWAA | MEDIA_TYPE |
RDMT_MED_TYPE
Media Types
|
MEDIA_TYPE |
| TWAA | SPKNR | TWAA | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| TWAA | SPKNR | TWAA | SPKNR |
KNA1
General Data in Customer Master
|
KUNNR |
| TWAA | SPPLT | TWAA | MANDT |
T189
Conditions: Price List Categories
|
MANDT |
| TWAA | SPPLT | TWAA | SPPLT |
T189
Conditions: Price List Categories
|
PLTYP |
| TWAA | SPVKO | TWAA | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| TWAA | SPVKO | TWAA | SPVKO |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| TWAA | SPVTW | TWAA | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| TWAA | SPVTW | TWAA | SPVTW |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |
| TWAA | WAELA | TWAA | MANDT |
TCURC
Currency Codes
|
MANDT |
| TWAA | WAELA | TWAA | WAELA |
TCURC
Currency Codes
|
WAERS |