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

tables for sales & purchase order data relating to delivery

hi all,

i am writing a report to download all the delivery data after the delivery is created.i have to download the sales order data & purchase order data relating to this delivery also.

i am using likp & lips table for delivery.which tables i

should use to get the sales order data & PO data for the same delivery (likp-vbeln). i.e i need the sales & purchase order related tables which has link with delivery tables like likp & lips etc.

plz advice me. it is very urgent.

any idea is highly appreaciated.

Regards

pabitra

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2006 at 02:58 AM

    Hi,

    Use the table link as below:

    VBAK -> VBAP -> LIKP -> LIPS

    VBAK is sales order header and VBAP is sales order item.

    Hope it helps you.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2006 at 03:02 AM

    Hi,

    VBAP-VBELN = LIPS-VGBEL

    VBAP-POSNR = LIPS-VGPOS..

    EKPO-EBELN = LIPS-VGBEL

    EKPO-EBELP = LIPS-VGPOS..

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi,

      EKPO-EBELN =LIPS-VGBEL

      EKPO-EBELP = LIPS-VGPOS.

      it is not correct as i am not getting the data from ekko by this relation.

      plz give me the relation, so that i can extract purchase order data from ekko & ekpo.

      i need relation bet ekko & ekpo with vbap & vbak.

      or relation bet ekko & ekpo with likp & lips.

      from likp & lips , i am getting vbak & vbap data. now i have to get ekko & ekpo data.plz give me the relation.

      any idea is highly appreaciated

      Thanks for ur help.

      Regards

      pabitra

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2006 at 04:07 AM

    hi

    good

    SALES ORDER->

    VBAK Header data

    VBAP Item data

    VBPA Partners in sales order

    VBKD Sales district data

    VBEP Data related to line items, delivery lines

    PURCHASE ORDER->

    KONH Conditions header

    KONP Conditions items

    KONV Procedure ( billing doc or sales order)

    KOND

    THANKS

    MRUTYUN^

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2006 at 04:13 AM

    hi,

    Check out this link..

    http://www.erpgenie.com/sap/abap/tables_sd.htm

    Regards,

    Santosh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2006 at 04:27 AM

    in Addition to NM ,

    in case of STO there is no Sales Order , Process will be like this

    PO-- >Delivery ->PGI--->Billing then u have to

    link

    *getting the History data of the PO
            select ebeln
                   ebelp
                   belnr
                   menge
                   from ekbe
                   into corresponding fields of table  w_ekbe
                   where ebeln eq w_lips-vgbel
                     and ebelp eq w_lips-vgpos
                     and bewtp eq 'L'.

    Regards

    Prabhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2006 at 04:05 PM

    Hi,

    If the confirmations are required..use the following relations..

    EKES-VBELN = LIPS-VBELN

    EKES-VBELP = LIPS-POSNR

    EKES-EBTYP = 'LA'.

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2006 at 05:10 PM

    Hi,

    EKES-VBELN is the delivery number

    EKES-EBELN is the purchase order number

    For inbound delivery the confirmation will always be 'LA'.

    THanks,

    Naren

    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.