SAP table TDWS (Document Status)

SAP table TDWS has 3 primary key fields being MANDT,DOKAR,DOKST.

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 T000 MANDT
DOKAR Document Type CHAR 3 0 TDWA DOKAR
DOKST Document Status CHAR 2 0 DOKST
PRFAW Field selection for log field CHAR 1 0 PRFAW
DOSAR Document status type CHAR 1 0 DOSAR
No special status type
A Archive status
C Check-in status
I Initial status
L Enable Lock Field Status
O Original processing status
P Primary status
S Locked status
T Temporary status
OBJPK Indicator: object check CHAR 1 0 OBJPK
FRKNZ Indicator: released CHAR 1 0 FRKNZ
SVOR1 Previous document status 1 CHAR 2 0 SVOR1
SVOR2 Previous document status 2 CHAR 2 0 SVOR2
SVOR3 Previous document status 3 CHAR 2 0 SVOR3
SVOR4 Previous document status 4 CHAR 2 0 SVOR4
SVOR5 Previous document status 5 CHAR 2 0 SVOR5
SVOR6 Previous document status 6 CHAR 2 0 SVOR6
FRTAE Completion message for engineering change management CHAR 1 0 FRTAE
AUDIT1 Content version CHAR 1 0 AUDIT
WFAUFGABE Workflow task CHAR 14 0 WFAUFGABE
STATEXIT Program executed when this status is set CHAR 40 0 TRDIR STATEXIT
STATFORM FORM routine to be executed when status is set CHAR 30 0 STATFORM
OTYPE Object Type CHAR 2 0 T778O OTYPE
OBJID Object ID NUMC 8 0 OBJEKTID
CV_IMMEDT Indicator: execute program immediately CHAR 1 0 CV_IMMEDT
DLOCK Indicator: distribution lock CHAR 1 0 DLOCK
SIGNSTRAT Signature Strategy CHAR 8 0 TC85 SIGNSTRAT
CHECKIN_FLAG Originals automatically checked in CHAR 1 0 DMS_CHECKIN_FLAG
CC_HIST_REQ History requirement active/inactive CHAR 1 0 CC_HIST_REQ
CHECKIN_REQ Check-In to Secure Storage Area Required CHAR 1 0 DMS_CHECKIN_REQ
ONLY_ONE_VERSION Create One Version Only CHAR 1 0 ONLY_ONE_VERSION
DELETE_VERSION Delete inactive content version on DIR release CHAR 1 0 DEL_VERS

TDWS foreign key relationships

Table Field Check Table Check Field
0 TDWS DOKAR TDWA Document Types MANDT
0 TDWS DOKAR TDWA Document Types DOKAR
1 TDWS OTYPE T778O Object Types MANDT
1 TDWS OTYPE T778O Object Types OTYPE
0 TDWS SIGNSTRAT TC85 Signature Strategy MANDT
0 TDWS SIGNSTRAT TC85 Signature Strategy APPLICID
1 TDWS STATEXIT TRDIR Generated Table for View NAME