C_WBSElementBasicInfo

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 C_WBSElementBasicInfo.
-- 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: CWBSBSCINFO

CREATE VIEW C_WBSElementBasicInfo AS
SELECT
  WBSElement.WBSElementWithCodingMask AS WBSElement,
  WBSElement.Version AS Version,
  WBSElement.WBSElementWithCodingMask AS WBSElementWithCodingMask,
  WBSElement.WBSElementObject AS WBSElementObject,
  WBSElement.WBSElementInternalID AS WBSElementInternalID,
  WBSElement.ProjectInternalID AS ProjectInternalID,
  WBSElement.Project AS Project,
  WBSElement.IsMarkedForDeletion AS IsMarkedForDeletion,
  case when WBSElement._WBSElementShortText.LanguageBasedShortText is not initial then WBSElement._WBSElementShortText.LanguageBasedShortText else WBSElement.WBSDescription end as WBSDescription AS WBSDescriptionendasWBSDescription,
  WBSElement.CompanyCode AS CompanyCode,
  cast( WBSElement._CompanyCode.CompanyCodeName as ps_s4_butxt preserving type ) AS CompanyCodeName,
  WBSElement.ResponsiblePerson AS ResponsiblePerson,
  WBSElement.ResponsiblePersonName AS ResponsiblePersonName,
  WBSElement.BasicStartDate AS BasicStartDate,
  WBSElement.BasicEndDate AS BasicEndDate,
  WBSElement.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  WBSElement.ApplicantCode AS ApplicantCode,
  WBSElement.ApplicantName AS ApplicantName,
  WBSElement.ProjectType AS ProjectType,
  cast( WBSElement._ProjectType._Text[1: Language = $session.system_language ].ProjectTypeName as ps_s4_pratx preserving type ) AS ProjectTypeName,
  WBSElement.PriorityCode AS PriorityCode,
  cast( WBSElement._PriorityCode._Text[1: Language = $session.system_language ].PriorityCodeName as ps_s4_priotext preserving type ) AS PriorityCodeName,
  WBSElement.ControllingObjectClass AS ControllingObjectClass,
  cast( WBSElement._ControllingObjectClass._Text[1: Language = $session.system_language ].ControllingObjectClassName as ps_s4_scope_cvtext ) AS ControllingObjectClassName,
  WBSElement.ControllingArea AS ControllingArea,
  cast( WBSElement._ControllingArea.ControllingAreaName as ps_s4_bezei preserving type ) AS ControllingAreaName,
  WBSElement.BusinessArea AS BusinessArea,
  cast( WBSElement._BusinessArea._Text[1: Language = $session.system_language ].BusinessAreaName as fis_gtext preserving type) AS BusinessAreaName,
  WBSElement.ProfitCenter AS ProfitCenter,
  WBSElement._ProfitCenter[1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text[1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  WBSElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  WBSElement.RequestingCostCenter AS RequestingCostCenter,
  WBSElement.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  WBSElement.Plant AS Plant,
  WBSElement._Plant.PlantName AS PlantName,
  WBSElement.ActualStartDate AS ActualStartDate,
  WBSElement.ActualEndDate AS ActualEndDate,
  WBSElement.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  WBSElement.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  WBSElement.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  WBSElement.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  WBSElement.WBSIsAccountAssignmentElement AS WBSIsAccountAssignmentElement,
  WBSElement.WBSElementIsPlanningElement AS WBSElementIsPlanningElement,
  WBSElement.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  WBSElement.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  WBSElement.CostingSheet AS CostingSheet,
  WBSElement.OverheadCode AS OverheadCode,
  WBSElement.CreatedByUser AS CreatedByUser,
  WBSElement.CreationDate AS CreationDate,
  WBSElement.LastChangedByUser AS LastChangedByUser,
  WBSElement.LastChangeDate AS LastChangeDate,
  WBSElement._WBSElementShortText AS _WBSElementShortText,
  _Project.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive
FROM I_WBSElementWithVersion AS WBSElement
LEFT OUTER JOIN C_ProjectStsObjActiveSts AS _Status ON _Status.StatusObject = WBSElementObject  -- association [0..*]
LEFT OUTER JOIN I_ProjectResponsiblePerson AS _ResponsiblePerson ON ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_ProjectApplicant AS _ProjectApplicant ON ApplicantCode = _ProjectApplicant.ApplicantCode  -- association [0..1]
LEFT OUTER JOIN I_UserAccByObjBsdAuthzn AS _UsrByObjBsdAuthzn ON WBSElementObject = _UsrByObjBsdAuthzn.ProjectObject AND _UsrByObjBsdAuthzn.ObjectBasedAuthorizationUser = $session.user AND _UsrByObjBsdAuthzn.AuthorizationTypeValue > 1  -- association [0..1]
;