C_ChgRecdRefWBSElmntBOMTP

DDL: C_CHGRECDREFWBSELMNTBOMTP Type: view_entity CONSUMPTION Package: VDM_PLMB_CR_O
42 Fields 1 Data Sources 3 Associations

WBS BOM Projection

C_ChgRecdRefWBSElmntBOMTP is a Consumption CDS View that provides data about "WBS BOM Projection" in SAP S/4HANA. It reads from 1 data source (R_ChgRecdRefWBSElmntBOMTP) and exposes 42 fields with key field ChangeRecordReferenceUUID. It has 3 associations to related views. Part of development package VDM_PLMB_CR_O.

Data Sources (1)

SourceAliasJoin Type
R_ChgRecdRefWBSElmntBOMTP R_ChgRecdRefWBSElmntBOMTP projection

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_ProjectBOMLink _BOMLink $projection.BillOfMaterialCategory = _BOMLink.BillOfMaterialCategory and $projection.BillOfMaterial = _BOMLink.BillOfMaterial and $projection.BillOfMaterialVariant = _BOMLink.BillOfMaterialVariant
[1..1] C_ChgRecdRlvnceWBSElmntBOMVH _ChangeRecordItemRelVH $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance and $projection.ChangeRecordType = _ChangeRecordItemRelVH.ChangeRecordType
[1..1] C_ChgRecordItemProcgStatusVH _ProcessingStatusVH $projection.ChangeRecordItemProcgStatus = _ProcessingStatusVH.ChgRecdNextItemProcgStatus and $projection.ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus and $projection.ChangeRecordLifecycleStatus = _ProcessingStatusVH.ChangeRecordLifecycleStatus

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label WBS BOM Projection view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID UUID
virtualProductImageURLproductimageurl
WBSElementInternalID WBSElementInternalID WBS Element
Material Material Vehicle Model
Plant Plant Valuation Area
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterialVariantUsageDesc _BillOfMaterialVariantUsage BillOfMaterialVariantUsageDesc
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
ChangeRecordItemRelevance ChangeRecordItemRelevance Relevance
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus Processing Status
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus
ChangeNumber ChangeNumber Change Number
PlannedStartDate Planned Start
PlannedEndDate Planned Finish
ChangeRecordLifecycleStatus _ChangeRecord ChangeRecordLifecycleStatus Issue Lifecycle
ChangeRecordType _ChangeRecord ChangeRecordType Record Type
ChangeRecordUUID ChangeRecordUUID NodeID
ChangeRecordReferenceType ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype Subtype
ParentChangeRecordRefUUID ParentChangeRecordRefUUID Node ID
MaterialName
WBSDescription _WBSElementBasic WBSDescription WBS Element Name
ChangeRecordReference ChangeRecordReference Ref. Object ID
BillOfMaterial BillOfMaterial BOM
ChangeRecordStatus _ChangeRecord ChangeRecordStatus
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
virtualCreationDateplmbcreated_on
LastChangedByUser LastChangedByUser User Name
BillOfMaterialCategory BillOfMaterialCategory BOM category
LastChangeDateTime LastChangeDateTime Timestamp
virtualLastChangeDateplmbchanged_on
ChgRecdReasonForChange ChgRecdReasonForChange Reason for Chge
ExpdCompltnDte ExpdCompltnDte Exp Completion Date
ChgRecdAuthznGrpText ChgRecdAuthznGrpText Authoriz. Group
ChgRecdNmbrChgSts ChgRecdNmbrChgSts Status
virtualChgRecdObjDgtlSgntrEnableboolean
_Material _Material
_Plant _Plant
_BOMLink _BOMLink
_BillOfMaterialVariantUsage _BillOfMaterialVariantUsage
_WBSElementBasic _WBSElementBasic

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 C_ChgRecdRefWBSElmntBOMTP.
-- 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.

CREATE VIEW C_ChgRecdRefWBSElmntBOMTP AS
SELECT
  ChangeRecordReferenceUUID,
  virtual ProductImageURL : productimageurl AS virtualProductImageURLproductimageurl,
  WBSElementInternalID,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  BillOfMaterialVariant,
  ChangeRecordItemRelevance,
  ChangeRecordItemProcgStatus,
  ChgRecdCurrentItemProcgStatus,
  ChangeNumber,
  _WBSElementBasic._Project.PlannedStartDate AS PlannedStartDate,
  _WBSElementBasic._Project.PlannedEndDate AS PlannedEndDate,
  _ChangeRecord.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  _ChangeRecord.ChangeRecordType AS ChangeRecordType,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ChangeRecordReferenceSubtype,
  ParentChangeRecordRefUUID,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _WBSElementBasic.WBSDescription AS WBSDescription,
  ChangeRecordReference,
  BillOfMaterial,
  _ChangeRecord.ChangeRecordStatus AS ChangeRecordStatus,
  CreatedByUser,
  CreationDateTime,
  virtual CreationDate : /plmb/created_on AS virtualCreationDateplmbcreated_on,
  LastChangedByUser,
  BillOfMaterialCategory,
  LastChangeDateTime,
  virtual LastChangeDate : /plmb/changed_on AS virtualLastChangeDateplmbchanged_on,
  ChgRecdReasonForChange,
  ExpdCompltnDte,
  ChgRecdAuthznGrpText,
  ChgRecdNmbrChgSts,
  virtual ChgRecdObjDgtlSgntrEnable : boolean AS virtualChgRecdObjDgtlSgntrEnableboolean
FROM R_ChgRecdRefWBSElmntBOMTP
LEFT OUTER JOIN I_ProjectBOMLink AS _BOMLink ON BillOfMaterialCategory = _BOMLink.BillOfMaterialCategory AND BillOfMaterial = _BOMLink.BillOfMaterial AND BillOfMaterialVariant = _BOMLink.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN C_ChgRecdRlvnceWBSElmntBOMVH AS _ChangeRecordItemRelVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelVH.ChangeRecordType  -- association [1..1]
LEFT OUTER JOIN C_ChgRecordItemProcgStatusVH AS _ProcessingStatusVH ON ChangeRecordItemProcgStatus = _ProcessingStatusVH.ChgRecdNextItemProcgStatus AND ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus AND ChangeRecordLifecycleStatus = _ProcessingStatusVH.ChangeRecordLifecycleStatus  -- association [1..1]
;

Learn More