VBLB SAP (Sales document: Release order data) Table details
Dictionary Type: Table
Description: Sales document: Release order data
Description: Sales document: Release order data
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
ABRLI | Internal delivery schedule number | ABRLI | NUMC | 4 | ABRLI | ||||
ABART | Release type | ABART | CHAR | 1 | ABART | ||||
DOCNUM | IDoc number | EDI_DOCNUM | NUMC | 16 | EDI_DOCNUM | DCN | |||
ABEFZ | Cumulative Quantity Received by Customer | ABKFZ | QUAN | 15(3) | MENGV15 | ||||
ABRAB | Dlv. sched. valid from | ABRAB | DATS | 8 | DATUM | ||||
ABRBI | SA rel. valid to | ABRBI | DATS | 8 | DATUM | ||||
LABNK | Customer number for forecast / JIT dlv. sched. | LABNK | CHAR | 17 | TEXT17 | ||||
ABRDT | Delivery Schedule Date | ABRDT | DATS | 8 | DATUM | ||||
TERSL | Date key for schedule line dates | TERSL | CHAR | 1 | TERSL | ||||
LFDKD | Date of last delivery posted by the customer | LFDKD | DATS | 8 | DATUM | ||||
LFNKD | Last delivery confirmed by the customer | LFNKD | CHAR | 10 | LIKP | ALPHA | VBELN | ||
ABFDA | Start of production go-ahead | ABFDA | DATS | 8 | DATUM | ||||
ABFDE | End of production go-ahead | ABFDE | DATS | 8 | DATUM | ||||
ABMDA | Start of material go-ahead | ABMDA | DATS | 8 | DATUM | ||||
ABMDE | End of material go-ahead | ABMDE | DATS | 8 | DATUM | ||||
ABLLI | Last internal release order number | ABLLI | NUMC | 4 | VBLB | ABRLI | |||
HIFFZ | Highest cumulative production go-ahead quantity | HIFFZ | QUAN | 15(3) | MENG15 | ||||
HIFFZLI | Internal schedule no.for highest prod.go-ahead cml.qty | HIFFZLI | NUMC | 4 | VBLB | ABRLI | |||
HIMFZ | Highest cumulative material go-ahead quantity | HIMFZ | QUAN | 15(3) | MENG15 | ||||
HIMFZLI | Internal schedule number for highest mat.go-ahead cml.qty | HIMFZLI | NUMC | 4 | VBLB | ABRLI | |||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZEI | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
HILFZ | Highest delivery go-ahead cumulative quantity | HILFZ | QUAN | 15(3) | MENG15 | ||||
HILFZLI | Internal schedule number for highest dlv.go-ahead cml.qty | HILFZLI | NUMC | 4 | VBLB | ABRLI | |||
ABHOR | JIT horizon | ABHOR | DATS | 8 | DATUM | ||||
GJKUN | Customer fiscal year | GJKUN | NUMC | 4 | GJAHR | GJAHR | |||
VJKUN | Customer fiscal year which is not yet closed | VJKUN | NUMC | 4 | GJAHR | GJAHR | |||
AKMFZ | Actual cumulative material go-ahead quantity | AKMFZ | QUAN | 15(3) | MENG15 | ||||
AKFFZ | Actual cumulative production go-ahead quantity | AKFFZ | QUAN | 15(3) | MENG15 | ||||
AKLFZ | Actual cumulative delivery go-ahead quantity | AKLFZ | QUAN | 15(3) | MENG15 | ||||
KRITB | Key for high priority stock | KRITB | CHAR | 1 | CHAR1 | ||||
LABKY | Requirements status key | BSTAS | CHAR | 1 | CHAR1 | ||||
VBRST | Customer point of consumption | VBRST | CHAR | 14 | CHAR14 | ||||
EDLLS | Last dlv. note sent by ext. service agent to the customer | LFEDL | CHAR | 20 | CHAR20 | ||||
EDLDT | Date of last delivery sent by external agent to customer | EDLDT | DATS | 8 | DATUM | ||||
LFMKD | Last delivery quantity received by the customer | LFMKD | QUAN | 13(3) | MENG13 | ||||
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | UMBSZ | ||||
UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | UMBSN | ||||
USR01 | Additional data field 1 for delivery schedules | USR01_D | CHAR | 35 | TEXT35 | ||||
USR02 | Additional data field 2 for delivery schedules | USR02_D | CHAR | 35 | TEXT35 | ||||
USR03 | Additional data field 3 for delivery schedules | USR03_D | CHAR | 35 | TEXT35 | ||||
USR04 | Additional data field 4 for delivery schedules | USR04_D | CHAR | 10 | CHAR10 | ||||
USR05 | Additional data field 5 for delivery schedules | USR05_D | CHAR | 10 | CHAR10 | ||||
CYEFZ | Cumulative quantity reached on date zero setting made | CYEFZ | QUAN | 15(3) | MENGV15 | ||||
CYDAT | Date on which cumulative received quantity set to zero | CYDAT | DATS | 8 | DATUM | ||||
MFLAUF | Material go-ahead - validity period | MFLAUF | NUMC | 3 | NUM3 | ||||
MFEIN | Material go-ahead - unit validity period | MFEIN | CHAR | 1 | EHFR | ||||
FFLAUF | Production go-ahead - validity period | FFLAUF | NUMC | 3 | NUM3 | ||||
FFEIN | Production go-ahead - Unit validity period | FFEIN | CHAR | 1 | EHFR | ||||
ABRDT_ORG | Delivery schedule date of creation | ABRDT_ORG | DATS | 8 | DATUM | ||||
LFMAIS | Last pick-up sheet sent by the customer | LFMAIS | CHAR | 20 | BSTNK | ||||
MAIDT | Date of last pick-up sheet | MAIDT | DATS | 8 | DATUM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM |
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 tableDATA: 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 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