TVLS SAP (Deliveries: Blocking Reasons/Criteria) Table details

Dictionary Type: Table
Description: Deliveries: Blocking Reasons/Criteria




ABAP Code to SELECT data from TVLS
Related tables to TVLS
Access table TVLS




Table field list including key, data, relationships and ABAP select examples

TVLS is a standard SAP Table which is used to store Deliveries: Blocking Reasons/Criteria data and is available within R/3 SAP systems depending on the version and release level.

The TVLS table consists of various fields, each holding specific information or linking keys about Deliveries: Blocking Reasons/Criteria data available in SAP. These include LIFSP (Default delivery block), SPELF (Delivery block), SPEKO (Picking Block), SPEWA (Goods Issue Block).. 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 cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = TVLST


SAP TVLS 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
LIFSPDefault delivery block LIFSPCHAR2LIFSP
SPELFDelivery block SPELFCHAR1XFELD
SPEKOPicking Block SPEKOCHAR1XFELD
SPEWAGoods Issue Block SPEWACHAR1XFELD
SPEFTBlock production SPEFTCHAR1XFELD
SPEBEConfirmation block SPEBECHAR1XFELD
SPEAUSales order block SPEAUCHAR1XFELD
SPEDRPrinting block SPEDRCHAR1XFELD
SPEVIDelivery due list block SPEVICHAR1XFELD
MBDIFDeferment period for material provision in days MBDIFNUMC3MBDIF

Key field Non-key field



How do I retrieve data from SAP table TVLS using ABAP code

The following ABAP code Example will allow you to do a basic selection on TVLS to SELECT all data from the table
DATA: WA_TVLS TYPE TVLS.

SELECT SINGLE *
FROM TVLS
INTO CORRESPONDING FIELDS OF WA_TVLS
WHERE...

How to access SAP table TVLS

Within an ECC or HANA version of SAP you can also view further information about TVLS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!