R_ChgRecdObjPgMfgBOMTP

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Chg Recd Obj Pg Mfg BOM'
@ObjectModel.usageType:{
 serviceQuality: #D,
 sizeCategory: #XXL,
 dataClass: #MIXED
}
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@VDM.viewType:#TRANSACTIONAL
define root view entity R_ChgRecdObjPgMfgBOMTP 
    as select from I_ChgRecdRefMBOM as reference_bom 

    //association [0..1] to E_ChgRecdRefMfgBOMBsc as _MfgBOMExtension on $projection.ChangeRecordReferenceUUID = _MfgBOMExtension.ChangeRecordReferenceUUID

    
    //association [0..*] to C_ChangeRecordMfgBOMVH      as _ChangeRecordMfgBOMVH      on  $projection.Material                   = _ChangeRecordMfgBOMVH.Material

                                                                                  //and $projection.Plant                      = _ChangeRecordMfgBOMVH.Plant

                                                                                  //and $projection.BillOfMaterialVariantUsage = _ChangeRecordMfgBOMVH.BillOfMaterialVariantUsage

                                                                                  //and $projection.BillOfMaterialVariant      = _ChangeRecordMfgBOMVH.BillOfMaterialVariant


    association [0..1] to I_Material                  as _Material                  on  $projection.Material = _Material.Material
  
    association [0..1] to I_Plant                     as _Plant                     on  $projection.Plant = _Plant.Plant
  
    //association [0..1] to C_ChangeRecordMfgBOMUsageVH as _ChangeRecordMfgBOMUsageVH on  $projection.BillOfMaterialVariantUsage = _ChangeRecordMfgBOMUsageVH.BillOfMaterialVariantUsage

  
  
    ///association [1..1] to C_ChangeRecordItemRelMbmVH  as _ChangeRecordItemRelVH     on  $projection.ChangeRecordItemRelevance              = _ChangeRecordItemRelVH.ChangeRecordItemRelevance

                                                                                    //and $projection.changerecordtype                       = _ChangeRecordItemRelVH.ChangeRecordType


    association [0..1] to I_VersionStatus             as _BOMVersionStsTxt          on  $projection.BOMVersionStatus = _BOMVersionStsTxt.BOMVersionStatus
                                                                                    and _BOMVersionStsTxt.Language   = $session.system_language
    association [0..1] to I_ChangeRecordMfgBOM        as _ChangeRecordMfgBOM        on  $projection.Material                   = _ChangeRecordMfgBOM.Material
                                                                                    and $projection.Plant                      = _ChangeRecordMfgBOM.Plant
                                                                                    and $projection.BillOfMaterialVariantUsage = _ChangeRecordMfgBOM.BillOfMaterialVariantUsage
                                                                                    and $projection.BillOfMaterialVariant      = _ChangeRecordMfgBOM.BillOfMaterialVariant
                                                                                    and $projection.BillOfMaterialVersion      = _ChangeRecordMfgBOM.BillOfMaterialVersion
    association [0..*] to I_BillOfMaterialStatusText  as _BOMStatusTxt              on  $projection.BillOfMaterialStatus = _BOMStatusTxt.BillOfMaterialStatus
    association [0..1] to I_ChgRecdProductionVersion  as _ProductionVersion         on  $projection.Material                             = _ProductionVersion.Material
                                                                                    and $projection.Plant                                = _ProductionVersion.Plant
                                                                                    and $projection.BillOfMaterialVariantUsage           = _ProductionVersion.BillOfMaterialVariantUsage
                                                                                    and $projection.BillOfMaterialVariant                = _ProductionVersion.BillOfMaterialVariant
                                                                                    and _ProductionVersion.PlanningAndExecutionBOMIsDiff = 'X'
    association [0..1] to I_ProdnBOMChgImpactObjMappg as _ObjTypeMapping            on  $projection.BillOfMaterialVariantUsage = _ObjTypeMapping.BillOfMaterialVariantUsage
      
    association [1..1] to R_ChangeRecordHeader     as _ChangeRecord        on  $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
          
{
  key reference_bom.ChangeRecordReferenceUUID,
      reference_bom.Material,
      reference_bom.Plant,
      reference_bom.BillOfMaterialVariantUsage,
      reference_bom.BillOfMaterialVariant,
      reference_bom.BillOfMaterialVersion,
      reference_bom.ChgRecdReasonForChange,
      reference_bom.ExpdCompltnDte,
      reference_bom.ChgRecdAuthznGrpText,
      reference_bom.ChgRecdNmbrChgSts,
      reference_bom.ChangeNumber,
      _ChangeRecord.ChangeRecordType,

      reference_bom.ChangeRecordUUID,
      //@ObjectModel.readOnly:true

      reference_bom.ChangeRecordReferenceType,
      reference_bom.ChangeRecordReferenceSubtype,
      reference_bom.ChangeRecordRefObjectUUID,
      reference_bom.ChangeRecordReference,
      reference_bom.ParentChangeRecordRefUUID,
      reference_bom.IsMainReference,
      @Semantics.user.createdBy: true
      reference_bom.CreatedByUser,
      reference_bom.CreationDateTime,
      @Semantics.user.lastChangedBy: true
      reference_bom.LastChangedByUser,
      reference_bom.LastChangeDateTime,
      reference_bom.ChangeRecordItemRelevance,
      reference_bom.ChangeRecordVirtualRefInd,

      cast(hextobin('00000000000000000000000000000000') as cs_guidb)                                                 as BillOfMaterialHeaderUUID,
      //concat(concat(concat(BillOfMaterial,BillOfMaterialCategory),BillOfMaterialVariantUsage),BillOfMaterialVariant) as BillOfMaterialUUID,

      //cast(concat(concat(concat(BillOfMaterial,BillOfMaterialCategory),BillOfMaterialVariantUsage),BillOfMaterialVariant) as abap.char( 16 ) ) as BillOfMaterialUUID,

      reference_bom.BillOfMaterial,
      reference_bom.BillOfMaterialCategory,
      cast('' as cs_versnind)                                                                                        as IsVersionBillOfMaterial,
      cast('' as cs_versnst)                                                                                         as BOMVersionStatus,
      cast('' as stlst)                                                                                              as BillOfMaterialStatus,

      
      _ChangeRecord,
      //_MfgBOMExtension,

      //_ChangeRecordMfgBOMVH,

      _Material,
      _Plant,
      //_ChangeRecordMfgBOMUsageVH,

      //_ChangeRecordItemRelVH,

      _BOMVersionStsTxt,
      _ChangeRecordMfgBOM,
      _BOMStatusTxt,
      _ProductionVersion,
      _ObjTypeMapping
}