SAP table VICAPROCESSID (Process)

SAP table VICAPROCESSID has 3 primary key fields being MANDT,PROCESSGUID,VERSION.

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
PROCESSGUID Generic Key of Process RAW 16 0 RECAPROCESSGUID
VERSION Version of Process CHAR 3 0 RECAPROCESSVER
COUNTER Number of Process in Fiscal Year NUMC 8 0 RECAPROCESSCOUNTER
FISC_YEAR Process Year NUMC 4 0 RECAPROCESSYEAR
PROCESS Process CHAR 4 0 TIVCAPROCESS RECAPROCESS
PROCESSID Process Identification -> Accounting Reference Number CHAR 16 0 RECAPROCESSID
TITLE Process Name CHAR 30 0 RECAPROCESSTITLE
FLG_REVERSAL Reversal indicator CHAR 1 0 VSSTORNO
Not reversed
X Reversed
HAS_NEW_VERSION Process Has a New Version CHAR 1 0 RECAHASNEWVERSION
NEW_GUID Generic Key for New Version of Process RAW 16 0 RECANEWPROCESSGUID
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
PROCESSEXTID External Identification Process CHAR 32 0 RECAPROCESSEXTID
PROCESSMODE Mode of Process CHAR 3 0 TIVCAPROCMODE RECAPROCMODE
PROCESSTYPE Process Type CHAR 3 0 TIVCAPROCITYPE RECAPROCITYPE
USEREXCLUSIVE User with Exclusive Change Authorization CHAR 12 0 RECAUSEREXCLUSIVE
FDELETE Deletion Indicator for Archiving CHAR 1 0 RECAARDELETEIND
STEPMSGLOG Settlement Steps Have Their Own Messages CHAR 1 0 RECAPROCSTEPMSGLOG

VICAPROCESSID foreign key relationships

Table Field Check Table Check Field
0 VICAPROCESSID PROCESS TIVCAPROCESS Process PROCESS
1 VICAPROCESSID PROCESSMODE TIVCAPROCMODE Mode of Process with Multiple Steps PROCESSMODE
0 VICAPROCESSID PROCESSTYPE TIVCAPROCITYPE Type of Process (Further Subdivision of Process) PROCESSTYPE