P_ProjSchedWBSElemVersAttrib

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_ProjSchedWBSElemVersAttrib.
-- 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: PWBSELVERSATTR

CREATE VIEW P_ProjSchedWBSElemVersAttrib AS
SELECT
  ProjectWBSElement.WBSElementInternalID AS WBSElementInternalID,
  ProjectWBSElement.Version AS Version,
  cast ( ProjectWBSElement.WBSElement as ps_posid_edit ) AS WBSElement,
  ProjectWBSElement.WBSElementExternalID AS WBSElementExternalID,
  ProjectWBSElement.WBSElementObject AS WBSElementObject,
  'V2' AS ObjectType,
  ProjectWBSElement.ProjectInternalID AS ProjectInternalID,
  ProjectWBSElement.WBSDescription AS WBSDescription,
  ProjectWBSElement.BasicStartDate AS BasicStartDate,
  ProjectWBSElement.BasicEndDate AS BasicEndDate,
  ProjectWBSElement.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  ProjectWBSElement.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  ProjectWBSElement.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  ProjectWBSElement.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  ProjectWBSElement.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  ProjectWBSElement.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  ProjectWBSElement.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  ProjectWBSElement.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  ProjectWBSElement.ActualStartDate AS ActualStartDate,
  ProjectWBSElement.ActualEndDate AS ActualEndDate,
  ProjectWBSElement.BasicDuration AS BasicDuration,
  ProjectWBSElement.BasicDurationUnit AS BasicDurationUnit,
  ProjectWBSElement.ActualDurationUnit AS ActualDurationUnit,
  ProjectWBSElement.ActualDuration AS ActualDuration,
  ProjectWBSElement.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  ProjectWBSElement.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  ProjectWBSElement.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  ProjectWBSElement.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  ProjectWBSElement.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  ProjectWBSElement.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  ProjectWBSElement.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  ProjectWBSElement.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  ProjectWBSElement.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  ProjectWBSElement.FreeDefinedAmount1 AS FreeDefinedAmount1,
  ProjectWBSElement.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  ProjectWBSElement.FreeDefinedAmount2 AS FreeDefinedAmount2,
  ProjectWBSElement.FreeDefinedDate1 AS FreeDefinedDate1,
  ProjectWBSElement.FreeDefinedDate2 AS FreeDefinedDate2,
  ProjectWBSElement.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  ProjectWBSElement.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  ProjectWBSElement.PriorityCode AS PriorityCode,
  ProjectWBSElement.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  ProjectWBSElement.Currency AS Currency,
  ProjectWBSElement.Plant AS Plant,
  ProjectWBSElement.CompanyCode AS CompanyCode,
  ProjectWBSElement.WBSElementIsPlanningElement AS WBSElementIsPlanningElement,
  ProjectWBSElement.WBSIsAccountAssignmentElement AS WBSIsAccountAssignmentElement,
  ProjectWBSElement.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  ProjectWBSElement.ProjectType AS ProjectType,
  ProjectWBSElement.CreationDate AS CreationDate,
  ProjectWBSElement.CreatedByUser AS CreatedByUser,
  ProjectWBSElement.LastChangeDate AS LastChangeDate,
  ProjectWBSElement.ResponsiblePerson AS ResponsiblePerson,
  ProjectWBSElement.ResponsiblePersonName AS ResponsiblePersonName,
  ProjectWBSElement.CostCenter AS CostCenter,
  ProjectWBSElement.ResponsibleCostCenter AS ResponsibleCostCenter
FROM I_WBSElementVersionData AS ProjectWBSElement
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _Status ON _Status.StatusObject = WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_ProjectApplicant AS _ProjectApplicant ON ApplicantCode = _ProjectApplicant.ApplicantCode  -- association [0..1]
LEFT OUTER JOIN E_WBSElementVersionData AS _Extension ON WBSElementInternalID = _Extension.WBSElementInternalID AND Version = _Extension.Version  -- association [1..1]
;