09-22-2006 3:35 AM
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
09-22-2006 3: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.
09-22-2006 3: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.
09-22-2006 4:02 AM
Hi,
VBAP-VBELN = LIPS-VGBEL
VBAP-POSNR = LIPS-VGPOS..
EKPO-EBELN = LIPS-VGBEL
EKPO-EBELP = LIPS-VGPOS..
Thanks,
Naren
09-22-2006 4:51 PM
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
09-22-2006 5: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^
09-22-2006 5:13 AM
09-22-2006 5: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
09-22-2006 5: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
09-22-2006 5:45 PM
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
09-22-2006 6: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