P_ChgRecdRefBOMAfterDataMigrtn

DDL: P_CHGRECDREFBOMAFTERDATAMIGRTN SQL: PCHGRECDREFBADM Type: view COMPOSITE Package: VDM_PLMB_CR_O
36 Fields 1 Data Sources

Change Record Reference BOM After Data Migration

P_ChgRecdRefBOMAfterDataMigrtn is a Composite CDS View that provides data about "Change Record Reference BOM After Data Migration" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefBOMBsc) and exposes 36 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 PCHGRECDREFBADM 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 (36)

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
ChgRecdDataMigrationStatus I_ChgRecdRefBOMBsc ChgRecdDataMigrationStatus status value done
ChangeNumber I_ChgRecdRefBOMBsc ChangeNumber Change Number
ChgRecdItmTgtSts I_ChgRecdRefBOMBsc ChgRecdItmTgtSts Tgt Proc. Sts
ChgRecdItmDSgntr I_ChgRecdRefBOMBsc ChgRecdItmDSgntr Itm. Dgt. Sign.
IsConfiguredMaterial BOMLink IsConfiguredMaterial Configured matl
ChgRecdReasonForChange I_ChgRecdRefBOMBsc ChgRecdReasonForChange Reason for Chge
ExpdCompltnDte I_ChgRecdRefBOMBsc ExpdCompltnDte Exp Completion Date
ChgRecdAuthznGrpText I_ChgRecdRefBOMBsc ChgRecdAuthznGrpText Authoriz. Group
ChgRecdNmbrChgSts I_ChgRecdRefBOMBsc ChgRecdNmbrChgSts Status
ChangeRecordLifecycleStatus I_ChgRecdRefBOMBsc ChangeRecordLifecycleStatus Issue Lifecycle
ChangeRecordStatus I_ChgRecdRefBOMBsc ChangeRecordStatus

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_ChgRecdRefBOMAfterDataMigrtn.
-- 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: PCHGRECDREFBADM

CREATE VIEW P_ChgRecdRefBOMAfterDataMigrtn 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.ChgRecdDataMigrationStatus AS ChgRecdDataMigrationStatus,
  reference_bom.ChangeNumber AS ChangeNumber,
  reference_bom.ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  reference_bom.ChgRecdItmDSgntr AS ChgRecdItmDSgntr,
  BOMLink.IsConfiguredMaterial AS IsConfiguredMaterial,
  reference_bom.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  reference_bom.ExpdCompltnDte AS ExpdCompltnDte,
  reference_bom.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  reference_bom.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  reference_bom.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  reference_bom.ChangeRecordStatus AS ChangeRecordStatus
FROM I_ChgRecdRefBOMBsc AS reference_bom
;

Learn More