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 |
|
|||||||||
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 |
|
|||||||||
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 |
|
|||||||||
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 |
|
|||||||||
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 |