C_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 C_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: CFIAPCSHDISUTI
-- Parameters: P_KeyDate : sydate, P_StartDate : vdm_v_start_date, P_DisplayCurrency : vdm_v_display_currency, P_Language : sylangu

CREATE VIEW C_APCshDiscUtilization AS
SELECT
  CompanyCode,
  Supplier,
  PaymentTerms,
  TransactionCurrency,
  YearMonth,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Supplier.SupplierName AS SupplierName,
  _PaymentTerms._Text[1: Language = :P_Language].PaymentTermsDescription AS PaymentTermsDescription,
  SupplierAccountGroup,
  _SupplierAccountGroup._SupplierAccountGroupText[1:Language = $parameters.P_Language].AccountGroupName AS SupplierAccountGroupName,
  Country,
  _Country._Text[1: Language = :P_Language].CountryName AS CountryName,
  SupplierRegion,
  _SupplierRegion._RegionText[1:Language = $parameters.P_Language].RegionName AS SupplierRegionName,
  DisplayCurrency,
  TakenCshDiscInDspCrcy_E,
  OfferedCshDiscInDspCrcy_E,
  LostCshDiscInDspCrcy_E,
  1 AS CshDiscUtilizationRatio
FROM I_APCshDiscUtilization
;