Document flow tables

[Former Member]

Hi,

Is there any other through which we can get the document flow for contract without accessing the VBFA table.

[Former Member]

Yes,

for the contract there will be a sales order created. both contract and SO will be in VBAP table only. if you want to find out the reference contract for the SO then in the VBAK-VGBEL will be the contract Document No, Pass this VGBEL to VBAK-VBELN you will get the contract header data, from this you can get the item from VBAP.

regards,

venkat suman

[Former Member]

Flow will be like this

SO CONTRACT CONTRACT ITEM

VBAK VBAK VBAP

(VGBEL) ---> (VBELN) ---> (VBELN)

[Former Member]

Hi,

For the best practice you should make a view like ZV_SOContract, made a joins like below

VBAP-VGBEL =VBAK-VBELN.

and after that insert your desired fields. Enjoy.

Regards,

Masoom Ali

[Former Member]

Hi,

The contract number can be fetched in a many ways,

One of them is :

Access se11 --> table name:VBKD then enter Sales order number in VBELN and you will get the corresponding PO number from Field BSTKD.

Pass PO number in field EBELN of EKKO table and fetch the corresponding LEGAL_CONTRACT ie the contract number.

Hope u got the correct info.!!

Regards,

Nishi.M

[former_member229034]

Hi Rekha,

Please follow the inline hyperlink and you can get to know the relation between various tables and documents. Do let me know if this doesn't help.

http://www.erpgenie.com/sap/abap/tables.htm

Best,

Chaitanya