I_MfgOrderDataList

DDL: I_MFGORDERDATALIST Type: view_entity COMPOSITE Package: PP_MAN_OM_MOR

Mfg Order Header (Data List)

I_MfgOrderDataList is a Composite CDS View that provides data about "Mfg Order Header (Data List)" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrder) and exposes 30 fields with key field ManufacturingOrder. It has 3 associations to related views. Part of development package PP_MAN_OM_MOR.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrder MfgOrder from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _ProductionUnit $projection.ProductionUnit = _ProductionUnit.UnitOfMeasure
[1..1] I_ManufacturingOrder _ManufacturingOrder $projection.ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder
[1..1] E_LogisticsOrder _Extension $projection.ManufacturingOrder = _Extension.OrderID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Mfg Order Header (Data List) view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder I_ManufacturingOrder ManufacturingOrder
OrderInternalBillOfOperations I_ManufacturingOrder MfgOrderInternalID
ProductConfiguration I_ManufacturingOrder ProductConfiguration
ManufacturingObject I_ManufacturingOrder ObjectInternalID
ManufacturingOrderText I_ManufacturingOrder ManufacturingOrderText
ProductionPlant I_ManufacturingOrder ProductionPlant
PlantName
MRPPlant I_ManufacturingOrder PlanningPlant
Batch I_ManufacturingOrder Batch
Material I_ManufacturingOrder Material
ManufacturingOrderType I_ManufacturingOrder ManufacturingOrderType
ManufacturingOrderCategory I_ManufacturingOrder ManufacturingOrderCategory
SalesOrder I_ManufacturingOrder SalesOrder
SalesOrderItem I_ManufacturingOrder SalesOrderItem
ProductionSupervisor I_ManufacturingOrder ProductionSupervisor
ProductionSupervisorName
MRPController I_ManufacturingOrder MRPController
MRPControllerName
ProductionSchedulingProfile I_ManufacturingOrder ProductionSchedulingProfile
Reservation I_ManufacturingOrder Reservation
MfgOrderPlannedTotalQty I_ManufacturingOrder MfgOrderPlannedTotalQty
ProductionUnit I_ManufacturingOrder ProductionUnit
MfgOrderScheduledStartDate I_ManufacturingOrder MfgOrderScheduledStartDate
MfgOrderScheduledEndDate I_ManufacturingOrder MfgOrderScheduledEndDate
MfgOrderCreationDate I_ManufacturingOrder CreationDate
LeadingOrder I_ManufacturingOrder LeadingOrder
MfgOrderSuperiorMfgOrder I_ManufacturingOrder SuperiorOrder
LongTextLanguageCode I_ManufacturingOrder LongTextLanguageCode
_ProductionUnit _ProductionUnit
_ManufacturingOrder _ManufacturingOrder 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Mfg Order Header (Data List)'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE

define view entity I_MfgOrderDataList
  as select from I_ManufacturingOrder as MfgOrder

  association [1..1] to I_UnitOfMeasure      as _ProductionUnit     on $projection.ProductionUnit = _ProductionUnit.UnitOfMeasure
  association [1..1] to I_ManufacturingOrder as _ManufacturingOrder on $projection.ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder
  association [1..1] to E_LogisticsOrder     as _Extension          on $projection.ManufacturingOrder = _Extension.OrderID // Extensibility


{

  key MfgOrder.ManufacturingOrder                             as ManufacturingOrder,

      // Internal Order ID

      MfgOrder.MfgOrderInternalID                             as OrderInternalBillOfOperations,
      // Variant Configuration

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

      MfgOrder.ObjectInternalID                               as ManufacturingObject,

      // Order text

      MfgOrder.ManufacturingOrderText                         as ManufacturingOrderText,

      // Plants

      MfgOrder.ProductionPlant                                as ProductionPlant,
      MfgOrder._ProductionPlant.PlantName                     as PlantName,
      MfgOrder.PlanningPlant                                  as MRPPlant,

      // Batch number

      MfgOrder.Batch                                          as Batch,

      // Material

      MfgOrder.Material                                       as Material,
      // Order type

      MfgOrder.ManufacturingOrderType                         as ManufacturingOrderType,
      MfgOrder.ManufacturingOrderCategory                     as ManufacturingOrderCategory,

      // Assignments

      MfgOrder.SalesOrder                                     as SalesOrder,
      MfgOrder.SalesOrderItem                                 as SalesOrderItem,
      
      // Production Supervisor

      MfgOrder.ProductionSupervisor                           as ProductionSupervisor,
      MfgOrder._ProductionSupervisor.ProductionSupervisorName as ProductionSupervisorName,

      MfgOrder.MRPController                                  as MRPController,
      MfgOrder._MRPController.MRPControllerName               as MRPControllerName,
      MfgOrder.ProductionSchedulingProfile                    as ProductionSchedulingProfile,

      MfgOrder.Reservation                                    as Reservation,

      // Quantities

      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrder.MfgOrderPlannedTotalQty                        as MfgOrderPlannedTotalQty,
      MfgOrder.ProductionUnit                                 as ProductionUnit,

      MfgOrder.MfgOrderScheduledStartDate                     as MfgOrderScheduledStartDate,
      MfgOrder.MfgOrderScheduledEndDate                       as MfgOrderScheduledEndDate,
      MfgOrder.CreationDate                                   as MfgOrderCreationDate,

      //Collective Order

      MfgOrder.LeadingOrder                                   as LeadingOrder,
      MfgOrder.SuperiorOrder                                  as MfgOrderSuperiorMfgOrder,

      // Longtext

      MfgOrder.LongTextLanguageCode                           as LongTextLanguageCode,

      _ProductionUnit,
      _ManufacturingOrder // Used by Data Source Extensibility

}

Learn More