HANA procedure error - SAP DBTech JDBC: [269]: too many values: ZZPROCESSED

[Former Member]

Dear Experts,

I am trying to write a procedure (Code in screenshot below) in HANA which will Insert data into a target table (BKPF_TOPJV , This is having definition as Original Source table BKPF ) based on all columns for selected rows of certain join conditions. However I am getting "too many values" error while executing the procedure.

Below is the snippet of the code and error -

Could you please help me to guide the root cause and fix for this. Please find attached table DDL for Target table which is copied from Source Table DDL and changed the table name
.

Thanks & Regards,

Jiten

TOPJV Tables DDL.txt.zip

[Former Member · Accepted solution]

In this case I would check if the number of columns in the source table and in the target table is really identical.

Furthermore your procedure imposes the risk of wrong results because you have forgotten to join also via MANDT column.

[Former Member · Accepted solution]

Thank you Martin ! You are Absolutely Correct. I somehow missed one column and due to mismatch in no. of columns it was throwing error. I will join it with MANDT too.

Thanks again !!

Regards,

Jiten