I_ChgRecdRefBOMSrchSupp

DDL: I_CHGRECDREFBOMSRCHSUPP SQL: ICHGRECDREFBSS Type: view COMPOSITE

Change Record Reference BOM Search Supp

I_ChgRecdRefBOMSrchSupp is a Composite CDS View that provides data about "Change Record Reference BOM Search Supp" in SAP S/4HANA. It reads from 4 data sources (P_ChgRecdRefBOMAfterDataMigrtn, P_ChgRecdRefBOMBfrDataMigrtn, R_ChgRecdDataMigrationStatus, R_ChgRecdDataMigrationStatus) and exposes 47 fields with key field ChangeRecordReferenceUUID.

4 data source(s) 47 fields

Data Sources (4)

SourceAliasJoin Type
P_ChgRecdRefBOMAfterDataMigrtn afterDataMigrtn union_all
P_ChgRecdRefBOMBfrDataMigrtn beforeDataMigrtn from
R_ChgRecdDataMigrationStatus tf inner
R_ChgRecdDataMigrationStatus tf inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECDREFBSS 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 BOM Search Supp view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID P_ChgRecdRefBOMBfrDataMigrtn ChangeRecordReferenceUUID
Material P_ChgRecdRefBOMBfrDataMigrtn Material
Plant P_ChgRecdRefBOMBfrDataMigrtn Plant
BillOfMaterialVariantUsage P_ChgRecdRefBOMBfrDataMigrtn BillOfMaterialVariantUsage
BillOfMaterialVariant P_ChgRecdRefBOMBfrDataMigrtn BillOfMaterialVariant
ChangeRecord P_ChgRecdRefBOMBfrDataMigrtn ChangeRecord
ChangeRecordUUID P_ChgRecdRefBOMBfrDataMigrtn ChangeRecordUUID
ChangeRecordReferenceType P_ChgRecdRefBOMBfrDataMigrtn ChangeRecordReferenceType
ChangeRecordReferenceSubtype P_ChgRecdRefBOMBfrDataMigrtn ChangeRecordReferenceSubtype
ParentChangeRecordRefUUID P_ChgRecdRefBOMBfrDataMigrtn ParentChangeRecordRefUUID
IsMainReference P_ChgRecdRefBOMBfrDataMigrtn IsMainReference
ChangeRecordReference P_ChgRecdRefBOMBfrDataMigrtn ChangeRecordReference
ChgRecRefInternalKey1 P_ChgRecdRefBOMBfrDataMigrtn ChgRecRefInternalKey1
ChgRecRefInternalKey2 P_ChgRecdRefBOMBfrDataMigrtn ChgRecRefInternalKey2
ChgRecRefInternalKey3 P_ChgRecdRefBOMBfrDataMigrtn ChgRecRefInternalKey3
CreatedByUser P_ChgRecdRefBOMBfrDataMigrtn CreatedByUser
CreationDateTime P_ChgRecdRefBOMBfrDataMigrtn CreationDateTime
LastChangedByUser P_ChgRecdRefBOMBfrDataMigrtn LastChangedByUser
LastChangeDateTime P_ChgRecdRefBOMBfrDataMigrtn LastChangeDateTime
ChangeRecordVirtualRefInd P_ChgRecdRefBOMBfrDataMigrtn ChangeRecordVirtualRefInd
ChangeRecordItemRelevance P_ChgRecdRefBOMBfrDataMigrtn ChangeRecordItemRelevance
ChangeRecordRefObjectUUID P_ChgRecdRefBOMBfrDataMigrtn ChangeRecordRefObjectUUID
ChangeRecordItemProcgStatus P_ChgRecdRefBOMBfrDataMigrtn ChangeRecordItemProcgStatus
ChangeRecordReferenceUUID
Material P_ChgRecdRefBOMAfterDataMigrtn Material
Plant P_ChgRecdRefBOMAfterDataMigrtn Plant
BillOfMaterialVariantUsage P_ChgRecdRefBOMAfterDataMigrtn BillOfMaterialVariantUsage
BillOfMaterialVariant P_ChgRecdRefBOMAfterDataMigrtn BillOfMaterialVariant
ChangeRecord P_ChgRecdRefBOMAfterDataMigrtn ChangeRecord
ChangeRecordUUID P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordUUID
ChangeRecordReferenceType P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordReferenceType
ChangeRecordReferenceSubtype P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordReferenceSubtype
ParentChangeRecordRefUUID P_ChgRecdRefBOMAfterDataMigrtn ParentChangeRecordRefUUID
IsMainReference P_ChgRecdRefBOMAfterDataMigrtn IsMainReference
ChangeRecordReference P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordReference
ChgRecRefInternalKey1 P_ChgRecdRefBOMAfterDataMigrtn ChgRecRefInternalKey1
ChgRecRefInternalKey2 P_ChgRecdRefBOMAfterDataMigrtn ChgRecRefInternalKey2
ChgRecRefInternalKey3 P_ChgRecdRefBOMAfterDataMigrtn ChgRecRefInternalKey3
CreatedByUser P_ChgRecdRefBOMAfterDataMigrtn CreatedByUser
CreationDateTime P_ChgRecdRefBOMAfterDataMigrtn CreationDateTime
LastChangedByUser P_ChgRecdRefBOMAfterDataMigrtn LastChangedByUser
LastChangeDateTime P_ChgRecdRefBOMAfterDataMigrtn LastChangeDateTime
ChangeRecordVirtualRefInd P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordVirtualRefInd
ChangeRecordItemRelevance P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordItemRelevance
ChangeRecordRefObjectUUID P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordRefObjectUUID
ChangeRecordItemProcgStatus P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordItemProcgStatus
ChgRecdDataMigrationStatus P_ChgRecdRefBOMAfterDataMigrtn ChgRecdDataMigrationStatus 
@AbapCatalog.sqlViewName: 'ICHGRECDREFBSS'
@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 BOM Search Supp'
define view I_ChgRecdRefBOMSrchSupp 
  as select from P_ChgRecdRefBOMBfrDataMigrtn 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.ParentChangeRecordRefUUID, 
      beforeDataMigrtn.IsMainReference,
      beforeDataMigrtn.ChangeRecordReference,
      beforeDataMigrtn.ChgRecRefInternalKey1,
      beforeDataMigrtn.ChgRecRefInternalKey2,
      beforeDataMigrtn.ChgRecRefInternalKey3,
      beforeDataMigrtn.CreatedByUser,
      beforeDataMigrtn.CreationDateTime,
      beforeDataMigrtn.LastChangedByUser,
      beforeDataMigrtn.LastChangeDateTime,
      beforeDataMigrtn.ChangeRecordVirtualRefInd,
      beforeDataMigrtn.ChangeRecordItemRelevance,
      beforeDataMigrtn.ChangeRecordRefObjectUUID,
      beforeDataMigrtn.ChangeRecordItemProcgStatus,
      beforeDataMigrtn.ChgRecdDataMigrationStatus
}

union all 
  
  select from P_ChgRecdRefBOMAfterDataMigrtn 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.ParentChangeRecordRefUUID,
      afterDataMigrtn.IsMainReference,
      afterDataMigrtn.ChangeRecordReference,
      afterDataMigrtn.ChgRecRefInternalKey1,
      afterDataMigrtn.ChgRecRefInternalKey2,
      afterDataMigrtn.ChgRecRefInternalKey3,
      afterDataMigrtn.CreatedByUser,
      afterDataMigrtn.CreationDateTime,
      afterDataMigrtn.LastChangedByUser,
      afterDataMigrtn.LastChangeDateTime,
      afterDataMigrtn.ChangeRecordVirtualRefInd,
      afterDataMigrtn.ChangeRecordItemRelevance,
      afterDataMigrtn.ChangeRecordRefObjectUUID,
      afterDataMigrtn.ChangeRecordItemProcgStatus,
      afterDataMigrtn.ChgRecdDataMigrationStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CHGRECDREFBOMAFTERDATAMIGRTN",
"P_CHGRECDREFBOMBFRDATAMIGRTN",
"R_CHGRECDDATAMIGRATIONSTATUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More