Skip to Content
avatar image
Former Member

Pricing details of sales order

Hi SAP GURUs,

I want to make report of pricing details of sales orders.

From which table i should get the pricing details. I know tables KONH and KONP...but i dont know how to get details in these tables for perticuler sales order.

Please help me out ...

Thanks,

Tarpan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 15, 2010 at 06:56 AM

    hi

    Table: VBAK

    get Doc. Condition from VBAK for sales order ( VBAK - KNUMV)

    pass this KNUMV to KONV table you will get details

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2010 at 07:16 AM

    Hi Tarpan.

    If you want the net value, you can get it IN "vbap-cmpre". Kindly please let me know If you need any more information on this.

    Regards.

    Ram Pedarla

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2010 at 07:20 AM

    Hi,

    You have to make use of the tables VBAK, VBAP and KONV

    VBAK-KNUMV = KONV-KNUMV

    VBAP-POSNR = KONV-KPOSN

    For this combination, you can fetch the following fields from KONV

    KONV-KSCHL (Condition type)

    KONV-KWERT ( Value of the condition type)

    KONV-KBETR (Rate for % condition types)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2010 at 06:57 AM

    Hi,

    In table VBAP, you already can get the price unit and net price, please do check.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2010 at 07:16 AM

    Hi Tarpan,

    You can create a pricing report besides standard pricing table by using V/LA t-code. in V/LA, you can add if which fields are needed for your report.

    Additionally, you need new table and need a new t-code for this report.

    Please explore this t-code and try it. please share further issue for this requirement with us.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded