N_ChangeRecordObjPgMfgBOM

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_ChangeRecordObjPgMfgBOM.
-- 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: NCHGRECREFMBOMTP

CREATE VIEW N_ChangeRecordObjPgMfgBOM AS
SELECT
  ChangeRecordReferenceUUID,
  ManufacturingBOM.Material AS Material,
  ManufacturingBOM.Plant AS Plant,
  ManufacturingBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _ChangeRecordMfgBOMUsageVH._BillOfMaterialUsageText[1:Language = $session.system_language].BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  ManufacturingBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  ManufacturingBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  ManufacturingBOM.BOMVersionStatus AS BOMVersionStatus,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  _ChangeRecordTP.ChangeRecordType AS ChangeRecordType,
  ParentChangeRecordRefUUID,
  ChangeRecordItemRelevance,
  ManufacturingBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  _ProductionVersion.HasProductionVersion AS HasProductionVersion,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  ChangeRecordReference,
  ManufacturingBOM.BillOfMaterial AS BillOfMaterial,
  ManufacturingBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  _ChangeRecordTP.ChangeNumber AS ChangeNumber,
  ReferenceMfgBOM.CreatedByUser AS CreatedByUser,
  CreationDateTime,
  cast( '00000000' as /plmb/created_on ) AS CreationDate,
  ReferenceMfgBOM.LastChangedByUser AS LastChangedByUser,
  LastChangeDateTime,
  cast( '00000000' as /plmb/changed_on ) AS LastChangeDate,
  cast (' ' as mpe_business_process preserving type) AS BusinessProcess
FROM I_ChgRecdRefMBOMSrchSupp AS ReferenceMfgBOM
LEFT OUTER JOIN I_ChangeRecordMfgBOMHdrSearch AS ManufacturingBOM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ChangeRecordObjPg AS _ChangeRecordTP ON ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN C_ChangeRecordMfgBOMVH AS _ChangeRecordMfgBOMVH ON Material = _ChangeRecordMfgBOMVH.Material AND Plant = _ChangeRecordMfgBOMVH.Plant AND BillOfMaterialVariantUsage = _ChangeRecordMfgBOMVH.BillOfMaterialVariantUsage AND BillOfMaterialVariant = _ChangeRecordMfgBOMVH.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_ChangeRecordMfgBOMUsageVH AS _ChangeRecordMfgBOMUsageVH ON BillOfMaterialVariantUsage = _ChangeRecordMfgBOMUsageVH.BillOfMaterialVariantUsage  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordItemRelMbmVH AS _ChangeRecordItemRelVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelVH.ChangeRecordType AND ( ChangeRecordReferenceType = _ChangeRecordItemRelVH.ChangeRecordReferenceType OR _ChangeRecordItemRelVH.ChangeRecordReferenceType = ' ' )  -- association [1..1]
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..*]
LEFT OUTER JOIN I_ChgRecdProductionVersion AS _ProductionVersion ON Material = _ProductionVersion.Material AND Plant = _ProductionVersion.Plant AND BillOfMaterialVariantUsage = _ProductionVersion.BillOfMaterialVariantUsage AND BillOfMaterialVariant = _ProductionVersion.BillOfMaterialVariant AND _ProductionVersion.PlanningAndExecutionBOMIsDiff = 'X'  -- association [0..1]
;