topic single select query on vbfa table in Application Development and Automation Discussions

single select query on vbfa table

Former Member — Tue, 30 Mar 2010 09:53:37 GMT

Hi,

i know the delivery number. Based on Delivery number i want to get sales order number and return delivery number.

is it possible to get sales order No and return delivery No using single select query on the VBFA table.

Regards,

Suresh

Re: single select query on vbfa table

Former Member — Tue, 30 Mar 2010 10:10:57 GMT

check in LIPS table

cheers

S.Janagar

Re: single select query on vbfa table

Former Member — Tue, 30 Mar 2010 10:20:34 GMT

It is not possible through VBFA table.Pass the delivery number to LIPS andyou get he sales order in VGBEL field.

Regards,

Sai Prasad

Re: single select query on vbfa table

Former Member — Tue, 30 Mar 2010 10:38:00 GMT

sure this is possible.

But not in ONE select single, you need two to do that.


data:  ls_vbfa       type vbfa.

select single vbelv
from   vbfa
into    corresponding fields of ls_vbfa
where vbeln = delivery_numer_you_were_talking_of
and   vbtyp_v = 'C'.

This will get a sales order connected to your delivery, Be AWARE that if you have more orders involved in this process you either need to adopt this or maybe even have no chance getting the desired one.


select single VBELN
from   vbfa
into   corresponding fields of ls_vbfa
where vbeln = delivery_numer_you_were_talking_of
and   vbtyp_n = 'T'.

Re: single select query on vbfa table

Former Member — Tue, 30 Mar 2010 10:54:59 GMT

Get Order number from LIPS-VGBEL. Extract Order flow information from function module "RV_ORDER_FLOW_INFORMATION".

Regards

Vinod