I_MRPMATERIALCOVERAGE

CDS View
72 Fields 2 CDS Views

MRP Material Coverage without Supplier

I_MRPMATERIALCOVERAGE is a CDS View in S/4HANA. MRP Material Coverage without Supplier. It contains 72 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MaterialCoverage view from CONSUMPTION MRP Material Coverage Net Segment
C_MRPExtRqmtMaterialOverview view_entity from CONSUMPTION MRP External Requirement Matl Overview

Fields (72)

KeyField CDS FieldsUsed in Views
KEY FactoryCalendar FactoryCalendar 2
KEY Material Material 2
KEY MaterialShortageProfile MaterialShortageProfile 2
KEY MaterialShortageProfileCount MaterialShortageProfileCount 2
KEY MRPArea MRPArea 2
KEY MRPPlanningSegment MRPPlanningSegment 2
KEY MRPPlanningSegmentType MRPPlanningSegmentType 1
KEY MRPPlant MRPPlant 2
_UnitOfMeasure _UnitOfMeasure 1
AvailabilityChart AvailabilityChart 1
DaysOfSupplyCriticality DaysOfSupplyCriticality 1
DaysOfSupplyDuration DaysOfSupplyDuration 2
EvaluationHorizonInDays EvaluationHorizonInDays 1
HasAcceptedShortage HasAcceptedShortage 1
HasShortageManualPlanHorizon HasShortageManualPlanHorizon 1
HasShortageMRPSafetyDuration HasShortageMRPSafetyDuration 1
HasShortageTotalReplnmtLead HasShortageTotalReplnmtLead 1
IntraDaySupplyDuration IntraDaySupplyDuration 1
IsMarkedForDeletion IsMarkedForDeletion 1
IssueCount IssueCount 1
LowLevelCode LowLevelCode 1
ManualPlanningHorizonEndDate ManualPlanningHorizonEndDate 1
MaterialABCClassification MaterialABCClassification 2
MaterialBaseUnit MaterialBaseUnit 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 2
MaterialGroup MaterialGroup 2
MaterialGroupName MaterialGroupName 2
MaterialName MaterialName 2
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 1
MaterialPlannedProductionDurn MaterialPlannedProductionDurn 2
MaterialProcurementCategory MaterialProcurementCategory 2
MaterialProcurementProfile MaterialProcurementProfile 1
MaterialReorderPointQty MaterialReorderPointQty 1
MaterialSafetyStockQty MaterialSafetyStockQty 1
MaterialShortageDefinitionName MaterialShortageDefinitionName 1
MaterialShortageDuration MaterialShortageDuration 1
MaterialShortageDurnInWorkdays MaterialShortageDurnInWorkdays 1
MaterialShortageEndDate MaterialShortageEndDate 2
MaterialShortageQuantity MaterialShortageQuantity 1
MaterialShortageStartDate MaterialShortageStartDate 2
MaterialType MaterialType 2
MaterialTypeName MaterialTypeName 2
MRPAvailableStockQty MRPAvailableStockQty 2
MRPController MRPController 2
MRPGroup MRPGroup 1
MRPMaterialNoteText MRPMaterialNoteText 1
MRPPlanningSegmentExternalCode MRPPlanningSegmentExternalCode 1
MRPResultIsProcessed MRPResultIsProcessed 1
MRPSafetyDuration MRPSafetyDuration 1
MRPSafetyDurationEndDate MRPSafetyDurationEndDate 1
MRPSafetyStockMethod MRPSafetyStockMethod 1
MRPType MRPType 1
MRPValidMaterialStatus MRPValidMaterialStatus 1
NumberOfCancelProcesses NumberOfCancelProcesses 1
NumberOfPastDueEndDateElements NumberOfPastDueEndDateElements 1
NumberOfPastDueStartDateElmnts NumberOfPastDueStartDateElmnts 1
NumberOfRescheduleOutElements NumberOfRescheduleOutElements 1
NumberOfSupplier NumberOfSupplier 1
PlanningTimeFenceInDays PlanningTimeFenceInDays 1
PlantLanguage PlantLanguage 1
ProductionProductHierarchy ProductionProductHierarchy 1
ProductionProductHierarchyNode ProductionProductHierarchyNode 1
PurchasingGroup PurchasingGroup 1
SegmentationStrategy SegmentationStrategy 1
StockDaysSupplyCriticality StockDaysSupplyCriticality 1
StockDaysSupplyDuration StockDaysSupplyDuration 1
StockIntraDaySupplyDuration StockIntraDaySupplyDuration 1
TimeTillShortageInCalendarDays TimeTillShortageInCalendarDays 1
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration 2
TotalReplnmtLeadDurnEndDate TotalReplnmtLeadDurnEndDate 1
UnitOfMeasureDspNmbrOfDcmls UnitOfMeasureDspNmbrOfDcmls 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 without Supplier
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPMATERIALCOVERAGE (
    FACTORYCALENDAR,
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MRPAREA,
    MRPPLANNINGSEGMENT,
    MRPPLANNINGSEGMENTTYPE,
    MRPPLANT,
    _UNITOFMEASURE,
    AVAILABILITYCHART,
    DAYSOFSUPPLYCRITICALITY,
    DAYSOFSUPPLYDURATION,
    EVALUATIONHORIZONINDAYS,
    HASACCEPTEDSHORTAGE,
    HASSHORTAGEMANUALPLANHORIZON,
    HASSHORTAGEMRPSAFETYDURATION,
    HASSHORTAGETOTALREPLNMTLEAD,
    INTRADAYSUPPLYDURATION,
    ISMARKEDFORDELETION,
    ISSUECOUNT,
    LOWLEVELCODE,
    MANUALPLANNINGHORIZONENDDATE,
    MATERIALABCCLASSIFICATION,
    MATERIALBASEUNIT,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    MATERIALNAME,
    MATERIALPLANNEDDELIVERYDURN,
    MATERIALPLANNEDPRODUCTIONDURN,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALPROCUREMENTPROFILE,
    MATERIALREORDERPOINTQTY,
    MATERIALSAFETYSTOCKQTY,
    MATERIALSHORTAGEDEFINITIONNAME,
    MATERIALSHORTAGEDURATION,
    MATERIALSHORTAGEDURNINWORKDAYS,
    MATERIALSHORTAGEENDDATE,
    MATERIALSHORTAGEQUANTITY,
    MATERIALSHORTAGESTARTDATE,
    MATERIALTYPE,
    MATERIALTYPENAME,
    MRPAVAILABLESTOCKQTY,
    MRPCONTROLLER,
    MRPGROUP,
    MRPMATERIALNOTETEXT,
    MRPPLANNINGSEGMENTEXTERNALCODE,
    MRPRESULTISPROCESSED,
    MRPSAFETYDURATION,
    MRPSAFETYDURATIONENDDATE,
    MRPSAFETYSTOCKMETHOD,
    MRPTYPE,
    MRPVALIDMATERIALSTATUS,
    NUMBEROFCANCELPROCESSES,
    NUMBEROFPASTDUEENDDATEELEMENTS,
    NUMBEROFPASTDUESTARTDATEELMNTS,
    NUMBEROFRESCHEDULEOUTELEMENTS,
    NUMBEROFSUPPLIER,
    PLANNINGTIMEFENCEINDAYS,
    PLANTLANGUAGE,
    PRODUCTIONPRODUCTHIERARCHY,
    PRODUCTIONPRODUCTHIERARCHYNODE,
    PURCHASINGGROUP,
    SEGMENTATIONSTRATEGY,
    STOCKDAYSSUPPLYCRITICALITY,
    STOCKDAYSSUPPLYDURATION,
    STOCKINTRADAYSUPPLYDURATION,
    TIMETILLSHORTAGEINCALENDARDAYS,
    TOTALREPLENISHMENTLEADDURATION,
    TOTALREPLNMTLEADDURNENDDATE,
    UNITOFMEASUREDSPNMBROFDCMLS,
    WEEKLYAVAILABILITYCHART,
    PRIMARY KEY (FACTORYCALENDAR, MATERIAL, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT, MRPAREA, MRPPLANNINGSEGMENT, MRPPLANNINGSEGMENTTYPE, MRPPLANT)
);

Learn More