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 » 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 » 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 » 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 » 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: Yahoo [Bot] and 4 guests





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