I_ProductionModelOperation

DDL: I_PRODUCTIONMODELOPERATION Type: view_entity COMPOSITE Package: MPE_PRODUCTION_MODEL_CDS

Production Model Operation

I_ProductionModelOperation is a Composite CDS View that provides data about "Production Model Operation" in SAP S/4HANA. It reads from 4 data sources (I_BillOfOperationsOpBasic, P_BOOVersBOMAssgmtLatest, I_BillOfOperationsOperation, I_ProductionModel) and exposes 19 fields with key fields ProductionModelUUID, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialCategory, BillOfMaterialVariantUsage. It has 2 associations to related views. Part of development package MPE_PRODUCTION_MODEL_CDS.

4 data source(s) 19 fields

Data Sources (4)

SourceAliasJoin Type
I_BillOfOperationsOpBasic BOOOANBasic inner
P_BOOVersBOMAssgmtLatest LatestBOMAssignment inner
I_BillOfOperationsOperation Operation from
I_ProductionModel ProductionModel inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProductionModel _ProductionModel $projection.ProductionModelUUID = ProductionModel.ProductionModelUUID
[0..*] I_ProdnModOperationActivity _OperationActivity $projection.ProductionModelUUID = _OperationActivity.ProductionModelUUID and $projection.BillOfMaterial = _OperationActivity.BillOfMaterial and $projection.BillOfMaterialVariant = _OperationActivity.BillOfMaterialVariant and $projection.BillOfMaterialCategory = _OperationActivity.BillOfMaterialCategory and $projection.Plant = _OperationActivity.Plant and $projection.BillOfOperationsType = _OperationActivity.BillOfOperationsType and $projection.BillOfOperationsGroup = _OperationActivity.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _OperationActivity.BillOfOperationsVariant and $projection.BillOfOperationsVersion = _OperationActivity.BillOfOperationsVersion and $projection.BOOOperationInternalID = _OperationActivity.BOOOperationInternalID

Annotations (7)

NameValueLevelField
EndUserText.label Production Model Operation view
AccessControl.authorizationCheck #NOT_REQUIRED 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 (19)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID I_ProductionModel ProductionModelUUID
KEY BillOfMaterial
KEY BillOfMaterialVariant P_BOOVersBOMAssgmtLatest BillOfMaterialVariant
KEY BillOfMaterialCategory P_BOOVersBOMAssgmtLatest BillOfMaterialCategory
KEY BillOfMaterialVariantUsage P_BOOVersBOMAssgmtLatest BillOfMaterialVariantUsage
KEY Plant P_BOOVersBOMAssgmtLatest Plant
KEY BillOfOperationsGroup P_BOOVersBOMAssgmtLatest BillOfOperationsGroup
KEY BillOfOperationsType P_BOOVersBOMAssgmtLatest BillOfOperationsType
KEY BillOfOperationsVariant P_BOOVersBOMAssgmtLatest BillOfOperationsVariant
KEY BOOOperationInternalID I_BillOfOperationsOpBasic BOOOperationInternalID
BillOfOperationsVersion P_BOOVersBOMAssgmtLatest BillOfOperationsVersion
BOOOpInternalVersionCounter I_BillOfOperationsOpBasic BOOOpInternalVersionCounter
OperationExternalID I_BillOfOperationsOpBasic OperationExternalID
Operation I_BillOfOperationsOpBasic Operation_2
OperationText I_BillOfOperationsOpBasic OperationText
LongTextLanguageCode I_BillOfOperationsOpBasic LongTextLanguageCode
OperationControlProfile I_BillOfOperationsOpBasic OperationControlProfile
_ProductionModel _ProductionModel
_OperationActivity _OperationActivity 
@EndUserText.label: 'Production Model Operation'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}

define view entity I_ProductionModelOperation
  as select from I_BillOfOperationsOperation as Operation
    inner join   P_BOOVersBOMAssgmtLatest    as LatestBOMAssignment on  LatestBOMAssignment.BillOfOperationsType    = Operation.BillOfOperationsType
                                                                    and LatestBOMAssignment.BillOfOperationsGroup   = Operation.BillOfOperationsGroup
                                                                    and LatestBOMAssignment.BillOfOperationsVariant = Operation.BillOfOperationsVariant
    inner join   I_BillOfOperationsOpBasic   as BOOOANBasic         on  BOOOANBasic.BillOfOperationsType    = Operation.BillOfOperationsType
                                                                    and BOOOANBasic.BillOfOperationsGroup   = Operation.BillOfOperationsGroup
                                                                    and BOOOANBasic.BOOOperationInternalID  = Operation.BOOOperationInternalID
                                                                    and BOOOANBasic.BillOfOperationsVersion = LatestBOMAssignment.BillOfOperationsVersion
    inner join   I_ProductionModel           as ProductionModel     on  ProductionModel.BillOfMaterial          = LatestBOMAssignment.BillOfMaterial
                                                                    and ProductionModel.BillOfMaterialVariant   = LatestBOMAssignment.BillOfMaterialVariant
                                                                    and ProductionModel.BillOfMaterialCategory  = LatestBOMAssignment.BillOfMaterialCategory
                                                                    and ProductionModel.Plant                   = LatestBOMAssignment.Plant
                                                                    and ProductionModel.BillOfMaterialVersion   = LatestBOMAssignment.BillOfMaterialVersion
                                                                    and ProductionModel.BillOfOperationsType    = LatestBOMAssignment.BillOfOperationsType
                                                                    and ProductionModel.BillOfOperationsGroup   = LatestBOMAssignment.BillOfOperationsGroup
                                                                    and ProductionModel.BillOfOperationsVariant = LatestBOMAssignment.BillOfOperationsVariant
                                                                    and ProductionModel.BillOfOperationsVersion = LatestBOMAssignment.BillOfOperationsVersion
  association [0..1] to I_ProductionModel           as _ProductionModel   on  $projection.ProductionModelUUID = ProductionModel.ProductionModelUUID
  association [0..*] to I_ProdnModOperationActivity as _OperationActivity on  $projection.ProductionModelUUID     = _OperationActivity.ProductionModelUUID
                                                                          and $projection.BillOfMaterial          = _OperationActivity.BillOfMaterial
                                                                          and $projection.BillOfMaterialVariant   = _OperationActivity.BillOfMaterialVariant
                                                                          and $projection.BillOfMaterialCategory  = _OperationActivity.BillOfMaterialCategory
                                                                          and $projection.Plant                   = _OperationActivity.Plant
                                                                          and $projection.BillOfOperationsType    = _OperationActivity.BillOfOperationsType
                                                                          and $projection.BillOfOperationsGroup   = _OperationActivity.BillOfOperationsGroup
                                                                          and $projection.BillOfOperationsVariant = _OperationActivity.BillOfOperationsVariant
                                                                          and $projection.BillOfOperationsVersion = _OperationActivity.BillOfOperationsVersion
                                                                          and $projection.BOOOperationInternalID  = _OperationActivity.BOOOperationInternalID

{

  key ProductionModel.ProductionModelUUID,
  key cast( LatestBOMAssignment.BillOfMaterial as cs_stlnr ) as BillOfMaterial,
  key LatestBOMAssignment.BillOfMaterialVariant,
  key LatestBOMAssignment.BillOfMaterialCategory,
  key LatestBOMAssignment.BillOfMaterialVariantUsage,
  key LatestBOMAssignment.Plant,
  key LatestBOMAssignment.BillOfOperationsGroup,
  key LatestBOMAssignment.BillOfOperationsType,
  key LatestBOMAssignment.BillOfOperationsVariant,
  key BOOOANBasic.BOOOperationInternalID,
      LatestBOMAssignment.BillOfOperationsVersion,
      BOOOANBasic.BOOOpInternalVersionCounter,
      BOOOANBasic.OperationExternalID,
      BOOOANBasic.Operation_2                                as Operation,
      BOOOANBasic.OperationText,
      BOOOANBasic.LongTextLanguageCode,
      BOOOANBasic.OperationControlProfile,
      _ProductionModel,
      _OperationActivity
}
where
  ProductionModel.ProdnModComplexAssemblyType <> 'MA';

Learn More