MDTB

Transparent Table Application Table
60 Fields 1 CDS Views

MRP Table

MDTB is an SAP database table in S/4HANA. MRP Table. It contains 60 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
pp_mrp_read_purchase_req view left_outer Deprecated: Replaced by I_MRPPurchaseRequisition

Fields (60)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY dtnum dtnum No. MRP table
KEY dtpos dtpos Itm no.MRP list
plakz plakz Plng segmnt ind
planr planr Plng Segmnt No.
dat00 dat00 Planned dates
sort1 sort1 Sort ind. 01
sort2 sort2 Sort ind. 02
delkz delkz MRP Elmnt Ind.
vstat vstat_d Processing Status
vrfkz vrfkz Availability
plumi plumi Plus/minus
mng01 mng01 Rec./reqd qty
mng02 mng02 Scrap
mng03 mng03 Shortage Quantity
dat01 dat01 Finish date
dat02 dat02 Start date
dat03 dat03 Opening Date
perkz perkz Period Ind.
prper prper Forecast period
webaz webaz GR proc. time
fix01 fix01 Fixed Lot Size
fix02 fix02 Fixed explosion
baart baart P.O./Order type
beskz beskz Procurement
sobes sobes Spec. procuremt
umskz umskz Special G/L Ind
plart plart Planning type
aussl aussl Key
wrk02 wrk02 Pl/pr plnt
lgort lgort_d Location
delnr delnr MRP element number
delps delps MRP elemnt item
delet delet Scheduling
aufvr aufvr Source number
posvr posvr Source item no.
einvr einvr Schedule line
ukz01 ukz01 Bring forward
umdat umdat Rescheduling date
del12 del12 MRP element number
baugr baugr Pegged Reqmt
delvr delkz MRP Elmnt Ind.
versb versb Version
oldsl oldsl 2nd except.msge
rdmng rdmng Excess Stock
plaab plaab MRP segment
tag00 tag00 Daily shift
abekz abekz Exception ind.
mdfst mdfst Status
mdmng mdmng Quantity
verid verid Prod. Version
wrk01 plwrk Planning Plant
sernr sernr BOM expl.number
revlv revlv Revision Level
dbskz dbskz Direct procure.
extnl extnl Ext. Procuremnt
adinf md_adinf Additional Info
reslo reslo Iss. Stor. Loc.
prio_urg prio_urg Reqmt Urgency
prio_req prio_req Reqmt Priority

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.

-- MRP Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDTB (
    MANDT,     -- Client [mandt]
    DTNUM,     -- No. MRP table [dtnum]
    DTPOS,     -- Itm no.MRP list [dtpos]
    PLAKZ,     -- Plng segmnt ind [plakz]
    PLANR,     -- Plng Segmnt No. [planr]
    DAT00,     -- Planned dates [dat00]
    SORT1,     -- Sort ind. 01 [sort1]
    SORT2,     -- Sort ind. 02 [sort2]
    DELKZ,     -- MRP Elmnt Ind. [delkz]
    VSTAT,     -- Processing Status [vstat_d]
    VRFKZ,     -- Availability [vrfkz]
    PLUMI,     -- Plus/minus [plumi]
    MNG01,     -- Rec./reqd qty [mng01]
    MNG02,     -- Scrap [mng02]
    MNG03,     -- Shortage Quantity [mng03]
    DAT01,     -- Finish date [dat01]
    DAT02,     -- Start date [dat02]
    DAT03,     -- Opening Date [dat03]
    PERKZ,     -- Period Ind. [perkz]
    PRPER,     -- Forecast period [prper]
    WEBAZ,     -- GR proc. time [webaz]
    FIX01,     -- Fixed Lot Size [fix01]
    FIX02,     -- Fixed explosion [fix02]
    BAART,     -- P.O./Order type [baart]
    BESKZ,     -- Procurement [beskz]
    SOBES,     -- Spec. procuremt [sobes]
    UMSKZ,     -- Special G/L Ind [umskz]
    PLART,     -- Planning type [plart]
    AUSSL,     -- Key [aussl]
    WRK02,     -- Pl/pr plnt [wrk02]
    LGORT,     -- Location [lgort_d]
    DELNR,     -- MRP element number [delnr]
    DELPS,     -- MRP elemnt item [delps]
    DELET,     -- Scheduling [delet]
    AUFVR,     -- Source number [aufvr]
    POSVR,     -- Source item no. [posvr]
    EINVR,     -- Schedule line [einvr]
    UKZ01,     -- Bring forward [ukz01]
    UMDAT,     -- Rescheduling date [umdat]
    DEL12,     -- MRP element number [del12]
    BAUGR,     -- Pegged Reqmt [baugr]
    DELVR,     -- MRP Elmnt Ind. [delkz]
    VERSB,     -- Version [versb]
    OLDSL,     -- 2nd except.msge [oldsl]
    RDMNG,     -- Excess Stock [rdmng]
    PLAAB,     -- MRP segment [plaab]
    TAG00,     -- Daily shift [tag00]
    ABEKZ,     -- Exception ind. [abekz]
    MDFST,     -- Status [mdfst]
    MDMNG,     -- Quantity [mdmng]
    VERID,     -- Prod. Version [verid]
    WRK01,     -- Planning Plant [plwrk]
    SERNR,     -- BOM expl.number [sernr]
    REVLV,     -- Revision Level [revlv]
    DBSKZ,     -- Direct procure. [dbskz]
    EXTNL,     -- Ext. Procuremnt [extnl]
    ADINF,     -- Additional Info [md_adinf]
    RESLO,     -- Iss. Stor. Loc. [reslo]
    PRIO_URG,  -- Reqmt Urgency [prio_urg]
    PRIO_REQ,  -- Reqmt Priority [prio_req]
    PRIMARY KEY (MANDT, DTNUM, DTPOS)
);

Learn More