SAP Knowledge Base Article - Public

2809662 - Key Date in Analytical apps

Symptom

Results shown in Analytical query show transactional data entered prior to "Key Date" entered on prompt screen of Analytical App

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

Environment

S/4 Hana Cloud

Reproducing the Issue

In app For example P & L Actuals (App ID F0958A) Enter prompts including Key Date.

Click on OK

Cause

 The Key Date entered on prompt screen does not influence the transaction data displayed

Resolution

Key date is used in query results to display attributes of time dependent CO objects like profit center or cost center.

Example

  1. In app Manage Cost Centers (F1443A) you can see Validity From and To Date. In this case example Cost center Validity date From 01.01.2012

  2. In app P & L - Actuals Enter in Prompts. Here key date entered is 01.01.2019. Click on OK

    prompts.png

  3. Add Cost Center to Rows

    P&LActuals.png

  4. Select Cost Center choose Attributes pick for example Company Code

    attributes.png

  5. Scroll accross. You can see company code assigned

    companycode.png

  6. Show Prompts

    showprompts.png
  7. Change 'Key Date' to 31.12.2011.

    31122011.png

  8. Click on OK

  9. Now Company code Shows Non Assigned for cost center. 

    companycodenot.png

  10. Use fiscal year and fiscal period to restrict transaction data.

Keywords

F0958A, F1710A, F1443A, F0963, F0963A, W0081, F2891, F0961, F0961A, W0080, F2890, W0076,  F2886, F0960, F0960A, F2888, W0078, F2888, F0959,  F0959A, W0079, F2889, F0958, F1710, F1710A, F1583a, F1583c, W0077, F2887, F1582a, F1582c,  F2334, F2334A, F2741 , KBA , FI-FIO-GL-IS , Reporting Apps , CO-OM-IS , Information System, iViews , Problem

Product

SAP S/4HANA Cloud all versions