R_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 R_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 R_ProjSrvcOrgTP AS
SELECT
  ProjectServiceOrganizationUUID,
  ProjectServiceOrganizationOID,
  cast (ProjectServiceOrganization as /s4ppm/tv_svorg_id) AS ProjectServiceOrganization,
  ProjSrvcOrgIsProjDeliveryOrg,
  ProjSrvcOrgIsResourceOrg,
  ProjSrvcOrgIsTimePostingAllwd,
  ProjSrvcOrgControllingArea,
  ProjSrvcOrgCompanyCode,
  ProjSrvcOrgSalesOrg,
  ProjSrvcOrgDivision,
  ProjSrvcOrgDistributionChannel,
  ProjSrvcOrgPurchaseOrg,
  ProjSrvcOrgPlant,
  ProjSrvcOrgDataMigrationStatus,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_ProjSrvcOrg AS ServiceOrganization
LEFT OUTER JOIN R_ProjSrvcOrgTextTP AS _TextBetter ON _TextBetter.Language = $session.system_language AND _TextBetter.ProjectServiceOrganization = ProjectServiceOrganization  -- association [1..1]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON _DivisionText.Division = ProjSrvcOrgDivision  -- association [1..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON _ControllingAreaText.ControllingArea = ProjSrvcOrgControllingArea  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON _CompanyCodeText.CompanyCode = ProjSrvcOrgCompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganizationText ON _PurchasingOrganizationText.PurchasingOrganization = ProjSrvcOrgPurchaseOrg  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlantText ON _PlantText.Plant = ProjSrvcOrgPlant  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON _SalesOrganizationText.SalesOrganization = ProjSrvcOrgSalesOrg  -- association [1..*]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON _DistributionChannelText.DistributionChannel = ProjSrvcOrgDistributionChannel  -- association [1..*]
LEFT OUTER JOIN R_ProjSrvcOrgCostCenterTP AS _CostCenter ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_ProjSrvcOrgTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [1..*]
;