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");