I_ChgRecdRefMBOMSrchSupp

DDL: I_CHGRECDREFMBOMSRCHSUPP SQL: ICHGRECDREFMBSS Type: view COMPOSITE Package: VDM_PLMB_CR
25 Fields 1 Data Sources

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.

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 UUID
Material P_ChgRecdRefMBMAfterDataMigrtn Material Vehicle Model
Plant P_ChgRecdRefMBMAfterDataMigrtn Plant Valuation Area
BillOfMaterialVariantUsage P_ChgRecdRefMBMAfterDataMigrtn BillOfMaterialVariantUsage Usage
BillOfMaterialVariant P_ChgRecdRefMBMAfterDataMigrtn BillOfMaterialVariant AlternativeBOM
ChangeRecord P_ChgRecdRefMBMAfterDataMigrtn ChangeRecord Char20
ChangeRecordUUID P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordUUID NodeID
ChangeRecordReferenceType P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordReferenceSubtype Subtype
ChangeRecordRefObjectUUID P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordRefObjectUUID
ParentChangeRecordRefUUID P_ChgRecdRefMBMAfterDataMigrtn ParentChangeRecordRefUUID Node ID
IsMainReference P_ChgRecdRefMBMAfterDataMigrtn IsMainReference Main Reference
ChangeRecordReference P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordReference Ref. Object ID
ChgRecRefInternalKey1 P_ChgRecdRefMBMAfterDataMigrtn ChgRecRefInternalKey1 Key
ChgRecRefInternalKey2 P_ChgRecdRefMBMAfterDataMigrtn ChgRecRefInternalKey2 Key
ChgRecRefInternalKey3 P_ChgRecdRefMBMAfterDataMigrtn ChgRecRefInternalKey3 Key
ChgRecRefInternalKey4 P_ChgRecdRefMBMAfterDataMigrtn ChgRecRefInternalKey4 Key
CreatedByUser P_ChgRecdRefMBMAfterDataMigrtn CreatedByUser User Name
CreationDateTime P_ChgRecdRefMBMAfterDataMigrtn CreationDateTime Timestamp
LastChangedByUser P_ChgRecdRefMBMAfterDataMigrtn LastChangedByUser User Name
LastChangeDateTime P_ChgRecdRefMBMAfterDataMigrtn LastChangeDateTime Timestamp
ChangeRecordVirtualRefInd P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordVirtualRefInd Virtual Reference
ChangeRecordItemRelevance P_ChgRecdRefMBMAfterDataMigrtn ChangeRecordItemRelevance Relevance
ChgRecdDataMigrationStatus P_ChgRecdRefMBMAfterDataMigrtn ChgRecdDataMigrationStatus
_ChangeRecordBsc P_ChgRecdRefMBMAfterDataMigrtn _ChangeRecordBsc

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ChgRecdRefMBOMSrchSupp.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICHGRECDREFMBSS

CREATE VIEW I_ChgRecdRefMBOMSrchSupp AS
SELECT
  afterDataMigrtn.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  afterDataMigrtn.Material AS Material,
  afterDataMigrtn.Plant AS Plant,
  afterDataMigrtn.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  afterDataMigrtn.BillOfMaterialVariant AS BillOfMaterialVariant,
  afterDataMigrtn.ChangeRecord AS ChangeRecord,
  afterDataMigrtn.ChangeRecordUUID AS ChangeRecordUUID,
  afterDataMigrtn.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  afterDataMigrtn.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  afterDataMigrtn.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  afterDataMigrtn.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  afterDataMigrtn.IsMainReference AS IsMainReference,
  afterDataMigrtn.ChangeRecordReference AS ChangeRecordReference,
  afterDataMigrtn.ChgRecRefInternalKey1 AS ChgRecRefInternalKey1,
  afterDataMigrtn.ChgRecRefInternalKey2 AS ChgRecRefInternalKey2,
  afterDataMigrtn.ChgRecRefInternalKey3 AS ChgRecRefInternalKey3,
  afterDataMigrtn.ChgRecRefInternalKey4 AS ChgRecRefInternalKey4,
  afterDataMigrtn.CreatedByUser AS CreatedByUser,
  afterDataMigrtn.CreationDateTime AS CreationDateTime,
  afterDataMigrtn.LastChangedByUser AS LastChangedByUser,
  afterDataMigrtn.LastChangeDateTime AS LastChangeDateTime,
  afterDataMigrtn.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  afterDataMigrtn.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  afterDataMigrtn.ChgRecdDataMigrationStatus AS ChgRecdDataMigrationStatus,
  afterDataMigrtn._ChangeRecordBsc AS _ChangeRecordBsc
FROM P_ChgRecdRefMBMAfterDataMigrtn AS afterDataMigrtn
;

Learn More