I_MRPMANUFACTURINGCOMPONENT

CDS View
70 Fields 2 CDS Views

MRP Manufacturing Components

I_MRPMANUFACTURINGCOMPONENT is a CDS View in S/4HANA. MRP Manufacturing Components. It contains 70 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MRPManufacturingComponent view from CONSUMPTION MRP Manufacturing Component
I_MRPOrderComponent view from COMPOSITE Mfg Component and Maint Component

Fields (70)

KeyField CDS FieldsUsed in Views
KEY RecordType RecordType 2
KEY Reservation Reservation 2
KEY ReservationItem ReservationItem 2
ActualEndDate ActualEndDate 2
ActualReleasedDate ActualReleasedDate 2
ActualStartDate ActualStartDate 2
BaseUnit BaseUnit 2
CommittedQuantity CommittedQuantity 2
Customer Customer 2
EmailAddress EmailAddress 2
ExpectedDeviationQuantity ExpectedDeviationQuantity 2
FixedLotSizeQuantity FixedLotSizeQuantity 2
GoodsReceiptQty GoodsReceiptQty 2
InventorySpecialStockType InventorySpecialStockType 2
LotSizeRoundingQuantity LotSizeRoundingQuantity 2
ManufacturingOrder ManufacturingOrder 2
ManufacturingOrderCategory ManufacturingOrderCategory,OrderCategory 2
ManufacturingOrderImportance ManufacturingOrderImportance,PriorityCode 2
ManufacturingOrderType ManufacturingOrderType,OrderType 2
Material Material 2
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 2
MaterialName MaterialName 2
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 2
MaterialPlannedProductionDurn MaterialPlannedProductionDurn 2
MaterialProcurementCategory MaterialProcurementCategory 2
MaterialProcurementType MaterialProcurementType 2
MaterialReplenishmentLeadDurn MaterialReplenishmentLeadDurn 2
MaximumLotSizeQuantity MaximumLotSizeQuantity 2
MinimumLotSizeQuantity MinimumLotSizeQuantity 2
MRPController MRPController 2
MRPControllerName MRPControllerName 2
MRPControllerPhoneNumber MRPControllerPhoneNumber 2
MRPPlant MRPPlant 2
OpenQuantity OpenQuantity 2
OrderedQuantity OrderedQuantity 2
OrderPlannedEndDate OrderPlannedEndDate 2
OrderPlannedScrapQty OrderPlannedScrapQty 2
OrderPlannedTotalQty OrderPlannedTotalQty 2
PlannedOrder PlannedOrder 2
PlannedStartDate PlannedStartDate 2
ProductionLine ProductionLine 2
ProductionPlant ProductionPlant 2
ProductionSupervisor ProductionSupervisor 2
ProductionVersion ProductionVersion 2
ProductionVersionText ProductionVersionText 2
Project Project 2
ProjectDescription ProjectDescription 2
ProjectInternalID ProjectInternalID 2
PurchasingGroup PurchasingGroup 2
RequirementDate RequirementDate 2
RequirementType RequirementType 2
ResponsiblePerson ResponsiblePerson 1
ResponsiblePersonName ResponsiblePersonName 1
RoundingProfile RoundingProfile 2
SalesOrder SalesOrder 2
SalesOrderItem SalesOrderItem 2
SalesOrderItemMaterial SalesOrderItemMaterial 2
SalesOrderType SalesOrderType 2
ScheduledBasicEndDate ScheduledBasicEndDate 2
ScheduledBasicStartDate ScheduledBasicStartDate 2
ScheduledReleaseDate ScheduledReleaseDate 2
Supplier Supplier 2
SupplyingPlant SupplyingPlant 2
TopLevelOrder TopLevelOrder 2
TopLevelOrderMaterial TopLevelOrderMaterial 2
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration 1
WBSDescription WBSDescription 1
WBSElement WBSElement 2
WBSElementInternalID WBSElementInternalID 2
WithdrawnQuantity WithdrawnQuantity 2

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 Manufacturing Components
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPMANUFACTURINGCOMPONENT (
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    ACTUALENDDATE,
    ACTUALRELEASEDDATE,
    ACTUALSTARTDATE,
    BASEUNIT,
    COMMITTEDQUANTITY,
    CUSTOMER,
    EMAILADDRESS,
    EXPECTEDDEVIATIONQUANTITY,
    FIXEDLOTSIZEQUANTITY,
    GOODSRECEIPTQTY,
    INVENTORYSPECIALSTOCKTYPE,
    LOTSIZEROUNDINGQUANTITY,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERIMPORTANCE,
    MANUFACTURINGORDERTYPE,
    MATERIAL,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALNAME,
    MATERIALPLANNEDDELIVERYDURN,
    MATERIALPLANNEDPRODUCTIONDURN,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALPROCUREMENTTYPE,
    MATERIALREPLENISHMENTLEADDURN,
    MAXIMUMLOTSIZEQUANTITY,
    MINIMUMLOTSIZEQUANTITY,
    MRPCONTROLLER,
    MRPCONTROLLERNAME,
    MRPCONTROLLERPHONENUMBER,
    MRPPLANT,
    OPENQUANTITY,
    ORDEREDQUANTITY,
    ORDERPLANNEDENDDATE,
    ORDERPLANNEDSCRAPQTY,
    ORDERPLANNEDTOTALQTY,
    PLANNEDORDER,
    PLANNEDSTARTDATE,
    PRODUCTIONLINE,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONVERSION,
    PRODUCTIONVERSIONTEXT,
    PROJECT,
    PROJECTDESCRIPTION,
    PROJECTINTERNALID,
    PURCHASINGGROUP,
    REQUIREMENTDATE,
    REQUIREMENTTYPE,
    RESPONSIBLEPERSON,
    RESPONSIBLEPERSONNAME,
    ROUNDINGPROFILE,
    SALESORDER,
    SALESORDERITEM,
    SALESORDERITEMMATERIAL,
    SALESORDERTYPE,
    SCHEDULEDBASICENDDATE,
    SCHEDULEDBASICSTARTDATE,
    SCHEDULEDRELEASEDATE,
    SUPPLIER,
    SUPPLYINGPLANT,
    TOPLEVELORDER,
    TOPLEVELORDERMATERIAL,
    TOTALREPLENISHMENTLEADDURATION,
    WBSDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    WITHDRAWNQUANTITY,
    PRIMARY KEY (RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More