TWLFE SAP (Sales price calculation: schema/list field) Table details
Description: Sales price calculation: schema/list field
Table field list including key, data, relationships and ABAP select examples
TWLFE is a standard SAP Table which is used to store Sales price calculation: schema/list field data and is available within R/3 SAP systems depending on the version and release level.
The TWLFE table consists of various fields, each holding specific information or linking keys about Sales price calculation: schema/list field data available in SAP. These include VKALS (Sales Pricing: Sales Price Calculation Schema), LIFEL (Sales Pricing: List Field for Determining Sales Price), KOFEL (Subtotal in sales price calculation schema), KVEWE (Usage of the condition table).. 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 or numeric)
SAP TWLFE 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 | |||
| VKALS | Sales Pricing: Sales Price Calculation Schema | VKALS | CHAR | 6 | T683 | KALSM | |||
| LIFEL | Sales Pricing: List Field for Determining Sales Price | LIFELD | CHAR | 5 | TWLF | LIFELD | |||
| KOFEL | Subtotal in sales price calculation schema | KOFEL | CHAR | 5 | KOFEL | ||||
| KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | T681V | KVEWE | KVW | ||
| KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
| KSCHL | Condition Type | KSCHL | CHAR | 4 | T685 | KSCHL | VKS | ||
| AKSCH | Promotion condition type | AKSCH | CHAR | 4 | T685 | KSCHL | |||
| KKSCH | Condition type in the sales price calculation schema | KKSCH | CHAR | 4 | T685 | KSCHL | |||
| WRSKZ | Sales Price Calculation: Default currency for conditions | WRSKZ | CHAR | 1 | WRSKZ | ||||
| KOAER | Pricing: Type of condition type determination | KOAER | CHAR | 1 | KOAER | ||||
| KOSER | Pricing: Condition record determination type | KOSER | CHAR | 1 | KOSER | ||||
| UEBNA | Pricing: method of adoption from calc. schema --> list field | UEBNA | CHAR | 1 | UEBNA |
| Key field | Non-key field |
How do I retrieve data from SAP table TWLFE using ABAP code
The following ABAP code Example will allow you to do a basic selection on TWLFE to SELECT all data from the tableDATA: WA_TWLFE TYPE TWLFE.
SELECT SINGLE *
FROM TWLFE
INTO CORRESPONDING FIELDS OF WA_TWLFE
WHERE...
How to access SAP table TWLFE
Within an ECC or HANA version of SAP you can also view further information about TWLFE 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