SAP Knowledge Base Article - Preview

3472975 - IBP: SQL Error for IBP_CONSUMPTION Key Figures

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

SAP Integrated Business Planning all versions

Keywords

OBP, Order-Based Planning, CONSUMPTIONMODE, SQL execution error, Error with sub-query task 0000, IBP_CONSUMPTION, Calculation Scenario Backend Access. , KBA , SCM-IBP-TDS , OBP Planning Area and external keyfigures , SCM-IBP-BF-ADV , Advanced Simulation , SCM-IBP-RM-PLG , Planning , SCM-IBP-CAL , Configured Calculations , SCM-IBP-XLS-UI , SAP IBP, add-in for Microsoft Excel (User Interface) , 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.