I_APInvoiceProcessingTime

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_APInvoiceProcessingTime.
-- 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: IFIAPINVPROTIME
-- Parameters: P_TodayDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_OverdueInterval1Days : farp_overdue_interval1, P_OverdueInterval2Days : farp_overdue_interval2, P_PostingDelayDesc : farp_posting_delay_desc, P_PaymentDelayDesc : farp_payment_delay_desc

CREATE VIEW I_APInvoiceProcessingTime AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  Supplier,
  cast(YearMonth as fis_yearmonth_c) AS YearMonth,
  PostingDate,
  cast( DueDate as due_date_sof ) AS DueDate,
  TransactionCurrency,
  cast( :P_DisplayCurrency as vdm_v_display_currency ) AS DisplayCurrency,
  cast( OverdueType as farp_overdue_type ) AS OverdueType,
  cast( OverdueTypeName as farp_overdue_type_name ) AS OverdueTypeName,
  cast( OverdueInterval1Days as farp_overdue_interval1 ) AS OverdueInterval1Days,
  cast( OverdueInterval2Days as farp_overdue_interval2 ) AS OverdueInterval2Days,
  cast( PaymentDelayDesc as farp_payment_delay_desc ) AS PaymentDelayDesc,
  cast( PostingDelayDesc as farp_posting_delay_desc ) AS PostingDelayDesc,
  _Supplier.AuthorizationGroup AS SupplierBasicAuthorizationGrp,
  _SupplierCompany.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  cast( TotalOverdueAmtInDspCrcy as farp_overdue_amount_dsp_crcy ) AS TotalOverdueAmtInDspCrcy,
  cast( OvrdInvcAmtInDspCrcy as farp_overdue_invc_amt_dspcrcy ) AS OvrdInvcAmtInDspCrcy,
  cast( OvrdPaytAmtInDspCrcy as farp_overdue_payt_amt_dspcrcy ) AS OvrdPaytAmtInDspCrcy,
  cast( cast( OvrdInvcLostDiscInDspCrcy as abap.curr(23,2)) as farp_od_in_lo_disc_amt_dspcrcy ) AS OvrdInvcLostDiscInDspCrcy,
  cast( cast( OvrdPaytLostDiscInDspCrcy as abap.curr(23,2)) as farp_od_pa_lo_disc_amt_dspcrcy ) AS OvrdPaytLostDiscInDspCrcy,
  cast( cast( OverdueInterval1AmtInDspCrcy as abap.curr(23,2)) as farp_ovrdue_intvl1_amt_dspcrcy ) AS OverdueInterval1AmtInDspCrcy,
  cast( cast( OverdueInterval2AmtInDspCrcy as abap.curr(23,2)) as farp_ovrdue_intvl2_amt_dspcrcy ) AS OverdueInterval2AmtInDspCrcy,
  cast( cast( OverdueInterval3AmtInDspCrcy as abap.curr(23,2)) as farp_ovrdue_intvl3_amt_dspcrcy ) AS OverdueInterval3AmtInDspCrcy,
  cast( cast( NumberOfPostingOverdueInvoices as abap.int4 ) as farp_number_postg_ovrd_invoice ) AS NumberOfPostingOverdueInvoices,
  cast( NumberOfClrgOverdueInvoices as farp_number_clrg_ovrd_invoice ) AS NumberOfClrgOverdueInvoices
FROM P_APInvoiceProcessingTime7
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
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_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
;