P_CHGRECDREFMFGBOMVIRTUAL

CDS View

Private view for Mfg. BOM Ref. (Virtual)

P_CHGRECDREFMFGBOMVIRTUAL is a CDS View in S/4HANA. Private view for Mfg. BOM Ref. (Virtual). 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgRecdRefMBOMDataMigrtn view union_all COMPOSITE Change Record Reference MBOM Data Mgrtn
P_ChgRecdRefMfgBOM view union_all TRANSACTIONAL Private view for Mfg. BOM Reference 
@AbapCatalog.sqlViewName: 'PCRREFMFGBOMVERV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

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

define view P_ChgRecdRefMfgBOMVirtual
  as select from I_ChgRecdRefMfgBOMBsc
{
  key ChangeRecordReferenceUUID,

      cast(SUBSTRING( ChangeRecordReference, 1, 40) as matnr)          as Material,
      cast(SUBSTRING( ChangeRecordReference, 41, 4) as werks_d)        as Plant,
      cast(SUBSTRING( ChangeRecordReference, 45, 1) as stlan)          as BillOfMaterialVariantUsage,
      cast(SUBSTRING( ChangeRecordReference, 46, 2) as stalt)          as BillOfMaterialVariant,
      cast(SUBSTRING( ChangeRecordReference, 48, 4) as cs_versn)       as BillOfMaterialVersion,

      ChangeRecordUUID,
      ChangeRecord,
      @ObjectModel.readOnly:true
      ChangeRecordReferenceType,
      ChangeRecordReferenceSubtype,
      ChangeRecordRefObjectUUID,
      ChangeRecordReference,
      ParentChangeRecordRefUUID,
      IsMainReference,
      ChgRecRefInternalKey1,
      ChgRecRefInternalKey2,
      ChgRecRefInternalKey3,
      ChgRecRefInternalKey4,
      @Semantics.user.createdBy: true
      @ObjectModel.readOnly:true
      CreatedByUser,
      CreationDateTime,
      @Semantics.user.lastChangedBy: true
      @ObjectModel.readOnly:true
      LastChangedByUser,
      LastChangeDateTime,
      ChangeRecordItemRelevance,
      ChgRecdDataMigrationStatus,
      ChangeRecordItemProcgStatus,
      ChgRecdItmTgtSts,
      ChgRecdItmDSgntr,
      ChangeRecordVirtualRefInd,
      ChgRecdReasonForChange,
      ExpdCompltnDte,
      ChgRecdAuthznGrpText,
      ChgRecdNmbrChgSts,
      ChangeNumber,
      cast( hextobin('00000000000000000000000000000000')  as cs_guidb) as BillOfMaterialHeaderUUID,
      @ObjectModel.readOnly:true
      ''                                                               as BillOfMaterialUUID,
      cast('' as stnum)                                                as BillOfMaterial,
      cast('' as stlty)                                                as BillOfMaterialCategory,
      cast('' as cs_versnind)                                          as IsVersionBillOfMaterial,
      cast('' as cs_versnst)                                           as BOMVersionStatus,
      cast('' as stlst)                                                as BillOfMaterialStatus,

      _ChangeRecordBsc
}
where
  ChangeRecordVirtualRefInd = 'X'

Learn More