tables for sales & purchase order data relating to delivery

[former_member190312]

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

[Former Member]

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.

[Former Member]

Hi,

VBAP-VBELN = LIPS-VGBEL

VBAP-POSNR = LIPS-VGPOS..

EKPO-EBELN = LIPS-VGBEL

EKPO-EBELP = LIPS-VGPOS..

Thanks,

Naren

[former_member190312]

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

[Former Member]

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^

[Former Member]

hi,

Check out this link..

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

Regards,

Santosh

[Former Member]

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

[Former Member]

Hi,

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

EKES-VBELN = LIPS-VBELN

EKES-VBELP = LIPS-POSNR

EKES-EBTYP = 'LA'.

Thanks,

Naren

[former_member190312]

hi narendran,

is ekes-vbeln is the PO number related to the delivery num lips-vbeln?

why ekes-ebtyp is 'LA'?can u plz suggest me the reason?

Thanks for ur help

Regards

pabitra

[Former Member]

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