I_CACHEMATERIAL

CDS View
29 Fields 6 CDS Views

MRP Cache Material

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_MaterialCoverage view inner COMPOSITE MRP Material Coverage
I_MRPAvailability view inner COMPOSITE MRP Availability of a Material
I_MRPMaterialCoverage view_entity inner COMPOSITE MRP Material Coverage without Supplier
I_MRPProductionDemand view_entity from COMPOSITE MRP Production Demand
I_MRPSalesDemand view from COMPOSITE MRP Sales Demand
I_MRPTransferDemand view_entity from COMPOSITE Transfer Demand

Fields (29)

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

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,
    MRPTYPE,
    PRODUCTIONSUPERVISOR,
    PURCHASINGGROUP,
    TOTALREPLENISHMENTLEADDURATION,
    TOTALREPLNMTLEADDURNENDDATE,
    PRIMARY KEY (FACTORYCALENDAR, MATERIAL, MRPAREA, MRPPLANT)
);

Learn More