SAP table TDWO (Document Management Object Link)
SAP table TDWO has 3 primary key fields being MANDT,DOKAR,DOKOB.
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
DOKOB
Linked SAP Object
CHAR
10
0
DOKOB
ONEONLY
Indicator: Only 1:N Ratios Allowed
CHAR
1
0
ONEONLY
DYNPRONR
Screen number
NUMC
4
0
DYNPRONR
VOBJ
Name of database table for object
CHAR
30
0
TCLO
TABELLE
ALE_MAINT
You cannot maintain the object links via ALE
CHAR
1
0
ALE_MAINT
ALE_COPY
Indicator: object link unchanged in target system
CHAR
1
0
ALE_OBJ_COPY
ADDITION_DATA
Additional functions for object links active
CHAR
1
0
ADDITION_DATA
DELETE_LOCK
Deletion lock for linked documents
CHAR
1
0
DMS_DELETE_LOCK
NEW_VERS_CONTROL
Controls behavior of links when a new version is created
CHAR
1
0
DMS_OBJ_NEW_VERSION_CONTROL
Possible values
Selection by user
0
Ignore link
1
Copy link automatically
SET_VERSION
Display Document Versions
CHAR
1
0
SET_VERSION
CREATE_DOC
Create documents
CHAR
1
0
CREATE_DOC
Possible values
0
You cannot create document
1
Create simple document
2
Use transaction to create document
ALE_OBJPK
Indicator: Object Check using ALE
CHAR
1
0
ALE_OBJPK
TDWO foreign key relationships
Table
Field
Check Table
Check Field
0 TDWO
DOKAR
TDWA
Document Types
MANDT
0 TDWO
DOKAR
TDWA
Document Types
DOKAR