04-12-2006 10:35 PM
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
04-12-2006 10:40 PM
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.
04-14-2006 5:36 AM
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.
04-14-2006 10:15 AM
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.
04-16-2006 7:19 AM
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.
07-09-2009 10:52 AM
Hi,
Can you see the table KONA which is header for this.
07-09-2009 10:55 AM