SAP Table
TDWA Document Types
SAP table TDWA has 2 primary key fields being MANDT,DOKAR.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TDWA columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||||||||||||
| KeyDOKAR | 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 | ||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
| VERVG | Version Assigned Automatically | CHAR | 1 | 0 | VERVG | ||||||||||||||||||||||||||||
| NUMVG | Type of Number Assignment | CHAR | 1 | 0 | NUMVG | ||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
/ Relationships
TDWA foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TDWA | ADYPROG | TRDIR | Generated Table for View | NAME |
| TDWA | DEF_APPLICATION | TDWP | Workstation Applications | MANDT |
| TDWA | DEF_APPLICATION | TDWP | Workstation Applications | DAPPL |
| TDWA | DIST_APPLICATION | TDWP | Workstation Applications | MANDT |
| TDWA | DIST_APPLICATION | TDWP | Workstation Applications | DAPPL |
| TDWA | KLASSENART | TCLA | Class Types | MANDT |
| TDWA | ZNRPROG | TRDIR | Generated Table for View | NAME |