N_ChangeRecordObjPgEngBOM

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_ChangeRecordObjPgEngBOM.
-- 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: NCHGRECREFEBOM

CREATE VIEW N_ChangeRecordObjPgEngBOM AS
SELECT
  ChangeRecordReferenceUUID,
  EngineeringBOM.Material AS Material,
  EngineeringBOM.Plant AS Plant,
  EngineeringBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _ChangeRecordEngBOMUsageVH._BillOfMaterialUsageText[1:Language = $session.system_language].BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  EngineeringBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  EngineeringBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ChangeRecordRefObjectUUID,
  ParentChangeRecordRefUUID,
  ChangeRecordItemRelevance,
  _EngBOMIncStatus.EngBOMIncStatus AS EngBOMIncStatus,
  EngineeringBOM.BOMVersionStatus AS BOMVersionStatus,
  EngineeringBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  ChangeRecordReference,
  EngineeringBOM.BillOfMaterial AS BillOfMaterial,
  EngineeringBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  _ChangeRecordObjPg.ChangeNumber AS ChangeNumber,
  EngineeringBOMBsc.CreatedByUser AS CreatedByUser,
  CreationDateTime,
  cast( '00000000' as /plmb/created_on ) AS CreationDate,
  EngineeringBOMBsc.LastChangedByUser AS LastChangedByUser,
  EngineeringBOMBsc.ChangeRecord AS ChangeRecord,
  _ChangeRecordObjPg.ChangeRecordType AS ChangeRecordType,
  EngineeringBOMBsc.LastChangeDateTime AS LastChangeDateTime,
  cast( '00000000' as /plmb/changed_on ) AS LastChangeDate
FROM I_ChgRecdRefEBOMSrchSupp AS EngineeringBOMBsc
LEFT OUTER JOIN I_ChangeRecordEngBOMHdrSearch AS EngineeringBOM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ChangeRecordObjPg AS _ChangeRecordObjPg ON ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN C_ChangeRecordEngBOMVH AS _ChangeRecordEngBOMVH ON Material = _ChangeRecordEngBOMVH.Material AND Plant = _ChangeRecordEngBOMVH.Plant AND BillOfMaterialVariantUsage = _ChangeRecordEngBOMVH.BillOfMaterialVariantUsage AND BillOfMaterialVariant = _ChangeRecordEngBOMVH.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordEngBOMUsageVH AS _ChangeRecordEngBOMUsageVH ON BillOfMaterialVariantUsage = _ChangeRecordEngBOMUsageVH.BillOfMaterialVariantUsage  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordItemRelEbmVH AS _ChangeRecordItemRelEngBOMVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelEngBOMVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelEngBOMVH.ChangeRecordType AND ( ChangeRecordReferenceType = _ChangeRecordItemRelEngBOMVH.ChangeRecordReferenceType OR _ChangeRecordItemRelEngBOMVH.ChangeRecordReferenceType = ' ' )  -- association [1..1]
LEFT OUTER JOIN I_ChgRecdProductionPlant AS _ChangeRecordProductionPlant ON ChangeRecordUUID = _ChangeRecordProductionPlant.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_EngBOMIncStatus AS _EngBOMIncStatus ON ChangeRecord = _EngBOMIncStatus.ChangeRecord AND BillOfMaterial = _EngBOMIncStatus.EngBillOfMaterial AND BillOfMaterialVariant = _EngBOMIncStatus.EngBillOfMaterialVariant AND BillOfMaterialVersion = _EngBOMIncStatus.EngBillOfMaterialVersion AND _EngBOMIncStatus.EngBillOfMaterialCategory = 'M'  -- association [0..1]
LEFT OUTER JOIN I_EngBOMIncStatusText AS _EngBOMIncStsTxt ON engbomincstatus = _EngBOMIncStsTxt.EngBOMIncStatus  -- association [0..*]
LEFT OUTER JOIN I_VersionStatus AS _BOMVersionStsTxt ON BOMVersionStatus = _BOMVersionStsTxt.BOMVersionStatus AND _BOMVersionStsTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialStatusText AS _BOMStatusTxt ON BillOfMaterialStatus = _BOMStatusTxt.BillOfMaterialStatus  -- association [0..*]
;