C_MRPOrderComponent

DDL: C_MRPORDERCOMPONENT SQL: CMRPORDERCOMP Type: view CONSUMPTION
82 Fields 1 Data Sources

Mfg Component and Maint Component

C_MRPOrderComponent is a Consumption CDS View that provides data about "Mfg Component and Maint Component" in SAP S/4HANA. It reads from 1 data source (I_MRPOrderComponent) and exposes 82 fields with key fields Reservation, ReservationItem, RecordType.

Data Sources (1)

SourceAliasJoin Type
I_MRPOrderComponent I_MRPOrderComponent from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMRPORDERCOMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Mfg Component and Maint Component view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
KEY RecordType RecordType Reservation Record Type
RequirementType RequirementType RequirementType
Material Material Vehicle Model
MaterialName MaterialName Material Description
MRPPlant MRPPlant Plant
SupplyingPlant SupplyingPlant Supplying Plant
RequirementDate RequirementDate Requirement Date
BaseUnit BaseUnit Unit of Measure
Supplier Supplier Supplier
PurchasingGroup PurchasingGroup Purchasing Group
MaterialProcurementCategory MaterialProcurementCategory Procurement
MaterialProcurementType MaterialProcurementType Spec. procuremt
ManufacturingOrder ManufacturingOrder Order
OrderCategory OrderCategory Order Category
OrderType OrderType Order Type
PriorityCode PriorityCode Priority
PlannedOrder PlannedOrder
ProductionPlant ProductionPlant Prod plnt
MRPController MRPController MRP Controller
MRPControllerName MRPControllerName Controller name
MRPControllerPhoneNumber MRPControllerPhoneNumber
EmailAddress EmailAddress E-Mail Address
ProductionSupervisor ProductionSupervisor Prodn Supervisor
ProductionVersion ProductionVersion Version ID
ProductionVersionText ProductionVersionText
ProductionLine ProductionLine Production Line
InventorySpecialStockType InventorySpecialStockType Special Stock Type
OrderedQuantity OrderedQuantity Quantity
WithdrawnQuantity WithdrawnQuantity Withdrawn Quantity
OpenQuantity OpenQuantity PBE Entry Open Qty
CommittedQuantity CommittedQuantity
OrderPlannedTotalQty OrderPlannedTotalQty
OrderPlannedScrapQty OrderPlannedScrapQty
ExpectedDeviationQuantity ExpectedDeviationQuantity
GoodsReceiptQty GoodsReceiptQty Quantity
PlannedStartDate PlannedStartDate Latest Planned Start
OrderPlannedEndDate OrderPlannedEndDate
ActualStartDate ActualStartDate Actual Start
ActualEndDate ActualEndDate Actual Finish
ActualReleasedDate ActualReleasedDate
ScheduledBasicStartDate ScheduledBasicStartDate Sched. start
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
ScheduledReleaseDate ScheduledReleaseDate
TopLevelOrder TopLevelOrder
TopLevelOrderMaterial TopLevelOrderMaterial
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn Pl. Deliv. Time
MaterialPlannedProductionDurn MaterialPlannedProductionDurn InhseProdTime
MaterialReplenishmentLeadDurn MaterialReplenishmentLeadDurn
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderType SalesOrderType Sales Order Type
SalesOrderItemMaterial SalesOrderItemMaterial
Customer Customer Sold-to Party
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElement WBSElement WBS Internal ID
WBSDescription WBSDescription WBS Element Name
ResponsiblePerson ResponsiblePerson Processor
ResponsiblePersonName ResponsiblePersonName User
ProjectInternalID ProjectInternalID Project Def.
ProjectDescription ProjectDescription Project Name
Project Project WBS Element
ProjectResponsiblePerson ProjectResponsiblePerson
ProjectResponsiblePersonName ProjectResponsiblePersonName
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration Total RL time
FixedLotSizeQuantity FixedLotSizeQuantity Fixed lot size
MinimumLotSizeQuantity MinimumLotSizeQuantity Min. Lot Size
MaximumLotSizeQuantity MaximumLotSizeQuantity Max. Lot Size
LotSizeRoundingQuantity LotSizeRoundingQuantity Rounding value
RoundingProfile RoundingProfile Rnding Profile
MaintPriorityType MaintPriorityType PriorityType
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenanceRevision MaintenanceRevision Revision
MaintenancePlan MaintenancePlan MaintenancePlan
MaintenanceNotification MaintenanceNotification Notification
MaintenanceWorkCenter MaintenanceWorkCenter Work Center
MaintenanceWorkCenterPlant MaintenanceWorkCenterPlant Work Ctr Plant
ActivityType ActivityType Activity Type
MaintenancePlannerGroupName MaintenancePlannerGroupName Planner Group Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MRPOrderComponent.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMRPORDERCOMP

CREATE VIEW C_MRPOrderComponent AS
SELECT
  Reservation,
  ReservationItem,
  RecordType,
  RequirementType,
  Material,
  MaterialName,
  MRPPlant,
  SupplyingPlant,
  RequirementDate,
  BaseUnit,
  Supplier,
  PurchasingGroup,
  MaterialProcurementCategory,
  MaterialProcurementType,
  ManufacturingOrder,
  OrderCategory,
  OrderType,
  PriorityCode,
  PlannedOrder,
  ProductionPlant,
  MRPController,
  MRPControllerName,
  MRPControllerPhoneNumber,
  EmailAddress,
  ProductionSupervisor,
  ProductionVersion,
  ProductionVersionText,
  ProductionLine,
  InventorySpecialStockType,
  OrderedQuantity,
  WithdrawnQuantity,
  OpenQuantity,
  CommittedQuantity,
  OrderPlannedTotalQty,
  OrderPlannedScrapQty,
  ExpectedDeviationQuantity,
  GoodsReceiptQty,
  PlannedStartDate,
  OrderPlannedEndDate,
  ActualStartDate,
  ActualEndDate,
  ActualReleasedDate,
  ScheduledBasicStartDate,
  ScheduledBasicEndDate,
  ScheduledReleaseDate,
  TopLevelOrder,
  TopLevelOrderMaterial,
  MaterialGoodsReceiptDuration,
  MaterialPlannedDeliveryDurn,
  MaterialPlannedProductionDurn,
  MaterialReplenishmentLeadDurn,
  SalesOrder,
  SalesOrderItem,
  SalesOrderType,
  SalesOrderItemMaterial,
  Customer,
  WBSElementInternalID,
  WBSElement,
  WBSDescription,
  ResponsiblePerson,
  ResponsiblePersonName,
  ProjectInternalID,
  ProjectDescription,
  Project,
  ProjectResponsiblePerson,
  ProjectResponsiblePersonName,
  TotalReplenishmentLeadDuration,
  FixedLotSizeQuantity,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  LotSizeRoundingQuantity,
  RoundingProfile,
  MaintPriorityType,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenanceRevision,
  MaintenancePlan,
  MaintenanceNotification,
  MaintenanceWorkCenter,
  MaintenanceWorkCenterPlant,
  ActivityType,
  MaintenancePlannerGroupName
FROM I_MRPOrderComponent
;

Learn More