I_APCshDiscUtilization

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_APCshDiscUtilization.
-- 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: IFIAPCSHDISUTI
-- Parameters: P_KeyDate : sydate, P_StartDate : vdm_v_start_date, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_APCshDiscUtilization AS
SELECT
  CompanyCode,
  Supplier,
  PaymentTerms,
  TransactionCurrency,
  cast(YearMonth as fis_yearmonth_c) AS YearMonth,
  cast(_Supplier.SupplierAccountGroup as farp_supplier_account_group) AS SupplierAccountGroup,
  cast(_Supplier._StandardAddress.Country as land1_gp) AS Country,
  cast(_Supplier._StandardAddress.Region as farp_supplier_region) AS SupplierRegion,
  DisplayCurrency,
  _Supplier.AuthorizationGroup AS SupplierBasicAuthorizationGrp,
  _SupplierCompany.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  cast( sum( TakenCshDiscInDspCrcy_E ) as farp_taken_cash_discounts_amt) AS TakenCshDiscInDspCrcy_E,
  cast( sum( OfferedCshDiscInDspCrcy_E ) as farp_offered_cash_discounts) AS OfferedCshDiscInDspCrcy_E,
  cast( sum( LostCshDiscInDspCrcy_E ) as farp_lost_cash_discounts) AS LostCshDiscInDspCrcy_E
FROM P_APCshDiscUtilizationA7
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON PaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [1..1]
LEFT OUTER JOIN C_CshDiscFcstPaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_SupplierAccountGroup AS _SupplierAccountGroup ON SupplierAccountGroup = _SupplierAccountGroup.SupplierAccountGroup  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _SupplierRegion ON SupplierRegion = _SupplierRegion.Region AND Country = _SupplierRegion.Country  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
;