topic SQL error 904 when accessing table CDESK_C_EXPLSR in Application Development and Automation Discussions

SQL error 904 when accessing table CDESK_C_EXPLSR

jeena_george — Wed, 28 Jan 2015 09:30:10 GMT

Dear SAP Gurus,

I am trying to implement a SNOTE(2018070) in my system, for that I needed to have a configuration in SPRO (Cross-Application Components -> CAD Integration -> CAD Desktop -> CAD Desktop).

When I am trying to access the path it throwing a short dump telling " Error Text of the Database: "ORA-00904: "BEHAVIOR": invalid identifier"

Requesting to help me in this regard.

Best Regards,

Jeena George

Re: SQL error 904 when accessing table CDESK_C_EXPLSR

Former Member — Wed, 28 Jan 2015 10:54:42 GMT

Hi Jeena,

please check, that all manual work has been processed for this note 2018070and for note

1943209 - CAD services: Using STOP-RULES for the hierarchy explosion

Regards,

Klaus

Re: SQL error 904 when accessing table CDESK_C_EXPLSR

jeena_george — Fri, 30 Jan 2015 06:15:45 GMT

Hi Klaus, Thank you for your reply. All the prerequisites for the note 2018070 have been completed successfully without any error. As per the note instruction the following changes were made in system. In the Program: SAPLCDESK_CUS and Screen Number: 0024 set the property of the field V_CDESK_C_EXPLSR-BEHAVIOR as 'Required'. Best Regards, Jeena George

Re: SQL error 904 when accessing table CDESK_C_EXPLSR

jeena_george — Fri, 30 Jan 2015 06:16:52 GMT

Hi Klaus,

Thank you for your reply.

All the prerequisites for the note 2018070 have been completed successfully without any error.

As per the note instruction the following changes were made in system.

In the Program: SAPLCDESK_CUS and Screen Number: 0024 set the property of the field V_CDESK_C_EXPLSR-BEHAVIOR as 'Required'.

Best Regards,

Jeena George