any transparent table to fetch the condition record number (knumh)

[Former Member]

dear all

As of now iam getting the condition record number(knumh) from the pooled table A004, which is taking a lot of time.

Want to know anyother transparent table to get KNUMH.

my actual reqiurement is to retrieve the sale price of the material.

[Former Member]

Hi,

try this:

SELECT SINGLE * FROM KONP WHERE KNUMH = A004-KNUMH.

Regards, Dieter

[i048168]

Hi,

You can find KNUMH in any of the following transparent tables based on the material configuration.

A016, A017, A018, A019, A045, A066, A068 etc.

Check the configuration in the pricing condition. (VK11).

Regards,

Vadi

[Former Member]

KNUMV is available in EKKO .

Thanks,

Karthik

[ThomasZloch]

A004 is the correct table for this. Make sure that you use all key fields for the access:

KAPPL (probably "V" or "V1")

KSCHL

VKORG

VTWEG

MATNR

Then your query should return the results very quickly.

Thomas

[Former Member]

hi

iam giving all the keyfields, now the retreiving time from A004 table is fine but while validating the data of 3 lakhs records (3,00,000) inside the loop, the job is not getting over.

[ThomasZloch]

so the problem is somewhere else then, probably internal table handling or another DB select.

Try running a performance analysis with SE30 on a smaller selection.

Good blog:

If it's not too many lines, paste your code here (wrapped in tags!)

Thomas

[Former Member]

Kamaraj,

Tables KONP and KONV has KNUMV as part the key filed Fectch would be slow , so go for EEKO as perviously suggested by me.

Thanks,

Karthik

[ThomasZloch]

what does EKKO have to do with material sales price?