P_ProjScheduleWBSElementAttrib

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_ProjScheduleWBSElementAttrib.
-- 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: PWBSELEMATTR

CREATE VIEW P_ProjScheduleWBSElementAttrib AS
SELECT
  WBSElementInternalID,
  cast ( WBSElement as ps_posid_edit ) AS WBSElement,
  WBSElementExternalID,
  WBSElementObject,
  'PR' AS ObjectType,
  ProjectInternalID,
  BasicStartDate,
  BasicEndDate,
  TentativeActualStartDate,
  TentativeActualEndDate,
  SchedldBasicEarliestStartDate,
  SchedldBasicEarliestEndDate,
  SchedldBasicLatestStartDate,
  ScheduledBasicLatestEndDate,
  SchedldFcstdEarliestStartDate,
  SchedldFcstdEarliestEndDate,
  LatestSchedldFcstdStartDate,
  LatestSchedldFcstdEndDate,
  ActualStartDate,
  ActualEndDate,
  BasicDuration,
  BasicDurationUnit,
  ActualDurationUnit,
  ActualDuration,
  FreeDefinedAttribute01,
  FreeDefinedAttribute02,
  FreeDefinedAttribute03,
  FreeDefinedAttribute04,
  FreeDefinedQuantity1Unit,
  FreeDefinedQuantity1,
  FreeDefinedQuantity2Unit,
  FreeDefinedQuantity2,
  FreeDefinedAmount1Currency,
  FreeDefinedAmount1,
  FreeDefinedAmount2Currency,
  FreeDefinedAmount2,
  FreeDefinedDate1,
  FreeDefinedDate2,
  FreeDefinedIndicator1,
  FreeDefinedIndicator2,
  PriorityCode,
  WBSElementHierarchyLevel,
  Currency,
  Plant,
  CompanyCode,
  WBSElementIsPlanningElement,
  WBSIsAccountAssignmentElement,
  WBSElementIsBillingElement,
  ProjectType,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  ResponsiblePerson,
  ResponsiblePersonName,
  CostCenter,
  ResponsibleCostCenter,
  ObjBasedAuthorizationIsActive,
  ControllingArea,
  RespCostCenterControllingArea,
  ProfitCenter
FROM I_WBSElementByInternalKey
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_WBSElement AS _Extension ON WBSElement = _Extension.WBSElement  -- association [1..1]
;