C_ServiceOrderAnalyticsQry

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_ServiceOrderAnalyticsQry.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_ServiceOrderAnalyticsQry AS
SELECT
  source_currency => TransactionCurrency AS source_currencyTransactionCurrency,
  target_currency => $parameters.P_DisplayCurrency AS P_DisplayCurrency,
  exchange_rate_type => 'M' AS exchange_rate_typeM,
  exchange_rate_date => cast( $session.system_date as abap.dats) AS dats
FROM I_ServiceOrderCube_2
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannel ON SalesOrganization = _DistributionChannel.SalesOrganization AND DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrgDivisionValueHelp AS _OrganizationDivision ON SalesOrganization = _OrganizationDivision.SalesOrganization AND DistributionChannel = _OrganizationDivision.DistributionChannel AND Division = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeValueHelp AS _SalesOffice ON SalesOrganization = _SalesOffice.SalesOrganization AND DistributionChannel = _SalesOffice.DistributionChannel AND Division = _SalesOffice.OrganizationDivision AND SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupValueHelp AS _SalesGroup ON SalesOffice = _SalesGroup.SalesOffice AND SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN C_DischannelOrgUnitVH AS _OrgUnitDistributionChannel ON SalesOrganizationOrgUnitID = _OrgUnitDistributionChannel.OrganizationalUnit AND OrgUnitDistributionChannel = _OrgUnitDistributionChannel.OrgUnitDistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_SalesOrgDivisionVH AS _SalesOrganizationDivision ON SalesOrganizationOrgUnitID = _SalesOrganizationDivision.OrganizationalUnit AND OrgUnitDistributionChannel = _SalesOrganizationDivision.DistributionChannel AND OrgUnitDivision = _SalesOrganizationDivision.OrgUnitDivision  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeOrgUnitVH AS _SalesOfficeOrgUnit ON SalesOrganizationOrgUnitID = _SalesOfficeOrgUnit.OrganizationalUnit AND OrgUnitDistributionChannel = _SalesOfficeOrgUnit.DistributionChannel AND OrgUnitDivision = _SalesOfficeOrgUnit.Division AND SalesOfficeOrgUnitID = _SalesOfficeOrgUnit.SalesOfficeOrgUnitID  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupOrgUnitVH AS _SalesGroupOrgUnit ON SalesOfficeOrgUnitID = _SalesGroupOrgUnit.SalesOfficeOrgUnitID AND SalesGroupOrgUnitID = _SalesGroupOrgUnit.SalesGroupOrgUnitID  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceOrder = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
;