I_ChgRecdRefBOMSrchSupp

DDL: I_CHGRECDREFBOMSRCHSUPP SQL: ICHGRECDREFBSS Type: view COMPOSITE Package: VDM_PLMB_CR
24 Fields 1 Data Sources

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 1 data source (P_ChgRecdRefBOMAfterDataMigrtn) and exposes 24 fields with key field ChangeRecordReferenceUUID. Part of development package VDM_PLMB_CR.

Data Sources (1)

SourceAliasJoin Type
P_ChgRecdRefBOMAfterDataMigrtn afterDataMigrtn from

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 (24)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordReferenceUUID UUID
Material P_ChgRecdRefBOMAfterDataMigrtn Material Vehicle Model
Plant P_ChgRecdRefBOMAfterDataMigrtn Plant Valuation Area
BillOfMaterialVariantUsage P_ChgRecdRefBOMAfterDataMigrtn BillOfMaterialVariantUsage Usage
BillOfMaterialVariant P_ChgRecdRefBOMAfterDataMigrtn BillOfMaterialVariant AlternativeBOM
ChangeRecord P_ChgRecdRefBOMAfterDataMigrtn ChangeRecord Char20
ChangeRecordUUID P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordUUID NodeID
ChangeRecordReferenceType P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordReferenceSubtype Subtype
ParentChangeRecordRefUUID P_ChgRecdRefBOMAfterDataMigrtn ParentChangeRecordRefUUID Node ID
IsMainReference P_ChgRecdRefBOMAfterDataMigrtn IsMainReference Main Reference
ChangeRecordReference P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordReference Ref. Object ID
ChgRecRefInternalKey1 P_ChgRecdRefBOMAfterDataMigrtn ChgRecRefInternalKey1 Key
ChgRecRefInternalKey2 P_ChgRecdRefBOMAfterDataMigrtn ChgRecRefInternalKey2 Key
ChgRecRefInternalKey3 P_ChgRecdRefBOMAfterDataMigrtn ChgRecRefInternalKey3 Key
CreatedByUser P_ChgRecdRefBOMAfterDataMigrtn CreatedByUser User Name
CreationDateTime P_ChgRecdRefBOMAfterDataMigrtn CreationDateTime Timestamp
LastChangedByUser P_ChgRecdRefBOMAfterDataMigrtn LastChangedByUser User Name
LastChangeDateTime P_ChgRecdRefBOMAfterDataMigrtn LastChangeDateTime Timestamp
ChangeRecordVirtualRefInd P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordVirtualRefInd Virtual Reference
ChangeRecordItemRelevance P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordItemRelevance Relevance
ChangeRecordRefObjectUUID P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordRefObjectUUID
ChangeRecordItemProcgStatus P_ChgRecdRefBOMAfterDataMigrtn ChangeRecordItemProcgStatus Processing Status
ChgRecdDataMigrationStatus P_ChgRecdRefBOMAfterDataMigrtn ChgRecdDataMigrationStatus

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_ChgRecdRefBOMSrchSupp.
-- 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: ICHGRECDREFBSS

CREATE VIEW I_ChgRecdRefBOMSrchSupp 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.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  afterDataMigrtn.IsMainReference AS IsMainReference,
  afterDataMigrtn.ChangeRecordReference AS ChangeRecordReference,
  afterDataMigrtn.ChgRecRefInternalKey1 AS ChgRecRefInternalKey1,
  afterDataMigrtn.ChgRecRefInternalKey2 AS ChgRecRefInternalKey2,
  afterDataMigrtn.ChgRecRefInternalKey3 AS ChgRecRefInternalKey3,
  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.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  afterDataMigrtn.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  afterDataMigrtn.ChgRecdDataMigrationStatus AS ChgRecdDataMigrationStatus
FROM P_ChgRecdRefBOMAfterDataMigrtn AS afterDataMigrtn
;

Learn More