SAP Table DRAD
Document-Object Link
DRAD (Document-Object Link) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DRAD to other SAP tables.
DRAD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
DOKAR
Document Type
|
DOKAR | TDWA |
CHAR
|
3 | 0 | |||||||||||
|
DOKNR
Document number
|
DOKNR | DRAW |
CHAR
|
25 | 0 | |||||||||||
|
DOKVR
Document Version
|
DOKVR |
CHAR
|
2 | 0 | ||||||||||||
|
DOKTL
Document Part
|
DOKTL_D |
CHAR
|
3 | 0 | ||||||||||||
|
DOKOB
Linked SAP Object
|
DOKOB | TDWO |
CHAR
|
10 | 0 | |||||||||||
|
OBZAE
Counter key
|
OBZAE |
NUMC
|
4 | 0 | ||||||||||||
|
OBJKY
Document management object key
|
OBJKY |
CHAR
|
50 | 0 | ||||||||||||
|
VRKSTAT
Link status of a document
|
VRKSTAT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
VRKSTAT1
Object link status for document
|
STAT_OBVK |
CHAR
|
2 | 0 | ||||||||||||
|
VOBJ
Name of database table for object
|
TABELLE | TCLO |
CHAR
|
30 | 0 | |||||||||||
|
VKEY
Document management object key
|
OBJKY |
CHAR
|
50 | 0 | ||||||||||||
|
VDIR
Direction of document link active
|
DRADDIR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
VIEWFLAG
Indicator: default document for view
|
CV_VIEW_FLAG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
DELFLAG
Deletion indicator: object link
|
DEL_DRAD_FLAG |
CHAR
|
1 | 0 | ||||||||||||
|
LONGTEXT_ID
DMS: GUID for allocation of long texts
|
LONGTEXT_ID |
CHAR
|
32 | 0 | ||||||||||||
|
CAD_POS
CAD: Assignment document <-> material
|
CAD_POS |
CHAR
|
1 | 0 | ||||||||||||
|
CM_FIXED
Document fixed
|
DMS_CM_FIXED |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
DRAD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| DRAD | DOKAR | DRAD | MANDT |
TDWA
Document Types
|
MANDT |
| DRAD | DOKAR | DRAD | DOKAR |
TDWA
Document Types
|
DOKAR |
| DRAD | DOKNR | DRAD | MANDT |
DRAW
Document Info Record
|
MANDT |
| DRAD | DOKNR | DRAD | DOKAR |
DRAW
Document Info Record
|
DOKAR |
| DRAD | DOKNR | DRAD | DOKNR |
DRAW
Document Info Record
|
DOKNR |
| DRAD | DOKNR | DRAD | DOKVR |
DRAW
Document Info Record
|
DOKVR |
| DRAD | DOKNR | DRAD | DOKTL |
DRAW
Document Info Record
|
DOKTL |
| DRAD | DOKOB | DRAD | DOKOB |
TDWO
Document Management Object Link
|
DOKOB |
| DRAD | DOKOB | DRAD | MANDT |
TDWO
Document Management Object Link
|
MANDT |
| DRAD | DOKOB | DRAD | DOKAR |
TDWO
Document Management Object Link
|
DOKAR |
| DRAD | MANDT | DRAD | MANDT |
T000
Clients
|
MANDT |
| DRAD | VOBJ | DRAD | VOBJ |
TCLO
Key Fields of Objects
|
OBTAB |