TWLV SAP (Listing procedure, assortments) Table details
Dictionary Type: Table
Description: Listing procedure, assortments
Description: Listing procedure, assortments
Table field list including key, data, relationships and ABAP select examples
TWLV is a standard SAP Table which is used to store Listing procedure, assortments data and is available within R/3 SAP systems depending on the version and release level.
The TWLV table consists of various fields, each holding specific information or linking keys about Listing procedure, assortments data available in SAP. These include LSTFL (Listing procedure), BEGRU (Authorization to use listing procedure), STDVF (Standard procedure (default)), AUTVF (Auto-Conversion Procedure with WRF6 Change/Assrtmt. Classif.).. 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: G - Customising table which is protected against SAP UpdateDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
Text table = TWLVT
SAP TWLV 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 | |||
| LSTFL | Listing procedure | LSTVF | CHAR | 2 | LSTFL | WLV | |||
| BEGRU | Authorization to use listing procedure | W_LV_BERGR | CHAR | 4 | BEGRU | ||||
| STDVF | Standard procedure (default) | W_LSTDVERF | CHAR | 1 | FLAG | ||||
| AUTVF | Auto-Conversion Procedure with WRF6 Change/Assrtmt. Classif. | W_AUT_LVF | CHAR | 1 | XFELD | ||||
| AKTVF | Std Lstng procedure for promotions | W_STDV_PRM | CHAR | 1 | FLAG | ||||
| AUFVF | Std lstg proc. for allocation processes | W_STDV_AUF | CHAR | 1 | FLAG | ||||
| VERF_MANU | Proc. used for external interface | LIST_MANU | CHAR | 1 | FLAG | ||||
| ALLE_VAR | Manual procedure per variant or for all together | LIST_MANVR | CHAR | 1 | FLAG | ||||
| MEHRFACH | Multiple listing allowed ('X') or not allowed (' ') | LIST_MEHRF | CHAR | 1 | FLAG | ||||
| MSG_CODE | Sequence control for linked listing check results | W_PFOLGE | CHAR | 1 | XFELD | ||||
| LIST_ALL | Listing for all assortments (without logic) | LIST_ALL | CHAR | 1 | FLAG | ||||
| CHECK_ALL | Funct module: Exit 'Listing all assortments' | W_FUNCT_A | CHAR | 30 | TFDIR | FUNCNAME | |||
| FOLGE1 | Sequence of listing procedure | LIST_FOLGE | CHAR | 1 | LIST_FOLGE | ||||
| VERKN1 | Link rule to link listing procedures | LIST_VERKN | CHAR | 1 | LIST_VERKN | ||||
| FOLGE2 | Sequence of listing procedure | LIST_FOLGE | CHAR | 1 | LIST_FOLGE | ||||
| VERKN2 | Link rule to link listing procedures | LIST_VERKN | CHAR | 1 | LIST_VERKN | ||||
| FOLGE3 | Sequence of listing procedure | LIST_FOLGE | CHAR | 1 | LIST_FOLGE | ||||
| VERKN3 | Link rule to link listing procedures | LIST_VERKN | CHAR | 1 | LIST_VERKN | ||||
| FOLGE4 | Sequence of listing procedure | LIST_FOLGE | CHAR | 1 | LIST_FOLGE | ||||
| MAN_EXIT | Exit: Listing via manual module assignment | W_FUNC_M | CHAR | 30 | TFDIR | FUNCNAME | |||
| PROF_ALG | Listing algorithm number | LIST_ALG | CHAR | 2 | TWLAG | LIST_ALG | |||
| PROF_WAGR | Rule when 'no astmt grade in mat. group-astmt. owner master' | W_LP_WAGRU | CHAR | 1 | XFELD | ||||
| PROF_MAT | Rule for 'No assortment grade specified for the material' | W_LP_MAT | CHAR | 1 | XFELD | ||||
| PROF_EXIT | Exit: listing a/c to assortment owner-material group master | W_FUNC_P | CHAR | 30 | TFDIR | FUNCNAME | |||
| MPZ_EXIT | Exit: listing acc. classifying char., mat. <-> astmt owner | W_FUNC_C | CHAR | 30 | TFDIR | FUNCNAME | |||
| LAY_EXIT | Exit: listing according to layout in assortment owner | W_FUNC_L | CHAR | 30 | TFDIR | FUNCNAME | |||
| LAY_CHECK | Rule when 'No layout assigned to material/plant' | W_LAY_FLAG | CHAR | 1 | FLAG | ||||
| VKP_CHECK | Check existing sales price when listing | W_VKP_FLAG | CHAR | 1 | FLAG | ||||
| VKP_ZERO | Zero sales prices accepted | W_VKP_ZERO | CHAR | 1 | FLAG | ||||
| OHNE_BAUST | Working without modules and listing conditions | W_MIT_BAUS | CHAR | 1 | FLAG | ||||
| LV_WRF1 | The listing procedure defined for the assortm. is to be used | W_LV_WRF1 | CHAR | 1 | XFELD | ||||
| LV_NLIF | List in DC only if warehouse procurement is possible | W_LV_NLIF | CHAR | 1 | XFELD | ||||
| LAYVF | Standard listing procedure for the layout workbench | W_STDV_LAYOUT | CHAR | 1 | FLAG |
| Key field | Non-key field |
How do I retrieve data from SAP table TWLV using ABAP code
The following ABAP code Example will allow you to do a basic selection on TWLV to SELECT all data from the tableDATA: WA_TWLV TYPE TWLV.
SELECT SINGLE *
FROM TWLV
INTO CORRESPONDING FIELDS OF WA_TWLV
WHERE...
How to access SAP table TWLV
Within an ECC or HANA version of SAP you can also view further information about TWLV 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