I_EngmntProjSrvcOrgDefValues

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 I_EngmntProjSrvcOrgDefValues.
-- 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: IEPSRVCORGDEFLT

CREATE VIEW I_EngmntProjSrvcOrgDefValues AS
SELECT
  EngagementProjectServiceOrg,
  cast( _CompanyCode.AssignedOrganisation as fis_bukrs ) AS CompanyCode,
  cast( _ControllingArea.AssignedOrganisation as fis_kokrs) AS ControllingArea,
  cast( _SaleOrganization.AssignedOrganisation as vkorg ) AS SalesOrganization,
  cast( _DistributionChannel.AssignedOrganisation as vtweg ) AS DistributionChannel,
  cast( _Division.AssignedOrganisation as spart ) AS Division,
  cast( _PurchasingOrganization.AssignedOrganisation as ekorg) AS PurchasingOrganization,
  cast( _Plant.AssignedOrganisation as werks_d ) AS Plant,
  _CostCenter.AssignedOrganisation AS CostCenter
FROM I_EngagementProjectSrvcOrg AS _EngagementProjectServiceOrg
LEFT OUTER JOIN I_EngagementProjectSrvcOrgDets AS _CompanyCode ON EngagementProjectServiceOrg = _CompanyCode.EngagementProjectServiceOrg AND _CompanyCode.AssignedOrganisationIsDefault = 'X' AND _CompanyCode.AssignedOrganisationType = 'CC'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgDets AS _ControllingArea ON EngagementProjectServiceOrg = _ControllingArea.EngagementProjectServiceOrg AND _ControllingArea.AssignedOrganisationIsDefault = 'X' AND _ControllingArea.AssignedOrganisationType = 'CA'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgDets AS _SaleOrganization ON EngagementProjectServiceOrg = _SaleOrganization.EngagementProjectServiceOrg AND _SaleOrganization.AssignedOrganisationIsDefault = 'X' AND _SaleOrganization.AssignedOrganisationType = 'SO'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgDets AS _DistributionChannel ON EngagementProjectServiceOrg = _DistributionChannel.EngagementProjectServiceOrg AND _DistributionChannel.AssignedOrganisationIsDefault = 'X' AND _DistributionChannel.AssignedOrganisationType = 'SC'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgDets AS _Division ON EngagementProjectServiceOrg = _Division.EngagementProjectServiceOrg AND _Division.AssignedOrganisationIsDefault = 'X' AND _Division.AssignedOrganisationType = 'SD'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgDets AS _PurchasingOrganization ON EngagementProjectServiceOrg = _PurchasingOrganization.EngagementProjectServiceOrg AND _PurchasingOrganization.AssignedOrganisationIsDefault = 'X' AND _PurchasingOrganization.AssignedOrganisationType = 'PO'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgDets AS _Plant ON EngagementProjectServiceOrg = _Plant.EngagementProjectServiceOrg AND _Plant.AssignedOrganisationIsDefault = 'X' AND _Plant.AssignedOrganisationType = 'PL'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgDets AS _CostCenter ON EngagementProjectServiceOrg = _CostCenter.EngagementProjectServiceOrg AND _CostCenter.AssignedOrganisationIsDefault = 'X' AND _CostCenter.AssignedOrganisationType = 'CS'  -- association [0..1]
;