Skip to Content
0
Feb 04, 2020 at 06:08 AM

Error while uploading the standard view in Eclipse

187 Views

Hello SAP,

I have downloaded the standard view - CA_C_CONTACT_IA_LOCAL_CUSTOMER and tried to upload the view in Eclipse. WHen i copy the table definition in SQL console in Eclipse and execute it, i get the below error. Can someone let me know how to fix this error -

Sample error code

Could not execute 'ALTER TABLE "ABAP"."CUANC_AGR_PAYF_T" ADD CONSTRAINT "CUANC_AGR_PAYF_T~0" PRIMARY KEY INVERTED ...'

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "INDIVIDUAL": line 3 col 28 (at pos 110)

Could not execute 'ALTER TABLE "ABAP"."CUANC_AGR_PAYF_T" ADD CONSTRAINT "CUANC_AGR_PAYF_T~0" PRIMARY KEY INVERTED ...'

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "INDIVIDUAL": line 3 col 22 (at pos 100)

SQL query

ALTERTABLE"ABAP"."CUANC_AGR_PAYF_T"

ADDCONSTRAINT"CUANC_AGR_PAYF_T~0"

PRIMARYKEY INVERTED INDIVIDUAL("SAPCLIENT",

"LANGUAGE",

"MKT_AGREEMENTPAYMENTFREQUENCY");