topic any transparent table to fetch the condition record number (knumh) in Application Development and Automation Discussions

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

Former Member — Fri, 29 Aug 2008 12:09:58 GMT

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.

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

Former Member — Fri, 29 Aug 2008 12:13:21 GMT

Hi,

try this:

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

Regards, Dieter

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

i048168 — Fri, 29 Aug 2008 12:17:58 GMT

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

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

Former Member — Fri, 29 Aug 2008 12:18:54 GMT

KNUMV is available in EKKO .

Thanks,

Karthik

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

ThomasZloch — Fri, 29 Aug 2008 12:22:39 GMT

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

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

Former Member — Fri, 29 Aug 2008 12:27:05 GMT

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

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

ThomasZloch — Fri, 29 Aug 2008 12:29:17 GMT

what does EKKO have to do with material sales price?

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

Former Member — Fri, 29 Aug 2008 12:43:27 GMT

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.

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

ThomasZloch — Fri, 29 Aug 2008 12:53:25 GMT

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