Skip to Content
avatar image
Former Member

Purchase order net value.

Dear Experts,

purchase order net values is stored in which table. in EKPO only gross price stored in line item level in EKKO table stored in total order gross price. in KONV table also stored line item wise with condition records except excise it is stored only basic price and tax alone.. the Excise values not stord in table KONV.

I want total net order value line item wise and header level also.with excise and tax. can you any one tell me the table name

Regards

P.Anandhakumar..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 16, 2009 at 10:16 AM

    Hi,

    You can find net price and net value both at item level in EKPO table,

    Regards,

    Romesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 16, 2009 at 01:09 PM

    Dear Anandha,

    Please check the report ME2L or MB5S . It will give you the net price, GR qty, Order qty, Qty Invoiced against PO Line Item. Yopu can easily get the subsequent values for the same. Hope this will help you . In table KONV you will get the excise. From EKKO you will get the document Condition no. (KNUMV). Put this no. in Table KONV - In the output data the Amount against Condition Type JEXS or NAVS will give you the excise value ( including tax ) depending upon Modvatable ( JEXS ) or Non-Modvatable (NAVS) conditions.

    Regards,

    Victor

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 16, 2009 at 04:02 PM

    Have subtotal in your pricing with "Condition subtotal" = S. this will take value to EKPO-EKKWR

    Add comment
    10|10000 characters needed characters exceeded