VBLB

Transparent Table Application Table
62 Fields 2 CDS Views

Sales document: Release order data

VBLB is an SAP database table in S/4HANA. Sales document: Release order data. It contains 62 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SalesSchedgAgrmtDelivSched view from EXTENSION Sales Scheduling Agreement Delivery Schedule Extension
I_SalesSchedgAgrmtDelivSched view from BASIC Delivery Schedule of Sales Scheduling Agreement

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY vbeln vbeln_va Sales Document
KEY posnr posnr_va Item
KEY abrli abrli Int.dlv.scd.no.
KEY abart abart Release type
docnum edi_docnum IDoc number
abefz abkfz CmlQtyReceived
abrab abrab Valid from
abrbi abrbi Valid to
labnk labnk Dlv.sched.
abrdt abrdt Dlv.sched.date
tersl tersl Date key
lfdkd lfdkd Date/last del.
lfnkd lfnkd Last delivery
abfda abfda StartPrdGoAhead
abfde abfde End PrdGoAhead
abmda abmda StartMatGoAhead
abmde abmde End MatGoAhead
ablli ablli Last rel.order
hiffz hiffz HighestCmlPrGQt
hiffzli hiffzli SchedProdCmlQty
himfz himfz HghstCmlMatQty
himfzli himfzli Sched-MatCmlQty
erdat erdat Created On
erzei erzet Time
ernam ernam Created By
hilfz hilfz Hghst DGACmlQty
hilfzli hilfzli Sched.DGACmlQty
abhor abhor JIT horizon
gjkun gjkun Cst.fiscal year
vjkun vjkun Previous year
akmfz akmfz ActlCMatGoAhQty
akffz akffz ActlCProdGoAQty
aklfz aklfz ActlCDlvGoAhQty
kritb kritb HighPriorStock
labky bstas Req.status key
vbrst vbrst Pt of consumptn
edlls lfedl Last dlv.-ESAgt
edldt edldt Ext.agent date
lfmkd lfmkd Last dlv.qty
umvkz umvkz Numerator
umvkn umvkn Denominat.
usr01 usr01_d Data 1
usr02 usr02_d Data 2
usr03 usr03_d Data 3
usr04 usr04_d Data 4
usr05 usr05_d Data 5
cyefz cyefz Cum.qty at zero
cydat cydat CRQ set to zero
mflauf mflauf MatlGoAhead Val
mfein mfein MatlGoAheadUnit
fflauf fflauf ProdGoAhd-ValPd
ffein ffein PrGoAhead Unit
abrdt_org abrdt_org Dlv.sched.date
lfmais lfmais Pick-up sheet
maidt maidt PUS date
aedat aedat Changed On
handle guid_32 GUID 16
session_creation_date session_creation_date Session Created On
session_creation_time session_creation_time Session Created At
_dataaging data_temperature Data Aging
edi_soap_msgid sysuuid_c UUID

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales document: Release order data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBLB (
    MANDT,                  -- Client [mandt]
    VBELN,                  -- Sales Document [vbeln_va]
    POSNR,                  -- Item [posnr_va]
    ABRLI,                  -- Int.dlv.scd.no. [abrli]
    ABART,                  -- Release type [abart]
    DOCNUM,                 -- IDoc number [edi_docnum]
    ABEFZ,                  -- CmlQtyReceived [abkfz]
    ABRAB,                  -- Valid from [abrab]
    ABRBI,                  -- Valid to [abrbi]
    LABNK,                  -- Dlv.sched. [labnk]
    ABRDT,                  -- Dlv.sched.date [abrdt]
    TERSL,                  -- Date key [tersl]
    LFDKD,                  -- Date/last del. [lfdkd]
    LFNKD,                  -- Last delivery [lfnkd]
    ABFDA,                  -- StartPrdGoAhead [abfda]
    ABFDE,                  -- End PrdGoAhead [abfde]
    ABMDA,                  -- StartMatGoAhead [abmda]
    ABMDE,                  -- End MatGoAhead [abmde]
    ABLLI,                  -- Last rel.order [ablli]
    HIFFZ,                  -- HighestCmlPrGQt [hiffz]
    HIFFZLI,                -- SchedProdCmlQty [hiffzli]
    HIMFZ,                  -- HghstCmlMatQty [himfz]
    HIMFZLI,                -- Sched-MatCmlQty [himfzli]
    ERDAT,                  -- Created On [erdat]
    ERZEI,                  -- Time [erzet]
    ERNAM,                  -- Created By [ernam]
    HILFZ,                  -- Hghst DGACmlQty [hilfz]
    HILFZLI,                -- Sched.DGACmlQty [hilfzli]
    ABHOR,                  -- JIT horizon [abhor]
    GJKUN,                  -- Cst.fiscal year [gjkun]
    VJKUN,                  -- Previous year [vjkun]
    AKMFZ,                  -- ActlCMatGoAhQty [akmfz]
    AKFFZ,                  -- ActlCProdGoAQty [akffz]
    AKLFZ,                  -- ActlCDlvGoAhQty [aklfz]
    KRITB,                  -- HighPriorStock [kritb]
    LABKY,                  -- Req.status key [bstas]
    VBRST,                  -- Pt of consumptn [vbrst]
    EDLLS,                  -- Last dlv.-ESAgt [lfedl]
    EDLDT,                  -- Ext.agent date [edldt]
    LFMKD,                  -- Last dlv.qty [lfmkd]
    UMVKZ,                  -- Numerator [umvkz]
    UMVKN,                  -- Denominat. [umvkn]
    USR01,                  -- Data 1 [usr01_d]
    USR02,                  -- Data 2 [usr02_d]
    USR03,                  -- Data 3 [usr03_d]
    USR04,                  -- Data 4 [usr04_d]
    USR05,                  -- Data 5 [usr05_d]
    CYEFZ,                  -- Cum.qty at zero [cyefz]
    CYDAT,                  -- CRQ set to zero [cydat]
    MFLAUF,                 -- MatlGoAhead Val [mflauf]
    MFEIN,                  -- MatlGoAheadUnit [mfein]
    FFLAUF,                 -- ProdGoAhd-ValPd [fflauf]
    FFEIN,                  -- PrGoAhead Unit [ffein]
    ABRDT_ORG,              -- Dlv.sched.date [abrdt_org]
    LFMAIS,                 -- Pick-up sheet [lfmais]
    MAIDT,                  -- PUS date [maidt]
    AEDAT,                  -- Changed On [aedat]
    HANDLE,                 -- GUID 16 [guid_32]
    SESSION_CREATION_DATE,  -- Session Created On [session_creation_date]
    SESSION_CREATION_TIME,  -- Session Created At [session_creation_time]
    _DATAAGING,             -- Data Aging [data_temperature]
    EDI_SOAP_MSGID,         -- UUID [sysuuid_c]
    PRIMARY KEY (MANDT, VBELN, POSNR, ABRLI, ABART)
);

Learn More