P_APCshDiscUtilization10

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 P_APCshDiscUtilization10.
-- 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: PFIAPCSHDISUTI10
-- Parameters: P_KeyDate : abap.dats, P_BeforeKeyDateDays : abap.int4, P_Language : abap.lang

CREATE VIEW P_APCshDiscUtilization10 AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  Supplier,
  PaymentTerms,
  TransactionCurrency,
  KeyDate,
  TakenCshDiscInTransacCrcy,
  cast(OfferedCshDiscInTransacCrcy as abap.curr( 23, 2 )) AS OfferedCshDiscInTransacCrcy,
  BlockReason,
  CauseOfCashDiscountLossCode,
  :P_BeforeKeyDateDays AS BeforeKeyDateDays
FROM P_APCshDiscUtilization9
LEFT OUTER JOIN I_APCshDiscLossCause AS _APCshDiscLossCause ON CauseOfCashDiscountLossCode = _APCshDiscLossCause.CashDiscountLossCause  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON BlockReason = _PaymentBlockingReason.PaymentBlockingReason  -- association [0..1]
;