Statistical Key Figures

[Former Member]

Hello Everyone

In allocation process, does anyone know if it is possible to update statistical key figures through excel file upload ?

Our client will need to update statistical figures every month, with a large amount of data.

Thanks a lot in advance

Mathieu Froger

[riwamouawad · Accepted solution]

Hi mfranco,

Take a look at these links: https://help.sap.com/viewer/9b74aa2eb6054f14afd06f402d75f747/1902.500/en-US/5cfde3615bee4968a85b359c... and https://help.sap.com/viewer/9b74aa2eb6054f14afd06f402d75f747/1902.500/en-US/704ed7531a4d424de1000000.... These links explain the purpose of "Import Statistical Key Figures Plan Data." Hope this helps!

Best,

Riwa

[MarioFranco · Accepted solution]

Hi riwamouawad,

Yes, I saw that information about this new app but I read that it refers to plan data, is it the same thing?.

Maybe you have more information about it.

Thanks in advance.

[Former Member · Accepted solution]

Dear riwamouawad , ccsmith , Former Member

We've seen and tested this new app "Import Statistical Key Figures Plan Data", but we think we have two problems:

1. We don't have the wbs element like field available to include in this excel. Do you know if it's possible to have it?.

2. If the data is plan data, is it possible to distribute real data with these values?

Can you help me, please?

[Djallal · Accepted solution]

Hello riwamouawad , is it normal that I can't download the template from the app "import statistical key figures". Thank you.

[riwamouawad · Accepted solution]

dmaldji Hello! Yes, the template is not downloadable via the application "Import Statistical Key Figures." Please take a look at these links to see the file format needed, and the overall process:

Structure of the source file: https://help.sap.com/viewer/9b74aa2eb6054f14afd06f402d75f747/1902.500/en-US/7ec858fabd27420d8f918050...

How to Import the Data: https://help.sap.com/viewer/9b74aa2eb6054f14afd06f402d75f747/1902.500/en-US/6480556e413b4af6a8f9337b...

Fields to be used: https://help.sap.com/viewer/9b74aa2eb6054f14afd06f402d75f747/1902.500/en-US/e5b7d03915bf4c9e882805c3...

Hope this helps!

-Riwa

[riwamouawad · Accepted solution]

Hi Former Member. Apologies, I am just seeing your questions. Did you find answers, or are your questions still open?

-Riwa

[Djallal · Accepted solution]

thanks riwamouawad it worked ! and do you which tile we need to go to display the imported data ? Can't seem to find that anywhere..

[Djallal · Accepted solution]

riwamouawad Hello, no I am using the plan stat key figures to allocate my overhead costs. I can't find the data once I uploaded it.

[riwamouawad · Accepted solution]

sandeep.kumar do you have any idea?

[riwamouawad · Accepted solution]

dmaldji No problem. There are several applications that will show the data, one application being the Plan / Actual report. What is the use case for using the Import Statistical Key Figures Plan Data? Are you using projects? If so, there might be other applications that are of interest to you.

Best,

Riwa

[jlrodriguez2017 · Accepted solution]

Dear Riwa,

When I want review those links, this message appears: "403 You don't have rights to view this page"

Could you share that information in this forum? Thanks in advance.

Regards,

José Luis

[riwamouawad · Accepted solution]

Hi jlrodriguez2017,

It seems that the links have changed. Please try the following links below:

https://help.sap.com/viewer/c56f622a2edf491b9f1b596b55587009/2102.500/en-US/704ed7531a4d424de1000000...

https://help.sap.com/viewer/1cbcff7ccd35405ab445b223c1ab1588/2102.500/en-US/5cfde3615bee4968a85b359c...

https://help.sap.com/viewer/1cbcff7ccd35405ab445b223c1ab1588/2102.500/en-US/6480556e413b4af6a8f9337b...

Best,

Riwa

[MarioFranco]

ccsmith what is the business context for that API, I don't find it!

Best Regards

[former_member508726]

Are you referring to this https://api.sap.com/api/API_STATISTICALKEYFIGURE_SRV/resource?

[former_member94298]

This is the one I was referring to https://api.sap.com/api/STATISTICALKEYFIGPOSTINGREQUES/overview

[MarioFranco]

ccsmith this API is used to create statistical key figure, right?, we want to Enter Statistical Key Figures but with a mass load an excel file, do you understand us?.

[former_member94298]

Ah - so you are looking to create the master data rather than make postings? I had misunderstood and assumed the latter.

The API that Eva mentions above does the former.

[former_member94298]

Good to see this plan app with 1902.

Can anyone from SAP reveal whether a similar .xls based load for actuals is on the roadmap - as this is probably of more business use?

[Former Member]

Yes, please...Can anyone from SAP reveal whether a similar .xls based load for actuals?

Thanks in advance.

[Former Member]

Hello Everyone,

actually we used the API describe by Clare , and we asked a developer to make an interface to mass load an excel file

Regards

Mathieu

[MarioFranco]

Hi Former Member,

Have you see the new app?

Take a look at these links: https://help.sap.com/viewer/9b74aa2eb6054f14afd06f402d75f747/1902.500/en-US/5cfde3615bee4968a85b359c... and https://help.sap.com/viewer/9b74aa2eb6054f14afd06f402d75f747/1902.500/en-US/704ed7531a4d424de1000000.... These links explain the purpose of "Import Statistical Key Figures Plan Data."

Hope this helps!

[MarioFranco]

Dear Former Member,

Finally, how have you thought to do the update statistical key figures through excel file upload?. Have you used the API?.

I see that in 1902 release, there is an app called "Import Statistical Key Figures Plan Data". I don't understand what is this new app and if it's useful in this situation.

Can you help me, please?

[rb2020]

Good to know what's out there from Clare, but feels like a simple upload could be value added for a lot of people. We'll for example use headcount per department to allocate overhead - enough data to be a pain, not enough to develop an API call. I'll watch this post to see if anyone logs as an enhancement request, but will do so myself after our implementation is over...

[former_member94298]

Agree - would definitely be a good idea to have something to do this out of the box!

[former_member94298]

There is an API for 'Post Statistical Key Figures' which should allow you to develop something fairly simple to do this