C_APCshDiscUtilznOvw

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_APCshDiscUtilznOvw.
-- 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: CAPCSHDISUTIOV
-- Parameters: P_DisplayCurrency : vdm_v_display_currency, P_Language : sylangu, P_KeyDate : sydate, P_StartDate : sydate, P_CurrentYearMonth : vdm_yearmonth, P_LastMonthStartDateYearMonth : vdm_yearmonth

CREATE VIEW C_APCshDiscUtilznOvw AS
SELECT
  lookupEntity : 'P_APCalendarLast6Mnths' AS lookupEntityP_APCalendarLast6Mnths,
  resultElement : 'KeyDate' AS resultElementKeyDate,
  resultElement : 'FirstDayOfLastHalfYearDate' AS resultElementFirstDayOfLastHalfYearDate,
  resultElement : 'CurrentYearMonth' AS resultElementCurrentYearMonth,
  resultElement : 'LastMonthStartDateYearMonth' AS resultElementLastMonthStartDateYearMonth,
  binding : [{ targetParameter : 'P_DisplayCurrency', type : #PARAMETER, value : 'P_DisplayCurrency' AS P_KeyDate,
  P_StartDate : $parameters.P_StartDate AS P_StartDate,
  U.Supplier AS Supplier,
  U.PaymentTerms AS PaymentTerms,
  U.TransactionCurrency AS TransactionCurrency,
  cast(U.YearMonth as fis_yearmonth_c) AS YearMonth,
  U.Country AS SupplierCountry,
  U.SupplierBasicAuthorizationGrp AS SupplierBasicAuthorizationGrp,
  U.SupplierAccountGroup AS SupplierAccountGroup,
  _SupplierCompany.ReconciliationAccount AS ReconciliationAccount,
  _SupplierCompany.AccountingClerk AS AccountingClerk,
  U.DisplayCurrency AS DisplayCurrency,
  U.TakenCshDiscInDspCrcy_E AS TakenCshDiscAmtInDspCrcy,
  U.OfferedCshDiscInDspCrcy_E AS OfferedCshDiscAmtInDspCrcy,
  U.LostCshDiscInDspCrcy_E AS LostCshDiscAmtInDspCrcy,
  U._Country AS _Country,
  U._CustomerPaymentTerms AS _CustomerPaymentTerms,
  U._DisplayCurrency AS _DisplayCurrency
FROM I_APCshDiscUtilization
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON U.CompanyCode = _SupplierCompany.CompanyCode AND U.Supplier = _SupplierCompany.Supplier  -- association [1..1]
;