R_ChgRecdObjPgEngBOMTP

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Chg Recd Obj Pg Eng BOM'
@ObjectModel.usageType:{
 serviceQuality: #D,
 sizeCategory: #XXL,
 dataClass: #MIXED
}
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@VDM.viewType:#TRANSACTIONAL
define root view entity R_ChgRecdObjPgEngBOMTP 
    as select from I_ChgRecdRefEBOM as reference_bom
    
    //association [0..1] to E_ChgRecdRefEngBOMBsc as _EngBOMExtension on $projection.ChangeRecordReferenceUUID = _EngBOMExtension.ChangeRecordReferenceUUID

    
    //association [0..*] to C_ChangeRecordEngBOMVH      as _ChangeRecordEngBOMVH      on  $projection.Material                   = _ChangeRecordEngBOMVH.Material

                                                                                    //and $projection.Plant                      = _ChangeRecordEngBOMVH.Plant

                                                                                    //and $projection.BillOfMaterialVariantUsage = _ChangeRecordEngBOMVH.BillOfMaterialVariantUsage

                                                                                    //and $projection.BillOfMaterialVariant      = _ChangeRecordEngBOMVH.BillOfMaterialVariant

    association [0..*] to I_MaterialBOMLink           as _BOMLink                    on  $projection.Plant = _BOMLink.Plant
                                                                                    and $projection.BillOfMaterial = _BOMLink.BillOfMaterial
                                                                                    and $projection.BillOfMaterialVariant = _BOMLink.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_ChangeRecordEngBOMUsageVH as _ChangeRecordEngBOMUsageVH   on  $projection.BillOfMaterialVariantUsage = _ChangeRecordEngBOMUsageVH.BillOfMaterialVariantUsage

    //association [1..1] to C_ChangeRecordItemRelEbmVH  as _ChangeRecordItemRelEngBOMVH on  $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelEngBOMVH.ChangeRecordItemRelevance

                                                                                      //and $projection.changerecordtype          = _ChangeRecordItemRelEngBOMVH.ChangeRecordType

    //                                                                                    and ( $projection.ChangeRecordReferenceType                     = _ChangeRecordItemRelEngBOMVH.ChangeRecordReferenceType

    //                                                                                    or    _ChangeRecordItemRelEngBOMVH.ChangeRecordReferenceType = ' '

    //                                                                                     )

  
    //association [0..1] to C_ChangeRecordObjPgPlngScp  as _PlngScpAssgd                on  $projection.ChangeRecordUUID = _PlngScpAssgd.ChangeRecordUUID

    association [0..*] to I_ChgRecdProductionPlant    as _ChangeRecordProductionPlant on  $projection.ChangeRecordUUID = _ChangeRecordProductionPlant.ChangeRecordUUID
    association [0..1] to I_EngBOMIncStatus           as _EngBOMIncStatus             on  $projection.ChangeRecord                   = _EngBOMIncStatus.ChangeRecord
                                                                                      and $projection.BillOfMaterial                 = _EngBOMIncStatus.EngBillOfMaterial
                                                                                      and $projection.BillOfMaterialVariant          = _EngBOMIncStatus.EngBillOfMaterialVariant
                                                                                      and $projection.BillOfMaterialVersion          = _EngBOMIncStatus.EngBillOfMaterialVersion
                                                                                      and _EngBOMIncStatus.EngBillOfMaterialCategory = 'M'
    association [0..*] to I_EngBOMIncStatusText       as _EngBOMIncStsTxt             on  $projection.engbomincstatus = _EngBOMIncStsTxt.EngBOMIncStatus
    association [0..1] to I_VersionStatus             as _BOMVersionStsTxt            on  $projection.BOMVersionStatus = _BOMVersionStsTxt.BOMVersionStatus
                                                                                      and _BOMVersionStsTxt.Language   = $session.system_language
    association [0..1] to I_ChangeRecordEngBOM        as _ChangeRecordEngBOM          on  $projection.Material                   = _ChangeRecordEngBOM.Material
                                                                                      and $projection.Plant                      = _ChangeRecordEngBOM.Plant
                                                                                      and $projection.BillOfMaterialVariantUsage = _ChangeRecordEngBOM.BillOfMaterialVariantUsage
                                                                                      and $projection.BillOfMaterialVariant      = _ChangeRecordEngBOM.BillOfMaterialVariant
                                                                                      and $projection.BillOfMaterialVersion      = _ChangeRecordEngBOM.BillOfMaterialVersion
    association [0..*] to I_BillOfMaterialStatusText  as _BOMStatusTxt                on  $projection.BillOfMaterialStatus = _BOMStatusTxt.BillOfMaterialStatus
    
    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.ChangeRecordUUID,
        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,
        reference_bom.ChgRecdReasonForChange,
        reference_bom.ExpdCompltnDte,
        reference_bom.ChgRecdAuthznGrpText,
        reference_bom.ChgRecdNmbrChgSts,
        reference_bom.ChangeNumber,
        _ChangeRecord.ChangeRecordType,
        _EngBOMIncStatus.EngBOMIncStatus,
        
  
  
        cast(hextobin('00000000000000000000000000000000') as cs_guidb)                                                 as BillOfMaterialHeaderUUID,
        //concat(concat(concat(BillOfMaterial,BillOfMaterialCategory),BillOfMaterialVariantUsage),BillOfMaterialVariant) as BillOfMaterialUUID,

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

        _Material,
        _Plant,
        //_ChangeRecordEngBOMUsageVH,

        //_ChangeRecordItemRelEngBOMVH,

        _ChangeRecordProductionPlant,
        _EngBOMIncStatus,
        _EngBOMIncStsTxt,
        _BOMVersionStsTxt,
        _ChangeRecordEngBOM,
        _BOMStatusTxt,
        _BOMLink
}