topic Re: Matchcode replaced with View in Application Development and Automation Discussions

Matchcode replaced with View

Former Member — Fri, 02 Aug 2013 18:47:16 GMT

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.

Re: Matchcode replaced with View

Former Member — Fri, 02 Aug 2013 19:25:50 GMT

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

Re: Matchcode replaced with View

Former Member — Fri, 02 Aug 2013 22:08:40 GMT

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

Re: Matchcode replaced with View

Former Member — Fri, 02 Aug 2013 23:50:35 GMT

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.