I_APFutureAccountsPayable

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_APFutureAccountsPayable.
-- 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: IFIAPFUTACCTPAYB
-- Parameters: P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_NetDueInterval1InDays : farp_net_due_interval1, P_NetDueInterval2InDays : farp_net_due_interval2, P_NetDueInterval3InDays : farp_net_due_interval3, P_NetDueInterval4InDays : farp_net_due_interval4

CREATE VIEW I_APFutureAccountsPayable AS
SELECT
  CompanyCode,
  Supplier,
  cast(NetDueIntervalText as farp_netdue_intvl_text) AS NetDueIntervalText,
  cast( PaymentBlockingReason as farp_dzlspr ) AS PaymentBlockingReason,
  cast(_Supplier._StandardAddress.Region as farp_supplier_region) AS SupplierRegion,
  cast(_Supplier.SupplierAccountGroup as farp_supplier_account_group) AS SupplierAccountGroup,
  _Supplier._StandardAddress.Country AS SupplierCountry,
  ExchangeRateType,
  DisplayCurrency,
  _Supplier.AuthorizationGroup AS SupplierBasicAuthorizationGrp,
  _SupplierCompany.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  cast( sum( TotalAmtInDspCrcy ) as farp_total_amount_display_crcy ) AS TotalAmountInDisplayCrcy,
  cast( sum( TotalOverdueAmtInDspCrcy ) as farp_overdue_amount_dsp_crcy ) AS TotalOverdueAmtInDspCrcy,
  cast( sum( TotalNotOvrdAmtInDspCrcy ) as farp_not_overdue_amt_dsp_crcy ) AS TotalNotOvrdAmtInDspCrcy,
  cast( sum( NetDueIntvl1AmtInDspCrcy ) as farp_netdue_intvl1_amt_dspcrcy ) AS NetDueIntvl1AmtInDspCrcy,
  cast( sum( NetDueIntvl2AmtInDspCrcy ) as farp_netdue_intvl2_amt_dspcrcy ) AS NetDueIntvl2AmtInDspCrcy,
  cast( sum( NetDueIntvl3AmtInDspCrcy ) as farp_netdue_intvl3_amt_dspcrcy ) AS NetDueIntvl3AmtInDspCrcy,
  cast( sum( NetDueIntvl4AmtInDspCrcy ) as farp_netdue_intvl4_amt_dspcrcy ) AS NetDueIntvl4AmtInDspCrcy,
  cast( sum( NetDueLastIntvlAmtInDspCrcy ) as farp_netdue_lintvl_amt_dspcrcy ) AS NetDueLastIntvlAmtInDspCrcy,
  cast( sum( NumberOfOpenItems ) as farp_number_of_open_items ) AS NumberOfOpenItems
FROM P_APFutureAccountsPay7
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON PaymentBlockingReason = _PaymentBlockingReason.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SupplierCountry ON SupplierCountry = _SupplierCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _SupplierRegion ON SupplierRegion = _SupplierRegion.Region AND SupplierCountry = _SupplierRegion.Country  -- association [0..1]
LEFT OUTER JOIN I_SupplierAccountGroup AS _SupplierAccountGroup ON SupplierAccountGroup = _SupplierAccountGroup.SupplierAccountGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
;