Skip to Content
avatar image
Former Member

Link of Sales Deal to Condition records

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Apr 12, 2006 at 09: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 14, 2006 at 04: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 14, 2006 at 09: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 16, 2006 at 06: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2009 at 09:52 AM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2009 at 09:55 AM

    hi,

    use the tables KONH AND KONA...

    Regards,

    Nagaraj

    Add comment
    10|10000 characters needed characters exceeded