Symptom
After following the documentation according to below help page to use IBP_CONSUMPTION for forecast consumption:
Configuration of the IBP_CONSUMPTION Function
1 - In attempt to open Forecast Input Key Figures in Excel UI, it returns the below error:
“SQL execution error
Error with sub-query task 0000 PLAREA __BASELINE”
forecast consumption mode # not found
And/or,
2 - There is an error when opening Projected Stock App.
And/or,
3 - Planning jobs are failing.
Then after reviewing the troubleshooting from help page: Troubleshooting, error still happening.
Read more...
Environment
- SAP Supply Chain Management (SCM)
- SAP Integrated Business Planning (SCM-IBP)
Product
Keywords
OBP, Order-Based Planning, CONSUMPTIONMODE, SQL execution error, Error with sub-query task 0000, IBP_CONSUMPTION, Calculation Scenario Backend Access. , KBA , SCM-IBP-CAL , Configured Calculations , SCM-IBP-BF-ADV , Advanced Simulation , SCM-IBP-RM-PLG , Planning , SCM-IBP-XLS-UI , SAP IBP, add-in for Microsoft Excel (User Interface) , SCM-IBP-TDS , OBP Planning Area and external keyfigures , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview