I_ARAgingGridGenLedgerCube

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_ARAgingGridGenLedgerCube.
-- 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.
-- Parameters: P_KeyDate : vdm_v_key_date, P_OverdueInterval1Days : far_overdue_interval1, P_OverdueInterval2Days : far_overdue_interval2, P_OverdueInterval3Days : far_overdue_interval3, P_OverdueInterval4Days : far_overdue_interval4, P_OverdueInterval5Days : far_overdue_interval5, P_OverdueInterval6Days : far_overdue_interval6, P_FutureDueInterval1Days : far_future_due_interval1, P_FutureDueInterval2Days : far_future_due_interval2, P_FutureDueInterval3Days : far_future_due_interval3, P_LeadingLedger : fins_ledger

CREATE VIEW I_ARAgingGridGenLedgerCube AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  Customer,
  GLAccount,
  SpecialGLCode,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  BillingDocument,
  AssignmentReference,
  CustomerClassification,
  _CustomerCompany.CustomerAccountNote AS CustomerAccountNote,
  cast( CustomerCorporateGroup as far_konzs preserving type ) AS CustomerCorporateGroup,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  PaymentMethod,
  FinancialAccountType,
  ControllingArea,
  cast( ChartOfAccounts as fis_ktopl preserving type ) AS ChartOfAccounts,
  cast( CustomerCountry as fis_customer_country preserving type ) AS CustomerCountry,
  cast( CustomerRegion as far_regio preserving type ) AS CustomerRegion,
  cast( _CustomerCompany.ReconciliationAccount as farp_akont preserving type ) AS ReconciliationAccount,
  cast( CustomerAccountGroup as farp_ktokd preserving type ) AS CustomerAccountGroup,
  cast( _CustomerCompany.AccountingClerk as farp_busab preserving type ) AS AccountingClerk,
  cast( CompanyCodeCountry as fis_company_code_country preserving type ) AS CompanyCodeCountry,
  cast( CustomerBasicAuthorizationGrp as fis_customer_basic_auth_grp preserving type ) AS CustomerBasicAuthorizationGrp,
  cast( _CustomerCompany.AuthorizationGroup as fis_customer_fins_auth_grp preserving type ) AS CustomerFinsAuthorizationGrp,
  CompanyCodeCurrency,
  cast( OverdueIntvl7AmtInCoCodeCrcy as far_overdue_intvl7_amt_inccrcy preserving type ) AS OverdueIntvl7AmtInCoCodeCrcy,
  cast( OverdueIntvl6AmtInCoCodeCrcy as far_overdue_intvl6_amt_inccrcy preserving type ) AS OverdueIntvl6AmtInCoCodeCrcy,
  cast( OverdueIntvl5AmtInCoCodeCrcy as far_overdue_intvl5_amt_inccrcy preserving type ) AS OverdueIntvl5AmtInCoCodeCrcy,
  cast( OverdueIntvl4AmtInCoCodeCrcy as far_overdue_intvl4_amt_inccrcy preserving type ) AS OverdueIntvl4AmtInCoCodeCrcy,
  cast( OverdueIntvl3AmtInCoCodeCrcy as far_overdue_intvl3_amt_inccrcy preserving type ) AS OverdueIntvl3AmtInCoCodeCrcy,
  cast( OverdueIntvl2AmtInCoCodeCrcy as far_overdue_intvl2_amt_inccrcy preserving type ) AS OverdueIntvl2AmtInCoCodeCrcy,
  cast( OverdueIntvl1AmtInCoCodeCrcy as far_overdue_intvl1_amt_inccrcy preserving type ) AS OverdueIntvl1AmtInCoCodeCrcy,
  cast( FutureDueIntvl4AmtInCoCodeCrcy as far_futrdue_intvl4_amt_inccrcy preserving type ) AS FutureDueIntvl4AmtInCoCodeCrcy,
  cast( FutureDueIntvl3AmtInCoCodeCrcy as far_futrdue_intvl3_amt_inccrcy preserving type ) AS FutureDueIntvl3AmtInCoCodeCrcy,
  cast( FutureDueIntvl2AmtInCoCodeCrcy as far_futrdue_intvl2_amt_inccrcy preserving type ) AS FutureDueIntvl2AmtInCoCodeCrcy,
  cast( FutureDueIntvl1AmtInCoCodeCrcy as far_futrdue_intvl1_amt_inccrcy preserving type ) AS FutureDueIntvl1AmtInCoCodeCrcy,
  cast( DueAtKeyDateAmtInCoCodeCrcy as farp_due_at_keydte_amt_cccrcy preserving type ) AS DueAtKeyDateAmtInCoCodeCrcy,
  cast( OverdueAmtInCoCodeCrcy as farp_overdue_amt_cocode_crcy preserving type ) AS OverdueAmtInCoCodeCrcy,
  cast( NotOverdueAmtInCoCodeCrcy as farp_not_overdue_amt_cccrcy preserving type ) AS NotOverdueAmtInCoCodeCrcy,
  cast( FutureDueAmtInCoCodeCrcy as farp_future_amt_cocode_crcy preserving type ) AS FutureDueAmtInCoCodeCrcy,
  cast( AmountInCompanyCodeCurrency as farp_total_amount_cocode_crcy preserving type ) AS AmountInCompanyCodeCurrency,
  DocumentDate,
  PostingDate,
  cast( NetDueDate as farp_netdt preserving type ) AS NetDueDate
FROM P_ARAgingIntervalAssignment
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- 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_GLAccountInChartOfAccounts AS _ReconciliationAccount ON _ReconciliationAccount.ChartOfAccounts = ChartOfAccounts AND _ReconciliationAccount.GLAccount = ReconciliationAccount  -- association [0..1]
LEFT OUTER JOIN I_CustomerAccountGroup AS _CustomerAccountGroup ON _CustomerAccountGroup.CustomerAccountGroup = CustomerAccountGroup  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON _PaymentMethod.PaymentMethod = PaymentMethod AND _PaymentMethod.Country = CompanyCodeCountry  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CustomerCountry ON _CustomerCountry.Country = CustomerCountry  -- association [0..1]
LEFT OUTER JOIN I_Region AS _CustomerRegion ON _CustomerRegion.Region = CustomerRegion AND _CustomerRegion.Country = CustomerCountry  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON _CustomerCompany.CompanyCode = CompanyCode AND _CustomerCompany.Customer = Customer  -- association [0..1]
;