cancel
Showing results for 
Search instead for 
Did you mean: 

SAP IBP Excel - products not available in templates

ydyulgerov
Participant
970

Hello everybody,

I face the following issue. I have transferred some data from the S/4 to IBP via CPI-DS. I have used the IBP_MD_S4_ERP_AddOn and the IBP_KF_S4_ERP_AddOn templates. Within the Excel Addin I am able to to create a Master Data Workbook and check the data there, which is fine.

However, when I create a standard template such as SOP 010 Sales Forecast or any other, and I try to filter with Product ID and use the products that I have transferred, the Excel returns with the error - No data found. Check your viewer settings. The same happens if I try to filter only with Location ID and use the locations I transferred. Screenshot is attached.

Thank you very much in advance.

Best regards,

Julian

View Entire Topic
ydyulgerov
Participant
0 Kudos

Hello Arif,

Thanks for the answer. Here is what I have tested and seen:

I have created a new view without template, whereas I put the materials I have transferred and all the KF available. It turned out I have data for the KF "Production lead time". Hence, I after loading the template SOP 010 Sales Forecast with this KF I was able to check the data for my materials.

But why can't I see the data for other KF despite the fact that I do not have data for it? For example for the KF sales forecast - there is no forecast for these materials but I expect to have at least a value of 0 instead of getting this error message.

May I ask you to give a bit more information on the your 2) suggestion. What is meant by creation of planning combinations?

Thank you very much in advance.

BR,
Julian

sap_km
Participant

Hi Julian,

Ivan has already addressed the query just in case you want to create the Combination manually you can follow the below option in order to create the same.

1. Click on New Planning Object option in Excel UI.

2. Enter desired combination in planning object field. Make sure these records are a part of individual simple master data types. Click on Add.

3. Enter data for new combination that has come up. Click on save data to save this combination along with the data.

Hope it helps!

Regards

Arif