This website is not affiliated with, sponsored by, or approved by SAP AG.
Development (ABAP Development WorkBench, ABAP/4 programming)
Moderators: Snowy, thx4allthefish, Gothmog, YuriT
as table KONV is cluster table, we cannot add index to imporve performance. Which transparent tables can retrieve same data?
Thanks in advance.
First select in KONH (condition Header), then go to KONP (condition Item) and move to KONV (Condition transaction data)
- Posts: 331
- Joined: Mon Nov 04, 2002 8:19 am
- Location: Belgium
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?
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.
- Posts: 368
- Joined: Tue Jul 20, 2004 12:07 pm
- Location: UK
Return to ABAP
Who is online
Users browsing this forum: Google Adsense [Bot] and 12 guests