I_MfgOrderItemDataList

DDL: I_MFGORDERITEMDATALIST SQL: IPPMORITMDATA Type: view COMPOSITE

Mfg Order Item Data List

I_MfgOrderItemDataList is a Composite CDS View that provides data about "Mfg Order Item Data List" in SAP S/4HANA. It reads from 2 data sources (I_ManufacturingOrderItem, I_OrderComponent) and exposes 19 fields with key fields ManufacturingOrder, ManufacturingOrderItem. It has 2 associations to related views.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
I_ManufacturingOrderItem MfgOrderItem from
I_OrderComponent resb inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _ProductionUnit $projection.ProductionUnit = _ProductionUnit.UnitOfMeasure
[1..1] I_ManufacturingOrderItem _ManufacturingOrderItem $projection.ManufacturingOrder = _ManufacturingOrderItem.ManufacturingOrder and $projection.ManufacturingOrderItem = _ManufacturingOrderItem.ManufacturingOrderItem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPPMORITMDATA view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Mfg Order Item Data List view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder I_ManufacturingOrderItem ManufacturingOrder
KEY ManufacturingOrderItem I_ManufacturingOrderItem ManufacturingOrderItem
CoProductReservation I_ManufacturingOrderItem CoProductReservation
CoProductReservationItem I_ManufacturingOrderItem CoProductReservationItem
ProductConfiguration I_ManufacturingOrderItem ProductConfiguration
ManufacturingObject I_ManufacturingOrderItem ObjectInternalID
BillOfMaterialItemNumber I_OrderComponent BillOfMaterialItemNumber
ManufacturingOrderItemText I_OrderComponent BOMItemDescription
LongTextLanguageCode I_OrderComponent LongTextLanguage
ProductionPlant I_ManufacturingOrderItem ProductionPlant
PlantName
MRPPlant I_ManufacturingOrderItem PlanningPlant
Product I_ManufacturingOrderItem Product
SalesOrder I_ManufacturingOrderItem SalesOrder
SalesOrderItem I_ManufacturingOrderItem SalesOrderItem
MfgOrderItemPlannedTotalQty I_ManufacturingOrderItem MfgOrderItemPlannedTotalQty
ProductionUnit I_ManufacturingOrderItem ProductionUnit
_ProductionUnit _ProductionUnit
_ManufacturingOrderItem _ManufacturingOrderItem 
@AbapCatalog.sqlViewName: 'IPPMORITMDATA'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Mfg Order Item Data List'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE

define view I_MfgOrderItemDataList
  as select from I_ManufacturingOrderItem as MfgOrderItem
  // Use INNER join to select co-products only

    inner join   I_OrderComponent         as resb on  resb.Reservation     = MfgOrderItem.CoProductReservation
                                                  and resb.ReservationItem = MfgOrderItem.CoProductReservationItem
                                                  and resb.RecordType      = ''

  association [1..1] to I_UnitOfMeasure          as _ProductionUnit         on  $projection.ProductionUnit = _ProductionUnit.UnitOfMeasure
  association [1..1] to I_ManufacturingOrderItem as _ManufacturingOrderItem on  $projection.ManufacturingOrder     = _ManufacturingOrderItem.ManufacturingOrder
                                                                            and $projection.ManufacturingOrderItem = _ManufacturingOrderItem.ManufacturingOrderItem

{

      @ObjectModel.foreignKey.association: null
  key MfgOrderItem.ManufacturingOrder          as ManufacturingOrder,
  key MfgOrderItem.ManufacturingOrderItem      as ManufacturingOrderItem,

      // Reservation

      @ObjectModel.foreignKey.association: null
      MfgOrderItem.CoProductReservation        as CoProductReservation,
      MfgOrderItem.CoProductReservationItem    as CoProductReservationItem,
      // Variant Configuration

      MfgOrderItem.ProductConfiguration        as ProductConfiguration,
      // Internal id for status

      MfgOrderItem.ObjectInternalID            as ManufacturingObject,

      resb.BillOfMaterialItemNumber            as BillOfMaterialItemNumber,

      // Order text

      resb.BOMItemDescription                  as ManufacturingOrderItemText,
      resb.LongTextLanguage                    as LongTextLanguageCode,

      @ObjectModel.foreignKey.association: null
      MfgOrderItem.ProductionPlant             as ProductionPlant,
      MfgOrderItem._ProductionPlant.PlantName  as PlantName,
      @ObjectModel.foreignKey.association: null
      MfgOrderItem.PlanningPlant               as MRPPlant,

      @ObjectModel.foreignKey.association: null
      MfgOrderItem.Product                     as Product,

      // Assignments

      @ObjectModel.foreignKey.association: null
      MfgOrderItem.SalesOrder                  as SalesOrder,
      @ObjectModel.foreignKey.association: null
      MfgOrderItem.SalesOrderItem              as SalesOrderItem,

      // Quantities

      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderItem.MfgOrderItemPlannedTotalQty as MfgOrderItemPlannedTotalQty,
      @Semantics.unitOfMeasure: true
      MfgOrderItem.ProductionUnit              as ProductionUnit,

      _ProductionUnit,
      _ManufacturingOrderItem // Used by Data Source Extensibility

}

where
  MfgOrderItem.IsMarkedForDeletion = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDERITEM",
"I_ORDERCOMPONENT",
"I_PLANT"
],
"ASSOCIATED":
[
"I_MANUFACTURINGORDERITEM",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More