I_APJrnlEntrItmAgingGrid

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_APJrnlEntrItmAgingGrid.
-- 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: IAPJEITMAGGRID
-- Parameters: P_KeyDate : sydate, P_NetDueInterval1InDays : farp_net_due_interval1, P_NetDueInterval2InDays : farp_net_due_interval2, P_NetDueInterval3InDays : farp_net_due_interval3, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst

CREATE VIEW I_APJrnlEntrItmAgingGrid AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  cast( 'K' as fis_koart ) AS FinancialAccountType,
  Supplier,
  GLAccount,
  SpecialGLCode,
  ProfitCenter,
  BusinessArea,
  Segment,
  AssignmentReference,
  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( _Company.ChartOfAccounts as fis_ktopl ) AS ChartOfAccounts,
  cast( _SupplierCompany.ReconciliationAccount as farp_akont ) AS ReconciliationAccount,
  cast( _Supplier.AuthorizationGroup as fis_supplier_basic_auth_grp ) AS SupplierBasicAuthorizationGrp,
  _SupplierCompany.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency
FROM P_APJrnlEntrItmAgingGrid4
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [1..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_Currency AS _DisplayCurrency ON _DisplayCurrency.Currency = DisplayCurrency  -- association [0..1]
LEFT OUTER JOIN I_SpecialGLCode AS _SpecialGLCode ON _SpecialGLCode.SpecialGLCode = SpecialGLCode AND _SpecialGLCode.FinancialAccountType = 'K'  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON _ChartOfAccounts.ChartOfAccounts = ChartOfAccounts  -- 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_GLAccountInChartOfAccounts AS _ReconciliationAccount ON _ReconciliationAccount.ChartOfAccounts = ChartOfAccounts AND _ReconciliationAccount.GLAccount = ReconciliationAccount  -- association [0..1]
LEFT OUTER JOIN I_SupplierAccountGroup AS _SupplierAccountGroup ON _SupplierAccountGroup.SupplierAccountGroup = SupplierAccountGroup  -- association [0..1]
;