This website is not affiliated with, sponsored by, or approved by SAP AG.

performance on KONV

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, Gothmog, YuriT

performance on KONV

Postby Violin on Thu Nov 25, 2004 8:37 pm

as table KONV is cluster table, we cannot add index to imporve performance. Which transparent tables can retrieve same data?

Thanks in advance.

Violin
 

Condition basis selection

Postby Yoolb on Fri Nov 26, 2004 2:37 am

First select in KONH (condition Header), then go to KONP (condition Item) and move to KONV (Condition transaction data)

Best regards,

Yoolb
PRO IT
Consulting for You and Me
Http://www.proit.be
Yoolb
 
Posts: 331
Joined: Mon Nov 04, 2002 8:19 am
Location: Belgium

KONV table

Postby Violin on Fri Nov 26, 2004 3:42 am

I don't understand why using KONH and KONP can speed up performance because requested data is still in KONV, not in KONH and KONP. I still need to access KONV to retrieve data. How come accessing KONH and KONP before accessing KONV can speed up performance?

Thanks.
Violin
 

Postby ABAPOSAUR on Fri Nov 26, 2004 6:19 am

KONV is transaction data, not master data, so KONH and KONP are not involved.

KONV is accessed via the DOCUMENT conditon number, e.g. VBRK-KNUMV = KONV-KNUMH, etc for other documents storing pricing there.
ABAPOSAUR
 
Posts: 368
Joined: Tue Jul 20, 2004 12:07 pm
Location: UK


Return to ABAP

Who is online

Users browsing this forum: No registered users and 10 guests



This website is not affiliated with, sponsored by, or approved by SAP AG.