I_DaysPayablesOutstanding

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_DaysPayablesOutstanding.
-- 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: IFIDPO
-- Parameters: P_PyblsRollingAverageMonths : fis_pybls_rolling_avg_months, P_PurRollingAverageMonths : fis_pur_rolling_avg_months, P_TodayDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst

CREATE VIEW I_DaysPayablesOutstanding AS
SELECT
  CompanyCode,
  Supplier,
  CalendarYear,
  CalendarMonth,
  GLAccount,
  SpecialGLCode,
  FinancialAccountType,
  cast( YearMonth as vdm_yearmonth ) AS YearMonth,
  CompanyCodeCurrency,
  cast(:P_ExchangeRateType as kurst) AS ExchangeRateType,
  cast( _Supplier._StandardAddress._Country.Country as farp_land1 ) AS SupplierCountry,
  _Supplier._StandardAddress._Region.Region AS SupplierRegion,
  cast( _SupplierCompany.AccountingClerk as farp_busab ) AS AccountingClerk,
  cast( cast( 'TAG' as abap.unit(3) ) as msehi ) AS DurationUnit,
  cast( _Company.ChartOfAccounts as fis_ktopl ) AS ChartOfAccounts,
  cast( _SupplierCompany.ReconciliationAccount as farp_akont ) AS ReconciliationAccount,
  _SupplierCompany.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  cast( DisplayCurrency as vdm_v_display_currency ) AS DisplayCurrency,
  cast( ( (DIVISION(CreditInDisplayCrcy, :P_PyblsRollingAverageMonths, 6) ) * (-1) ) as abap.curr( 27, 6 )) AS CreditAmtInDisplayCrcy,
  cast( ( (DIVISION(PurchasesInDisplayCrcy, :P_PurRollingAverageMonths, 6) ) * (-1) ) as abap.curr( 27, 6 )) AS PurchaseAmtInDisplayCrcy
FROM P_DaysPyblOutstanding04
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = DurationUnit  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _Company ON _Company.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON _FinancialAccountType.FinancialAccountType = FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON _SupplierCompany.CompanyCode = CompanyCode AND _SupplierCompany.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_AccountingClerk AS _AccountingClerk ON _AccountingClerk.CompanyCode = CompanyCode AND _AccountingClerk.AccountingClerk = AccountingClerk  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SupplierCountry ON _SupplierCountry.Country = SupplierCountry  -- association [0..1]
LEFT OUTER JOIN I_Region AS _SupplierRegion ON _SupplierRegion.Region = SupplierRegion AND _SupplierRegion.Country = SupplierCountry  -- association [0..1]
LEFT OUTER JOIN I_CalendarYear AS _CalendarYear ON _CalendarYear.CalendarYear = CalendarYear  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON _CalendarMonth.CalendarMonth = CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON _ChartOfAccounts.ChartOfAccounts = ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _ReconciliationAccount ON _ReconciliationAccount.ChartOfAccounts = ChartOfAccounts AND _ReconciliationAccount.GLAccount = ReconciliationAccount  -- association [0..1]
LEFT OUTER JOIN I_SpecialGLCode AS _SpecialGLCode ON _SpecialGLCode.SpecialGLCode = SpecialGLCode AND _SpecialGLCode.FinancialAccountType = FinancialAccountType AND _SpecialGLCode.FinancialAccountType = 'K'  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON _GLAccountInChartOfAccounts.ChartOfAccounts = ChartOfAccounts AND _GLAccountInChartOfAccounts.GLAccount = GLAccount  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON _DisplayCurrency.Currency = DisplayCurrency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON _CompanyCodeCurrency.Currency = CompanyCodeCurrency  -- association [0..1]
LEFT OUTER JOIN I_SupplierAccountGroup AS _SupplierAccountGroup ON _SupplierAccountGroup.SupplierAccountGroup = SupplierAccountGroup  -- association [0..1]
;