I_MRPPRODUCTIONDEMAND

CDS View
47 Fields 1 CDS Views

MRP Production Demand

I_MRPPRODUCTIONDEMAND is a CDS View in S/4HANA. MRP Production Demand. It contains 47 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MRPInternalRequirement view_entity from CONSUMPTION MRP Internal Requirement

Fields (47)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MaterialShortageProfile MaterialShortageProfile 1
KEY MaterialShortageProfileCount MaterialShortageProfileCount 1
KEY MRPArea MRPArea 1
KEY MRPElement MRPElement 1
KEY MRPElementAvailyOrRqmtDate MRPElementAvailyOrRqmtDate 1
KEY MRPElementCategory MRPElementCategory 1
KEY MRPElementItem MRPElementItem 1
KEY MRPElementScheduleLine MRPElementScheduleLine 1
KEY MRPPlanningSegment MRPPlanningSegment 1
KEY MRPPlanningSegmentType MRPPlanningSegmentType 1
KEY MRPPlant MRPPlant 1
FactoryCalendar FactoryCalendar 1
HasShortageManualPlanHorizon HasShortageManualPlanHorizon 1
HasShortageMRPSafetyDuration HasShortageMRPSafetyDuration 1
HasShortageTotalReplnmtLead HasShortageTotalReplnmtLead 1
LatestPlannedAvailabilityDate LatestPlannedAvailabilityDate 1
MaterialBaseUnit MaterialBaseUnit 1
MaterialExternalID MaterialExternalID 1
MaterialName MaterialName 1
MaterialShortageDefinition MaterialShortageDefinition 1
MaximumDelayInDays MaximumDelayInDays 1
MaximumDelayInWorkdays MaximumDelayInWorkdays 1
MRPAreaText MRPAreaText 1
MRPController MRPController 1
MRPControllerName MRPControllerName 1
MRPElementDelayedQuantity MRPElementDelayedQuantity 1
MRPElementOpenQuantity MRPElementOpenQuantity 1
MRPElementUncoveredQuantity MRPElementUncoveredQuantity 1
MRPPlanningSegmentExternalCode MRPPlanningSegmentExternalCode 1
OrderQuantity OrderQuantity 1
OrderType OrderType 1
PlanningSegmentDocument PlanningSegmentDocument 1
PlanningSegmentDocumentItem PlanningSegmentDocumentItem 1
PlantName PlantName 1
ProcurementProgress ProcurementProgress 1
ProductionLine ProductionLine 1
ProductionPlant ProductionPlant 1
ProductionSupervisor ProductionSupervisor 1
ProductionSupervisorName ProductionSupervisorName 1
ProductionVersion ProductionVersion 1
ProductionVersionText ProductionVersionText 1
SourceMRPElementCategory SourceMRPElementCategory 1
SourceMRPElementItem SourceMRPElementItem 1
StorageLocation StorageLocation 1
UnitOfMeasureDspNmbrOfDcmls TargetQuantityUnitDisplayDcmls 1
UnitOfMeasureNumberOfDecimals TargetQuantityUnitDcmls 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 Production Demand
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPPRODUCTIONDEMAND (
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MRPAREA,
    MRPELEMENT,
    MRPELEMENTAVAILYORRQMTDATE,
    MRPELEMENTCATEGORY,
    MRPELEMENTITEM,
    MRPELEMENTSCHEDULELINE,
    MRPPLANNINGSEGMENT,
    MRPPLANNINGSEGMENTTYPE,
    MRPPLANT,
    FACTORYCALENDAR,
    HASSHORTAGEMANUALPLANHORIZON,
    HASSHORTAGEMRPSAFETYDURATION,
    HASSHORTAGETOTALREPLNMTLEAD,
    LATESTPLANNEDAVAILABILITYDATE,
    MATERIALBASEUNIT,
    MATERIALEXTERNALID,
    MATERIALNAME,
    MATERIALSHORTAGEDEFINITION,
    MAXIMUMDELAYINDAYS,
    MAXIMUMDELAYINWORKDAYS,
    MRPAREATEXT,
    MRPCONTROLLER,
    MRPCONTROLLERNAME,
    MRPELEMENTDELAYEDQUANTITY,
    MRPELEMENTOPENQUANTITY,
    MRPELEMENTUNCOVEREDQUANTITY,
    MRPPLANNINGSEGMENTEXTERNALCODE,
    ORDERQUANTITY,
    ORDERTYPE,
    PLANNINGSEGMENTDOCUMENT,
    PLANNINGSEGMENTDOCUMENTITEM,
    PLANTNAME,
    PROCUREMENTPROGRESS,
    PRODUCTIONLINE,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONSUPERVISORNAME,
    PRODUCTIONVERSION,
    PRODUCTIONVERSIONTEXT,
    SOURCEMRPELEMENTCATEGORY,
    SOURCEMRPELEMENTITEM,
    STORAGELOCATION,
    UNITOFMEASUREDSPNMBROFDCMLS,
    UNITOFMEASURENUMBEROFDECIMALS,
    PRIMARY KEY (MATERIAL, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT, MRPAREA, MRPELEMENT, MRPELEMENTAVAILYORRQMTDATE, MRPELEMENTCATEGORY, MRPELEMENTITEM, MRPELEMENTSCHEDULELINE, MRPPLANNINGSEGMENT, MRPPLANNINGSEGMENTTYPE, MRPPLANT)
);

Learn More