VBLB SAP (Sales document: Release order data) Table details

Dictionary Type: Table
Description: Sales document: Release order data




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




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

VBLB is a standard SAP Table which is used to store Sales document: Release order data data and is available within R/3 SAP systems depending on the version and release level.

The VBLB table consists of various fields, each holding specific information or linking keys about Sales document: Release order data data available in SAP. These include VBELN (Sales Document), POSNR (Sales Document Item), ABRLI (Internal delivery schedule number), ABART (Release type).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VBLB 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 MANDTCLNT3T000MANDT
VBELNSales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
POSNRSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
ABRLIInternal delivery schedule number ABRLINUMC4ABRLI
ABARTRelease type ABARTCHAR1ABART
DOCNUMIDoc number EDI_DOCNUMNUMC16EDI_DOCNUMDCN
ABEFZCumulative Quantity Received by Customer ABKFZQUAN15(3) MENGV15
ABRABDlv. sched. valid from ABRABDATS8DATUM
ABRBISA rel. valid to ABRBIDATS8DATUM
LABNKCustomer number for forecast / JIT dlv. sched. LABNKCHAR17TEXT17
ABRDTDelivery Schedule Date ABRDTDATS8DATUM
TERSLDate key for schedule line dates TERSLCHAR1TERSL
LFDKDDate of last delivery posted by the customer LFDKDDATS8DATUM
LFNKDLast delivery confirmed by the customer LFNKDCHAR10LIKPALPHAVBELN
ABFDAStart of production go-ahead ABFDADATS8DATUM
ABFDEEnd of production go-ahead ABFDEDATS8DATUM
ABMDAStart of material go-ahead ABMDADATS8DATUM
ABMDEEnd of material go-ahead ABMDEDATS8DATUM
ABLLILast internal release order number ABLLINUMC4VBLBABRLI
HIFFZHighest cumulative production go-ahead quantity HIFFZQUAN15(3) MENG15
HIFFZLIInternal schedule no.for highest prod.go-ahead cml.qty HIFFZLINUMC4VBLBABRLI
HIMFZHighest cumulative material go-ahead quantity HIMFZQUAN15(3) MENG15
HIMFZLIInternal schedule number for highest mat.go-ahead cml.qty HIMFZLINUMC4VBLBABRLI
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZEIEntry time ERZETTIMS6UZEIT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
HILFZHighest delivery go-ahead cumulative quantity HILFZQUAN15(3) MENG15
HILFZLIInternal schedule number for highest dlv.go-ahead cml.qty HILFZLINUMC4VBLBABRLI
ABHORJIT horizon ABHORDATS8DATUM
GJKUNCustomer fiscal year GJKUNNUMC4GJAHRGJAHR
VJKUNCustomer fiscal year which is not yet closed VJKUNNUMC4GJAHRGJAHR
AKMFZActual cumulative material go-ahead quantity AKMFZQUAN15(3) MENG15
AKFFZActual cumulative production go-ahead quantity AKFFZQUAN15(3) MENG15
AKLFZActual cumulative delivery go-ahead quantity AKLFZQUAN15(3) MENG15
KRITBKey for high priority stock KRITBCHAR1CHAR1
LABKYRequirements status key BSTASCHAR1CHAR1
VBRSTCustomer point of consumption VBRSTCHAR14CHAR14
EDLLSLast dlv. note sent by ext. service agent to the customer LFEDLCHAR20CHAR20
EDLDTDate of last delivery sent by external agent to customer EDLDTDATS8DATUM
LFMKDLast delivery quantity received by the customer LFMKDQUAN13(3) MENG13
UMVKZNumerator (factor) for conversion of sales quantity into SKU UMVKZDEC5UMBSZ
UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKU UMVKNDEC5UMBSN
USR01Additional data field 1 for delivery schedules USR01_DCHAR35TEXT35
USR02Additional data field 2 for delivery schedules USR02_DCHAR35TEXT35
USR03Additional data field 3 for delivery schedules USR03_DCHAR35TEXT35
USR04 Additional data field 4 for delivery schedules USR04_DCHAR10CHAR10
USR05Additional data field 5 for delivery schedules USR05_DCHAR10CHAR10
CYEFZCumulative quantity reached on date zero setting made CYEFZQUAN15(3) MENGV15
CYDATDate on which cumulative received quantity set to zero CYDATDATS8DATUM
MFLAUFMaterial go-ahead - validity period MFLAUFNUMC3NUM3
MFEINMaterial go-ahead - unit validity period MFEINCHAR1EHFR
FFLAUFProduction go-ahead - validity period FFLAUFNUMC3NUM3
FFEINProduction go-ahead - Unit validity period FFEINCHAR1EHFR
ABRDT_ORGDelivery schedule date of creation ABRDT_ORGDATS8DATUM
LFMAISLast pick-up sheet sent by the customer LFMAISCHAR20BSTNK
MAIDTDate of last pick-up sheet MAIDTDATS8DATUM
AEDATChanged On AEDATDATS8DATUM

Key field Non-key field



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

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

SELECT SINGLE *
FROM VBLB
INTO CORRESPONDING FIELDS OF WA_VBLB
WHERE...

How to access SAP table VBLB

Within an ECC or HANA version of SAP you can also view further information about VBLB 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!