SAP Knowledge Base Article - Public

3073528 - Accounts Payable Aging Analytical Query (I_APJrnlEntrItmAgingGrid)

Symptom

User has created custom aging analytical query based on the data source CDS view I_APJrnlEntrItmAgingGrid. The balance amount for the chosen supplier is with a opposite sign when comparing from the App Manage Supplier Line Items.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP S/4HANA Cloud 

Reproducing the Issue

  1. Create a Custom CDS view from the data source Accounts Payable Aging Grid Cube (I_APJrnlEntrItmAgingGrid).
  2. Use the custom CDS view to create an Analytical query.
  3. Preview the query results.
  4. Compare the analytical query results from the App Manage Supplier Line Items.

Cause

  1. This is a Standard system behavior of Accounts Payable analytical query/App
  2. Amounts in AP analytic apps (underlying CDS views) = -1 * amounts in Manage supplier line items.
  3. Positive / negative sign in the App Manage Supplier line items means Debit/Credit Indicator which shows on which side of the account (S = debit, H = credit) the transaction figures are updated.

Resolution

Use other analytic apps e.g. Aging Report for Accounts Payable or  Aging Analysis to compare the results from the analytical query.

See Also

Accounts Payable Aging Grid Cube

Keywords

I_APJrnlEntrItmAgingGrid, aging, manage, supplier, line, items, S4_PC, supplier, amount, opposite, accounts, payable , KBA , FI-AP-IS , Information System , Problem

Product

SAP S/4HANA Cloud all versions