P_ChgRecdRefBOMItmVirt

@AbapCatalog.sqlViewName: 'PCRREFBOMITMVT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_ChgRecdRefBOMItmVirt
  as select from I_ChgRecdRefBOMItmBsc as reference_bit
{
  key        ChangeRecordReferenceUUID,

             cast(SUBSTRING( reference_bit.ChangeRecordReference, 1, 40) as matnr)            as Material,
             cast(SUBSTRING( reference_bit.ChangeRecordReference, 41, 4) as werks_d)          as Plant,
             cast(SUBSTRING( reference_bit.ChangeRecordReference, 45, 1) as stlan)            as BillOfMaterialVariantUsage,
             cast(SUBSTRING( reference_bit.ChangeRecordReference, 46, 2) as stalt)            as BillOfMaterialVariant,
             cast ( hextobin('00000000000000000000000000000000') as cs_guid preserving type ) as BillOfMaterialItemUUID,
             cast(SUBSTRING( reference_bit.ChangeRecordReference, 48, 4) as cs_sposn)         as BillOfMaterialItemNumber,
             cast('' as idnrk)                                                                as BillOfMaterialComponent,
             cast('' as stnum)                                                                as BillOfMaterial,
             cast ('M' as stlty preserving type)                                              as BillOfMaterialCategory,

             ChangeRecordUUID,
             ChangeRecord,
             ChangeRecordReferenceType,
             ChangeRecordReferenceSubtype,
             ChangeRecordReference,
             ParentChangeRecordRefUUID,
             IsMainReference,

             ChgRecRefInternalKey1,
             ChgRecRefInternalKey2,
             ChgRecRefInternalKey3,
             ChgRecRefInternalKey4,

             ChgRecdReasonForChange,
             ExpdCompltnDte,
             ChgRecdAuthznGrpText,
             ChgRecdNmbrChgSts,
             ChangeNumber,


             ChgRecdDataMigrationStatus,
             reference_bit.ChangeRecordItemProcgStatus,
             reference_bit.ChgRecdItmTgtSts,
             reference_bit.ChgRecdItmDSgntr,
             @Semantics.user.createdBy: true
             reference_bit.CreatedByUser,
             reference_bit.CreationDateTime,
             @Semantics.user.lastChangedBy: true
             reference_bit.LastChangedByUser,
             reference_bit.LastChangeDateTime,

             ChangeRecordItemRelevance,
             ChangeRecordVirtualRefInd,

             _ChangeRecordBsc

}
where
      ChangeRecordReferenceType = 'BIT'
  and ChangeRecordVirtualRefInd = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFBOMITMBSC"
],
"ASSOCIATED":
[
"I_CHANGERECORDBSC"
],
"BASE":
[
"I_CHGRECDREFBOMITMBSC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/