I_CACHEMATERIAL

CDS View
28 Fields 3 CDS Views

MRP Cache Material

I_CACHEMATERIAL is a CDS View in S/4HANA. MRP Cache Material. It contains 28 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MaterialCoverage view inner COMPOSITE MRP Material Coverage
I_MRPAvailability view inner COMPOSITE MRP Availability of a Material
I_MRPSalesDemand view from COMPOSITE MRP Sales Demand

Fields (28)

KeyField CDS FieldsUsed in Views
KEY FactoryCalendar FactoryCalendar 2
KEY Material Material 1
KEY MRPArea MRPArea 1
KEY MRPPlant MRPPlant 1
LastBufferUpdateDateTime LastBufferUpdateDateTime 1
ManualPlanningHorizonEndDate ManualPlanningHorizonEndDate 2
MaterialABCClassification MaterialABCClassification 1
MaterialBaseUnit MaterialBaseUnit 3
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 1
MaterialGroup MaterialGroup 1
MaterialGroupName MaterialGroupName 1
MaterialName MaterialName 1
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 1
MaterialPlannedProductionDurn MaterialPlannedProductionDurn 1
MaterialProcurementCategory MaterialProcurementCategory 2
MaterialProcurementProfile MaterialProcurementProfile 1
MaterialReplnmtLeadDurnEndDate MaterialReplnmtLeadDurnEndDate 2
MaterialSafetyStockQty MaterialSafetyStockQty 1
MaterialType MaterialType 1
MaterialTypeName MaterialTypeName 1
MRPController MRPController 2
MRPGroup MRPGroup 1
MRPSafetyDuration MRPSafetyDuration 1
MRPSafetyDurationEndDate MRPSafetyDurationEndDate 2
ProductionSupervisor ProductionSupervisor 1
PurchasingGroup PurchasingGroup 1
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration 1
TotalReplnmtLeadDurnEndDate TotalReplnmtLeadDurnEndDate 2

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 Cache Material
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CACHEMATERIAL (
    FACTORYCALENDAR,
    MATERIAL,
    MRPAREA,
    MRPPLANT,
    LASTBUFFERUPDATEDATETIME,
    MANUALPLANNINGHORIZONENDDATE,
    MATERIALABCCLASSIFICATION,
    MATERIALBASEUNIT,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    MATERIALNAME,
    MATERIALPLANNEDDELIVERYDURN,
    MATERIALPLANNEDPRODUCTIONDURN,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALPROCUREMENTPROFILE,
    MATERIALREPLNMTLEADDURNENDDATE,
    MATERIALSAFETYSTOCKQTY,
    MATERIALTYPE,
    MATERIALTYPENAME,
    MRPCONTROLLER,
    MRPGROUP,
    MRPSAFETYDURATION,
    MRPSAFETYDURATIONENDDATE,
    PRODUCTIONSUPERVISOR,
    PURCHASINGGROUP,
    TOTALREPLENISHMENTLEADDURATION,
    TOTALREPLNMTLEADDURNENDDATE,
    PRIMARY KEY (FACTORYCALENDAR, MATERIAL, MRPAREA, MRPPLANT)
);

Learn More