single select query on vbfa table

[Former Member]

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

[Former Member]

check in LIPS table

cheers

S.Janagar

[Former Member]

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

Regards,

Sai Prasad

[Former Member]

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'.

[Former Member]

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

Regards

Vinod