ABAP code tuning in BW extractor

[Former Member]

Hi All,

I am enhancing a purchasing BW extractor to get Pricing details for a PO and its Item .

The ABAP code in the user exit is similar to this:

select SINGLE knumh from A016 INTO T_KNUMH1

WHERE EVRTN = EKPO-KONNR

AND EVRTP = EKPO-KTPNR

AND ( DATAB LE EKPO-AEDAT AND

DATBI GE EKPO-AEDAT ).

The problem here is A016 is a pooled table and when i check in SM50 while this user exit is running the code hangs in KAPOL ( Table pool) for a long time.

We are having long times during data loads. Does anyone know how to tune this code or any other tables from which i can take pricing related to purchasing.

Regards

satish

[Former Member]

Hi,

can you check the table : EKBO is this helpfull for you??

Thanks,

Greetson

[Former Member]

if you look for the check tables for KONNR and KTPNR, it is EKKO and EKPO itself. that means, there shud be an entry in EKKO with your required KONNR.

so why dont you pick the knumv from EKKO itself ?

select knumv from ekko where ebeln = ekpo-konnr.

now, do whatever further selections you want to do, using this KNUMV.

knumv = a016-knumh.

no need to do select from a016 at all, as we already have KNUMV.