I_MATERIALCOVERAGE

CDS View
46 Fields

MRP Material Coverage

I_MATERIALCOVERAGE is a CDS View in S/4HANA. MRP Material Coverage. It contains 46 fields.

Fields (46)

KeyField CDS FieldsUsed in Views
KEY FactoryCalendar FactoryCalendar 1
KEY Material Material 1
KEY MaterialShortageProfile MaterialShortageProfile 1
KEY MaterialShortageProfileCount MaterialShortageProfileCount 1
KEY MRPArea MRPArea 1
KEY MRPPlanningSegment MRPPlanningSegment 1
KEY MRPPlanningSegmentType MRPPlanningSegmentType 1
KEY MRPPlant MRPPlant 1
AvailabilityChart AvailabilityChart 1
EvaluationHorizonInDays EvaluationHorizonInDays 1
HasMaterialShortageReplnmtLead HasMaterialShortageReplnmtLead 1
HasShortageManualPlanHorizon HasShortageManualPlanHorizon 1
HasShortageMRPSafetyDuration HasShortageMRPSafetyDuration 1
HasShortageTotalReplnmtLead HasShortageTotalReplnmtLead 1
ManualPlanningHorizonEndDate ManualPlanningHorizonEndDate 1
MaterialABCClassification MaterialABCClassification 1
MaterialBaseUnit MaterialBaseUnit 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 1
MaterialGroup MaterialGroup 1
MaterialGroupName MaterialGroupName 1
MaterialName MaterialName 1
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 1
MaterialPlannedProductionDurn MaterialPlannedProductionDurn 1
MaterialProcurementCategory MaterialProcurementCategory 1
MaterialProcurementProfile MaterialProcurementProfile 1
MaterialReorderPointQty MaterialReorderPointQty 1
MaterialReplnmtLeadDurnEndDate MaterialReplnmtLeadDurnEndDate 1
MaterialSafetyStockQty MaterialSafetyStockQty 1
MaterialShortageDefinitionName MaterialShortageDefinitionName 1
MaterialShortageEndDate MaterialShortageEndDate 1
MaterialShortageStartDate MaterialShortageStartDate 1
MaterialTypeName MaterialTypeName 1
MRPAvailableStockQty MRPAvailableStockQty 1
MRPController MRPController 1
MRPGroup MRPGroup 1
MRPPlanningSegmentExternalCode MRPPlanningSegmentExternalCode 1
MRPSafetyDuration MRPSafetyDuration 1
MRPSafetyDurationEndDate MRPSafetyDurationEndDate 1
MRPSafetyStockMethod MRPSafetyStockMethod 1
MRPType MRPType 1
NumberOfSupplier NumberOfSupplier 1
PlanningTimeFenceInDays PlanningTimeFenceInDays 1
PurchasingGroup PurchasingGroup 1
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration 1
TotalReplnmtLeadDurnEndDate TotalReplnmtLeadDurnEndDate 1
WeeklyAvailabilityChart WeeklyAvailabilityChart 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 Material Coverage
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALCOVERAGE (
    FACTORYCALENDAR,
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MRPAREA,
    MRPPLANNINGSEGMENT,
    MRPPLANNINGSEGMENTTYPE,
    MRPPLANT,
    AVAILABILITYCHART,
    EVALUATIONHORIZONINDAYS,
    HASMATERIALSHORTAGEREPLNMTLEAD,
    HASSHORTAGEMANUALPLANHORIZON,
    HASSHORTAGEMRPSAFETYDURATION,
    HASSHORTAGETOTALREPLNMTLEAD,
    MANUALPLANNINGHORIZONENDDATE,
    MATERIALABCCLASSIFICATION,
    MATERIALBASEUNIT,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    MATERIALNAME,
    MATERIALPLANNEDDELIVERYDURN,
    MATERIALPLANNEDPRODUCTIONDURN,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALPROCUREMENTPROFILE,
    MATERIALREORDERPOINTQTY,
    MATERIALREPLNMTLEADDURNENDDATE,
    MATERIALSAFETYSTOCKQTY,
    MATERIALSHORTAGEDEFINITIONNAME,
    MATERIALSHORTAGEENDDATE,
    MATERIALSHORTAGESTARTDATE,
    MATERIALTYPENAME,
    MRPAVAILABLESTOCKQTY,
    MRPCONTROLLER,
    MRPGROUP,
    MRPPLANNINGSEGMENTEXTERNALCODE,
    MRPSAFETYDURATION,
    MRPSAFETYDURATIONENDDATE,
    MRPSAFETYSTOCKMETHOD,
    MRPTYPE,
    NUMBEROFSUPPLIER,
    PLANNINGTIMEFENCEINDAYS,
    PURCHASINGGROUP,
    TOTALREPLENISHMENTLEADDURATION,
    TOTALREPLNMTLEADDURNENDDATE,
    WEEKLYAVAILABILITYCHART,
    PRIMARY KEY (FACTORYCALENDAR, MATERIAL, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT, MRPAREA, MRPPLANNINGSEGMENT, MRPPLANNINGSEGMENTTYPE, MRPPLANT)
);

Learn More