Skip to Content
0
Former Member
Jun 08, 2007 at 10:21 AM

PERFORMANCE ANALYSE

29 Views

hi experts,

I am doing a task which need the following specification.

SELECTION SCREEN CONTAINS :

SETTLEMENT PERIOD : <PERIO>

FISCAL YEAR : <GJAHR>

PLANT : <WERKS>

selection of KOKRS BELNR BUZEI PERIO WTGBTR OBJNR WERKS KSTAR GJAHR FROM COEP(BASED ON SELECTION SCREEN ELEMENT) AND

AUFNR KDAUF OBJNR KOKRS FROM AUFK.

JOINING CONDITION : KOKRS AND OBJNR.

I USED INDIVIDULAL SELECT QUERY:

QUERY 1: FETECHING DATA FROM COEP BASED ON SELECTION SCREEN DATA.

QUERY 2 : FECTECH DATA FROM AUFK FOR ALL ENTRIES IN COEP (FROM QUERY 1).

BUT THE PERFORMANCE IS VERY POOR. PLS GIVE ME A IDEA TO IMPROVE THE PERFORMANCE.

IF I CHOOSE INNERJOIN QUERY IT'S ALSO VERY POOR. PLS GIVE ME IDEA.

Thanks ya.