cancel
Showing results for 
Search instead for 
Did you mean: 

CE Join is getting error

Former Member
0 Kudos

Hi Experts,

Script:

BEGIN

col_tab1 = CE_COLUMN_TABLE("SAP_ECC"."VBAK","VKORG","VTWEG","NETWR");

col_tab2 = CE_COLUMN_TABLE("SAP_ECC"."TVKO","WEARKS","LIFNR","ADRNR","KUNNR","VKORG"); 

var_out = CE_JOIN(:col_tab1,:col_tab2,["VKORG"],["VTWEG","WEARKS","LIFNR","ADRNR","NETWR","KUNNR","VKORG"]);

END /********* End Procedure Script ************/

Error:

Message :

  Validation failed, no measure defined in a reporting enabled analytic or calculation view

Semntics:

NETWR has been already defined as a measure.

Please check and suggest.

Thanks.

Br,

Ed

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member210482
Active Participant
0 Kudos

Hi,

Are you still facing the issue?

Regards

Safiyu

Former Member
0 Kudos

No, Thanks.

Former Member
0 Kudos

Hi ,

Is your syntax for CE_COLUMN_TABLE given correctly in view or it is typo in your post? If it is typo in your post, please attach screen shot of your semantics here, then the problem can be easily identified.


Syntax:

CE_COLUMN_TABLE(<table_name> [<attributes>])

In your case, it should be like this


col_tab1 = CE_COLUMN_TABLE("SAP_ECC"."VBAK", ["VKORG","VTWEG","NETWR"] );

col_tab2 =  CE_COLUMN_TABLE("SAP_ECC"."TVKO",["WEARKS","LIFNR","ADRNR","KUNNR","VKORG"]);


-Siva

Message was edited by: Sivakumar Palaniswamy