Table that link Contract and FI doc

[manthana_c]

Hello Guru:

when display Contract condition, each cash flow line will show status "POSTED" and we can double click to see FI doc.

which table link this together please.

Thanks in advance.

[Former Member · Accepted solution]

Manthan,

Documents Posted in REFX can be viewed in REFX tables VIRADOC (header) and VIRADOCITEM (item), iyou can use Doc.Ref.Key (REFDOCID) field from header table to view FI documents posted in FI ledger table BKPF field (AWKEY). When you click on the Cashflow Posted item, a standard FM is called which uses this ref key to find FI document.

Thanks,

Jag

[manthana_c · Accepted solution]

Any relationship between VIRADOC and VICNCN (contract).

I cannot find contract number in VIRADOC.

pls help again and thanks in advance.

[Former Member · Accepted solution]

To add to what Jagannath has provided. 

To find out the A/c document for a posted condition I have done the following.

VICNCN - Select the RE KEY [INTERNO]

VICDCFPAY  Field INTERNO = VICNCN INTERNO gives you the cashflow.

VICDCFPAY -REFGUID - Select this value and then link it to VIRADOC - DOCGUID.   [ For posted / processed payment conditions this column will not be blank ]

Select VIRADOC - REFDOCID  and provide it as input to BKPF - AWKEY  which provides you with FI-document details.

[manthana_c]

.

[Former Member]

Hi,

When you double click on item, system calls the FM BAPI_ACC_DOCUMENT_RECORD or BAPI_ACC_DOCUMENT_DISPLAY.

Ex.: Import parameters

OBJ_TYPE REACI

OBJ_KEY 10006789201100000001

OBJ_SYS QARCLNT200

regards,

Srini