V_MRP_RESERV

22 Fields 2 CDS Views

Generated Table for View

V_MRP_RESERV is an SAP database table in S/4HANA. Generated Table for View. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
e_mrp_mfg_comps view inner
e_mrp_prod_demands view inner

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
reservation RSNUM Reservation
reservationitem4 RSPOS Item no.
reservationitem6 abap.char
reservationrecordtype RSART Record type
requirementtype BDART RequirementType
material MATNR Material
plant WERKS_D Plant
storagelocation LGORT_D Location
inventoryspecialstocktype SOBKZ Special Stock
salesorder KDAUF Sales Order
salesorderitem KDPOS Sales Ord. Item
wbselementinternalid PS_POSNR WBS Element
requirementdate BDTER Reqmts date
requiredquantity BDMNG Requirement qty
withdrawnquantity ENMNG Withdrawal Qty
materialbaseunit MEINS Base Unit
reservationisfinallyissued KZEAR Final Issue
materialcomponentisphantomitem DUMPS Phantom item
materialisbulkmaterial SCHGT Bulk material
mrpplanningsegmenttype abap.numc
mrpplanningsegmentnumber abap.char

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_MRP_RESERV (
    MANDT,                           -- Client [MANDT]
    RESERVATION,                     -- Reservation [RSNUM]
    RESERVATIONITEM4,                -- Item no. [RSPOS]
    RESERVATIONITEM6,                -- abap.char
    RESERVATIONRECORDTYPE,           -- Record type [RSART]
    REQUIREMENTTYPE,                 -- RequirementType [BDART]
    MATERIAL,                        -- Material [MATNR]
    PLANT,                           -- Plant [WERKS_D]
    STORAGELOCATION,                 -- Location [LGORT_D]
    INVENTORYSPECIALSTOCKTYPE,       -- Special Stock [SOBKZ]
    SALESORDER,                      -- Sales Order [KDAUF]
    SALESORDERITEM,                  -- Sales Ord. Item [KDPOS]
    WBSELEMENTINTERNALID,            -- WBS Element [PS_POSNR]
    REQUIREMENTDATE,                 -- Reqmts date [BDTER]
    REQUIREDQUANTITY,                -- Requirement qty [BDMNG]
    WITHDRAWNQUANTITY,               -- Withdrawal Qty [ENMNG]
    MATERIALBASEUNIT,                -- Base Unit [MEINS]
    RESERVATIONISFINALLYISSUED,      -- Final Issue [KZEAR]
    MATERIALCOMPONENTISPHANTOMITEM,  -- Phantom item [DUMPS]
    MATERIALISBULKMATERIAL,          -- Bulk material [SCHGT]
    MRPPLANNINGSEGMENTTYPE,          -- abap.numc
    MRPPLANNINGSEGMENTNUMBER,        -- abap.char
    PRIMARY KEY (MANDT)
);

Learn More