A_ChangeRecordReferenceBit

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel: {
//   createEnabled: true,

   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #L
   }
}

@Metadata: {
  ignorePropagatedAnnotations: true
}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@EndUserText.label: 'BOM Item Assignments to Change Records'
define view entity A_ChangeRecordReferenceBit
  as select from I_ChangeRecordRefBOMItmTP_2
  association        to parent A_ChangeRecord as _ChangeRecord    on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
  association [0..1] to E_ChgRecdRefBOMItmBsc as _BOMItmExtension on $projection.ChangeRecordReferenceUUID = _BOMItmExtension.ChangeRecordReferenceUUID
{
  key    ChangeRecordReferenceUUID,
         ChangeRecord,
         ChangeRecordUUID,
         ChangeRecordReferenceType,
         CreatedByUser,
         CreationDateTime,
         LastChangedByUser,
         case
             when LastChangeDateTime = fltp_to_dec( 0.00 as timestampl )
             then fltp_to_dec( 19720401000000.00 as timestampl )
             else LastChangeDateTime
          end                                                      as LastChangeDateTime,
         cast( BillOfMaterialItemNumber as sposn preserving type ) as BillOfMaterialItemNumber,
         BillOfMaterialComponent,
         Material,
         Plant,
         BillOfMaterialVariantUsage,
         BillOfMaterialVariant,
         ChangeRecordItemRelevance,
         _ChangeRecord
}