Error while uploading the standard view in Eclipse

[former_member576423]

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

[Kunal_Bansal]

Hello Mayank,

That's an issue to be reported under

HAN-DB SAP HANA Database

best regards,

Kunal

[former_member576423]

Hi kunalkumar.bansal

DO i need to raise a SAP ticket for this?

[Kunal_Bansal]

Yes, under HAN-DB