I_ManageProjectForEndItem

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 I_ManageProjectForEndItem.
-- 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: IMANAGEPROJECT

CREATE VIEW I_ManageProjectForEndItem AS
SELECT
  BomRel.Project AS Project,
  BomRel.Plant AS Plant,
  BomRel.ParameterEffectivityValue AS ParameterEffectivityValue,
  BomRel.BillOfMaterial AS BillOfMaterial,
  BomRel.BillOfMaterialVariant AS BillOfMaterialVariant,
  BomRel.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BomRel.BillOfMaterialVersion AS BillOfMaterialVersion,
  BomRel.VersionSelection AS VersionSelection,
  BomRel.BOMExplosionDate AS BOMExplosionDate,
  BomRel.MjrAssyBckgndProcgStatus AS MjrAssyBckgndProcgStatus,
  ProjectBasicData. ProjectDescription AS ProjectDescription,
  ProjectBasicData. PlannedStartDate AS PlannedStartDate,
  ProjectBasicData. PlannedEndDate AS PlannedEndDate,
  ProjectBasicData. ProjectObject AS ProjectObject,
  ProjectBasicData. ProjectProfileCode AS ProjectProfileCode,
  ProjectBasicData.ResponsiblePersonName AS ResponsiblePersonName,
  ProjectBasicData.ResponsiblePerson AS ResponsiblePerson,
  _ProjectProfile.ProjectProfileCodeText AS ProjectProfileCodeText,
  Material.Material AS Material,
  _Text.MaterialName AS MaterialDescription
INNER JOIN I_Project AS ProjectBasicData ON /* join condition not captured in parsed metadata */
INNER JOIN I_Material AS Material ON /* join condition not captured in parsed metadata */
INNER JOIN I_UnitizedMaterialType AS UnitizedType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS _Text ON Material = _Text.Material AND _Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProjectProfileCodeText AS _ProjectProfile ON ProjectProfileCode = _ProjectProfile.ProjectProfileCode AND _ProjectProfile.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MajorAssemblyProjectStatus AS _status ON ProjectBasicData.ProjectObject = _status.ProjectObject  -- association [0..1]
;