Skip to Content
avatar image
Former Member

table of sales order with its condition types

hi,

suppose i have a thousands of sales order ,say from 1 to 1500, and now i want to check that the conditions for every sales order is correct or not.

one option is to open all the sales order in VA02, one by one and check the correspondng conditions, but for a thousands of

sales order , it is a very lengthy procedure.

isn't there any table that contais sales order no, its material and also what condition types we maintained for that material.

thanx in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Aug 10, 2009 at 09:27 AM

    Hello,

    You can get the Item conditions from the KONV table

    Check the Sales document header table VBAK and get the KNUMV which is the DOCUMENT CONDITION, and with the document number as the Key input field for the KONV you can fetch the value of the particular condition by giving KSCHLwhich is the CONDITION TYPE and KWERT as the Condition value

    So in summary you have to know KNUMV field, KSCHL, to get the KWERT value from the KONV

    Hope it is clear,

    regards,

    santosh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 10, 2009 at 07:11 AM

    Goto VBAK table give ur sales document no and get all DOCUMENT CONDITIONS and pass this Document condition to KONV table here you can see all conditions for sales document and values for the same

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 10, 2009 at 07:19 AM

    hi,

    check table KOMG also check the standard report V/LD to check the condition for sales area and material based

    regards

    senya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2009 at 12:00 PM

    thank you all guys, my priblem has been solved, thank you very much

    Add comment
    10|10000 characters needed characters exceeded