field in vbfa table

[Former Member]

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]

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]

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]

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]

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