C_ProjectBasicInfo

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_ProjectBasicInfo.
-- 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: CPROJBSCINFO

CREATE VIEW C_ProjectBasicInfo AS
SELECT
  I_ProjectWithVersion.Project AS Project,
  I_ProjectWithVersion.Version AS Version,
  I_ProjectWithVersion.ProjectWithCodingMask AS ProjectWithCodingMask,
  I_ProjectWithVersion.ProjectObject AS ProjectObject,
  I_ProjectWithVersion.ProjectInternalID AS ProjectInternalID,
  I_ProjectWithVersion.ControllingArea AS ControllingArea,
  cast ( I_ProjectWithVersion._ControllingArea.ControllingAreaName as ps_s4_bezei ) AS ControllingAreaName,
  cast( I_ProjectWithVersion._NetworkProfile._Text[1: Language = $session.system_language ].NetworkProfileName as ps_s4_ntwk_profi_txt ) AS NetworkProfileName,
  I_ProjectWithVersion.ResponsiblePerson AS ResponsiblePerson,
  I_ProjectWithVersion.ResponsiblePersonName AS ResponsiblePersonName,
  I_ProjectWithVersion.ApplicantCode AS ApplicantCode,
  I_ProjectWithVersion.ApplicantName AS ApplicantName,
  I_ProjectWithVersion.PlannedStartDate AS PlannedStartDate,
  I_ProjectWithVersion.PlannedEndDate AS PlannedEndDate,
  I_ProjectWithVersion.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_ProjectWithVersion.CreationDate AS CreationDate,
  I_ProjectWithVersion.CreatedByUser AS CreatedByUser,
  I_ProjectWithVersion.LastChangeDate AS LastChangeDate,
  I_ProjectWithVersion.LastChangedByUser AS LastChangedByUser,
  I_ProjectWithVersion.ProjectProfileCode AS ProjectProfileCode,
  I_ProjectWithVersion.CompanyCode AS CompanyCode,
  I_ProjectWithVersion.BusinessArea AS BusinessArea,
  I_ProjectWithVersion.ProfitCenter AS ProfitCenter,
  I_ProjectWithVersion.Plant AS Plant,
  I_ProjectWithVersion.CostCenter AS CostCenter,
  I_ProjectWithVersion.ControllingObjectClass AS ControllingObjectClass,
  I_ProjectWithVersion.FactoryCalendar AS FactoryCalendar,
  I_ProjectWithVersion.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive,
  I_ProjectWithVersion._ProjectShortText AS _ProjectShortText
FROM I_ProjectWithVersion
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 ProjectObject = _UsrByObjBsdAuthzn.ProjectObject AND _UsrByObjBsdAuthzn.ObjectBasedAuthorizationUser = $session.user AND _UsrByObjBsdAuthzn.AuthorizationTypeValue > 1  -- association [0..1]
;