I_SlsQtanCnvrsnRateAnalytics

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_SlsQtanCnvrsnRateAnalytics.
-- 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: ISDSQCRA
-- Parameters: P_Date : sydate

CREATE VIEW I_SlsQtanCnvrsnRateAnalytics AS
SELECT
  cast(SQIA.SalesDocument as sales_quotation preserving type) AS SalesQuotation,
  cast(SQIA.SalesDocumentItem as sales_quotation_item preserving type) AS SalesQuotationItem,
  SQIA.SalesDocumentType AS SalesQuotationType,
  SQIA.SalesDocumentItemType AS SalesQuotationItemType,
  SQIA.SalesOrganization AS SalesOrganization,
  SQIA._SalesOrganization AS _SalesOrganization,
  SQIA.DistributionChannel AS DistributionChannel,
  SQIA._DistributionChannel AS _DistributionChannel,
  SQIA.OrganizationDivision AS OrganizationDivision,
  SQIA._OrganizationDivision AS _OrganizationDivision,
  SQIA.SalesOffice AS SalesOffice,
  SQIA._SalesOffice AS _SalesOffice,
  SQIA.SalesGroup AS SalesGroup,
  SQIA._SalesGroup AS _SalesGroup,
  SQIA.SoldToParty AS SoldToParty,
  SQIA._SoldToParty AS _SoldToParty,
  cast(COALESCE(ItemPartner.ResponsibleEmployeeWorkAgrmt, HeaderPartner.ResponsibleEmployeeWorkAgrmt) as resp_empl) AS ResponsibleEmployee,
  cast(COALESCE(ItemPartner.SalesEmployeeWorkAgreement, HeaderPartner.SalesEmployeeWorkAgreement) as sales_empl) AS SalesEmployee,
  SQIA.CreationDate AS CreationDate,
  SQIA.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  SQIA.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  SQIA.Material AS Material,
  SQIA._Material AS _Material,
  SQIA.Product AS Product,
  SQIA._Product AS _Product,
  SQIA.TransactionCurrency AS TransactionCurrency,
  SQIA._TransactionCurrency AS _TransactionCurrency,
  SQIA.SalesQuotationNetAmount AS SalesQuotationNetAmount
FROM I_SalesQuotationItemAnalytics AS SQIA
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _SalesEmployee ON SalesEmployee = _SalesEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ResponsibleEmployee ON ResponsibleEmployee = _ResponsibleEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesQuotation = _Extension.SalesDocument AND SalesQuotationItem = _Extension.SalesDocumentItem  -- association [0..1]
;