1. Home
  2. Resources
  3. SAP Tables
  4. DMS_DB_DRAD - DVS: Structure for table DRAD

SAP Table DMS_DB_DRAD

DVS: Structure for table DRAD

DMS_DB_DRAD (DVS: Structure for table DRAD) 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 DMS_DB_DRAD to other SAP tables.

DMS_DB_DRAD table fields

Field Data element Checktable Datatype Length Decimals
UPDATEFLAG Document Management Flag CVFLAG CHAR 1 0
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
NULL No link status
1 To be created
2 To be edited
3 To be noted
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
X Yes
NULL No
VIEWFLAG Indicator: default document for view CV_VIEW_FLAG CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No

DMS_DB_DRAD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DMS_DB_DRAD DOKAR DMS_DB_DRAD MANDT TDWA Document Types MANDT
DMS_DB_DRAD DOKAR DMS_DB_DRAD DOKAR TDWA Document Types DOKAR
DMS_DB_DRAD DOKNR DMS_DB_DRAD MANDT DRAW Document Info Record MANDT
DMS_DB_DRAD DOKNR DMS_DB_DRAD DOKAR DRAW Document Info Record DOKAR
DMS_DB_DRAD DOKNR DMS_DB_DRAD DOKNR DRAW Document Info Record DOKNR
DMS_DB_DRAD DOKNR DMS_DB_DRAD DOKVR DRAW Document Info Record DOKVR
DMS_DB_DRAD DOKNR DMS_DB_DRAD DOKTL DRAW Document Info Record DOKTL
DMS_DB_DRAD DOKOB DMS_DB_DRAD DOKAR TDWO Document Management Object Link DOKAR
DMS_DB_DRAD DOKOB DMS_DB_DRAD DOKOB TDWO Document Management Object Link DOKOB
DMS_DB_DRAD DOKOB DMS_DB_DRAD MANDT TDWO Document Management Object Link MANDT
DMS_DB_DRAD MANDT DMS_DB_DRAD MANDT T000 Clients MANDT
DMS_DB_DRAD VOBJ DMS_DB_DRAD VOBJ TCLO Key Fields of Objects OBTAB