R_WBSElementTP_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 R_WBSElementTP_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.

CREATE VIEW R_WBSElementTP_2 AS
SELECT
  WBSElementInternalID,
  WBSElementShortID,
  WBSDescription,
  _WBSElementShortText.WBSElementLangBsdDescription AS WBSElementLangBsdDescription,
  ResponsiblePerson,
  ResponsiblePersonName,
  ApplicantCode,
  ApplicantName,
  cast( CompanyCode as bukrs preserving type ) AS CompanyCode,
  BusinessArea,
  cast( ControllingArea as ps_s4_kokrs preserving type ) AS ControllingArea,
  FunctionalArea,
  ProfitCenter,
  ResponsibleCostCenter,
  Plant,
  FreeDefinedTableFieldSemantic,
  FactoryCalendar,
  PriorityCode,
  Currency,
  CostingSheet,
  CostCenter,
  RequestingCostCenter,
  ProjectInternalID,
  WBSElementIsBillingElement,
  WBSElementObject,
  InvestmentProfile,
  WBSIsStatisticalWBSElement,
  WBSIsAccountAssignmentElement,
  ProjectType,
  WBSElementIsPlanningElement,
  WorkCenterLocation,
  ResultAnalysisInternalID,
  TaxJurisdiction,
  cast( FunctionalLocation as tplnr_unconverted preserving type ) AS FunctionalLocation,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  RespCostCenterControllingArea,
  WBSIsMarkedForIntegratedPlng,
  Equipment,
  ProjectObjectChangeNumber,
  WBSElementHierarchyLevel,
  OverheadCode,
  ReferenceElement,
  ProjInterestCalcProfile,
  ProgressAnlysAggregationWeight,
  ReqgCostCenterControllingArea,
  Language,
  IsMarkedForDeletion,
  WBSElementIsGroupingWBSElement,
  WBSElementIsUsedInProjSmmry,
  CostingVariant,
  BasicStartDate,
  ActualStartDate,
  BasicEndDate,
  ActualEndDate,
  TechnicalCompletionDate,
  BasicDuration,
  BasicDurationUnit,
  ActualDuration,
  ActualDurationUnit,
  SchedldBasicEarliestStartDate,
  ScheduledBasicLatestEndDate,
  SchedldFcstdEarliestStartDate,
  LatestSchedldFcstdEndDate,
  TentativeActualStartDate,
  TentativeActualEndDate,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  JntVntrProjectType,
  JntIntrstBillgClass,
  JntIntrstBillgSubClass,
  SubProject,
  InvestmentReason,
  InvestmentScale,
  EnvironmentalInvestmentReason,
  RequestingCompanyCode,
  NetworkAssignmentType,
  CostObject,
  BillingPlan,
  ControllingObjectClass,
  _WBSElementHierarchyData.WBSElementParentInternalID AS WBSElementParentInternalID,
  _WBSElementHierarchyData.WBSElementChildInternalID AS WBSElementChildInternalID,
  _WBSElementHierarchyData.LeftSiblingWBSElmntInternalID AS LeftSiblingWBSElmntInternalID,
  _WBSElementHierarchyData.RightSiblingWBSElmntInternalID AS RightSiblingWBSElmntInternalID,
  FreeDefinedAttribute01,
  FreeDefinedAttribute02,
  FreeDefinedAttribute03,
  FreeDefinedAttribute04,
  FreeDefinedQuantity1,
  FreeDefinedQuantity1Unit,
  FreeDefinedQuantity2,
  FreeDefinedQuantity2Unit,
  FreeDefinedAmount1,
  FreeDefinedAmount1Currency,
  FreeDefinedAmount2,
  FreeDefinedAmount2Currency,
  FreeDefinedDate1,
  FreeDefinedDate2,
  FreeDefinedIndicator1,
  FreeDefinedIndicator2,
  StatusProfile,
  DistributionProfile,
  SchedldBasicEarliestEndDate,
  SchedldBasicLatestStartDate,
  SchedldFcstdEarliestEndDate,
  LatestSchedldFcstdStartDate,
  StatusCombinationCode,
  ObjBasedAuthorizationIsActive
FROM I_WBSElementData_2
LEFT OUTER JOIN I_WBSElementShortText AS _WBSElementShortText ON WBSElementObject = _WBSElementShortText.WBSElementObject AND _WBSElementShortText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WBSElementHierarchyData AS _WBSElementHierarchyData ON WBSElementInternalID = _WBSElementHierarchyData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN E_WBSElement_2 AS _Extension ON WBSElementInternalID = _Extension.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN R_WBSElementTP_2 AS _ParentWBSElement ON wbselementparentinternalid = _ParentWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN R_WBSElementTP_2 AS _SubWBSElement ON WBSElementInternalID = _SubWBSElement.WBSElementParentInternalID  -- association [1..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation  -- association [1..1]
LEFT OUTER JOIN R_ProjectNetworkTP AS _ProjectNetwork ON WBSElementInternalID = _ProjectNetwork.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjectNetworkTP AS _ProjectNetworkUpdate ON WBSElementInternalID = _ProjectNetworkUpdate.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjectNetworkTP AS _ProjectNetworkDelete ON WBSElementInternalID = _ProjectNetworkDelete.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjectNetworkActivityTP AS _ProjectNetworkActivity ON WBSElementInternalID = _ProjectNetworkActivity.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjectNetworkActivityTP AS _ProjectNetworkActivityUpdate ON WBSElementInternalID = _ProjectNetworkActivityUpdate.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjectNetworkActivityTP AS _ProjectNetworkActivityDelete ON WBSElementInternalID = _ProjectNetworkActivityDelete.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNetworkActivityElementTP AS _ProjNtwkActivityElement ON WBSElementInternalID = _ProjNtwkActivityElement.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNetworkActivityElementTP AS _ProjNtwkActivityElementUpdate ON WBSElementInternalID = _ProjNtwkActivityElementUpdate.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNetworkActivityElementTP AS _ProjNtwkActivityElementDelete ON WBSElementInternalID = _ProjNtwkActivityElementDelete.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNtwkActyMatlCompTP AS _ProjNtwkActyMatlComp ON WBSElementInternalID = _ProjNtwkActyMatlComp.AssignedWBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNtwkActyMatlCompTP AS _ProjNtwkActyMatlCompUpdate ON WBSElementInternalID = _ProjNtwkActyMatlCompUpdate.AssignedWBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNtwkActyMatlCompTP AS _ProjNtwkActyMatlCompDelete ON WBSElementInternalID = _ProjNtwkActyMatlCompDelete.AssignedWBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNtwkActivityMilestoneTP AS _ProjNtwkActyMilestone ON WBSElementInternalID = _ProjNtwkActyMilestone.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNtwkActivityMilestoneTP AS _ProjNtwkActyMilestoneUpdate ON WBSElementInternalID = _ProjNtwkActyMilestoneUpdate.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNtwkActivityMilestoneTP AS _ProjNtwkActyMilestoneDelete ON WBSElementInternalID = _ProjNtwkActyMilestoneDelete.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNtwkActyRelationshipTP AS _ProjNtwkActyRelshp ON WBSElementInternalID = _ProjNtwkActyRelshp.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_ProjNtwkActyRelationshipTP AS _ProjNtwkActyRelshpDelete ON WBSElementInternalID = _ProjNtwkActyRelshpDelete.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN R_WBSElementMilestoneTP AS _WBSElementMilestone ON /* condition not available in parsed metadata */  -- association [0..*]
;