SAP table TDWA (Document Types)

SAP table TDWA has 2 primary key fields being MANDT,DOKAR.

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 DOKAR
FLDSL Field selection table CHAR 20 0 FLDSL
STAEN Status Changes When a Change is Made CHAR 1 0 STAEN
PROJB Documents with Revision Levels CHAR 1 0 RLVFLAG
ALPHN Version Number Increment Control CHAR 1 0 ALPHN
* for USER-EXIT
0 No version numbering
1 Numerical version numbers 00 .. 99
2 Numerical version numbers 01 .. 99
3 Alphanumeric numbering A0 .. Z9
4 Alphanumeric numbering A1 .. Z9
5 Alphanumeric numbering AA .. ZZ
6 AA .. AZ; A0 .. A9; BA .. Z9
7 as 6, but without 0
8 _A .. Z ; AA .. Z9
9 as 5, but 00 allowed
A as 6, but 00 allowed
Z Eigene Reihenfolgedefinition
VERVG Version Assigned Automatically CHAR 1 0 VERVG
NUMVG Type of Number Assignment CHAR 1 0 NUMVG
Internal or external number assignment
1 Only internal number assignment
2 Only external number assignment
3 Mixed number assignment with Exit
4 Only external number assignment with Exit
5 External number assignment without number range check only
6 Internal or external number assignment with exit
INUMNR Number of number range for internal number assignment CHAR 2 0 INUMNR
ENUMNR Number of number range for external number assignment CHAR 2 0 ENUMNR
AENBL Create Change Documents CHAR 1 0 AENBL
ARCHF Indicator: storage in archive supported CHAR 1 0 ARCHF
ALTDY Alternative screen NUMC 4 0 ALTDY
ADYPROG Program Exit for Alternative Document Management Screen CHAR 40 0 TRDIR ADYPROG
ZNRPROG Program exit for document number CHAR 40 0 TRDIR DZNRPROG
FHMDK Indicator: document can be PRT CHAR 1 0 FHMDK
FILELEN Allowed size of file for saving to SAP database NUMC 10 0 FILELEN
KLASSE Class number CHAR 18 0 KLASSE_D
KLASSENART Class Type CHAR 3 0 TCLA KLASSENART
ORIG_DEL Deletion indicator for local original after check-in CHAR 1 0 ORIG_DEL
ORIG_DSTRB Transport originals with ALE CHAR 1 0 ORIG_DSTRB
KPRO_USE Document Storage via Knowledge Provider CHAR 1 0 DMS_KPRO_USE
CLASS_INCLUDE Display Position for Additional Data from Classification CHAR 1 0 DMS_CLASS_INCLUDE
Separate register card
0 Not in subscreen
DEF_APPLICATION Default Value for Application CHAR 3 0 TDWP DMS_DEFAULT_APPLICATION
DIST_APPLICATION Application default for distribution CHAR 3 0 TDWP DMS_DIST_APPLICATION
NEW_VERS_IGNORE Do not copy originals when newer version created CHAR 1 0 DMS_FILE_NEW_VERSION_IGNORE
CM_RELEVANCE Relevant for Configuration Management CHAR 1 0 DE_CM_RELEVANCE_FLAG
DOKVR_INC Version Sequence CHAR 5 0 DMS_VERSION_INCREMENT
ACM_USE Use ACM on the PLM Web User Interface CHAR 1 0 DMS_ACM_USE
ACM_ENABLE_OBJEC Display Object Links When Using Access Control Management CHAR 1 0 DMS_ACM_ENABLE_OBJECT_LINKS
DS_USE Use of DS Package for Signatures CHAR 1 0 DMS_DS_USE
ISRESTRICEDTOONEMAINFILE Restrict to one main file CHAR 1 0 DMS_ISRESTRICEDTOONEMAINFILE
SET_LCK_STS Set Lock Status For Pre-version of DIR when latest Ver is RL CHAR 1 0 SET_LCK_STS
VERSION_LIMIT DMS: Version Limit for Originals (for Doc type) NUMC 2 0 DMS_VERSION_LIMIT
VER_LIMIT_MSG DMS: Display Version Limit Message Check CHAR 1 0 DMS_VER_LIMIT_MSG

TDWA foreign key relationships

Table Field Check Table Check Field
0 TDWA ADYPROG TRDIR Generated Table for View NAME
1 TDWA DEF_APPLICATION TDWP Workstation Applications MANDT
1 TDWA DEF_APPLICATION TDWP Workstation Applications DAPPL
0 TDWA DIST_APPLICATION TDWP Workstation Applications MANDT
0 TDWA DIST_APPLICATION TDWP Workstation Applications DAPPL
1 TDWA KLASSENART TCLA Class Types MANDT
0 TDWA ZNRPROG TRDIR Generated Table for View NAME