SAP IBP Excel - products not available in templates

[ydyulgerov]

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

[former_member194529 · Accepted solution]

Hi Julian,

By default if you have not uploaded KF values for some specific combinations, their values are NULL, not 0, that's why you won't see any values if you include those KFs on the planning view.

However, you can apply front-end formatting to replace NULL values by "0" if you wish, but for that to work you will have to have at least 1 combination with value to be retrieved, otherwise the NO DATA FOUND error message will always come in the first place.

Best,

Ivan