Skip to Content
avatar image
Former Member

List of all sales condition records(VK13) with a particular tax code

Hi all

We have a requirement to list out all sales condition records created through VK11 which has a particular tax code in it.Say list of all condtion records which have tax code as 'IA'. Could you please let us know the easier way to pull out such report.

We understand that we can get such list from tables KONV and KONP but we are not able to correlate output from such tables with condition record display in VK13. Any pointers to this would be highly appreciated.

Regards,

Santosh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 17, 2008 at 01:44 PM

    Hi,

    Have you tried Tcode V/LD

    Rgds

    San

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2008 at 01:50 PM

    Hello,

    Try with KONP table with field for selection MWSK1. You may go to the Settings --> Field for selection and add filed MWSK1 and give tax code and execute.

    Prase

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Use KONH and KONP tables. condition record whole information will be stored in these 2 tables.

      In KONH table you will get header information of the record. like condition type,condition table, created date and validity periods. In varkey field sales area and material other info. .. Note the record number 0000007609.

      Goto KONP table, enter same record number in condition record number field. you will get item level information.

      Regards,

      Chandra