Matchcode replaced with View

[Former Member]

Hi All,

We have created Views instead of Macthcode ID. And we have fetched data from view instead of match code and the performance of the program is very poor now.

Details of Matchcode:

Primary table      EKKO

Secondary tables   EKPO        EKET

Selection condition for Matchcode ID:

Table       MC field    Data elem.  

EKKO        MANDT       MANDT       

EKPO        EMATN       EMATNR      

Details of View:

Tables: EKKO; EKPO; EKET

Join Condition relationships on giving the above tables is:

EKKO	MANDT	=	EKPO	MANDT
EKPO	MANDT	=	EKET	MANDT
EKKO	MANDT	=	EKET	MANDT
EKKO	EBELN	=	EKPO	EBELN
EKPO	EBELN	=	EKET	EBELN
EKKO	EBELN	=	EKET	EBELN
EKPO	EBELP	=	EKET	EBELP

I am not able to include MATNR in the Join conditions as only EKPO table is having MATNR.

In most of the programs MATNR field is used in the where clause while fetching the data from match code ID/view. Please suggest how can I improve the performance. 

[Former Member]

hello,

you have complicated your join query. please try this join condition

EKKO EBELN = EKPO EBELN

EKKO EBELN = EKET EBELN

EKPO EBELP = EKET EBELP

or else

if you know how to get data ahead of time from EKKO. Get that and then query EKPO and EKET.

best regards,

swanand

[Former Member]

Hi Swanand,

The sequence you have mentioned is atleast saving program from run time error, but still we have performance issue.

I did not get your point: if you know how to get data ahead of time from EKKO. Get that and then query EKPO and EKET.

Thanks,

Vachana

[Former Member]

I meant get the required EBELN from EKKO first and then get the required data from EKPO and EKET. This way you might reduce the performance issue a little more. Join on two table (EKPO and EKET) will be a little better that join on EKKO-EKPO-EKET.