C_ProjSrvcOrgTP

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_ProjSrvcOrgTP.
-- 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 C_ProjSrvcOrgTP AS
SELECT
  ProjectServiceOrganizationUUID,
  ProjectServiceOrganization,
  _Text[1: Language = $session.system_language].ProjSrvcOrgName AS ProjSrvcOrgName,
  cast (ProjSrvcOrgIsTimePostingAllwd as abap_boolean preserving type ) AS ProjSrvcOrgIsTimePostingAllwd,
  ProjSrvcOrgControllingArea,
  ProjSrvcOrgCompanyCode,
  ProjSrvcOrgPurchaseOrg,
  ProjSrvcOrgPlant,
  ProjSrvcOrgSalesOrg,
  ProjSrvcOrgDivision,
  _DivisionText.DivisionName as DivisionName : localized AS DivisionNameasDivisionNamelocalized,
  _ControllingAreaText.ControllingAreaName AS ControllingAreaName,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  _PurchasingOrganizationText.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PlantText.PlantName AS PlantName,
  ProjSrvcOrgDistributionChannel,
  ProjSrvcOrgIsProjDeliveryOrg,
  ProjSrvcOrgIsResourceOrg,
  _CostCenter[1: ProjSrvcOrgIsMainCostCenter='X'].ProjSrvcOrgCostCenter AS ProjSrvcOrgCostCenter,
  _CostCenter[1: ProjSrvcOrgIsMainCostCenter='X']._CostCenterText.CostCenterName AS ProjSrvcOrgCostCenterName,
  virtual ProjSrvcOrgClassfctnTxt : text60 AS virtualProjSrvcOrgClassfctnTxttext60,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_ProjSrvcOrgTP
;