SAP Table VBLB

Sales document: Release order data

VBLB (Sales document: Release order data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBLB to other SAP tables.

VBLB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Sales Document VBELN_VA VBUK CHAR 10 0
POSNR Sales Document Item POSNR_VA VBUP NUMC 6 0
ABRLI Internal delivery schedule number ABRLI NUMC 4 0
ABART Release type ABART CHAR 1 0
NULL Order
1 Forecast dlv. sched.
2 JIT delivery schedule
3 Issue for external agent (only in delivery)
4 Returns for scheduling agreemnt w/ release (only in dlvy)
5 Planning delivery schedule
6 Delivery order (only in the delivery)
7 Returns for delivery order (only in delivery)
DOCNUM IDoc number EDI_DOCNUM NUMC 16 0
ABEFZ Cumulative Quantity Received by Customer ABKFZ QUAN 15 3
ABRAB Dlv. sched. valid from ABRAB DATS 8 0
ABRBI SA rel. valid to ABRBI DATS 8 0
LABNK Customer number for forecast / JIT dlv. sched. LABNK CHAR 17 0
ABRDT Delivery Schedule Date ABRDT DATS 8 0
TERSL Date key for schedule line dates TERSL CHAR 1 0
NULL Date of arrival at customer
V Date of departure from vendor
S Date of arrival at collecting point
P Planning preview
T Scheduling for the day
K Short term info
LFDKD Date of last delivery posted by the customer LFDKD DATS 8 0
LFNKD Last delivery confirmed by the customer LFNKD LIKP CHAR 10 0
ABFDA Start of production go-ahead ABFDA DATS 8 0
ABFDE End of production go-ahead ABFDE DATS 8 0
ABMDA Start of material go-ahead ABMDA DATS 8 0
ABMDE End of material go-ahead ABMDE DATS 8 0
ABLLI Last internal release order number ABLLI VBLB NUMC 4 0
HIFFZ Highest cumulative production go-ahead quantity HIFFZ QUAN 15 3
HIFFZLI Internal schedule no.for highest prod.go-ahead cml.qty HIFFZLI VBLB NUMC 4 0
HIMFZ Highest cumulative material go-ahead quantity HIMFZ QUAN 15 3
HIMFZLI Internal schedule number for highest mat.go-ahead cml.qty HIMFZLI VBLB NUMC 4 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZEI Entry time ERZET TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
HILFZ Highest delivery go-ahead cumulative quantity HILFZ QUAN 15 3
HILFZLI Internal schedule number for highest dlv.go-ahead cml.qty HILFZLI VBLB NUMC 4 0
ABHOR JIT horizon ABHOR DATS 8 0
GJKUN Customer fiscal year GJKUN NUMC 4 0
VJKUN Customer fiscal year which is not yet closed VJKUN NUMC 4 0
AKMFZ Actual cumulative material go-ahead quantity AKMFZ QUAN 15 3
AKFFZ Actual cumulative production go-ahead quantity AKFFZ QUAN 15 3
AKLFZ Actual cumulative delivery go-ahead quantity AKLFZ QUAN 15 3
KRITB Key for high priority stock KRITB CHAR 1 0
LABKY Requirements status key BSTAS CHAR 1 0
VBRST Customer point of consumption VBRST CHAR 14 0
EDLLS Last dlv. note sent by ext. service agent to the customer LFEDL CHAR 20 0
EDLDT Date of last delivery sent by external agent to customer EDLDT DATS 8 0
LFMKD Last delivery quantity received by the customer LFMKD QUAN 13 3
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
USR01 Additional data field 1 for delivery schedules USR01_D CHAR 35 0
USR02 Additional data field 2 for delivery schedules USR02_D CHAR 35 0
USR03 Additional data field 3 for delivery schedules USR03_D CHAR 35 0
USR04 Additional data field 4 for delivery schedules USR04_D CHAR 10 0
USR05 Additional data field 5 for delivery schedules USR05_D CHAR 10 0
CYEFZ Cumulative quantity reached on date zero setting made CYEFZ QUAN 15 3
CYDAT Date on which cumulative received quantity set to zero CYDAT DATS 8 0
MFLAUF Material go-ahead - validity period MFLAUF NUMC 3 0
MFEIN Material go-ahead - unit validity period MFEIN CHAR 1 0
1 Day
2 Week
3 Month
FFLAUF Production go-ahead - validity period FFLAUF NUMC 3 0
FFEIN Production go-ahead - Unit validity period FFEIN CHAR 1 0
1 Day
2 Week
3 Month
ABRDT_ORG Delivery schedule date of creation ABRDT_ORG DATS 8 0
LFMAIS Last pick-up sheet sent by the customer LFMAIS CHAR 20 0
MAIDT Date of last pick-up sheet MAIDT DATS 8 0
AEDAT Changed On AEDAT DATS 8 0

VBLB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBLB ABLLI VBLB ABART VBLB Sales document: Release order data ABART
VBLB ABLLI VBLB MANDT VBLB Sales document: Release order data MANDT
VBLB ABLLI VBLB VBELN VBLB Sales document: Release order data VBELN
VBLB ABLLI VBLB POSNR VBLB Sales document: Release order data POSNR
VBLB ABLLI VBLB ABLLI VBLB Sales document: Release order data ABRLI
VBLB HIFFZLI VBLB ABART VBLB Sales document: Release order data ABART
VBLB HIFFZLI VBLB MANDT VBLB Sales document: Release order data MANDT
VBLB HIFFZLI VBLB VBELN VBLB Sales document: Release order data VBELN
VBLB HIFFZLI VBLB POSNR VBLB Sales document: Release order data POSNR
VBLB HIFFZLI VBLB HIFFZLI VBLB Sales document: Release order data ABRLI
VBLB HILFZLI VBLB MANDT VBLB Sales document: Release order data MANDT
VBLB HILFZLI VBLB VBELN VBLB Sales document: Release order data VBELN
VBLB HILFZLI VBLB POSNR VBLB Sales document: Release order data POSNR
VBLB HILFZLI VBLB HILFZLI VBLB Sales document: Release order data ABRLI
VBLB HILFZLI VBLB ABART VBLB Sales document: Release order data ABART
VBLB HIMFZLI VBLB MANDT VBLB Sales document: Release order data MANDT
VBLB HIMFZLI VBLB VBELN VBLB Sales document: Release order data VBELN
VBLB HIMFZLI VBLB POSNR VBLB Sales document: Release order data POSNR
VBLB HIMFZLI VBLB HIMFZLI VBLB Sales document: Release order data ABRLI
VBLB HIMFZLI VBLB ABART VBLB Sales document: Release order data ABART
VBLB LFNKD VBLB MANDT LIKP SD Document: Delivery Header Data MANDT
VBLB LFNKD VBLB LFNKD LIKP SD Document: Delivery Header Data VBELN
VBLB MANDT VBLB MANDT T000 Clients MANDT
VBLB POSNR VBLB MANDT VBUP Sales Document: Item Status MANDT
VBLB POSNR VBLB VBELN VBUP Sales Document: Item Status VBELN
VBLB POSNR VBLB POSNR VBUP Sales Document: Item Status POSNR
VBLB VBELN VBLB MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBLB VBELN VBLB VBELN VBUK Sales Document: Header Status and Administrative Data VBELN