on 2016 May 31 3:47 AM
Hi All,
I am new to SAP RE-FX and want to know about the documents that are generated while integrated posting (RERAPP) i.e., FI document, CO document & RE document .
Regards
Hi Achyuth,
Please refer to the following tables:
For RE document:
VIRADOC - RE Document Header
VIRADOCITEM - RE Document Item
For FI document:
BKPF - Accounting Document Header
BSEG - Accounting Document Item
For CO document:
COBK - CO Object: Document Header
COEP - CO Object: Line Items (by Period)
KR,
Andrzej
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Achyuth,
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.
KR,
Andrzej
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
4 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.