I_MRPMFGORDERITEM

CDS View
16 Fields 1 CDS Views

MRP Manufacturing Order Item

I_MRPMFGORDERITEM is a CDS View in S/4HANA. MRP Manufacturing Order Item. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CacheMRPMfgOrder view from COMPOSITE Cache MRP Manufacturing Orders

Fields (16)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MRPPlant MRPPlant 1
KEY OrderID MRPElement 1
_Material _Material 1
_MRPPlant _MRPPlant 1
_Order _Order 1
_ProductionPlant _ProductionPlant 1
_StorageLocation _StorageLocation 1
InventorySpecialStockType InventorySpecialStockType 1
MfgOrderItemQtyToBaseQtyDnmntr MfgOrderItemQtyToBaseQtyDnmntr 1
MfgOrderItemQtyToBaseQtyNmrtr MfgOrderItemQtyToBaseQtyNmrtr 1
MRPArea MRPArea 1
OrderIsReleased OrderIsReleased 1
PlannedEndDate MRPElementAvailyOrRqmtDate 1
ProductionPlant ProductionPlant 1
StorageLocation StorageLocation 1

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 Manufacturing Order Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPMFGORDERITEM (
    MATERIAL,
    MRPPLANT,
    ORDERID,
    _MATERIAL,
    _MRPPLANT,
    _ORDER,
    _PRODUCTIONPLANT,
    _STORAGELOCATION,
    INVENTORYSPECIALSTOCKTYPE,
    MFGORDERITEMQTYTOBASEQTYDNMNTR,
    MFGORDERITEMQTYTOBASEQTYNMRTR,
    MRPAREA,
    ORDERISRELEASED,
    PLANNEDENDDATE,
    PRODUCTIONPLANT,
    STORAGELOCATION,
    PRIMARY KEY (MATERIAL, MRPPLANT, ORDERID)
);

Learn More