Skip to Content
author's profile photo Former Member
Former Member

how to see delivered and ordered amount on Purchase document

Hi Experts,

i need a table to see the delivered ,ordered amount and delivered,ordered value of each purchase document.

Briefly, ı have several Purchase order, i want to check out each purchase document delivered ,ordered amount and value.When ı check it out the table EKET, i anly see the delivered and orderd amaount ,but i am not able to see their value.

thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2012 at 09:57 AM

    I dont think you can get all the details in one single table. You need to have mix of tables like MSEG,RSEG, BKPF, MKPF, EKKO and EKPO alog with EKBE.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Actually ı can see the delivered and orderd amount in one table EKET,as i mentioned . however,is there any table to see their values. ,ı can combine two tables of course if there is a table show us to delivered and ordered value based on purchase document,

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2012 at 10:12 AM

    Hi,

    EIPA, EKBE,EKKO,EKPO,EKET, RSEG,MSEG,BKPF,MKPF,this tables help full u

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2012 at 10:33 AM

    For calculating total value, you need to add various costs such as delivery cost, taxes and reduce discounts if any which are not made available in easy table. However they are available in bits n pieces in above mentioned tables. Since most of them are calculated based on pricing, best approach is to fetch them from conditions tables such as KOMP and KONV. You can have PO number and then based on below logic you can fetch the data.

    For PO no ,from EKKO-KNUMV number connect to( KONV-KWERT) for various conditions such as JCFA,JFR1,JFR2,P&F1,P&F2,P&F3,FRC1,FRB1,JOCM,PFP1,PFP2,JFR1.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 20, 2012 at 10:34 AM

    Hi dear,

    Use standard transaction ME80FN.

    Enter PO numbers and execute report in the displayed screen choose option of PO history.

    Then u will all the details ur looking for

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2012 at 09:59 AM

    I believe the values you are requesting to view are computed during execution of a certain transaction and not stored in tables.

    If the requirement is to see the Ordered/Delivered/Invoiced amounts, use the report ME2N with Scope of List ALV to see what is the values by using the fields Still to be Delivered (value)/Still to be Invoiced (Value) in the selection criteria.

    /Manoj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2012 at 10:11 AM

    You can see quantity and value, however fur further analysis, you need to build a logic by multiplying or dividing the quantity and rate with the help of abaper. These values wont be stored in any tables.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.