TWAA SAP (Promotion Type, IS-R) Table details
Dictionary Type: Table
Description: Promotion Type, IS-R
Description: Promotion Type, IS-R
Table field list including key, data, relationships and ABAP select examples
TWAA is a standard SAP Table which is used to store Promotion Type, IS-R data and is available within R/3 SAP systems depending on the version and release level.
The TWAA table consists of various fields, each holding specific information or linking keys about Promotion Type, IS-R data available in SAP. These include AKART (Promotion Type), AKTYP (Promotion Category), VKONB (Validity of purch. cond. lead time before promotion start), VKONE (Follow-on time of purchasing conditions after promotion end).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = TWAAT
SAP TWAA table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AKART | Promotion Type | W_AKART | CHAR | 4 | W_AKART | WAA | |||
AKTYP | Promotion Category | W_AKTYP | CHAR | 4 | TWTY | AKTTY | |||
VKONB | Validity of purch. cond. lead time before promotion start | W_VKONB | NUMC | 3 | ANZTA | ||||
VKONE | Follow-on time of purchasing conditions after promotion end | W_VKONE | NUMC | 3 | ANZTA | ||||
EKKON | Create purchase price condition records | W_EKKON | CHAR | 1 | XFELD | ||||
VKKON | Create sales price condition records | W_VKKON | CHAR | 1 | XFELD | ||||
VLISB | Leadtime listing | W_VLISB | NUMC | 3 | ANZTA | ||||
VLISE | Listing follow-up time | W_VLISE | NUMC | 3 | ANZTA | ||||
VBEKB | Lead time, announcement of promotion start | W_VBEKB | NUMC | 3 | ANZTA | ||||
VWEFI | Lead time goods receipt in store before start of promotion | W_VWEFI | NUMC | 3 | ANZTA | ||||
NUMKI | Number range in the case of internal number assignment | NUMKI | CHAR | 2 | NUMKR | ||||
NUMKE | Number range in the case of external number assignment | NUMKE | CHAR | 2 | NUMKR | ||||
KOBOG | Group of condition types/tables for purchasing conditions | W_KOBOG | CHAR | 4 | CHAR4 | ||||
KOPGR | Screen sequence group for document header & item | BIFGR | CHAR | 4 | TVHB | BIFGR | |||
FELDK | Field selection group for document header | FELDK | CHAR | 4 | TVHF | FAWGR | |||
AUFAR | Allocation Table Type | AUFAR | CHAR | 4 | T620 | AUFAR | ATG | ||
BEKTY | Promotion announcement category | W_BEKTY | CHAR | 4 | T626 | AAVIT | |||
KAPPL | Application for output conditions | NA_KAPPL | CHAR | 2 | T681A | KAPPL | NA_KAPPL | ||
KSBEK | Message Schema | W_NACHSM | CHAR | 6 | T683 | KALSM | |||
KOBVK | Group of condition types/tables for sales price conditions | W_KOBVK | CHAR | 4 | CHAR4 | ||||
SPVKO | Sales Organization for Suggested Sales Price | W_SPVKO | CHAR | 4 | TVKO | VKORG | |||
SPVTW | Distribution Channel for Suggested Sales Price | W_SPVTW | CHAR | 2 | TVTW | VTWEG | |||
SPKNR | Plant-Based Customer no. for Suggested Sales Price | W_SPKNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
LIGRU | List group | LIGRU | CHAR | 1 | LIGRU | LIG | |||
KALKE | Activation type for sales prices | W_AKTARTH | CHAR | 1 | AKTARTH | ||||
VZKON | Create DC condition records | W_VZKON | CHAR | 1 | XFELD | ||||
LIVAR | List variant for sales price calculation | LIVAR | CHAR | 2 | TWST | LIVAR | LIV | ||
EKERV | Promotion: Purchase price determination sequence | W_EKERV | CHAR | 2 | TWEV | EKERV | |||
KSCHL_PERC | Condition Type Percentage Discount | KSCHL_PERC | CHAR | 4 | T685 | KSCHL | |||
KSCHL_VAL | Condition Type Absolute Discount | KSCHL_VAL | CHAR | 4 | T685 | KSCHL | |||
NO_KALK | Price Activation w/o Price Calculation | NO_KALK | CHAR | 1 | XFELD | ||||
LCHECK | Check Against Listing Rules/Listing Conditions | W_LCHECK | CHAR | 1 | W_LCHECK | ||||
SPPLT | Price List of Default Sales Price | W_SPPLT | CHAR | 2 | T189 | PLTYP | |||
FIELDCAT | Archive Information System Field Catalog | AIND_FCAT | CHAR | 15 | AIND_STR1 | AIND_DESC | |||
MEDIA_TYPE | Media Type | RDM_MEDIA_TYPE | CHAR | 4 | RDMT_MED_TYPE | RDM_MEDIA_TYPE | |||
CUSTOMER_TYPE | Customer Type | RDM_CUSTOMER_TYPE | CHAR | 4 | RDMT_CUST_TYPE | RDM_CUSTOMER_TYPE | |||
FORMTYPE | Form Type | NA_FORMTYPE | CHAR | 1 | NA_FORMTYPE | ||||
WAELA | Currency current promotion - planning | W_WAELA | CUKY | 5 | TCURC | WAERS | FWS | ||
ALLOW_PMAT_IGNO | Variant Price Allowed (for Promotion Type) | WPM_ALLOW_PMAT_IGNO_PROMO | CHAR | 1 | XFELD | ||||
ITEMS_4_BBY | Control of Subsequent Processing of Bonus Buy Materials | WPM_ITEMS_4_BBYS | CHAR | 1 | WPM_ITEMS_4_BBYS | ||||
ALLOW_DISP_MAT | Addition of Display Materials Allowed | WPM_ALLOW_DISP_MAT | CHAR | 1 | XFELD | ||||
INIT_SLS_PRICE | Allow Initial Sales Price in Price Activation | WPM_ALLOW_INITIAL_SLS_PRICE | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
XPROMOTION_MEDIA | IS-M: Allowed Promotion Types for Contract Interface | XPROMOTION_MEDIA | CHAR | 1 | XPROMOTION_MEDIA | ||||
.INCLU--AP | 0 | ||||||||
BPROF | Bonus Buy: Bonus buy profile | RDM_BBY_BPROF | CHAR | 4 | RDMT_BBY_PROF | CHAR4 | RDM_BBY_BPROF | RDM_BBY_BPROF_SHLP |
Key field | Non-key field |
How do I retrieve data from SAP table TWAA using ABAP code
The following ABAP code Example will allow you to do a basic selection on TWAA to SELECT all data from the tableDATA: WA_TWAA TYPE TWAA.
SELECT SINGLE *
FROM TWAA
INTO CORRESPONDING FIELDS OF WA_TWAA
WHERE...
How to access SAP table TWAA
Within an ECC or HANA version of SAP you can also view further information about TWAA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects