I_MRPOrderComponent

DDL: I_MRPORDERCOMPONENT SQL: IMRPORDERCOMP Type: view COMPOSITE

Mfg Component and Maint Component

I_MRPOrderComponent is a Composite CDS View that provides data about "Mfg Component and Maint Component" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceOrderComponent_2, I_MRPManufacturingComponent) and exposes 159 fields with key fields Reservation, ReservationItem, RecordType. It has 4 associations to related views.

2 data source(s) 159 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceOrderComponent_2 I_MaintenanceOrderComponent_2 union_all
I_MRPManufacturingComponent I_MRPManufacturingComponent from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_MfgOrderTypeText _MfgOrderTypeText $projection.OrderType = _MfgOrderTypeText.ManufacturingOrderType
[0..1] I_WBSElement _WBSElement $projection.WBSElement = _WBSElement.WBSElement
[0..1] I_ProductPlant _ProductPlant $projection.Material = _ProductPlant.Product and $projection.MRPPlant = _ProductPlant.Plant
[0..1] I_ProductSupplyPlanning _ProductSupplyPlanning $projection.Material = _ProductSupplyPlanning.Product and $projection.MRPPlant = _ProductSupplyPlanning.Plant

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMRPORDERCOMP 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 #COMPOSITE view

Fields (159)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_MRPManufacturingComponent Reservation
KEY ReservationItem I_MRPManufacturingComponent ReservationItem
KEY RecordType I_MRPManufacturingComponent RecordType
RequirementType I_MRPManufacturingComponent RequirementType
Material I_MRPManufacturingComponent Material
MaterialName I_MRPManufacturingComponent MaterialName
MRPPlant I_MRPManufacturingComponent MRPPlant
SupplyingPlant I_MRPManufacturingComponent SupplyingPlant
RequirementDate I_MRPManufacturingComponent RequirementDate
BaseUnit I_MRPManufacturingComponent BaseUnit
Supplier I_MRPManufacturingComponent Supplier
PurchasingGroup I_MRPManufacturingComponent PurchasingGroup
MaterialProcurementCategory I_MRPManufacturingComponent MaterialProcurementCategory
MaterialProcurementType I_MRPManufacturingComponent MaterialProcurementType
ManufacturingOrder I_MRPManufacturingComponent ManufacturingOrder
OrderCategory I_MRPManufacturingComponent ManufacturingOrderCategory
OrderType I_MRPManufacturingComponent ManufacturingOrderType
OrderTypeName
PriorityCode I_MRPManufacturingComponent ManufacturingOrderImportance
PlannedOrder I_MRPManufacturingComponent PlannedOrder
ProductionPlant I_MRPManufacturingComponent ProductionPlant
MRPController I_MRPManufacturingComponent MRPController
MRPControllerName I_MRPManufacturingComponent MRPControllerName
MRPControllerPhoneNumber I_MRPManufacturingComponent MRPControllerPhoneNumber
EmailAddress I_MRPManufacturingComponent EmailAddress
ProductionSupervisor I_MRPManufacturingComponent ProductionSupervisor
ProductionVersion I_MRPManufacturingComponent ProductionVersion
ProductionVersionText I_MRPManufacturingComponent ProductionVersionText
ProductionLine I_MRPManufacturingComponent ProductionLine
InventorySpecialStockType I_MRPManufacturingComponent InventorySpecialStockType
OrderedQuantity I_MRPManufacturingComponent OrderedQuantity
WithdrawnQuantity I_MRPManufacturingComponent WithdrawnQuantity
OpenQuantity I_MRPManufacturingComponent OpenQuantity
CommittedQuantity I_MRPManufacturingComponent CommittedQuantity
OrderPlannedTotalQty I_MRPManufacturingComponent OrderPlannedTotalQty
OrderPlannedScrapQty I_MRPManufacturingComponent OrderPlannedScrapQty
ExpectedDeviationQuantity I_MRPManufacturingComponent ExpectedDeviationQuantity
GoodsReceiptQty I_MRPManufacturingComponent GoodsReceiptQty
PlannedStartDate I_MRPManufacturingComponent PlannedStartDate
OrderPlannedEndDate I_MRPManufacturingComponent OrderPlannedEndDate
ActualStartDate I_MRPManufacturingComponent ActualStartDate
ActualEndDate I_MRPManufacturingComponent ActualEndDate
ActualReleasedDate I_MRPManufacturingComponent ActualReleasedDate
ScheduledBasicStartDate I_MRPManufacturingComponent ScheduledBasicStartDate
ScheduledBasicEndDate I_MRPManufacturingComponent ScheduledBasicEndDate
ScheduledReleaseDate I_MRPManufacturingComponent ScheduledReleaseDate
TopLevelOrder I_MRPManufacturingComponent TopLevelOrder
TopLevelOrderMaterial I_MRPManufacturingComponent TopLevelOrderMaterial
MaterialGoodsReceiptDuration I_MRPManufacturingComponent MaterialGoodsReceiptDuration
MaterialPlannedDeliveryDurn I_MRPManufacturingComponent MaterialPlannedDeliveryDurn
MaterialPlannedProductionDurn I_MRPManufacturingComponent MaterialPlannedProductionDurn
MaterialReplenishmentLeadDurn I_MRPManufacturingComponent MaterialReplenishmentLeadDurn
SalesOrder I_MRPManufacturingComponent SalesOrder
SalesOrderItem I_MRPManufacturingComponent SalesOrderItem
SalesOrderType I_MRPManufacturingComponent SalesOrderType
SalesOrderItemMaterial I_MRPManufacturingComponent SalesOrderItemMaterial
Customer I_MRPManufacturingComponent Customer
WBSElementInternalID I_MRPManufacturingComponent WBSElementInternalID
WBSElement I_MRPManufacturingComponent WBSElement
WBSDescription I_MRPManufacturingComponent WBSDescription
ProjectInternalID I_MRPManufacturingComponent ProjectInternalID
ProjectDescription I_MRPManufacturingComponent ProjectDescription
Project I_MRPManufacturingComponent Project
TotalReplenishmentLeadDuration I_MRPManufacturingComponent TotalReplenishmentLeadDuration
FixedLotSizeQuantity I_MRPManufacturingComponent FixedLotSizeQuantity
MinimumLotSizeQuantity I_MRPManufacturingComponent MinimumLotSizeQuantity
MaximumLotSizeQuantity I_MRPManufacturingComponent MaximumLotSizeQuantity
LotSizeRoundingQuantity I_MRPManufacturingComponent LotSizeRoundingQuantity
RoundingProfile I_MRPManufacturingComponent RoundingProfile
MaintPriorityType
MaintenancePlanningPlant
MaintenancePlannerGroup
MaintenanceRevision
MaintenancePlan
MaintenanceNotification
MaintenanceWorkCenter
MaintenanceWorkCenterPlant
ActivityType
Reservation
ReservationItem I_MaintenanceOrderComponent_2 ReservationItem
RecordType I_MaintenanceOrderComponent_2 ReservationType
RequirementType
Material I_MaintenanceOrderComponent_2 Material
MaterialName
MRPPlant I_MaintenanceOrderComponent_2 Plant
SupplyingPlant
RequirementDate
BaseUnit I_MaintenanceOrderComponent_2 BaseUnit
Supplier
PurchasingGroup
MaterialProcurementCategory _ProductPlant ProcurementType
MaterialProcurementType _ProductPlant SpecialProcurementType
ManufacturingOrder I_MaintenanceOrderComponent_2 MaintenanceOrder
OrderCategory
OrderType
OrderTypeName
PriorityCode
PlannedOrder
ProductionPlant
MRPController
MRPControllerName
MRPControllerPhoneNumber
EmailAddress
ProductionSupervisor
ProductionVersion
ProductionVersionText
ProductionLine
InventorySpecialStockType
OrderedQuantity I_MaintenanceOrderComponent_2 RequirementQuantityInBaseUnit
WithdrawnQuantity I_MaintenanceOrderComponent_2 QuantityWithdrawnInBaseUnit
OpenQuantity
CommittedQuantity 0
OrderPlannedTotalQty
OrderPlannedScrapQty 0
ExpectedDeviationQuantity 0
GoodsReceiptQty 0
PlannedStartDate
OrderPlannedEndDate
ActualStartDate
ActualEndDate
ActualReleasedDate
ScheduledBasicStartDate
ScheduledBasicEndDate
ScheduledReleaseDate
TopLevelOrder
TopLevelOrderMaterial
MaterialGoodsReceiptDuration 0
MaterialPlannedDeliveryDurn 0
MaterialPlannedProductionDurn 0
MaterialReplenishmentLeadDurn 0
SalesOrder
SalesOrderItem
SalesOrderType
SalesOrderItemMaterial
Customer
WBSElementInternalID
WBSElement
WBSDescription
ResponsiblePerson
ResponsiblePersonName
ProjectInternalID
ProjectDescription
Project
TotalReplenishmentLeadDuration _ProductSupplyPlanning TotalReplenishmentLeadTime
FixedLotSizeQuantity _ProductSupplyPlanning FixedLotSizeQuantity
MinimumLotSizeQuantity _ProductSupplyPlanning MinimumLotSizeQuantity
MaximumLotSizeQuantity _ProductSupplyPlanning MaximumLotSizeQuantity
LotSizeRoundingQuantity _ProductSupplyPlanning LotSizeRoundingQuantity
RoundingProfile _ProductSupplyPlanning RoundingProfile
MaintPriorityType
MaintenancePlanningPlant
MaintenancePlannerGroup
MaintenanceRevision
MaintenancePlan
MaintenanceNotification
MaintenanceWorkCenter
MaintenanceWorkCenterPlant
ActivityType
MaintenancePlannerGroupName 
@AbapCatalog.sqlViewName: 'IMRPORDERCOMP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:  #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Mfg Component and Maint Component'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

@VDM.viewType: #COMPOSITE
define view I_MRPOrderComponent
  as select from I_MRPManufacturingComponent
  association [0..*] to I_MfgOrderTypeText as _MfgOrderTypeText on $projection.OrderType = _MfgOrderTypeText.ManufacturingOrderType
  association [0..1] to I_WBSElement       as _WBSElement       on $projection.WBSElement = _WBSElement.WBSElement
  
{
  key I_MRPManufacturingComponent.Reservation,
  key I_MRPManufacturingComponent.ReservationItem,
  key I_MRPManufacturingComponent.RecordType,
      I_MRPManufacturingComponent.RequirementType,
      I_MRPManufacturingComponent.Material,
      I_MRPManufacturingComponent.MaterialName,
      I_MRPManufacturingComponent.MRPPlant,
      I_MRPManufacturingComponent.SupplyingPlant,
      I_MRPManufacturingComponent.RequirementDate,
      I_MRPManufacturingComponent.BaseUnit,
      I_MRPManufacturingComponent.Supplier,
      I_MRPManufacturingComponent.PurchasingGroup,
      I_MRPManufacturingComponent.MaterialProcurementCategory,
      I_MRPManufacturingComponent.MaterialProcurementType,
      I_MRPManufacturingComponent.ManufacturingOrder,
      I_MRPManufacturingComponent.ManufacturingOrderCategory   as OrderCategory,
      I_MRPManufacturingComponent.ManufacturingOrderType       as OrderType,
      _MfgOrderTypeText[1: Language = $session.system_language ].ManufacturingOrderTypeName as OrderTypeName,
      I_MRPManufacturingComponent.ManufacturingOrderImportance as PriorityCode,
      I_MRPManufacturingComponent.PlannedOrder,
      I_MRPManufacturingComponent.ProductionPlant,
      I_MRPManufacturingComponent.MRPController,
      I_MRPManufacturingComponent.MRPControllerName,
      I_MRPManufacturingComponent.MRPControllerPhoneNumber,
      I_MRPManufacturingComponent.EmailAddress,
      I_MRPManufacturingComponent.ProductionSupervisor,
      I_MRPManufacturingComponent.ProductionVersion,
      I_MRPManufacturingComponent.ProductionVersionText,
      I_MRPManufacturingComponent.ProductionLine,
      I_MRPManufacturingComponent.InventorySpecialStockType,
      I_MRPManufacturingComponent.OrderedQuantity,
      I_MRPManufacturingComponent.WithdrawnQuantity,
      I_MRPManufacturingComponent.OpenQuantity,
      I_MRPManufacturingComponent.CommittedQuantity,
      I_MRPManufacturingComponent.OrderPlannedTotalQty,
      I_MRPManufacturingComponent.OrderPlannedScrapQty,
      I_MRPManufacturingComponent.ExpectedDeviationQuantity,
      I_MRPManufacturingComponent.GoodsReceiptQty,
      I_MRPManufacturingComponent.PlannedStartDate,
      I_MRPManufacturingComponent.OrderPlannedEndDate,
      I_MRPManufacturingComponent.ActualStartDate,
      I_MRPManufacturingComponent.ActualEndDate,
      I_MRPManufacturingComponent.ActualReleasedDate,
      I_MRPManufacturingComponent.ScheduledBasicStartDate,
      I_MRPManufacturingComponent.ScheduledBasicEndDate,
      I_MRPManufacturingComponent.ScheduledReleaseDate,
      I_MRPManufacturingComponent.TopLevelOrder,
      I_MRPManufacturingComponent.TopLevelOrderMaterial,
      I_MRPManufacturingComponent.MaterialGoodsReceiptDuration,
      I_MRPManufacturingComponent.MaterialPlannedDeliveryDurn,
      I_MRPManufacturingComponent.MaterialPlannedProductionDurn,
      I_MRPManufacturingComponent.MaterialReplenishmentLeadDurn,
      I_MRPManufacturingComponent.SalesOrder,
      I_MRPManufacturingComponent.SalesOrderItem,
      I_MRPManufacturingComponent.SalesOrderType,
      I_MRPManufacturingComponent.SalesOrderItemMaterial,
      I_MRPManufacturingComponent.Customer,
      I_MRPManufacturingComponent.WBSElementInternalID,
      I_MRPManufacturingComponent.WBSElement,
      I_MRPManufacturingComponent.WBSDescription,
      
      cast( case
         when I_MRPManufacturingComponent.ResponsiblePerson = '00000000' or I_MRPManufacturingComponent.ResponsiblePerson is null
            then _WBSElement._EntProjectResponsiblePerson.PersonWorkAgreement
          else
            I_MRPManufacturingComponent.ResponsiblePerson
        end as ps_s4_vernr preserving type )                   as ResponsiblePerson, //WBS Responsible

      cast( case
         when I_MRPManufacturingComponent.ResponsiblePerson = '00000000' or I_MRPManufacturingComponent.ResponsiblePerson is null
            then _WBSElement._EntProjectResponsiblePerson._WorkforcePerson.PersonFullName
          else
            I_MRPManufacturingComponent.ResponsiblePersonName
        end as ad_namtext preserving type )                    as ResponsiblePersonName, //WBS Responsible

      
      I_MRPManufacturingComponent.ProjectInternalID,
      I_MRPManufacturingComponent.ProjectDescription,
      I_MRPManufacturingComponent.Project,
      I_MRPManufacturingComponent.TotalReplenishmentLeadDuration,
      I_MRPManufacturingComponent.FixedLotSizeQuantity,
      I_MRPManufacturingComponent.MinimumLotSizeQuantity,
      I_MRPManufacturingComponent.MaximumLotSizeQuantity,
      I_MRPManufacturingComponent.LotSizeRoundingQuantity,
      I_MRPManufacturingComponent.RoundingProfile,

      ''                                                       as MaintPriorityType,
      '0000'                                                   as MaintenancePlanningPlant,
      ''                                                       as MaintenancePlannerGroup,
      ''                                                       as MaintenanceRevision,
      ''                                                       as MaintenancePlan,
      ''                                                       as MaintenanceNotification,
      ''                                                       as MaintenanceWorkCenter,
      '0000'                                                   as MaintenanceWorkCenterPlant,
      ''                                                       as ActivityType,
      ''                                                       as MaintenancePlannerGroupName
} where I_MRPManufacturingComponent.RequirementType = 'AR'

union all select from I_MaintenanceOrderComponent_2

association [0..1] to I_ProductPlant          as _ProductPlant          on  $projection.Material = _ProductPlant.Product
                                                                        and $projection.MRPPlant = _ProductPlant.Plant
association [0..1] to I_ProductSupplyPlanning as _ProductSupplyPlanning on  $projection.Material = _ProductSupplyPlanning.Product
                                                                        and $projection.MRPPlant = _ProductSupplyPlanning.Plant
                                                                        
{
  I_MaintenanceOrderComponent_2.Reservation,
  I_MaintenanceOrderComponent_2.ReservationItem,
  I_MaintenanceOrderComponent_2.ReservationType                                                                        as RecordType,
  'AR'                                                                                                               as RequirementType,
  I_MaintenanceOrderComponent_2.Material,
  I_MaintenanceOrderComponent_2._Material._Text[1: Language = $session.system_language ].MaterialName,
  I_MaintenanceOrderComponent_2.Plant                                                                                  as MRPPlant,
  ''                                                                                                                 as SupplyingPlant,
  '00000000'                                                                                                         as RequirementDate,
  I_MaintenanceOrderComponent_2.BaseUnit,
  ''                                                                                                                 as Supplier,
  I_MaintenanceOrderComponent_2._MaintenanceOrderOperation.PurchasingGroup,
  _ProductPlant.ProcurementType                                                                                      as MaterialProcurementCategory,
  _ProductPlant.SpecialProcurementType                                                                               as MaterialProcurementType,
  I_MaintenanceOrderComponent_2.MaintenanceOrder                                                                       as ManufacturingOrder,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintenanceOrderCategory                                             as OrderCategory,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintenanceOrderType                                                 as OrderType,
  I_MaintenanceOrderComponent_2._MaintenanceOrder._MaintenanceOrderType._Text[1: Language = $session.system_language ].OrderTypeName,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintPriority                                                        as PriorityCode,
  ''                                                                                                                 as PlannedOrder,
  ''                                                                                                                 as ProductionPlant,
  ''                                                                                                                 as MRPController,
  ''                                                                                                                 as MRPControllerName,
  ''                                                                                                                 as MRPControllerPhoneNumber,
  ''                                                                                                                 as EmailAddress,
  ''                                                                                                                 as ProductionSupervisor,
  ''                                                                                                                 as ProductionVersion,
  ''                                                                                                                 as ProductionVersionText,
  ''                                                                                                                 as ProductionLine,
  ''                                                                                                                 as InventorySpecialStockType,
  I_MaintenanceOrderComponent_2.RequirementQuantityInBaseUnit                                                          as OrderedQuantity,
  I_MaintenanceOrderComponent_2.QuantityWithdrawnInBaseUnit                                                            as WithdrawnQuantity,
  I_MaintenanceOrderComponent_2.RequirementQuantityInBaseUnit - I_MaintenanceOrderComponent_2.QuantityWithdrawnInBaseUnit as OpenQuantity,
  0                                                                                                                  as CommittedQuantity,
  I_MaintenanceOrderComponent_2._MaintenanceOrderOperation._OperationPlanningValues.ConfirmationTotalQuantity          as OrderPlannedTotalQty, // to check

  0                                                                                                                  as OrderPlannedScrapQty,
  0                                                                                                                  as ExpectedDeviationQuantity,
  0                                                                                                                  as GoodsReceiptQty,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintOrdBasicStartDate                                               as PlannedStartDate,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintOrdBasicEndDate                                                 as OrderPlannedEndDate,
  I_MaintenanceOrderComponent_2._MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionStartDate         as ActualStartDate,
  I_MaintenanceOrderComponent_2._MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionEndDate           as ActualEndDate,
  '00000000'                                                                                                         as ActualReleasedDate,
  I_MaintenanceOrderComponent_2._MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecStrtDte          as ScheduledBasicStartDate,
  I_MaintenanceOrderComponent_2._MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecEndDte           as ScheduledBasicEndDate,
  '00000000'                                                                                                         as ScheduledReleaseDate,
  ''                                                                                                                 as TopLevelOrder,
  ''                                                                                                                 as TopLevelOrderMaterial,
  0                                                                                                                  as MaterialGoodsReceiptDuration,
  0                                                                                                                  as MaterialPlannedDeliveryDurn,
  0                                                                                                                  as MaterialPlannedProductionDurn,
  0                                                                                                                  as MaterialReplenishmentLeadDurn,
  ''                                                                                                                 as SalesOrder,
  '000000'                                                                                                           as SalesOrderItem,
  ''                                                                                                                 as SalesOrderType,
  ''                                                                                                                 as SalesOrderItemMaterial,
  ''                                                                                                                 as Customer,
  '00000000'                                                                                                         as WBSElementInternalID,
  ''                                                                                                                 as WBSElement,
  ''                                                                                                                 as WBSDescription,
  '00000000'                                                                                                         as ResponsiblePerson,
  ''                                                                                                                 as ResponsiblePersonName,
  '00000000'                                                                                                         as ProjectInternalID,
  ''                                                                                                                 as ProjectDescription,
  ''                                                                                                                 as Project,
  _ProductSupplyPlanning.TotalReplenishmentLeadTime                                                                  as TotalReplenishmentLeadDuration,
  _ProductSupplyPlanning.FixedLotSizeQuantity, // MaterialFixedLotSizeQuantity

  _ProductSupplyPlanning.MinimumLotSizeQuantity, //MaterialMinLotSizeQuantity,

  _ProductSupplyPlanning.MaximumLotSizeQuantity, //MaterialMaxLotSizeQuantity,

  _ProductSupplyPlanning.LotSizeRoundingQuantity, //MaterialRoundingQuantity,

  _ProductSupplyPlanning.RoundingProfile, //MaterialRoundingProfile,


  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintPriority                                                        as MaintPriorityType,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintenancePlanningPlant,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintenancePlannerGroup,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintenanceRevision,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintenancePlan,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintenanceNotification,
  I_MaintenanceOrderComponent_2._MaintenanceOrder._MainWorkCenter.WorkCenter                                           as MaintenanceWorkCenter,
  I_MaintenanceOrderComponent_2._MaintenanceOrder._MainWorkCenter.Plant                                                as MaintenanceWorkCenterPlant,
  I_MaintenanceOrderComponent_2._MaintenanceOrder.MaintenanceActivityType                                              as ActivityType,
  I_MaintenanceOrderComponent_2._MaintenanceOrder._MaintenancePlannerGroup.MaintenancePlannerGroupName
  
};

Learn More