R_ProjSrvcOrg

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_ProjSrvcOrg.
-- 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_ProjSrvcOrg AS
SELECT
  service_org_uuid AS ProjectServiceOrganizationUUID,
  org_unit_id AS ProjectServiceOrganization,
  service_org_oid AS ProjectServiceOrganizationOID,
  data_migration_status AS ProjSrvcOrgDataMigrationStatus,
  cast(_ServiceOrganization.sales_org as /s4ppm/tv_svorg_isprojdelivorg) AS ProjSrvcOrgIsProjDeliveryOrg,
  cast(_ServiceOrganization.delivery_org as /s4ppm/tv_svorg_isresourceorg) AS ProjSrvcOrgIsResourceOrg,
  cast(_OrganizationalStructure[1: org_unit_typ='CA'].org_unit_key as /s4ppm/tv_svorg_kokrs) AS ProjSrvcOrgControllingArea,
  cast(_OrganizationalStructure[1: org_unit_typ='CC'].org_unit_key as /s4ppm/tv_svorg_bukrs) AS ProjSrvcOrgCompanyCode,
  cast(_OrganizationalStructure[1: org_unit_typ='SO'].org_unit_key as /s4ppm/tv_svorg_vkorg ) AS ProjSrvcOrgSalesOrg,
  cast(_OrganizationalStructure[1: org_unit_typ='SD'].org_unit_key as /s4ppm/tv_svorg_spart) AS ProjSrvcOrgDivision,
  cast(_OrganizationalStructure[1: org_unit_typ='SC'].org_unit_key as /s4ppm/tv_svorg_vtweg) AS ProjSrvcOrgDistributionChannel,
  cast(_OrganizationalStructure[1: org_unit_typ='PO'].org_unit_key as /s4ppm/tv_svorg_ekorg) AS ProjSrvcOrgPurchaseOrg,
  cast(_OrganizationalStructure[1: org_unit_typ='PL'].org_unit_key as /s4ppm/tv_svorg_werks_d) AS ProjSrvcOrgPlant,
  created_by AS CreatedByUser,
  created_at AS CreationDateTime,
  last_changed_by AS LastChangedByUser,
  last_changed_at AS LastChangeDateTime
FROM /cpd/pwsc_org_at
LEFT OUTER JOIN /cpd/pwsc_orgid AS _ServiceOrganization ON _ServiceOrganization.org_unit_id = ProjectServiceOrganization  -- association [1..1]
LEFT OUTER JOIN /cpd/pwsc_orgpid AS _OrganizationalStructure ON _OrganizationalStructure.org_unit_id = ProjectServiceOrganization AND _OrganizationalStructure.default_val = 'X'  -- association [0..*]
;