N_ChgRecdObjPgWBSElmntBOM

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 N_ChgRecdObjPgWBSElmntBOM.
-- 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: NCHGRCDOBJPGWBS

CREATE VIEW N_ChgRecdObjPgWBSElmntBOM AS
SELECT
  ChangeRecordReferenceUUID,
  BOMLink.WBSElementInternalID AS WBSElementInternalID,
  BOMLink.Material AS Material,
  BOMLink.Plant AS Plant,
  BOMLink.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  BOMLink.BillOfMaterialVariant AS BillOfMaterialVariant,
  _WBSElementBasic._Project.PlannedStartDate AS PlannedStartDate,
  _WBSElementBasic._Project.PlannedEndDate AS PlannedEndDate,
  ChangeNumber,
  ChangeRecordItemRelevance,
  ChangeRecordItemProcgStatus,
  _ChangeRecordObjPg.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  _ChangeRecordObjPg.ChangeRecordItemIsNotEditable AS ChangeRecordItemIsNotEditable,
  _ChangeRecordObjPg.ChangeRecordItmIsAddDelEnabled AS ChangeRecordItmIsAddDelEnabled,
  _ChangeRecordObjPg.ChangeRecordType AS ChangeRecordType,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ChangeRecordReferenceSubtype,
  ParentChangeRecordRefUUID,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _WBSElementBasic.WBSDescription AS WBSDescription,
  ChangeRecordReference,
  _ChangeRecordObjPg.ChgRecdItemProcgStatusIsEnbld AS ChgRecdItemProcgStatusIsEnbld,
  BillOfMaterial,
  _ChangeRecordObjPg.ChangeRecordStatus AS ChangeRecordStatus,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  BillOfMaterialCategory,
  LastChangeDateTime,
  ChangeRecordVirtualRefInd
FROM I_ChangeRecdRefWBSElmntBOMBsc AS RefWBSElmntBOMBsc
INNER JOIN I_ProjectBOMLink AS BOMLink ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ChangeRecordWBSElmntBOMVH AS _ChangeRecordWBSBOMVH ON WBSElementInternalID = _ChangeRecordWBSBOMVH.WBSElementInternalID AND Material = _ChangeRecordWBSBOMVH.Material AND Plant = _ChangeRecordWBSBOMVH.Plant AND BillOfMaterialVariantUsage = _ChangeRecordWBSBOMVH.BillOfMaterialVariantUsage AND BillOfMaterialVariant = _ChangeRecordWBSBOMVH.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN C_ChgRecdRefWBSElmntBOM AS _ChangeRecordObjPg ON ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialVariantUsage ON BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage AND _BillOfMaterialVariantUsage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasic ON WBSElementInternalID = _WBSElementBasic.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN C_ChgRecordItemProcgStatusVH AS _ProcessingStatusVH ON ChangeRecordItemProcgStatus = _ProcessingStatusVH.ChgRecdNextItemProcgStatus AND ChangeRecordLifecycleStatus = _ProcessingStatusVH.ChangeRecordLifecycleStatus AND _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus = ''  -- association [1..1]
LEFT OUTER JOIN I_ChgRecdItemProcgStatusText AS _ProcessingStatusTxt ON ChangeRecordItemProcgStatus = _ProcessingStatusTxt.ChangeRecordItemProcgStatus  -- association [0..*]
LEFT OUTER JOIN E_ChgRecdRefWBSElmntBOMBsc AS _WBSElmntBOMExtension ON ChangeRecordReferenceUUID = _WBSElmntBOMExtension.ChangeRecordReferenceUUID  -- association [0..1]
LEFT OUTER JOIN C_ChgRecdRlvnceWBSElmntBOMVH AS _ChangeRecordItemRelVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelVH.ChangeRecordType AND ( ChangeRecordReferenceType = _ChangeRecordItemRelVH.ChangeRecordReferenceType OR _ChangeRecordItemRelVH.ChangeRecordReferenceType = ' ' )  -- association [1..1]
;