P_AnalyticalAgingIncrement

DDL: P_ANALYTICALAGINGINCREMENT SQL: PANALAGINC Type: view COMPOSITE
11 Fields 4 Data Sources

P_AnalyticalAgingIncrement is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_LedgerCompanyCodeCrcyRoles, I_GLAgingScopeIncrement, I_AcctgPrncpImprmtConfign, I_FiscalPeriodForVariant) and exposes 11 fields.

Data Sources (4)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles AccountingPrinciple from
I_GLAgingScopeIncrement aging inner
I_AcctgPrncpImprmtConfign Config inner
I_FiscalPeriodForVariant FiscalPeriod inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PANALAGINC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
Ledger Ledger Ledger
CompanyCode CompanyCode Receiver Company Code
AccountingPrinciple I_AcctgPrncpImprmtConfign AccountingPrinciple AP Ledger/CoCode
FiscalYearVariant I_LedgerCompanyCodeCrcyRoles FiscalYearVariant FY Variant
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
FiscalPeriodEndDate FiscalPeriodEndDate End Date
GeneralLedgerAgingScope I_AcctgPrncpImprmtConfign GeneralLedgerAgingScope Aging
GeneralLedgerAgingIncrement GeneralLedgerAgingIncrement Increment
GLAgingIncrmtRelativeDays GLAgingIncrmtRelativeDays Thresh.Days
GLAgingIncrmtRelativeMonths GLAgingIncrmtRelativeMonths Thresh. Months

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_AnalyticalAgingIncrement.
-- 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: PANALAGINC

CREATE VIEW P_AnalyticalAgingIncrement AS
SELECT
  Ledger,
  CompanyCode,
  Config.AccountingPrinciple AS AccountingPrinciple,
  AccountingPrinciple.FiscalYearVariant AS FiscalYearVariant,
  FiscalYear,
  FiscalPeriod,
  FiscalPeriodEndDate,
  Config.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  GeneralLedgerAgingIncrement,
  GLAgingIncrmtRelativeDays,
  GLAgingIncrmtRelativeMonths
FROM I_LedgerCompanyCodeCrcyRoles AS AccountingPrinciple
INNER JOIN I_FiscalPeriodForVariant AS FiscalPeriod ON /* join condition not captured in parsed metadata */
INNER JOIN I_AcctgPrncpImprmtConfign AS Config ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAgingScopeIncrement AS aging ON /* join condition not captured in parsed metadata */
;

Learn More