RECN 和财务(BKPF/BSEG)的关联关系

 

In general to find out more, run transaction ST05 (Performance Trace) before the process (e.g. real posting in RERAPP) and read the (insert) statements.

How to switch between tables for posted doc. if You select type of contract before:

Table: VICNCN

Point out: BUKRS (Company Code) and RECNTYPE(Contract Type)

Output Key: INTRENO (RE Key).

 

Then move to the cash flow tables.

Tables: VICDCFPAY (Payment-Related Cash Flow), VICDCFOBJ (Object-Related Cash Flow);

Point out: INTRENO (RE Key), CFSTATUS EQ 'I'

Output Key: REFGUID (Document References in Cash Flow) used by VIRADOC-DOCGUID

 

Then move to the document tables.

Table: VIRADOC

Point out: DOCGUID (GUID: RE Doc.)

Output Key: (DOCGUID, PROCESSGUID - used by VIRADOCITEM), REFDOCID used by BKPF-AWKEY, PROCESSID used by BKPF-XBLNR

 

Table: BKPF

Point out: AWKEY (Reference Key), BUKRS (Company Code), GJAHR (Fiscal Year), XBLNR (Reference)

Output Key: (BUKRS, BELNR, GJAHR - used by BSEG), (AWKEY, GJAHR) used by COBK

 

Table: COBK

Point out: REFBN (first 10 char of AWKEY) and AWORG (last 10 char of AWKEY), KOKRS (CO Area), GJAHR (Fiscal Year)

Output Key: (KOKRS, BELNR - used by COEP);

 

If You review the data there is a space to increase performance by filtering (contracts validity, reference transaction AWTYP etc.). I omitted reversed doc.

 

FROM：https://archive.sap.com/discussions/thread/3912379