VBBE

Transparent Table Application Table
42 Fields 12 CDS Views

Sales Requirements: Individual Records

VBBE is an SAP database table in S/4HANA. Sales Requirements: Individual Records. It contains 42 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
Arun_Open_Delivery_C view from Supply Assignment open deliveries
Arun_Open_Delivery_C view inner Supply Assignment open deliveries
Atpc_Cds_Vbbe view from CDS View on VBBE Table for ATP
atpc_dvol_peak_creation_tstmp view inner Data Volume for Peaks with Creation Timestamp
I_JITSalesRequirementsBasic view from BASIC JIT Sales Requirements
I_SupDmndAllDocOpenDeliveries view inner BASIC View for Open Deliveries
I_SupDmndOpenDelivery view from BASIC Basic View for Deliveries
I_SupDmndOvwOpenDeliveries view from BASIC Basic View for Open Deliveries
PPH_E_VBBE_1 view from
PPH_E_VBBE_AGG_1 view from
R_SDScheduleLineWthOpenRqmtQty view_entity from BASIC Schedule Line With Open Rqmt Qty for SD
SHSM_RMVBBE view from CDS Search Help for Sales Order replacing RMVBBE

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vbeln VBELN_VA Sales Document
KEY posnr POSNR_VA Item
KEY etenr ETENR Schedule Line
matnr MATNR Material
werks WERKS_D Plant
berid BERID MRP Area
mbdat MBDAT Mat.Avail.Date
lgort LGORT_D Location
charg CHARG_D Batch
vbtyp VBTYPL Document Cat.
bdart BDART RequirementType
plart PLART Planning type
omeng OMENG Open Quantity
vmeng VMENG Qty.f.avail.chk
meins MEINS Base Unit
vbele VBELE Business docum.
posne POSNE Items
etene ETENE Schedule line
awahr AWAHR Order Probab.
auart AUART Sales Doc. Type
projn PROJN not in use
kunnr KUNAG Sold-to Party
nodis NODIS No MRP
vpzuo VPZUO Allocation Ind.
vpmat VPMAT Plng material
vpwrk VPWRK Planning Plant
prbme PRBME Prod. grp unit
umref UMREFF Conversion
pzmng PZMNG Planned qty
knttp KNTTP Acct Assgmt Cat
sobkz SOBKZ Special Stock
kzvbr KZVBR Consumption
sernr SERNR BOM expl.number
pspel PS_POSNR WBS Element
plnkz PLNKZ Planning ind.
cuobj CUOBJ_VA Configuration
monkz MONKZ Assembly Orders
kzbws KZBWS Valuation
techs TECHS StandardVariant
sgt_rcat SGT_RCAT Req. Segment
fsh_ralloc_qty FSH_RALLOC_QTY Alloc. 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 Requirements: Individual Records
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBBE (
    MANDT,           -- Client [MANDT]
    VBELN,           -- Sales Document [VBELN_VA]
    POSNR,           -- Item [POSNR_VA]
    ETENR,           -- Schedule Line [ETENR]
    MATNR,           -- Material [MATNR]
    WERKS,           -- Plant [WERKS_D]
    BERID,           -- MRP Area [BERID]
    MBDAT,           -- Mat.Avail.Date [MBDAT]
    LGORT,           -- Location [LGORT_D]
    CHARG,           -- Batch [CHARG_D]
    VBTYP,           -- Document Cat. [VBTYPL]
    BDART,           -- RequirementType [BDART]
    PLART,           -- Planning type [PLART]
    OMENG,           -- Open Quantity [OMENG]
    VMENG,           -- Qty.f.avail.chk [VMENG]
    MEINS,           -- Base Unit [MEINS]
    VBELE,           -- Business docum. [VBELE]
    POSNE,           -- Items [POSNE]
    ETENE,           -- Schedule line [ETENE]
    AWAHR,           -- Order Probab. [AWAHR]
    AUART,           -- Sales Doc. Type [AUART]
    PROJN,           -- not in use [PROJN]
    KUNNR,           -- Sold-to Party [KUNAG]
    NODIS,           -- No MRP [NODIS]
    VPZUO,           -- Allocation Ind. [VPZUO]
    VPMAT,           -- Plng material [VPMAT]
    VPWRK,           -- Planning Plant [VPWRK]
    PRBME,           -- Prod. grp unit [PRBME]
    UMREF,           -- Conversion [UMREFF]
    PZMNG,           -- Planned qty [PZMNG]
    KNTTP,           -- Acct Assgmt Cat [KNTTP]
    SOBKZ,           -- Special Stock [SOBKZ]
    KZVBR,           -- Consumption [KZVBR]
    SERNR,           -- BOM expl.number [SERNR]
    PSPEL,           -- WBS Element [PS_POSNR]
    PLNKZ,           -- Planning ind. [PLNKZ]
    CUOBJ,           -- Configuration [CUOBJ_VA]
    MONKZ,           -- Assembly Orders [MONKZ]
    KZBWS,           -- Valuation [KZBWS]
    TECHS,           -- StandardVariant [TECHS]
    SGT_RCAT,        -- Req. Segment [SGT_RCAT]
    FSH_RALLOC_QTY,  -- Alloc. Qty [FSH_RALLOC_QTY]
    PRIMARY KEY (MANDT, VBELN, POSNR, ETENR)
);

Learn More