I_ChgRecdRefMBOMSrchSupp

DDL: I_CHGRECDREFMBOMSRCHSUPP SQL: ICHGRECDREFMBSS Type: view COMPOSITE Package: VDM_PLMB_CR

Change Record Reference MBOM Search Supp

I_ChgRecdRefMBOMSrchSupp is a Composite CDS View that provides data about "Change Record Reference MBOM Search Supp" in SAP S/4HANA. It reads from 1 data source (P_ChgRecdRefMBMAfterDataMigrtn) and exposes 25 fields with key field ChangeRecordReferenceUUID. Part of development package VDM_PLMB_CR.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
P_ChgRecdRefMBMAfterDataMigrtn afterDataMigrtn from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECDREFMBSS 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 MBOM Search Supp view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordReferenceUUID
Material P_ChgRecdRefMBMAfterDataMigrtn Material
Plant P_ChgRecdRefMBMAfterDataMigrtn Plant
BillOfMaterialVariantUsage P_ChgRecdRefMBMAfterDataMigrtn BillOfMaterialVariantUsage
BillOfMaterialVariant P_ChgRecdRefMBMAfterDataMigrtn BillOfMaterialVariant
ChangeRecord P_ChgRecdRefMBMAfterDataMigrtn ChangeRecord
ChangeRecordUUID P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordUUID
ChangeRecordReferenceType P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordReferenceType
ChangeRecordReferenceSubtype P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordReferenceSubtype
ChangeRecordRefObjectUUID P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordRefObjectUUID
ParentChangeRecordRefUUID P_ChgRecdRefMBMAfterDataMigrtn ParentChangeRecordRefUUID
IsMainReference P_ChgRecdRefMBMAfterDataMigrtn IsMainReference
ChangeRecordReference P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordReference
ChgRecRefInternalKey1 P_ChgRecdRefMBMAfterDataMigrtn ChgRecRefInternalKey1
ChgRecRefInternalKey2 P_ChgRecdRefMBMAfterDataMigrtn ChgRecRefInternalKey2
ChgRecRefInternalKey3 P_ChgRecdRefMBMAfterDataMigrtn ChgRecRefInternalKey3
ChgRecRefInternalKey4 P_ChgRecdRefMBMAfterDataMigrtn ChgRecRefInternalKey4
CreatedByUser P_ChgRecdRefMBMAfterDataMigrtn CreatedByUser
CreationDateTime P_ChgRecdRefMBMAfterDataMigrtn CreationDateTime
LastChangedByUser P_ChgRecdRefMBMAfterDataMigrtn LastChangedByUser
LastChangeDateTime P_ChgRecdRefMBMAfterDataMigrtn LastChangeDateTime
ChangeRecordVirtualRefInd P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordVirtualRefInd
ChangeRecordItemRelevance P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordItemRelevance
ChgRecdDataMigrationStatus P_ChgRecdRefMBMAfterDataMigrtn ChgRecdDataMigrationStatus
_ChangeRecordBsc P_ChgRecdRefMBMAfterDataMigrtn _ChangeRecordBsc 
@AbapCatalog.sqlViewName: 'ICHGRECDREFMBSS'
@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 MBOM Search Supp'
define view I_ChgRecdRefMBOMSrchSupp
  as select from P_ChgRecdRefMBMAfterDataMigrtn as afterDataMigrtn
{
  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._ChangeRecordBsc
}

Learn More