P_ChgRecdRefBOMDataMigrtn

DDL: P_CHGRECDREFBOMDATAMIGRTN SQL: PCHGRECDREFBDM Type: view COMPOSITE Package: VDM_PLMB_CR_O
26 Fields 1 Data Sources

Change Record SDM Helper View for BOM

P_ChgRecdRefBOMDataMigrtn is a Composite CDS View that provides data about "Change Record SDM Helper View for BOM" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefBOMBsc) and exposes 26 fields with key field ChangeRecordReferenceUUID. Part of development package VDM_PLMB_CR_O.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefBOMBsc reference_bom from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCHGRECDREFBDM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (26)

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

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 P_ChgRecdRefBOMDataMigrtn.
-- 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: PCHGRECDREFBDM

CREATE VIEW P_ChgRecdRefBOMDataMigrtn AS
SELECT
  reference_bom.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  BOMLink.Material AS Material,
  BOMLink.Plant AS Plant,
  BOMLink.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BOMLink.BillOfMaterialVariant AS BillOfMaterialVariant,
  cast( BOMLink.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  BOMLink.BillOfMaterialCategory AS BillOfMaterialCategory,
  reference_bom.ChangeRecord AS ChangeRecord,
  reference_bom.ChangeRecordUUID AS ChangeRecordUUID,
  reference_bom.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_bom.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_bom.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_bom.IsMainReference AS IsMainReference,
  reference_bom.ChangeRecordReference AS ChangeRecordReference,
  reference_bom.ChgRecRefInternalKey1 AS ChgRecRefInternalKey1,
  reference_bom.ChgRecRefInternalKey2 AS ChgRecRefInternalKey2,
  reference_bom.ChgRecRefInternalKey3 AS ChgRecRefInternalKey3,
  reference_bom.CreatedByUser AS CreatedByUser,
  reference_bom.CreationDateTime AS CreationDateTime,
  reference_bom.LastChangedByUser AS LastChangedByUser,
  reference_bom.LastChangeDateTime AS LastChangeDateTime,
  reference_bom.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  reference_bom.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_bom.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  reference_bom.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  reference_bom.ChangeNumber AS ChangeNumber
FROM I_ChgRecdRefBOMBsc AS reference_bom
;

Learn More