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 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| VIEWFLAG | Indicator: default document for view | CV_VIEW_FLAG | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
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 | 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 | DOKNR | DRAD | MANDT | DRAW | Document Info Record | MANDT |
| DRAD | DOKNR | DRAD | DOKAR | DRAW | Document Info Record | DOKAR |
| DRAD | DOKOB | DRAD | MANDT | TDWO | Document Management Object Link | MANDT |
| DRAD | DOKOB | DRAD | DOKAR | TDWO | Document Management Object Link | DOKAR |
| DRAD | DOKOB | DRAD | DOKOB | TDWO | Document Management Object Link | DOKOB |
| DRAD | MANDT | DRAD | MANDT | T000 | Clients | MANDT |
| DRAD | VOBJ | DRAD | VOBJ | TCLO | Key Fields of Objects | OBTAB |
