I_MRPTRANSFERDEMAND

CDS View
44 Fields 1 CDS Views

Transfer Demand

I_MRPTRANSFERDEMAND is a CDS View in S/4HANA. Transfer Demand. It contains 44 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MRPUncoveredDemand view_entity union COMPOSITE Uncovered Demands

Fields (44)

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 MRPPlanningSegmentType MRPPlanningSegmentType 1
CompanyCurrency CompanyCurrency 1
Customer ShipToParty,SoldToParty 1
FactoryCalendar FactoryCalendar 1
IssuingOrReceivingPlant Customer 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
MRPOrderCategory MRPOrderCategory 1
MRPSafetyDurationEndDate MRPSafetyDurationEndDate 1
OrderQuantity OrderQuantity 1
OrderType OrderType 1
PlanningSegmentDocument PlanningSegmentDocument 1
PlanningSegmentDocumentItem PlanningSegmentDocumentItem 1
ProcurementProgress ProcurementProgress 1
ProductionSupervisor ProductionSupervisor 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
SourceMRPElement SourceMRPElement 1
SourceMRPElementCategory SourceMRPElementCategory 1
SourceMRPElementItem SourceMRPElementItem 1
StorageLocation StorageLocation 1
TotalReplnmtLeadDurnEndDate TotalReplnmtLeadDurnEndDate 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.

-- Transfer Demand
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPTRANSFERDEMAND (
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MRPAREA,
    MRPELEMENT,
    MRPELEMENTCATEGORY,
    MRPELEMENTITEM,
    MRPELEMENTSCHEDULELINE,
    MRPPLANNINGSEGMENT,
    MRPPLANNINGSEGMENTTYPE,
    COMPANYCURRENCY,
    CUSTOMER,
    FACTORYCALENDAR,
    ISSUINGORRECEIVINGPLANT,
    MANUALPLANNINGHORIZONENDDATE,
    MATERIALBASEUNIT,
    MATERIALNAME,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALREPLNMTLEADDURNENDDATE,
    MATERIALSAFETYSTOCKQTY,
    MAXIMUMDELAYDATE,
    MAXIMUMDELAYINDAYS,
    MAXIMUMDELAYINWORKDAYS,
    MRPCONTROLLER,
    MRPELEMENTAVAILYORRQMTDATE,
    MRPELEMENTDELAYEDQUANTITY,
    MRPELEMENTTYPEIMPORTANCE,
    MRPELEMENTUNCOVEREDQUANTITY,
    MRPORDERCATEGORY,
    MRPSAFETYDURATIONENDDATE,
    ORDERQUANTITY,
    ORDERTYPE,
    PLANNINGSEGMENTDOCUMENT,
    PLANNINGSEGMENTDOCUMENTITEM,
    PROCUREMENTPROGRESS,
    PRODUCTIONSUPERVISOR,
    PURCHASEORDERBYCUSTOMER,
    SOURCEMRPELEMENT,
    SOURCEMRPELEMENTCATEGORY,
    SOURCEMRPELEMENTITEM,
    STORAGELOCATION,
    TOTALREPLNMTLEADDURNENDDATE,
    UNITOFMEASUREDSPNMBROFDCMLS,
    UNITOFMEASURENUMBEROFDECIMALS,
    PRIMARY KEY (MATERIAL, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT, MRPAREA, MRPELEMENT, MRPELEMENTCATEGORY, MRPELEMENTITEM, MRPELEMENTSCHEDULELINE, MRPPLANNINGSEGMENT, MRPPLANNINGSEGMENTTYPE)
);

Learn More