I_ProductionModel

DDL: I_PRODUCTIONMODEL Type: view_entity COMPOSITE Package: MPE_PRODUCTION_MODEL_CDS

Production Model Header

I_ProductionModel is a Composite CDS View that provides data about "Production Model Header" in SAP S/4HANA. It reads from 3 data sources (P_BOOVersBOMAssgmtLatest, P_ProdnModelLatestBOMVersion, I_ProductionModelBasic) and exposes 24 fields with key field ProductionModelUUID. It has 4 associations to related views. Part of development package MPE_PRODUCTION_MODEL_CDS.

3 data source(s) 24 fields

Data Sources (3)

SourceAliasJoin Type
P_BOOVersBOMAssgmtLatest BooVersionBOMAssgmtLatest inner
P_ProdnModelLatestBOMVersion LatestBOMVersion inner
I_ProductionModelBasic ProductionModel from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_ProductionModelComponent _HeaderComponent $projection.ProductionModelUUID = _HeaderComponent.ProductionModelUUID
[0..*] I_ProductionModelOperation _Operation $projection.ProductionModelUUID = _Operation.ProductionModelUUID
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant and _Plant.Language = $session.system_language
[0..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language

Annotations (7)

NameValueLevelField
EndUserText.label Production Model Header view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID I_ProductionModelBasic ProductionModelUUID
ProductionModelProcessType I_ProductionModelBasic ProductionModelProcessType
ProdnModComplexAssemblyType I_ProductionModelBasic ProdnModComplexAssemblyType
Material I_ProductionModelBasic Material
BillOfMaterial I_ProductionModelBasic BillOfMaterial
BillOfMaterialVariant I_ProductionModelBasic BillOfMaterialVariant
BillOfMaterialCategory I_ProductionModelBasic BillOfMaterialCategory
BillOfMaterialVariantUsage I_ProductionModelBasic BillOfMaterialVariantUsage
BillOfMaterialVersion P_BOOVersBOMAssgmtLatest BillOfMaterialVersion
BillOfOperationsVersion P_BOOVersBOMAssgmtLatest BillOfOperationsVersion
Plant I_ProductionModelBasic Plant
BillOfOperationsType I_ProductionModelBasic BillOfOperationsType
BillOfOperationsGroup I_ProductionModelBasic BillOfOperationsGroup
BillOfOperationsVariant I_ProductionModelBasic BillOfOperationsVariant
SalesOrder I_ProductionModelBasic SalesOrder
SalesOrderItem I_ProductionModelBasic SalesOrderItem
ProdnModelCreationDateTime I_ProductionModelBasic ProdnModelCreationDateTime
ProductionModelCreatedByUser I_ProductionModelBasic ProductionModelCreatedByUser
ProdnModelChangedDateTime I_ProductionModelBasic ProdnModelChangedDateTime
ProductionModelChangedByUser I_ProductionModelBasic ProductionModelChangedByUser
_HeaderComponent _HeaderComponent
_Operation _Operation
_Plant _Plant
_MaterialText _MaterialText 
@EndUserText.label: 'Production Model Header'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
define view entity I_ProductionModel
  as select from I_ProductionModelBasic       as ProductionModel
    inner join   P_ProdnModelLatestBOMVersion as LatestBOMVersion          on  LatestBOMVersion.BillOfMaterial             = ProductionModel.BillOfMaterial
                                                                           and LatestBOMVersion.BillOfMaterialCategory     = ProductionModel.BillOfMaterialCategory
                                                                           and LatestBOMVersion.BillOfMaterialVariant      = ProductionModel.BillOfMaterialVariant
                                                                           and LatestBOMVersion.BillOfMaterialVariantUsage = ProductionModel.BillOfMaterialVariantUsage
    inner join   P_BOOVersBOMAssgmtLatest     as BooVersionBOMAssgmtLatest on  BooVersionBOMAssgmtLatest.BillOfOperationsType    = ProductionModel.BillOfOperationsType
                                                                           and BooVersionBOMAssgmtLatest.BillOfOperationsGroup   = ProductionModel.BillOfOperationsGroup
                                                                           and BooVersionBOMAssgmtLatest.BillOfOperationsVariant = ProductionModel.BillOfOperationsVariant
  association [0..*] to I_ProductionModelComponent as _HeaderComponent on  $projection.ProductionModelUUID = _HeaderComponent.ProductionModelUUID
  association [0..*] to I_ProductionModelOperation as _Operation       on  $projection.ProductionModelUUID = _Operation.ProductionModelUUID
  association [0..1] to I_Plant                    as _Plant           on  $projection.Plant = _Plant.Plant
                                                                       and _Plant.Language   = $session.system_language
  association [0..1] to I_MaterialText             as _MaterialText    on  $projection.Material   = _MaterialText.Material
                                                                       and _MaterialText.Language = $session.system_language
{

  key ProductionModel.ProductionModelUUID,
      ProductionModel.ProductionModelProcessType,
      ProductionModel.ProdnModComplexAssemblyType,
      ProductionModel.Material,
      ProductionModel.BillOfMaterial,
      ProductionModel.BillOfMaterialVariant,
      ProductionModel.BillOfMaterialCategory,
      ProductionModel.BillOfMaterialVariantUsage,
      BooVersionBOMAssgmtLatest.BillOfMaterialVersion,
      BooVersionBOMAssgmtLatest.BillOfOperationsVersion,
      ProductionModel.Plant,
      ProductionModel.BillOfOperationsType,
      ProductionModel.BillOfOperationsGroup,
      ProductionModel.BillOfOperationsVariant,
      ProductionModel.SalesOrder,
      ProductionModel.SalesOrderItem,
      ProductionModel.ProdnModelCreationDateTime,
      ProductionModel.ProductionModelCreatedByUser,
      ProductionModel.ProdnModelChangedDateTime,
      ProductionModel.ProductionModelChangedByUser,
      _HeaderComponent,
      _Operation,
      _Plant,
      _MaterialText

}

Learn More