Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CE_JOIN Error

Hi

We get below errors while trying to call a stored procedure created with CE functions.

Code:

J1 = CE_JOIN(:EKPO, :EKKO, ["EBELN","MANDT"],["WERKS","EBELN","MATNR","EBELP","MANDT","MEINS","WEBAZ","BSART","LIFNR","RESWK"]);

J2 = CE_JOIN(:J1, :MARC, ["MANDT"],["WERKS","EBELN","MATNR","EBELP","MANDT","MEINS","WEBAZ","BSART","LIFNR","RESWK"]);

fn_output = CE_PROJECTION(:J2,["WERKS","EBELN","MATNR","EBELP","MANDT","MEINS","WEBAZ","BSART","LIFNR","RESWK"]);

Error:

Inconsistent calculation model (34011)

Details (Errors):

- CalculationNode (J2): Attribute WERKS was found more than once.

- CalculationNode (J2): Attribute MATNR was found more than once.

- CalculationNode (J2): Attribute WEBAZ was found more than once.


Could anyone help me understand what the issue is due to?


Thanks in advance.

Former Member
Former Member replied

Hi Avinash,

The issue is you have WERKS,MATNR and WEBAZ columns coming from J1 and same columns exist in MARC table as well.

You can use sql to make it simple or use projection after J1 to rename this 3 columns to different name and then you can rename them again in the final projection if you want.

Code:

J1 = CE_JOIN(:EKPO, :EKKO, ["EBELN","MANDT"],["WERKS","EBELN","MATNR","EBELP","MANDT","MEINS","WEBAZ","BSART","LIFNR","RESWK"]);

J1_Proj = CE_PROJECTION(:J1,["WERKS" AS "J1_WERKS","EBELN","MATNR" AS "J1_MATNR","EBELP","MANDT","MEINS","WEBAZ" AS "J1_WEBAZ","BSART","LIFNR","RESWK"]);

J2 = CE_JOIN(:J1_proj, :MARC, ["MANDT"],["J1_WERKS","EBELN","J1_MATNR","EBELP","MANDT","MEINS","J1_WEBAZ","BSART","LIFNR","RESWK"]);

fn_output = CE_PROJECTION(:J2,["J1_WERKS" AS "WERKS","EBELN","J1_MATNR" AS "MATNR","EBELP","MANDT","MEINS","J1_WEBAZ" AS "WEBAZ","BSART","LIFNR","RESWK"]);

Regards,

Venkat N.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question