Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Link of Sales Deal to Condition records

Former Member
0 Kudos

Hi,

What is the link table of Sales deal and Condition record no for SALES. We need to pick up condition record for a particular sales deal.

Even though it is available in konp and konh but since the sales deal is not a primary key there so system takes too much time to fetch the matching records.

Pls suggest. all the suggestion will be appreciate.

Thanks,

Pradeep

6 REPLIES 6

Former Member
0 Kudos

Try to create an index for the required fields of the KONP & KONH tables. Th index creation will be much useful while retrieving the data from tables & it will be fast to fetch the data.

Hope this will be helpful.

Former Member
0 Kudos

Hi,

Don't you have Number of the document condition in sales deal header table?? It would be the key for your Condition records in the condition table KONV, if my understanding of your sales deal as a Sales document is correct.

Let me know if I am wrong..

Regards,

Nagaraju Chidurupalli.

Former Member
0 Kudos

Hi!

There is a field named 'KNUMA' present in VBAP and KONH. This is the field for Sales deal. If you do a little R&D you will find it. The check table is KONA. which is having a field BOTEXT as its description, whether it is Sales Deal or anything else.

I suppose there is no direct link as such between KONH and VBAK.

Link them through VBAP.

Just go through these fields:

KONH-KNUMA_AG, VBAP-KNUMA_AG.

Regards,

Sangeeta.

Kindly give points.

Former Member

Hello all,

KONH is not correct table to look for condition records of transaction data document like sales order, invoice... etc..

It contains the pricing master records.. i.e. pricing records at global level which will would copied over to the transaction document while creating it (based on the pricing procedure applicable for that document) . So when ever you are trying to get the pricing records related to a document you should be just looking at the table KONV (again, no KONP either, it is the details table for KONH).

So, for example, you wanted to get the all the header pricing records of a Sales order, then get the Document condition number (KNUMH) from VBAK and select the entries header pricing records from KONV with the Document condition number and Condition Item number as 000000 (Header). If you want to get the item pricing records pass the Sales order Item number as Pricing item along with the document condition number (VBAK-KNUMH)..

Hope this clears all the confusion..

Regards,

Nagaraju Chidurupalli.

Former Member
0 Kudos

Hi,

Can you see the table KONA which is header for this.

former_member404244
Active Contributor
0 Kudos

hi,

use the tables KONH AND KONA...

Regards,

Nagaraj