topic Re: field in vbfa table in Application Development and Automation Discussions

field in vbfa table

Former Member — Fri, 12 Dec 2008 10:34:55 GMT

Hi friends,

I am facing a problem in vbfa table.

I have a billing documnet number 1000 in l_value1

now based upon this billing document number i need to get the delivery number from vbfa table

can any one tell which field should i use to retrive delivery number from vbfa table.

and after the delivery number from vbfa table later i need to get the shipment number for that particular delivery number.

can any one tell me which field should i use.

Regards

Priyanka.

Former Member — Fri, 12 Dec 2008 10:39:18 GMT

Hi,

Try to put the billing document number in the field VBELN of the VBFA table. You will get the preceding document i.e the Delivery in the VBELV field.

regards,

Advait

Subhankar — Fri, 12 Dec 2008 10:42:28 GMT

Hi,

Use the logic in this way to get the delivery number...

select vbelv " Preceding sales and distribution

posnv " Preceding item of an SD document

vbeln " Subsequent sales and distribution

posnn " Subsequent item of an SD document

vbtyp_n " Subsequent document document category

from vbfa

into table i_vbfa

for all entries in i_value

where vbeln = i_value-vbeln and

vbtyp_v = 'J'. " Deliveryr

Edited by: Subhankar Garani on Dec 12, 2008 11:42 AM

Former Member — Fri, 12 Dec 2008 11:53:08 GMT

can u tell me how to link to get the shipment for that particular delivery number.

now i got the delivery number in i_vbfa table.

for those delivery numbers i should get the shipments.

Regards

Priyanka.

Edited by: priyanka jain on Dec 12, 2008 12:55 PM