VBEP

Transparent Table Application Table
78 Fields 21 CDS Views

Sales Document: Schedule Line Data

VBEP is an SAP database table in S/4HANA. Sales Document: Schedule Line Data. It contains 78 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
arun_i_sl_so_sel view from SO selection at Date level
ARUN_I_SO_VBEP_FIELD view inner Date level information for SO
ARUN_SD_DB view inner Sales document data
ARUN_SO_ITEM_QTY view inner Fetch Sup Assgmt status of a sales order
Arun_So_Reqmt view left_outer Sales Order Requirement
ARUN_SO_REQMT_SL view from SO selection at Date level
ARun_ValAddedSrvcSDAvalyDte view left_outer Mat Availability Dates
ARun_ValAddedSrvcSDReqdDte view from Requested Date
ARUN_VBEP_DATE view inner Supply Assignment date calculation
Fcdm_Keyfigures_Read_Custrq view inner Read Cust Rqmt for Fcs Demand Keyfigures
I_ARunMntrItemSD view inner BASIC Basic View for Item data of SD document in ARun Monitor Runs
I_SalesDocumentScheduleLine view from BASIC Sales Document Schedule Line
I_SupDmndAllDocRetSlsOrd view inner BASIC View for Return Sales Orders
P_Fcdm_Keyf_Read_Custrq_Sls view inner BASIC Read Customer sales Forecast Demand Keyfigures
P_RFM_EBAN_ACCASSIGN view inner BASIC CDS view for RFM EBAN SDM
P_SupDmndAllDocSDRqmtType view inner BASIC View for Sales Document Requirement Type
P_SupDmndOvwSDDateBasic view inner BASIC SD Item For Supply Demand Overview
pp_mrp_read_sales_order view inner Read Sales Order
rfm_psst_assign view inner PSST Assignment monitor view
rfm_scc_salesdata_basic_V view inner Salesdata basic view
RFM_SD_SEASONS_BASIC_VIEW view inner RFM Sales Document Seasons Basic View

Fields (78)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY vbeln vbeln_va Sales Document
KEY posnr posnr_va Item
KEY etenr etenr Schedule Line
ettyp ettyp Sched.Line Cat.
lfrel lfrel Item rel.f.dlv.
edatu edatu Delivery Date
ezeit ezeit_vbep Arrival time
wmeng wmeng Order Quantity
bmeng bmeng Confirmed Qty
vrkme vrkme Sales Unit
lmeng lmeng Required Qty
meins meins Base Unit
bddat bddat Requirement dte
bdart bdart RequirementType
plart plart Planning type
vbele vbele Business docum.
posne posne Items
etene etene Schedule line
rsdat rsdat Reservation
idnnr idnnr Maintenance req
banfn banfn Purchase Req.
bsart bsart Order Type
bstyp bstyp Doc. Category
wepos wepos_a Confirm status
repos repos Invoice Receipt
lrgdt lrgdt ReturnPackaging
prgrs prgrs Date type
tddat tddat_d TranspPlngDate
mbdat mbdat Mat.Avail.Date
lddat lddat Loading Date
wadat wadat Goods Issue
cmeng cmeng Corr.qty
lifsp lifsp_ep Delivery Block
grstr grstr GrpDefn of StrucData
abart abart Release type
abruf abruf F. dlv. sched.
roms1 dcqnt Committed qty
roms2 roms2 Size 2
roms3 roms3 Size 3
romei romei Size unit
rform rform VSI Formula
umvkz umvkz Numerator
umvkn umvkn Denominat.
verfp verfp_mas Avail. confirm.
bwart bwart Movement Type
bnfpo bnfpo Requisn. item
etart edi_ettyp Sched.line type
aufnr aufnr Order
plnum plnum Planned Order
sernr sernr BOM expl.number
aeskd aeskd Engin. Change
abges abges_cm Guaranteed
mbuhr mbuhr Matl Staging Tme
tduhr tduhr Tr. Plan. Time
lduhr lduhr Loading Time
wauhr wauhr GI Time
aulwe aulwe Route Schedule
dscontd_indicator dscontd_indicator Dscontn Status
dscontd_source_item dscontd_source_item Source Item
dscontd_source_schedule_line dscontd_source_schedule_line Source Schedule Line
delivery_date_type_rule sd_delivery_date_type_rule Deliv Date Rule
dlvqty_bu dlvqty Delivered Qty
dlvqty_su dlvqty Delivered Qty
ocdqty_bu ocdqty Open Quantity
ocdqty_su ocdqty Open Quantity
ordqty_bu ordqty Open Quantity
ordqty_su ordqty Open Quantity
crea_dlvdate ledat Delivery Date
req_dlvdate edatu Delivery Date
bedar bedar Reqmts Class
_dataaging data_temperature Data Aging
waerk waerk Doc. Currency
odn_amount tdd_odn_amount Open Delivery Amount
handle guid_16 GUID 16
lccst tdd_lccst Legal Status
rrqqty_bu tdd_rrqqty_bu Reqd Rqmt Qty
crqqty_bu tdd_crqqty_bu Confd Rqmt Qty

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: Schedule Line Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBEP (
    MANDT,                         -- Client [mandt]
    VBELN,                         -- Sales Document [vbeln_va]
    POSNR,                         -- Item [posnr_va]
    ETENR,                         -- Schedule Line [etenr]
    ETTYP,                         -- Sched.Line Cat. [ettyp]
    LFREL,                         -- Item rel.f.dlv. [lfrel]
    EDATU,                         -- Delivery Date [edatu]
    EZEIT,                         -- Arrival time [ezeit_vbep]
    WMENG,                         -- Order Quantity [wmeng]
    BMENG,                         -- Confirmed Qty [bmeng]
    VRKME,                         -- Sales Unit [vrkme]
    LMENG,                         -- Required Qty [lmeng]
    MEINS,                         -- Base Unit [meins]
    BDDAT,                         -- Requirement dte [bddat]
    BDART,                         -- RequirementType [bdart]
    PLART,                         -- Planning type [plart]
    VBELE,                         -- Business docum. [vbele]
    POSNE,                         -- Items [posne]
    ETENE,                         -- Schedule line [etene]
    RSDAT,                         -- Reservation [rsdat]
    IDNNR,                         -- Maintenance req [idnnr]
    BANFN,                         -- Purchase Req. [banfn]
    BSART,                         -- Order Type [bsart]
    BSTYP,                         -- Doc. Category [bstyp]
    WEPOS,                         -- Confirm status [wepos_a]
    REPOS,                         -- Invoice Receipt [repos]
    LRGDT,                         -- ReturnPackaging [lrgdt]
    PRGRS,                         -- Date type [prgrs]
    TDDAT,                         -- TranspPlngDate [tddat_d]
    MBDAT,                         -- Mat.Avail.Date [mbdat]
    LDDAT,                         -- Loading Date [lddat]
    WADAT,                         -- Goods Issue [wadat]
    CMENG,                         -- Corr.qty [cmeng]
    LIFSP,                         -- Delivery Block [lifsp_ep]
    GRSTR,                         -- GrpDefn of StrucData [grstr]
    ABART,                         -- Release type [abart]
    ABRUF,                         -- F. dlv. sched. [abruf]
    ROMS1,                         -- Committed qty [dcqnt]
    ROMS2,                         -- Size 2 [roms2]
    ROMS3,                         -- Size 3 [roms3]
    ROMEI,                         -- Size unit [romei]
    RFORM,                         -- VSI Formula [rform]
    UMVKZ,                         -- Numerator [umvkz]
    UMVKN,                         -- Denominat. [umvkn]
    VERFP,                         -- Avail. confirm. [verfp_mas]
    BWART,                         -- Movement Type [bwart]
    BNFPO,                         -- Requisn. item [bnfpo]
    ETART,                         -- Sched.line type [edi_ettyp]
    AUFNR,                         -- Order [aufnr]
    PLNUM,                         -- Planned Order [plnum]
    SERNR,                         -- BOM expl.number [sernr]
    AESKD,                         -- Engin. Change [aeskd]
    ABGES,                         -- Guaranteed [abges_cm]
    MBUHR,                         -- Matl Staging Tme [mbuhr]
    TDUHR,                         -- Tr. Plan. Time [tduhr]
    LDUHR,                         -- Loading Time [lduhr]
    WAUHR,                         -- GI Time [wauhr]
    AULWE,                         -- Route Schedule [aulwe]
    DSCONTD_INDICATOR,             -- Dscontn Status [dscontd_indicator]
    DSCONTD_SOURCE_ITEM,           -- Source Item [dscontd_source_item]
    DSCONTD_SOURCE_SCHEDULE_LINE,  -- Source Schedule Line [dscontd_source_schedule_line]
    DELIVERY_DATE_TYPE_RULE,       -- Deliv Date Rule [sd_delivery_date_type_rule]
    DLVQTY_BU,                     -- Delivered Qty [dlvqty]
    DLVQTY_SU,                     -- Delivered Qty [dlvqty]
    OCDQTY_BU,                     -- Open Quantity [ocdqty]
    OCDQTY_SU,                     -- Open Quantity [ocdqty]
    ORDQTY_BU,                     -- Open Quantity [ordqty]
    ORDQTY_SU,                     -- Open Quantity [ordqty]
    CREA_DLVDATE,                  -- Delivery Date [ledat]
    REQ_DLVDATE,                   -- Delivery Date [edatu]
    BEDAR,                         -- Reqmts Class [bedar]
    _DATAAGING,                    -- Data Aging [data_temperature]
    WAERK,                         -- Doc. Currency [waerk]
    ODN_AMOUNT,                    -- Open Delivery Amount [tdd_odn_amount]
    HANDLE,                        -- GUID 16 [guid_16]
    LCCST,                         -- Legal Status [tdd_lccst]
    RRQQTY_BU,                     -- Reqd Rqmt Qty [tdd_rrqqty_bu]
    CRQQTY_BU,                     -- Confd Rqmt Qty [tdd_crqqty_bu]
    PRIMARY KEY (MANDT, VBELN, POSNR, ETENR)
);

Learn More