V_PEG_MDRS2

52 Fields 1 CDS Views

Generated Table for View

V_PEG_MDRS2 is an SAP database table in S/4HANA. Generated Table for View. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
cds_peg_mdrs2 view from

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rsnum RSNUM Reservation
KEY rspos RSPOS Item no.
KEY rsart RSART Record type
bdart BDART RequirementType
schgt SCHGT Bulk material
txtps TXTPS Text Item
dumps DUMPS Phantom item
dbskz DBSKZ Direct procure.
xloek XLOEK Deleted
kzear KZEAR Final Issue
matnr MATNR Material
werks WERKS_D Plant
charg CHARG_D Batch
knttp KNTTP Acct Assgmt Cat
sobkz SOBKZ Special Stock
kzvbr KZVBR Consumption
bdter BDTER Reqmts date
bdmng BDMNG Requirement qty
meins MEINS Base Unit
shkzg SHKZG Debit/Credit
enmng ENMNG Withdrawal Qty
baugr BAUGR Pegged Reqmt
kdein KDEIN SOrder schedule
pspel PS_POSNR WBS Element
plnum PLNUM Planned Order
banfn BANFN Purchase Req.
bnfpo BNFPO Requisn. item
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
ebele EETEN Schedule Line
aufnr AUFNR Order
aufps AUFPS Order item no.
umwrk UMWRK Receiving plant
kzaus AUSLF Discontin.Type
nfeag CS_NFEAG Discont. group
nfgrp CS_NFGRP Follow-up group
nfpkz CS_KZNFP Follow-Up Item
nafkz NAFKZ FollowUp MatInd
nomng NOMNG Input Quantity
nomat NOMAT FollUp/OrigMat.
sbter SBTER Latest req.date
ndisp NO_DISP_PLUS Eff. mat. plng
stlnr STNUM BOM
pbdnr PBDNR Requirements Plan
umrez UMREZ Numerator
umren UMREN Denominator
erfme ERFME Unit of Entry
erfmg ERFMG Quantity in UnE
vorab VORABKZ Prelim. order
aufpl CO_AUFPL Plan No.f.Oper.
aplzl CIM_COUNT Counter

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_PEG_MDRS2 (
    MANDT,  -- Client [MANDT]
    RSNUM,  -- Reservation [RSNUM]
    RSPOS,  -- Item no. [RSPOS]
    RSART,  -- Record type [RSART]
    BDART,  -- RequirementType [BDART]
    SCHGT,  -- Bulk material [SCHGT]
    TXTPS,  -- Text Item [TXTPS]
    DUMPS,  -- Phantom item [DUMPS]
    DBSKZ,  -- Direct procure. [DBSKZ]
    XLOEK,  -- Deleted [XLOEK]
    KZEAR,  -- Final Issue [KZEAR]
    MATNR,  -- Material [MATNR]
    WERKS,  -- Plant [WERKS_D]
    CHARG,  -- Batch [CHARG_D]
    KNTTP,  -- Acct Assgmt Cat [KNTTP]
    SOBKZ,  -- Special Stock [SOBKZ]
    KZVBR,  -- Consumption [KZVBR]
    BDTER,  -- Reqmts date [BDTER]
    BDMNG,  -- Requirement qty [BDMNG]
    MEINS,  -- Base Unit [MEINS]
    SHKZG,  -- Debit/Credit [SHKZG]
    ENMNG,  -- Withdrawal Qty [ENMNG]
    BAUGR,  -- Pegged Reqmt [BAUGR]
    KDEIN,  -- SOrder schedule [KDEIN]
    PSPEL,  -- WBS Element [PS_POSNR]
    PLNUM,  -- Planned Order [PLNUM]
    BANFN,  -- Purchase Req. [BANFN]
    BNFPO,  -- Requisn. item [BNFPO]
    EBELN,  -- Purchasing Doc. [EBELN]
    EBELP,  -- Item [EBELP]
    EBELE,  -- Schedule Line [EETEN]
    AUFNR,  -- Order [AUFNR]
    AUFPS,  -- Order item no. [AUFPS]
    UMWRK,  -- Receiving plant [UMWRK]
    KZAUS,  -- Discontin.Type [AUSLF]
    NFEAG,  -- Discont. group [CS_NFEAG]
    NFGRP,  -- Follow-up group [CS_NFGRP]
    NFPKZ,  -- Follow-Up Item [CS_KZNFP]
    NAFKZ,  -- FollowUp MatInd [NAFKZ]
    NOMNG,  -- Input Quantity [NOMNG]
    NOMAT,  -- FollUp/OrigMat. [NOMAT]
    SBTER,  -- Latest req.date [SBTER]
    NDISP,  -- Eff. mat. plng [NO_DISP_PLUS]
    STLNR,  -- BOM [STNUM]
    PBDNR,  -- Requirements Plan [PBDNR]
    UMREZ,  -- Numerator [UMREZ]
    UMREN,  -- Denominator [UMREN]
    ERFME,  -- Unit of Entry [ERFME]
    ERFMG,  -- Quantity in UnE [ERFMG]
    VORAB,  -- Prelim. order [VORABKZ]
    AUFPL,  -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,  -- Counter [CIM_COUNT]
    PRIMARY KEY (MANDT, RSNUM, RSPOS, RSART)
);

Learn More