Skip to Content
avatar image
Former Member

po total value

Hi All,

Which table that i can see the total value of the purchase order in a single record without need to add up in ekpo?

thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Jul 05, 2010 at 12:43 PM

    There is no such table as you required

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2010 at 12:45 PM

    Hi,

    Use T code ME80FN, it gives you a report with PO/ line item.

    To get the total PO Value, select the "Net order Value column" and Click on the TOTAL button which is marked with sigma.

    The report will then provide you with the total value of each PO.

    Regards

    Naveen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2010 at 12:54 PM

    Hi,

    Can you try with the following Tcodes.

    MB5L List of Stock Values: Balances

    MBBS Display valuated special stock

    MC$G PURCHIS: Material PurchVal Selection

    MC$I PURCHIS: Material PurchQty Selection

    Regards.

    MBKM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2010 at 12:56 PM

    Hi,

    Get the document condition from EKKO table and pass that value to KONV table .From KONV table you can get the condition value for the selected document condition number.

    Thanks & Regards,

    Renuga.A

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2010 at 04:07 AM

    Hi,

    If you want total net value of the PO, you can get it throug EKKO-RLWRT , once PO is released.

    Hope this work for you.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2010 at 04:48 AM

    Hi,

    Purchase order Net value (before tax) stored in one structured name not in table name, that structured name is MEPO1235 and net value stored field name is VALUE01.

    Hope, it is useful for you.

    Regards,

    K.Rajendran

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 05:34 PM

    Hi,

    The Total PO value is sum of PO values of lines items and to get the PO Line item value, go to table EKPO and look for the field EFFWR(Effective value of item).

    Let me know if it works.

    Add comment
    10|10000 characters needed characters exceeded