Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to fetch delivery no from Table VBFA?

Former Member
0 Kudos

Hi,

How can I query to fetch the delivery no from table VBFA based on the sales order no?

Regards,

MD

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

You need to give the preceding document number as your sales order number VBELV and sales order item in POSNV and you need to pass 'J' into VBTYP_N and get the value of delivery number in the VBELN and the item in POSNN.

Regards,

Pramod

3 REPLIES 3

Former Member
0 Kudos

Hi,

You need to give the preceding document number as your sales order number VBELV and sales order item in POSNV and you need to pass 'J' into VBTYP_N and get the value of delivery number in the VBELN and the item in POSNN.

Regards,

Pramod

Former Member
0 Kudos

Hi,

To get Delivery number from VBFA using the OA number you have to place the following values :


VBFA-VBELV = <your oa number>
VBFA-VBTYP_V = 'G'.
VBFA-VBTYP_N = 'J'.

Regards

Debarshi

Former Member
0 Kudos

Hi,

To fetch delivery number from VBFA enter:

VBELV = Sale order number

POSNV = Sa;es prder item

VBTYP_N = J

Thanks & Regards,

Navneeth K.