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

How to get the Database table behind condition records

Hello All

In transaction VK13, after giving condition type, I can select sales document.

For a given Sales Document number, there are several conditions.

How can i extract all the conditions for a given sales document?

I am coding a report for this. In which database table can i get the condition between sales document number & different conditions attached to it?

On the screen, i can see that the fields are from the structure KOMG. What is the corresponding table?

Thanks

Chandra Sekhar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2009 at 11:58 AM

    Hi,

    corersponding tables will be konp , a771,a511,a564

    here i am providing you sample query related to it

    { -Get the Territory list price YPR0

    SELECT vkorgau

    zzland1_ag

    zzmatgrade

    a511~kfrst

    datbi

    datab

    kbetr

    INTO TABLE it_list1

    FROM a511

    JOIN konp

    ON a511knumh = konpknumh

    WHERE a511~kappl = 'V'

    AND a511~kschl = 'YPR0'

    AND vkorgau = '5000'

    AND zzland1_ag = v_land1

    AND loevm_ko <> 'X'.}

    Thanks & Regards,

    Sateesh.

    Edited by: sateesh kumar on Nov 12, 2009 12:59 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2009 at 12:47 PM

    Conditions in SD may be at header or item level....look at table KONP for your document with posnr = 0 for header, <> 0 for conditions for a specific item.

    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.