You cannot activate planning area. In the log you observe similar error as below:
E - An exception of type 'CX_AMDP_EXECUTION_FAILED' occurred, that was not caught anywhere in the call hierarchy. It was not handled locally or declared using a RAISING clause.
E - An error occurred when the database procedure /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ALTER_TABLES was called. Potentially, the procedure /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ALTER_TABLES was called by another database procedure. The method called from ABAP is /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLSET Database connection used: "" (default connection if empty) SQL error on the database: "129" SQL message on the database: "transaction rolled back by an internal error: search table error: "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLSET#stb2#20170724122723": line 8 col 3 (at pos 196): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLSET": line 28 col 5 (at pos 1593):  (range 3): transaction rolled back by an internal error: transaction rolled back by an internal error: search table error: "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLANOBJ": line 190 col 13 (at pos 11859):  (range 3): transaction rolled back by an internal error: sql syntax error: search table error: "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ALTER_TABLES": line 105 col 11 (at pos 4734):  (range 3) sql syntax error exception: sql syntax error: incorrect syntax near "XXXXXX": line 1 col 60 (at pos 60)"
E - Error at: /IBP/CL_SAP_SFND_SOPDM========CP, /IBP/CL_SAP_SFND_SOPDM========CM00J:101
- SAP Supply Chain Management (SCM)
- SAP Sales and Operations Planning (SCM-SOP)
- SAP Integrated Business Planning (SCM-IBP)
Naming Restrictions, Activation, 'CX_AMDP_EXECUTION_FAILED', sql syntax error, incorrect syntax, IBP, SOP , KBA , SCM-IBP-CNF , Configuration , SCM-IBP-CNF-ACT , Activation , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.