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 | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
FFLAUF
Production go-ahead - validity period
|
FFLAUF |
NUMC
|
3 | 0 | ||||||||||||||||||||
|
FFEIN
Production go-ahead - Unit validity period
|
FFEIN |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ABLLI |
VBLB
Sales document: Release order data
|
ABRLI |
| 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 | HIFFZLI | VBLB | HIFFZLI |
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 | HILFZLI | VBLB | HILFZLI |
VBLB
Sales document: Release order data
|
ABRLI |
| VBLB | HILFZLI | VBLB | ABART |
VBLB
Sales document: Release order data
|
ABART |
| 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 | HIMFZLI | 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 | 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 | POSNR |
VBUP
Sales Document: Item Status
|
POSNR |
| VBLB | POSNR | VBLB | MANDT |
VBUP
Sales Document: Item Status
|
MANDT |
| VBLB | POSNR | VBLB | VBELN |
VBUP
Sales Document: Item Status
|
VBELN |
| 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 |