I_ChgRecdRefEBOMSrchSupp

DDL: I_CHGRECDREFEBOMSRCHSUPP SQL: ICHGRECDREFEBSS Type: view COMPOSITE Package: VDM_PLMB_CR_O

Change Record Reference EBOM Search Supp

I_ChgRecdRefEBOMSrchSupp is a Composite CDS View that provides data about "Change Record Reference EBOM Search Supp" in SAP S/4HANA. It reads from 4 data sources (P_ChgRecdRefEBMAfterDataMigrtn, P_ChgRecdRefEBMBfrDataMigrtn, R_ChgRecdDataMigrationStatus, R_ChgRecdDataMigrationStatus) and exposes 49 fields with key field ChangeRecordReferenceUUID. Part of development package VDM_PLMB_CR_O.

4 data source(s) 49 fields

Data Sources (4)

SourceAliasJoin Type
P_ChgRecdRefEBMAfterDataMigrtn afterDataMigrtn union_all
P_ChgRecdRefEBMBfrDataMigrtn beforeDataMigrtn from
R_ChgRecdDataMigrationStatus tf inner
R_ChgRecdDataMigrationStatus tf inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECDREFEBSS view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
EndUserText.label Change Record Reference EBOM Search Supp view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID P_ChgRecdRefEBMBfrDataMigrtn ChangeRecordReferenceUUID
Material P_ChgRecdRefEBMBfrDataMigrtn Material
Plant P_ChgRecdRefEBMBfrDataMigrtn Plant
BillOfMaterialVariantUsage P_ChgRecdRefEBMBfrDataMigrtn BillOfMaterialVariantUsage
BillOfMaterialVariant P_ChgRecdRefEBMBfrDataMigrtn BillOfMaterialVariant
ChangeRecord P_ChgRecdRefEBMBfrDataMigrtn ChangeRecord
ChangeRecordUUID P_ChgRecdRefEBMBfrDataMigrtn ChangeRecordUUID
ChangeRecordReferenceType P_ChgRecdRefEBMBfrDataMigrtn ChangeRecordReferenceType
ChangeRecordReferenceSubtype P_ChgRecdRefEBMBfrDataMigrtn ChangeRecordReferenceSubtype
ChangeRecordRefObjectUUID P_ChgRecdRefEBMBfrDataMigrtn ChangeRecordRefObjectUUID
ParentChangeRecordRefUUID P_ChgRecdRefEBMBfrDataMigrtn ParentChangeRecordRefUUID
IsMainReference P_ChgRecdRefEBMBfrDataMigrtn IsMainReference
ChangeRecordReference P_ChgRecdRefEBMBfrDataMigrtn ChangeRecordReference
ChgRecRefInternalKey1 P_ChgRecdRefEBMBfrDataMigrtn ChgRecRefInternalKey1
ChgRecRefInternalKey2 P_ChgRecdRefEBMBfrDataMigrtn ChgRecRefInternalKey2
ChgRecRefInternalKey3 P_ChgRecdRefEBMBfrDataMigrtn ChgRecRefInternalKey3
ChgRecRefInternalKey4 P_ChgRecdRefEBMBfrDataMigrtn ChgRecRefInternalKey4
CreatedByUser P_ChgRecdRefEBMBfrDataMigrtn CreatedByUser
CreationDateTime P_ChgRecdRefEBMBfrDataMigrtn CreationDateTime
LastChangedByUser P_ChgRecdRefEBMBfrDataMigrtn LastChangedByUser
LastChangeDateTime P_ChgRecdRefEBMBfrDataMigrtn LastChangeDateTime
ChangeRecordVirtualRefInd P_ChgRecdRefEBMBfrDataMigrtn ChangeRecordVirtualRefInd
ChangeRecordItemRelevance P_ChgRecdRefEBMBfrDataMigrtn ChangeRecordItemRelevance
ChgRecdDataMigrationStatus P_ChgRecdRefEBMBfrDataMigrtn ChgRecdDataMigrationStatus
ChangeRecordReferenceUUID
Material P_ChgRecdRefEBMAfterDataMigrtn Material
Plant P_ChgRecdRefEBMAfterDataMigrtn Plant
BillOfMaterialVariantUsage P_ChgRecdRefEBMAfterDataMigrtn BillOfMaterialVariantUsage
BillOfMaterialVariant P_ChgRecdRefEBMAfterDataMigrtn BillOfMaterialVariant
ChangeRecord P_ChgRecdRefEBMAfterDataMigrtn ChangeRecord
ChangeRecordUUID P_ChgRecdRefEBMAfterDataMigrtn ChangeRecordUUID
ChangeRecordReferenceType P_ChgRecdRefEBMAfterDataMigrtn ChangeRecordReferenceType
ChangeRecordReferenceSubtype P_ChgRecdRefEBMAfterDataMigrtn ChangeRecordReferenceSubtype
ChangeRecordRefObjectUUID P_ChgRecdRefEBMAfterDataMigrtn ChangeRecordRefObjectUUID
ParentChangeRecordRefUUID P_ChgRecdRefEBMAfterDataMigrtn ParentChangeRecordRefUUID
IsMainReference P_ChgRecdRefEBMAfterDataMigrtn IsMainReference
ChangeRecordReference P_ChgRecdRefEBMAfterDataMigrtn ChangeRecordReference
ChgRecRefInternalKey1 P_ChgRecdRefEBMAfterDataMigrtn ChgRecRefInternalKey1
ChgRecRefInternalKey2 P_ChgRecdRefEBMAfterDataMigrtn ChgRecRefInternalKey2
ChgRecRefInternalKey3 P_ChgRecdRefEBMAfterDataMigrtn ChgRecRefInternalKey3
ChgRecRefInternalKey4 P_ChgRecdRefEBMAfterDataMigrtn ChgRecRefInternalKey4
CreatedByUser P_ChgRecdRefEBMAfterDataMigrtn CreatedByUser
CreationDateTime P_ChgRecdRefEBMAfterDataMigrtn CreationDateTime
LastChangedByUser P_ChgRecdRefEBMAfterDataMigrtn LastChangedByUser
LastChangeDateTime P_ChgRecdRefEBMAfterDataMigrtn LastChangeDateTime
ChangeRecordVirtualRefInd P_ChgRecdRefEBMAfterDataMigrtn ChangeRecordVirtualRefInd
ChangeRecordItemRelevance P_ChgRecdRefEBMAfterDataMigrtn ChangeRecordItemRelevance
ChgRecdDataMigrationStatus P_ChgRecdRefEBMAfterDataMigrtn ChgRecdDataMigrationStatus
_ChangeRecord P_ChgRecdRefEBMAfterDataMigrtn _ChangeRecord 
@AbapCatalog.sqlViewName: 'ICHGRECDREFEBSS'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Change Record Reference EBOM Search Supp'
define view I_ChgRecdRefEBOMSrchSupp 
  as select from P_ChgRecdRefEBMBfrDataMigrtn as beforeDataMigrtn
    inner join   R_ChgRecdDataMigrationStatus as tf on ( tf.ChgRecdDataMigrationPhase = 'X' ) 
                                                    or ( tf.ChgRecdDataMigrationPhase = 'R' )
{
  key beforeDataMigrtn.ChangeRecordReferenceUUID,
      beforeDataMigrtn.Material,
      beforeDataMigrtn.Plant,
      beforeDataMigrtn.BillOfMaterialVariantUsage,
      beforeDataMigrtn.BillOfMaterialVariant,
      beforeDataMigrtn.ChangeRecord,
      beforeDataMigrtn.ChangeRecordUUID,
      beforeDataMigrtn.ChangeRecordReferenceType,
      beforeDataMigrtn.ChangeRecordReferenceSubtype,
      beforeDataMigrtn.ChangeRecordRefObjectUUID,
      beforeDataMigrtn.ParentChangeRecordRefUUID,
      beforeDataMigrtn.IsMainReference,
      beforeDataMigrtn.ChangeRecordReference,
      beforeDataMigrtn.ChgRecRefInternalKey1,
      beforeDataMigrtn.ChgRecRefInternalKey2,
      beforeDataMigrtn.ChgRecRefInternalKey3,
      beforeDataMigrtn.ChgRecRefInternalKey4,
      beforeDataMigrtn.CreatedByUser,
      beforeDataMigrtn.CreationDateTime,
      beforeDataMigrtn.LastChangedByUser,
      beforeDataMigrtn.LastChangeDateTime,
      beforeDataMigrtn.ChangeRecordVirtualRefInd,
      beforeDataMigrtn.ChangeRecordItemRelevance,
      beforeDataMigrtn.ChgRecdDataMigrationStatus,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      beforeDataMigrtn._ChangeRecord
}

union all 

  select from P_ChgRecdRefEBMAfterDataMigrtn as afterDataMigrtn
    inner join          R_ChgRecdDataMigrationStatus   as tf on ( tf.ChgRecdDataMigrationPhase = 'F' )
{
  key afterDataMigrtn.ChangeRecordReferenceUUID,
      afterDataMigrtn.Material,
      afterDataMigrtn.Plant,
      afterDataMigrtn.BillOfMaterialVariantUsage,
      afterDataMigrtn.BillOfMaterialVariant,
      afterDataMigrtn.ChangeRecord,
      afterDataMigrtn.ChangeRecordUUID,
      afterDataMigrtn.ChangeRecordReferenceType,
      afterDataMigrtn.ChangeRecordReferenceSubtype,
      afterDataMigrtn.ChangeRecordRefObjectUUID,
      afterDataMigrtn.ParentChangeRecordRefUUID,
      afterDataMigrtn.IsMainReference,
      afterDataMigrtn.ChangeRecordReference,
      afterDataMigrtn.ChgRecRefInternalKey1,
      afterDataMigrtn.ChgRecRefInternalKey2,
      afterDataMigrtn.ChgRecRefInternalKey3,
      afterDataMigrtn.ChgRecRefInternalKey4,
      afterDataMigrtn.CreatedByUser,
      afterDataMigrtn.CreationDateTime,
      afterDataMigrtn.LastChangedByUser,
      afterDataMigrtn.LastChangeDateTime,
      afterDataMigrtn.ChangeRecordVirtualRefInd,
      afterDataMigrtn.ChangeRecordItemRelevance,
      afterDataMigrtn.ChgRecdDataMigrationStatus,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      afterDataMigrtn._ChangeRecord
}

Learn More