VBFA Table

[Former Member]

Hi Freinds,

Can any one explain about VBFA Table and what is the use of this table . any sample program ???

thanks and regards

Vijaya

points will be given

[Former Member]

vbfa table contains the flow of a sales order

suppose one sales order done delivery after that billing

then this table contains the entry of that sales order

if enter sales order no then u will get subsequent doc no of delivery

for delivery subsequent doc no is billing.

even u can see this flow in Va02 / va03 enter sales doc no and press Shift+F5 / press on display document flow button

rewards point if useful

Madhavi

[Former Member]

Hi ,

In sales Process:

1. First we create a Quotation

2. Then we create a contrate

3. Then with the reference to that contract we create a sales order

4. Then with the referance to the sales order we create a delivery document

5. Then with the referance to the delivery we create a billing document and shipment document

So Subsequent document of a sales quotation is :

1. Contract

2. Sales Order

3. Billing Document

4. Credit memo

etc

and Preceding document of a billing document is :

1. delivery document

2. Sales order

3. Contract etc

etc

So Subsequent document of a sales quotation is :

VBFA table have this flow of documents.

a. In You enter any document VBELN field the you will get the type ( contract or sales oredr) of that perticular document and all the Preceding documents and their types.

b. In You enter any document VBELv field the you will get the type of that perticular document and all the Subsequent documents .

and VBFA helps to relate the document flow for Sales Documents.

VBTYP_N and VBTYP_V determines the document category.

F4 on this field gives you the list.

This is same as what we see the document flow on Sales Order, Delivery or Billing Document transactions....

Imagine that you have a Sales Order and you want to know which deliveries it's realted to. You go to VBFA with VBELV (Preceding document) = SALES ORDER and VBTYP_N (Type of subsecuent document) = 'J'. The result are the deliveries (VBELN) related to that sales document.

Here is stored a lot of document relationships, not only the one I've mentioned, check field VBTYP_N for more detail. The use of this table is that if you need to go backwards in the document flow, you just check the content of the related document fields (LIPS-VGBEL in our example), but when going forewards, you would need to change the sales order to store the delivery number and furthermore, more than one delivery could be related to the sales order, hence the need of this table.

Last but not least, remember that this table is for going FORWARDS in the document flow. Never us it to go backwards, because it has low performance (the table is not indexed in that way). You should check the reference fields as I said before.

Thanx

bgan.

[Former Member]

Hi,

In any sales document you have a button on the application toolbar which displays the "sales document flow"

The different documents in a sales document flow are: sales order, delivery, billing document etc.

One document is generated based on another.

Now the relation between all the sales documents and the type of relation between every preceeding and subsequent document is all stored in this single VBFA table.

Hence if you are asked to find the subsequent document for a billing document, then you query VBFA for it.

Cheers,

Aditya