I_MRPSALESDEMAND

CDS View
63 Fields 1 CDS Views

MRP Sales Demand

I_MRPSALESDEMAND is a CDS View in S/4HANA. MRP Sales Demand. It contains 63 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MRPUncoveredDemand view_entity from COMPOSITE Uncovered Demands

Fields (63)

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 MRPElementCategory MRPElementCategory 1
KEY MRPElementItem MRPElementItem 1
KEY MRPElementScheduleLine MRPElementScheduleLine 1
KEY MRPPlanningSegment MRPPlanningSegment 1
KEY MRPPlant MRPPlant 1
CompanyCurrency CompanyCurrency 1
CurrencyDecimals CurrencyDecimals 1
Customer Customer 1
DeliveryBlockReason DeliveryBlockReason 1
DeliveryBlockReasonText DeliveryBlockReasonText 1
DeliveryDateQuantityIsFixed DeliveryDateQuantityIsFixed 1
DeliveryIsBlocked MRPDeliveryIsBlocked 1
DeliveryPriority DeliveryPriority 1
DeliveryPriorityDesc DeliveryPriorityDesc 1
DistributionChannel DistributionChannel 1
Division Division 1
DocumentCurrency DocumentCurrency 1
FactoryCalendar FactoryCalendar 1
IssuingOrReceivingPlant IssuingOrReceivingPlant 1
ManualPlanningHorizonEndDate ManualPlanningHorizonEndDate 1
MaterialBaseUnit MaterialBaseUnit 1
MaterialName MaterialName 1
MaterialProcurementCategory MaterialProcurementCategory 1
MaterialReplnmtLeadDurnEndDate MaterialReplnmtLeadDurnEndDate 1
MaterialSafetyStockQty MaterialSafetyStockQty 1
MaximumDelayDate MaximumDelayDate 1
MaximumDelayInDays MaximumDelayInDays 1
MaximumDelayInWorkdays MaximumDelayInWorkdays 1
MRPController MRPController 1
MRPElementAvailyOrRqmtDate MRPElementAvailyOrRqmtDate 1
MRPElementDelayedQuantity MRPElementDelayedQuantity 1
MRPElementTypeImportance MRPElementTypeImportance 1
MRPElementUncoveredQuantity MRPElementUncoveredQuantity 1
MRPSafetyDurationEndDate MRPSafetyDurationEndDate 1
NetValueInDocCurrency NetValueInDocCurrency 1
OrderCategory MRPOrderCategory 1
OrderCreationDate OrderCreationDate 1
OrderQuantity OrderQuantity 1
OrderType OrderType 1
PartialDeliveryIsAllowed PartialDeliveryIsAllowed 1
PlanningSegmentDocument PlanningSegmentDocument 1
PlanningSegmentDocumentItem PlanningSegmentDocumentItem 1
ProcurementProgress ProcurementProgress 1
ProductionSupervisor ProductionSupervisor 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
RequestedDeliveryDate RequestedDeliveryDate 1
RequestedGoodsIssueDate RequestedGoodsIssueDate 1
RequestedLoadingDate RequestedLoadingDate 1
SalesOrganization SalesOrganization 1
ShipToParty ShipToParty 1
SourceMRPElement SourceMRPElement 1
SourceMRPElementCategory SourceMRPElementCategory 1
SourceMRPElementItem SourceMRPElementItem 1
StorageLocation StorageLocation 1
TotalReplnmtLeadDurnEndDate TotalReplnmtLeadDurnEndDate 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 1
UnitOfMeasureDspNmbrOfDcmls UnitOfMeasureDspNmbrOfDcmls 1
UnitOfMeasureNumberOfDecimals UnitOfMeasureNumberOfDecimals 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 Sales Demand
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPSALESDEMAND (
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MRPAREA,
    MRPELEMENT,
    MRPELEMENTCATEGORY,
    MRPELEMENTITEM,
    MRPELEMENTSCHEDULELINE,
    MRPPLANNINGSEGMENT,
    MRPPLANT,
    COMPANYCURRENCY,
    CURRENCYDECIMALS,
    CUSTOMER,
    DELIVERYBLOCKREASON,
    DELIVERYBLOCKREASONTEXT,
    DELIVERYDATEQUANTITYISFIXED,
    DELIVERYISBLOCKED,
    DELIVERYPRIORITY,
    DELIVERYPRIORITYDESC,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTCURRENCY,
    FACTORYCALENDAR,
    ISSUINGORRECEIVINGPLANT,
    MANUALPLANNINGHORIZONENDDATE,
    MATERIALBASEUNIT,
    MATERIALNAME,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALREPLNMTLEADDURNENDDATE,
    MATERIALSAFETYSTOCKQTY,
    MAXIMUMDELAYDATE,
    MAXIMUMDELAYINDAYS,
    MAXIMUMDELAYINWORKDAYS,
    MRPCONTROLLER,
    MRPELEMENTAVAILYORRQMTDATE,
    MRPELEMENTDELAYEDQUANTITY,
    MRPELEMENTTYPEIMPORTANCE,
    MRPELEMENTUNCOVEREDQUANTITY,
    MRPSAFETYDURATIONENDDATE,
    NETVALUEINDOCCURRENCY,
    ORDERCATEGORY,
    ORDERCREATIONDATE,
    ORDERQUANTITY,
    ORDERTYPE,
    PARTIALDELIVERYISALLOWED,
    PLANNINGSEGMENTDOCUMENT,
    PLANNINGSEGMENTDOCUMENTITEM,
    PROCUREMENTPROGRESS,
    PRODUCTIONSUPERVISOR,
    PURCHASEORDERBYCUSTOMER,
    REQUESTEDDELIVERYDATE,
    REQUESTEDGOODSISSUEDATE,
    REQUESTEDLOADINGDATE,
    SALESORGANIZATION,
    SHIPTOPARTY,
    SOURCEMRPELEMENT,
    SOURCEMRPELEMENTCATEGORY,
    SOURCEMRPELEMENTITEM,
    STORAGELOCATION,
    TOTALREPLNMTLEADDURNENDDATE,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNITOFMEASUREDSPNMBROFDCMLS,
    UNITOFMEASURENUMBEROFDECIMALS,
    PRIMARY KEY (MATERIAL, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT, MRPAREA, MRPELEMENT, MRPELEMENTCATEGORY, MRPELEMENTITEM, MRPELEMENTSCHEDULELINE, MRPPLANNINGSEGMENT, MRPPLANT)
);

Learn More