SAP VBLB Sales document: Release order data Table
Overview
VBLB is a standard SAP S/4HANA table that stores Sales document: Release order data data. There are total 63 fields in the VBLB table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBLB belongs to Sales (SD-SLS) module and is located in the package Application development R/3 Sales (VA).
In addition, following links provide an overview of foreign key relationships, if any, that link VBLB to other SAP tables and standard CDS views available based on VBLB table in S/4HANA 2020.
Techincal Settings of VBLB
Below are technical details of the table VBLB
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBLB Fields
The following table gives you an overview of the fields available in VBLB
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Sales Document | VBELN_VA | CHAR | 10 | |
| POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | |
| ABRLI | Internal delivery schedule number | ABRLI | NUMC | 4 | |
| ABART | Release type | ABART | CHAR | 1 | |
| DOCNUM | IDoc number | EDI_DOCNUM | NUMC | 16 | |
| ABEFZ | Cumulative Quantity Received by Customer | ABKFZ | QUAN | 15 | |
| ABRAB | Valid-from date of delivery schedule | ABRAB | DATS | 8 | |
| ABRBI | Valid-to date of delivery schedule | ABRBI | DATS | 8 | |
| LABNK | Current key of delivery schedule | LABNK | CHAR | 17 | |
| ABRDT | Delivery Schedule Date | ABRDT | DATS | 8 | |
| TERSL | Date key for schedule line dates | TERSL | CHAR | 1 | |
| LFDKD | Date of last delivery posted by the customer | LFDKD | DATS | 8 | |
| LFNKD | Last delivery confirmed by the customer | LFNKD | LIKP | CHAR | 10 |
| ABFDA | Start of production go-ahead | ABFDA | DATS | 8 | |
| ABFDE | End of production go-ahead | ABFDE | DATS | 8 | |
| ABMDA | Start of material go-ahead | ABMDA | DATS | 8 | |
| ABMDE | End of material go-ahead | ABMDE | DATS | 8 | |
| ABLLI | Last internal release order number | ABLLI | VBLB | NUMC | 4 |
| HIFFZ | Highest cumulative production go-ahead quantity | HIFFZ | QUAN | 15 | |
| HIFFZLI | Internal schedule no.for highest prod.go-ahead cml.qty | HIFFZLI | VBLB | NUMC | 4 |
| HIMFZ | Highest cumulative material go-ahead quantity | HIMFZ | QUAN | 15 | |
| HIMFZLI | Internal schedule number for highest mat.go-ahead cml.qty | HIMFZLI | VBLB | NUMC | 4 |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERZEI | Entry time | ERZET | TIMS | 6 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| HILFZ | Highest delivery go-ahead cumulative quantity | HILFZ | QUAN | 15 | |
| HILFZLI | Internal schedule number for highest dlv.go-ahead cml.qty | HILFZLI | VBLB | NUMC | 4 |
| ABHOR | JIT horizon | ABHOR | DATS | 8 | |
| GJKUN | Customer fiscal year | GJKUN | NUMC | 4 | |
| VJKUN | Customer fiscal year which is not yet closed | VJKUN | NUMC | 4 | |
| AKMFZ | Actual cumulative material go-ahead quantity | AKMFZ | QUAN | 15 | |
| AKFFZ | Actual cumulative production go-ahead quantity | AKFFZ | QUAN | 15 | |
| AKLFZ | Actual cumulative delivery go-ahead quantity | AKLFZ | QUAN | 15 | |
| KRITB | Key for high priority stock | KRITB | CHAR | 1 | |
| LABKY | Requirements status key | BSTAS | CHAR | 1 | |
| VBRST | Customer point of consumption | VBRST | CHAR | 14 | |
| EDLLS | Last dlv. note sent by ext. service agent to the customer | LFEDL | CHAR | 20 | |
| EDLDT | Date of last delivery sent by external agent to customer | EDLDT | DATS | 8 | |
| LFMKD | Last delivery quantity received by the customer | LFMKD | QUAN | 13 | |
| UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | |
| UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | |
| USR01 | Additional data field 1 for delivery schedules | USR01_D | CHAR | 35 | |
| USR02 | Additional data field 2 for delivery schedules | USR02_D | CHAR | 35 | |
| USR03 | Additional data field 3 for delivery schedules | USR03_D | CHAR | 35 | |
| USR04 | Additional data field 4 for delivery schedules | USR04_D | CHAR | 10 | |
| USR05 | Additional data field 5 for delivery schedules | USR05_D | CHAR | 10 | |
| CYEFZ | Cumulative quantity reached on date zero setting made | CYEFZ | QUAN | 15 | |
| CYDAT | Date on which cumulative received quantity set to zero | CYDAT | DATS | 8 | |
| MFLAUF | Material go-ahead - validity period | MFLAUF | NUMC | 3 | |
| MFEIN | Material go-ahead - unit validity period | MFEIN | CHAR | 1 | |
| FFLAUF | Production go-ahead - validity period | FFLAUF | NUMC | 3 | |
| FFEIN | Production go-ahead - Unit validity period | FFEIN | CHAR | 1 | |
| ABRDT_ORG | Delivery schedule date of creation | ABRDT_ORG | DATS | 8 | |
| LFMAIS | Last pick-up sheet sent by the customer | LFMAIS | CHAR | 20 | |
| MAIDT | Date of last pick-up sheet | MAIDT | DATS | 8 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| HANDLE | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | |
| SESSION_CREATION_DATE | Date of the Session During Which the Record Was Created | SESSION_CREATION_DATE | DATS | 8 | |
| SESSION_CREATION_TIME | Time of the Session During Which the Record Was Created | SESSION_CREATION_TIME | TIMS | 6 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| DUMMY_SCHEDGAGRMT_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| EDI_SOAP_MSGID | UUID in character form | SYSUUID_C | CHAR | 32 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBLB
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBLB | ABLLI | C: C | VBLB |
| VBLB | HIFFZLI | C: CN | VBLB |
| VBLB | HILFZLI | C: CN | VBLB |
| VBLB | HIMFZLI | C: CN | VBLB |
| VBLB | LFNKD | C: CN | LIKP |
| VBLB | MANDT | 1: CN | T000 |