SAP table VIRADOC (RE Document Header)

SAP table VIRADOC has 2 primary key fields being MANDT,DOCGUID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
DOCGUID GUID: Unique Internal Key for RE Document RAW 16 0 RERADOCGUID
PSTNGPROCEDURE Posting Procedure CHAR 4 0 TIVRAPROCEDURE RERAPROCEDURE
PROCESS Process CHAR 4 0 TIVCAPROCESS RECAPROCESS
PROCESSGUID Generic Key of Process RAW 16 0 RECAPROCESSGUID
PROCESSID Process Identification -> Accounting Reference Number CHAR 16 0 RECAPROCESSID
FISC_YEAR Fiscal Year NUMC 4 0 GJAHR
PSTNGPERIOD Posting Period NUMC 2 0 RERAPSTNGPERIOD
PSTNGDATE Posting Date DATS 8 0 RERAPSTNGDATE
DOCDATE Document Date DATS 8 0 RERADOCDATE
ACCSYSTYPE Type of Accounting System CHAR 4 0 RERAACCSYSTYPE
AA SAP Asset Accounting (AA)
FC SAP Contract A/R & A/P (FI-CA)
FI SAP Financial Accounting (FI)
REFDOCID Reference Key of Document CHAR 20 0 RERAREFDOCID
LOGSYSTEM Logical System CHAR 10 0 * LOGSYSTEM
REVID Indicator for Reversed Documents CHAR 1 0 RERAREVID
1 Reversed Document
2 Reversal Document
X Document has been reversed
REVDOCGUID GUID: Internal Key for Accompanying Reversal Document RAW 16 0 RERAREVDOCGUID
STATUS RE Document Status CHAR 1 0 RERASTATUS
TAXID Tax Exists CHAR 1 0 RERATAXID
HASGLACCSYMB Indicator: Account Symbol CHAR 1 0 RERAHASGLACCSYMB
REFERENCEDOCGUID Reference GUID RAW 16 0 RERAREFGUID
RERF Entered By CHAR 12 0 RERF
DERF First Entered On DATS 8 0 DERF
TERF Time of Creation TIMS 6 0 TERF
REHER Source of Initial Entry CHAR 10 0 REHER
RBEAR Employee ID CHAR 12 0 RBEAR
DBEAR Last Edited On DATS 8 0 DBEAR
TBEAR Last Edited At TIMS 6 0 TBEAR
RBHER Editing Source CHAR 10 0 RBHER
FDELETE Deletion Indicator for Archiving CHAR 1 0 RECAARDELETEIND
CTRULE Currency Translation Rule CHAR 20 0 * RECACTRULE
CTRATE Exchange Rate DEC 9 5 RECACTRATE
POSTCDCURR Post in Condition Currency CHAR 1 0 RECACTPOSTCDCURR
CTDATEREQ Planned Translation Date DATS 8 0 RECACTDATEREQ
CTDATEACT Actual Translation Date DATS 8 0 RECACTDATEACT
CTFCCURRKEY Foreign Currency CUKY 5 0 * RECACTFCCURRKEY
DOCSTATUS RE Document Status CHAR 2 0 RERADOCSTATUS
Normal Document
01 Posted in RE Only (Never in FI)
SECONDDOCGUID GUID: Unique Internal Key for RE Document RAW 16 0 RERADOCGUID
SPLITDOCGUID GUID: Unique Internal Key for RE Document RAW 16 0 RERADOCGUID
CERULE Valuation Rule CHAR 10 0 TIVCERULE RECECERULE
ACCPRINCIPLE Accounting Principle CHAR 4 0 TACC_PRINCIPLE ACCOUNTING_PRINCIPLE
CEDOCTYPE Valuation Document Type CHAR 2 0 RECEDOCTYPE
General Document
01 Asset Transaction (New)
02 Asset Transaction (Old)
03 Direct Balance Sheet Posting
WAERS1 Local Currency CUKY 5 0 * HWAER
KURST1 Exchange Rate Type CHAR 4 0 TCURV KURST
WAERS2 Currency Key of Second Local Currency CUKY 5 0 * HWAE2
KURS2 Exchange Rate for the Second Local Currency DEC 9 5 KURS2
KURST2 Exchange Rate Type CHAR 4 0 TCURV KURST
WAERS3 Currency Key of Third Local Currency CUKY 5 0 * HWAE3
KURS3 Exchange Rate for the Third Local Currency DEC 9 5 KURS3
KURST3 Exchange Rate Type CHAR 4 0 TCURV KURST

VIRADOC foreign key relationships

Table Field Check Table Check Field
0 VIRADOC ACCPRINCIPLE TACC_PRINCIPLE Accounting Principle MANDT
0 VIRADOC ACCPRINCIPLE TACC_PRINCIPLE Accounting Principle ACC_PRINCIPLE
1 VIRADOC CERULE TIVCERULE Valuation Rule CERULE
0 VIRADOC KURST1 TCURV Exchange rate types for currency translation MANDT
0 VIRADOC KURST1 TCURV Exchange rate types for currency translation KURST
1 VIRADOC KURST2 TCURV Exchange rate types for currency translation MANDT
1 VIRADOC KURST2 TCURV Exchange rate types for currency translation KURST
0 VIRADOC KURST3 TCURV Exchange rate types for currency translation MANDT
0 VIRADOC KURST3 TCURV Exchange rate types for currency translation KURST
1 VIRADOC PROCESS TIVCAPROCESS Process PROCESS
0 VIRADOC PSTNGPROCEDURE TIVRAPROCEDURE Posting Procedure POSTNGPROCEDURE