I_CACHEMRPMFGORDER

CDS View
61 Fields 2 CDS Views

Cache MRP Manufacturing Orders

I_CACHEMRPMFGORDER is a CDS View in S/4HANA. Cache MRP Manufacturing Orders. It contains 61 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_CacheMRPMfgOrder view from CONSUMPTION MRP Manufacturing Orders
I_MRPManufacturingOrder view_entity from COMPOSITE MRP Manufacturing Order

Fields (61)

KeyField CDS FieldsUsed in Views
KEY Material Material 2
KEY MaterialShortageProfile MaterialShortageProfile 2
KEY MaterialShortageProfileCount MaterialShortageProfileCount 2
KEY MRPElement MRPElement 1
KEY MRPElementCategory MRPElementCategory 2
KEY MRPPlanningSegment MRPPlanningSegment 2
KEY MRPPlant MRPPlant 2
_CacheMaterial _CacheMaterial 1
_Material _Material 2
_MfgOrderType _MfgOrderType 1
_MRPPlant _MRPPlant 1
_Order _Order 1
_ProductionPlant _ProductionPlant 1
_ShortageDefinition _ShortageDefinition 1
_StorageLocation _StorageLocation 2
ComponentShortageDefinition ComponentShortageDefinition 2
DurnPlndStatusToTodayInWrkdays DurnPlndStatusToTodayInWrkdays 1
FactoryCalendar FactoryCalendar 2
LateSupplyLatenessWorkdays LateSupplyLatenessWorkdays 2
ManufacturingOrderIsLate ManufacturingOrderIsLate 2
ManufacturingOrderText ManufacturingOrderText 1
ManufacturingOrderType ManufacturingOrderType 2
MaterialBaseUnit MaterialBaseUnit 1
MaterialCompIsProcuredDirectly MaterialCompIsProcuredDirectly 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 2
MaximumDelayDate MaximumDelayDate 1
MaximumDelayInDays MaximumDelayInDays 2
MaximumDelayInWorkdays MaximumDelayInWorkdays 2
MfgOrderActualReleaseDate MfgOrderActualReleaseDate 1
MfgOrderNextStatusPlannedDate MfgOrderNextStatusPlannedDate 2
MfgOrderPlannedEndDate MfgOrderPlannedEndDate 2
MfgOrderPlannedReleaseDate MfgOrderPlannedReleaseDate 2
MfgOrderPlannedStartDate MfgOrderPlannedStartDate 2
MfgOrderPlannedTotalQty MfgOrderPlannedTotalQty 2
MfgOrderProgressNextStatus MfgOrderProgressNextStatus 1
MfgOrderProgressStatus MfgOrderProgressStatus 2
MfgOrderScheduledEndDate MfgOrderScheduledEndDate 1
MfgOrderScheduledReleaseDate MfgOrderScheduledReleaseDate 1
MfgOrderScheduledStartDate MfgOrderScheduledStartDate 1
MfgOrderStatusActualDate MfgOrderStatusActualDate 2
MfgOrderStatusPlannedDate MfgOrderStatusPlannedDate 1
MRPArea MRPArea 2
MRPController MRPController 2
MRPElementAvailyOrRqmtDate MRPElementAvailyOrRqmtDate 1
MRPElementDelayedQuantity MRPElementDelayedQuantity 1
MRPElementOpenQuantity MRPElementOpenQuantity 2
NumberOfUncoveredDemandItems NumberOfUncoveredDemandItems 1
PlanningSegmentDocument PlanningSegmentDocument 1
PlanningSegmentDocumentItem PlanningSegmentDocumentItem 1
ProductionLine ProductionLine 2
ProductionPlant ProductionPlant 2
ProductionSupervisor ProductionSupervisor 2
ProductionUnit ProductionUnit 2
ProductionVersion ProductionVersion 2
ProductionVersionText ProductionVersionText 2
Reservation Reservation 1
StorageLocation StorageLocation 2
UnitOfMeasureDspNmbrOfDcmls UnitOfMeasureDspNmbrOfDcmls 1
UnitOfMeasureNumberOfDecimals UnitOfMeasureNumberOfDecimals 1
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 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.

-- Cache MRP Manufacturing Orders
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CACHEMRPMFGORDER (
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MRPELEMENT,
    MRPELEMENTCATEGORY,
    MRPPLANNINGSEGMENT,
    MRPPLANT,
    _CACHEMATERIAL,
    _MATERIAL,
    _MFGORDERTYPE,
    _MRPPLANT,
    _ORDER,
    _PRODUCTIONPLANT,
    _SHORTAGEDEFINITION,
    _STORAGELOCATION,
    COMPONENTSHORTAGEDEFINITION,
    DURNPLNDSTATUSTOTODAYINWRKDAYS,
    FACTORYCALENDAR,
    LATESUPPLYLATENESSWORKDAYS,
    MANUFACTURINGORDERISLATE,
    MANUFACTURINGORDERTEXT,
    MANUFACTURINGORDERTYPE,
    MATERIALBASEUNIT,
    MATERIALCOMPISPROCUREDDIRECTLY,
    MATERIALGOODSRECEIPTDURATION,
    MAXIMUMDELAYDATE,
    MAXIMUMDELAYINDAYS,
    MAXIMUMDELAYINWORKDAYS,
    MFGORDERACTUALRELEASEDATE,
    MFGORDERNEXTSTATUSPLANNEDDATE,
    MFGORDERPLANNEDENDDATE,
    MFGORDERPLANNEDRELEASEDATE,
    MFGORDERPLANNEDSTARTDATE,
    MFGORDERPLANNEDTOTALQTY,
    MFGORDERPROGRESSNEXTSTATUS,
    MFGORDERPROGRESSSTATUS,
    MFGORDERSCHEDULEDENDDATE,
    MFGORDERSCHEDULEDRELEASEDATE,
    MFGORDERSCHEDULEDSTARTDATE,
    MFGORDERSTATUSACTUALDATE,
    MFGORDERSTATUSPLANNEDDATE,
    MRPAREA,
    MRPCONTROLLER,
    MRPELEMENTAVAILYORRQMTDATE,
    MRPELEMENTDELAYEDQUANTITY,
    MRPELEMENTOPENQUANTITY,
    NUMBEROFUNCOVEREDDEMANDITEMS,
    PLANNINGSEGMENTDOCUMENT,
    PLANNINGSEGMENTDOCUMENTITEM,
    PRODUCTIONLINE,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    PRODUCTIONVERSION,
    PRODUCTIONVERSIONTEXT,
    RESERVATION,
    STORAGELOCATION,
    UNITOFMEASUREDSPNMBROFDCMLS,
    UNITOFMEASURENUMBEROFDECIMALS,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (MATERIAL, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT, MRPELEMENT, MRPELEMENTCATEGORY, MRPPLANNINGSEGMENT, MRPPLANT)
);

Learn More