Skip to Content
author's profile photo Former Member
Former Member

Issue in fetching condition records

Dear All

I am trying to fetch condition data (rate, currency etc) from table KONV for a Z condition type.

The table is huge and query on the table even for a single record is resulting into a dump.

Kindly let me know is there any FM to fetch the data using condition record number.

Regards

Dinesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2008 at 08:38 AM

    Hi,

    Can please elaborate your requirement, is your requirement to display the condition type value based on sales order number -

    Here there are two ways,

    1. if you are developing Z Report through ABAP then go as below logic -

    based on VBAK-VBELN-KNUMV(Condition number), goto KONV with selection as KONV-KNUMV then bring the value from KWERT or KBETR

    2. In case you are generating report through ABAP Query, then -

    i. In pricing procedure, use subtotal functionality

    ii. Against your condition type, assign any subtotal available in dropdown.

    iii. During the document processing, system update the value againt the condition type in VBAP/VBRP table of sub total fields

    iv. Through query bring those values

    Let me know once done

    Regards

    Goutham

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2008 at 08:51 AM

    Hi

    Dinesh

    If you are facthing for a report then select the VBAK-KNUMV go to table KONV and fatch the condition record against that Doc. condition no. If you want to facth particular conditiion then hard code the same in programme KONV- KSCHL=' PR00 '.

    If you are simply fatching the data from the table then do it in the same way.

    Thx.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2008 at 09:43 AM

    Hi

    I have a z condition type. Its stored in table a305. I fetch its KNUMH from a305 table.

    Now I fetch prices for this condition record number from KONV.

    But KNUMH is not a key field and due to huge data in table, its resulting in time out error.

    Kindly let me know the appropriate procedure for same.

    Regards

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dinesh,

      Try picking the condition record no (KNUMV) and in table KONV enter the Condition type in KONV-KSCHL filed.

      When you give these two inputs 1. KNUMV and 2. KSCHL in table KONV you will get only those records of this particular condition type. You can use KBETR and other fields data as per your requirement...

      Going to A302 table wont help you much. It Stores only the condition records that are created using T code VK11.

      Regards,

      Abhilash

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2009 at 10:14 AM

    solved on my own.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2009 at 10:25 AM

    HI

    As a responsible member of the forum and for the benefit of other members can you explain how you have resolved this issue.

    So that in future if some one have the same issue then they can refer your post

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 04, 2019 at 01:29 PM

    It really frustrates me as to how people "Solve the issue on their own" but doesn't bother to post it here. You had the time to type your question out, ask for help but once you "Solved on your own" you didn't even let the form know how you did it so. These kind of post should he moderated for the good of this form.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.