P_ARAgingIntervalAssignment

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 P_ARAgingIntervalAssignment.
-- 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 P_ARAgingIntervalAssignment AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  Customer,
  GLAccount,
  SpecialGLCode,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  BillingDocument,
  AssignmentReference,
  FinancialAccountType,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  PaymentMethod,
  ChartOfAccounts,
  ControllingArea,
  case when SpecialGLTransactionType = 'A' and SpecialGLCode != 'F' then $parameters.P_KeyDate else NetDueDate end as NetDueDate AS P_KeyDateelseNetDueDateendasNetDueDate,
  dats_days_between(NetDueDate, $parameters.P_KeyDate) AS NetDueArrearsDays,
  abap.int4'-4000000' AS DaysInArrearsBoundaryInFuture,
  abap.int4'4000000' AS DaysInArrearsBoundaryInPast,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  CustomerCountry,
  CustomerRegion,
  CustomerAccountGroup,
  CompanyCodeCountry,
  CustomerBasicAuthorizationGrp,
  CustomerClassification,
  CustomerCorporateGroup,
  DocumentDate,
  PostingDate,
  WBSElementExternalID,
  WBSElementInternalID,
  ProjectExternalID,
  ProjectInternalID
FROM P_ARJrnlEntrItmOpenRec2_CC
;