I_ProductionModel

DDL: I_PRODUCTIONMODEL Type: view_entity COMPOSITE

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_ProdnModLatestBOOVersion, I_BOOVersionBOMAssignment, I_ProductionModelBasic) and exposes 29 fields with key field ProductionModelUUID. It has 8 associations to related views.

3 data source(s) 29 fields

Data Sources (3)

SourceAliasJoin Type
P_ProdnModLatestBOOVersion BooLatestVersion inner
I_BOOVersionBOMAssignment BooVersionBOMAssgmt inner
I_ProductionModelBasic ProductionModel from

Associations (8)

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
[0..1] I_BOOVersionStatusText _BOOVersionStatusText $projection.billofoperationsversionstatus = _BOOVersionStatusText.BillOfOperationsVersionStatus and _BOOVersionStatusText.Language = $session.system_language
[0..1] I_BillOfMaterialUsage _BOMUsageText $projection.BillOfMaterialVariantUsage = _BOMUsageText.BillOfMaterialVariantUsage and _BOMUsageText.Language = $session.system_language
[0..1] I_BillOfOperationsTypeText _BOOTypeText $projection.BillOfOperationsType = _BOOTypeText.BillOfOperationsType and _BOOTypeText.Language = $session.system_language
[0..1] I_SalesDocumentItem _SalesDocumentItemText $projection.SalesOrder = _SalesDocumentItemText.SalesDocument and $projection.SalesOrderItem = _SalesDocumentItemText.SalesDocumentItem

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 (29)

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 I_BOOVersionBOMAssignment BillOfMaterialVersion
Plant I_ProductionModelBasic Plant
BillOfOperationsType I_ProductionModelBasic BillOfOperationsType
BillOfOperationsGroup I_ProductionModelBasic BillOfOperationsGroup
BillOfOperationsVariant I_ProductionModelBasic BillOfOperationsVariant
BillOfOperationsVersion I_BOOVersionBOMAssignment BillOfOperationsVersion
SalesOrder I_ProductionModelBasic SalesOrder
SalesOrderItem I_ProductionModelBasic SalesOrderItem
BillOfOperationsVersionStatus
ProdnModelCreationDateTime I_ProductionModelBasic ProdnModelCreationDateTime
ProductionModelCreatedByUser I_ProductionModelBasic ProductionModelCreatedByUser
ProdnModelChangedDateTime I_ProductionModelBasic ProdnModelChangedDateTime
ProductionModelChangedByUser I_ProductionModelBasic ProductionModelChangedByUser
_HeaderComponent _HeaderComponent
_Operation _Operation
_Plant _Plant
_MaterialText _MaterialText
_BOOVersionStatusText _BOOVersionStatusText
_BOMUsageText _BOMUsageText
_BOOTypeText _BOOTypeText
_SalesDocumentItemText _SalesDocumentItemText 
@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_ProdnModLatestBOOVersion as BooLatestVersion    on  BooLatestVersion.BillOfOperationsType    = ProductionModel.BillOfOperationsType
                                                                   and BooLatestVersion.BillOfOperationsGroup   = ProductionModel.BillOfOperationsGroup
                                                                   and BooLatestVersion.BillOfOperationsVariant = ProductionModel.BillOfOperationsVariant
    inner join   I_BOOVersionBOMAssignment  as BooVersionBOMAssgmt on  BooVersionBOMAssgmt.BillOfOperationsType    = ProductionModel.BillOfOperationsType
                                                                   and BooVersionBOMAssgmt.BillOfOperationsGroup   = ProductionModel.BillOfOperationsGroup
                                                                   and BooVersionBOMAssgmt.BillOfOperationsVariant = ProductionModel.BillOfOperationsVariant
                                                                   and BooVersionBOMAssgmt.BillOfOperationsVersion = BooLatestVersion.BillOfOperationsVersion
  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
  association [0..1] to I_BOOVersionStatusText     as _BOOVersionStatusText  on  $projection.billofoperationsversionstatus = _BOOVersionStatusText.BillOfOperationsVersionStatus
                                                                             and _BOOVersionStatusText.Language            = $session.system_language
  association [0..1] to I_BillOfMaterialUsage      as _BOMUsageText          on  $projection.BillOfMaterialVariantUsage = _BOMUsageText.BillOfMaterialVariantUsage
                                                                             and _BOMUsageText.Language                 = $session.system_language
  association [0..1] to I_BillOfOperationsTypeText as _BOOTypeText           on  $projection.BillOfOperationsType = _BOOTypeText.BillOfOperationsType
                                                                             and _BOOTypeText.Language            = $session.system_language
  association [0..1] to I_SalesDocumentItem        as _SalesDocumentItemText on  $projection.SalesOrder     = _SalesDocumentItemText.SalesDocument
                                                                             and $projection.SalesOrderItem = _SalesDocumentItemText.SalesDocumentItem
{

  key ProductionModel.ProductionModelUUID,
      ProductionModel.ProductionModelProcessType,
      ProductionModel.ProdnModComplexAssemblyType,
      ProductionModel.Material,
      ProductionModel.BillOfMaterial,
      ProductionModel.BillOfMaterialVariant,
      ProductionModel.BillOfMaterialCategory,
      ProductionModel.BillOfMaterialVariantUsage,
      BooVersionBOMAssgmt.BillOfMaterialVersion,
      ProductionModel.Plant,
      ProductionModel.BillOfOperationsType,
      ProductionModel.BillOfOperationsGroup,
      ProductionModel.BillOfOperationsVariant,
      BooVersionBOMAssgmt.BillOfOperationsVersion,
      ProductionModel.SalesOrder,
      ProductionModel.SalesOrderItem,
      @ObjectModel.text.association: '_BOOVersionStatusText'
      BooVersionBOMAssgmt._BillOfOperationsVersion.BillOfOperationsVersionStatus,
      ProductionModel.ProdnModelCreationDateTime,
      ProductionModel.ProductionModelCreatedByUser,
      ProductionModel.ProdnModelChangedDateTime,
      ProductionModel.ProductionModelChangedByUser,
      _HeaderComponent,
      _Operation,
      _Plant,
      _MaterialText,
      _BOOVersionStatusText,
      _BOMUsageText,
      _BOOTypeText,
      _SalesDocumentItemText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONSVERSION",
"I_BOOVERSIONBOMASSIGNMENT",
"I_PRODUCTIONMODELBASIC",
"P_PRODNMODLATESTBOOVERSION"
],
"ASSOCIATED":
[
"I_BILLOFMATERIALUSAGE",
"I_BILLOFOPERATIONSTYPETEXT",
"I_BOOVERSIONSTATUSTEXT",
"I_MATERIALTEXT",
"I_PLANT",
"I_PRODUCTIONMODELCOMPONENT",
"I_PRODUCTIONMODELOPERATION",
"I_SALESDOCUMENTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More