P_ProjectObject_2

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 P_ProjectObject_2.
-- 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: PPROJECTOBJECT2

CREATE VIEW P_ProjectObject_2 AS
SELECT
  ProjectObject AS ProjectObjectNode,
  'A' AS IsActiveEntity,
  ProjectObject AS ProjectObjectRootNode,
  cast(' ' as abap.char(22)) AS ProjectObjectParentNode,
  cast('PD' as abap.char(2)) AS ProjectObjectType,
  ProjectInternalID AS ProjectObjectInternalID,
  cast( '' as ps_s4_posid ) AS WBSElement,
  ProfitCenter AS ProjectObjectProfitCenter,
  cast( '' as ps_s4_fkstl ) AS ResponsibleCostCenter,
  cast( '' as ps_s4_prart ) AS ProjectType,
  cast( '' as aufart ) as OrderType AS WBSElementObjectasProjectObjectNode,
  _WBSElement.WBSElementExternalID AS ProjectObjectExternalID,
  case _Project.ProjectExternalID when '' then cast( _Project.Project as ps_pspid_edit preserving type ) else _Project.ProjectExternalID end as Project AS ProjectExternalIDendasProject,
  MaintenanceOrderDesc AS ProjectObjectDescription,
  case _WBSElement._Project.ProjectWithCodingMask when '' then cast( _WBSElement._Project.Project as ps_pspid_edit preserving type ) else _WBSElement._Project.ProjectWithCodingMask end as Project AS ProjectWithCodingMaskendasProject,
  case SuperiorNtwkActivityInternalID when '00000000' then cast('NV' as abap.char(2)) else cast('EL' as abap.char(2)) end as ProjectObjectType AS char2endasProjectObjectType,
  cast( '' as aufart ) as OrderType AS ControllingObjectasProjectObjectNode,
  cast( '' as aufart ) AS OrderType
FROM I_ProjectData_2
LEFT OUTER JOIN I_ProjectData_2 AS _Projectdata ON ProjectObjectRootNode = _Projectdata.ProjectObject  -- association [0..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElement ON ProjectObjectInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentItem AS _SC ON _SV.SrvcContrItmControllingObject = _SC.ControllingObject AND _SC.WBSElementInternalID <> '00000000'  -- association [0..*]
-- UNION ALL with additional select branch(es): I_WBSElementHierarchyData, I_MaintenanceOrder, I_ProjectNetwork, I_NetworkActivityForCostReport, I_InternalOrder, I_ManufacturingOrder, I_AcctgServiceDocumentItem, I_AcctgServiceDocumentItem
;