P_CHGRECDREFBOMVIRTUAL

CDS View

P_CHGRECDREFBOMVIRTUAL is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChgRecdRefBOMDataMigrtn view union_all COMPOSITE Change Record Reference BOM Data Migrtn 
@AbapCatalog.sqlViewName: 'PCRREFBOMVERV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_ChgRecdRefBOMVirtual
  as select from I_ChgRecdRefBOMBsc as reference_bom
{
  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('' as cs_stlnr)                                      as BillOfMaterial,
      cast('' as stlty)                                         as BillOfMaterialCategory,
      reference_bom.ChangeRecord,
      reference_bom.ChangeRecordUUID,
      reference_bom.ChangeRecordReferenceType,
      reference_bom.ChangeRecordReferenceSubtype,
      reference_bom.ParentChangeRecordRefUUID,
      reference_bom.IsMainReference,
      reference_bom.ChangeRecordReference,
      reference_bom.ChgRecRefInternalKey1,
      reference_bom.ChgRecRefInternalKey2,
      reference_bom.ChgRecRefInternalKey3,
      reference_bom.CreatedByUser,
      reference_bom.CreationDateTime,
      reference_bom.LastChangedByUser,
      reference_bom.LastChangeDateTime,
      reference_bom.ChangeRecordVirtualRefInd,
      reference_bom.ChangeRecordItemRelevance,
      reference_bom.ChangeRecordRefObjectUUID,
      reference_bom.ChangeRecordItemProcgStatus,
      reference_bom.ChgRecdDataMigrationStatus,
      reference_bom.ChangeNumber,
      reference_bom.ChgRecdItmTgtSts,
      reference_bom.ChgRecdItmDSgntr,
      reference_bom.ChgRecdReasonForChange,
      reference_bom.ExpdCompltnDte,
      reference_bom.ChgRecdAuthznGrpText,
      reference_bom.ChgRecdNmbrChgSts,
      reference_bom.ChangeRecordLifecycleStatus,
      reference_bom.ChangeRecordStatus
}
where
  ChangeRecordVirtualRefInd = 'X'

Learn More