topic Re: Document flow tables in Application Development and Automation Discussions

Document flow tables

Former Member — Fri, 12 Nov 2010 14:40:36 GMT

Hi,

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

Re: Document flow tables

Former Member — Sat, 13 Nov 2010 07:02:12 GMT

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

Re: Document flow tables

Former Member — Sat, 13 Nov 2010 07:06:29 GMT

Flow will be like this

SO CONTRACT CONTRACT ITEM

VBAK VBAK VBAP

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

Re: Document flow tables

Former Member — Sun, 14 Nov 2010 05:21:42 GMT

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

Re: Document flow tables

Former Member — Wed, 17 Nov 2010 09:42:11 GMT

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

Re: Document flow tables

former_member229034 — Wed, 17 Nov 2010 14:59:28 GMT

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