SAP table DRAD (Document-Object Link)

SAP table DRAD has 8 primary key fields being MANDT,DOKAR,DOKNR,DOKVR,DOKTL,DOKOB,OBZAE,OBJKY.

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
DOKNR Document number CHAR 25 0 DRAW DOKNR
DOKVR Document Version CHAR 2 0 DOKVR
DOKTL Document Part CHAR 3 0 DOKTL_D
DOKOB Linked SAP Object CHAR 10 0 TDWO DOKOB
OBZAE Counter key NUMC 4 0 OBZAE
OBJKY Document Management Object Key CHAR 90 0 OBJKY
VRKSTAT Link Status of a Document CHAR 1 0 VRKSTAT
No link status
1 To be created
2 To be edited
3 To be noted
VRKSTAT1 Object Link Status for Document CHAR 2 0 STAT_OBVK
VOBJ Name of database table for object CHAR 30 0 TCLO TABELLE
VKEY Document Management Object Key CHAR 90 0 OBJKY
VDIR Direction of Document Link Active CHAR 1 0 DRADDIR
VIEWFLAG Indicator: Default Document for View CHAR 1 0 CV_VIEW_FLAG
DELFLAG Deletion Indicator: Object Link CHAR 1 0 DEL_DRAD_FLAG
LONGTEXT_ID DMS: GUID for Allocation of Long Texts CHAR 32 0 LONGTEXT_ID
CAD_POS CAD: Assignment Document <-> Material CHAR 1 0 CAD_POS
CM_FIXED Document Fixed CHAR 1 0 DMS_CM_FIXED
ARCHFLAG Archive Flag CHAR 1 0 DMS_ARCH_FLAG
Not Archived
X Archived
DUMMY_DRAD_INCL_EEW_PS Data Element for Document Info Recoed Object Link CHAR 1 0 DRAD_INCL_EEW
BO_ALTKEY Alternative Key for Busienss Object CHAR 100 0 DMS_BO_ALTKEY

DRAD foreign key relationships

Table Field Check Table Check Field
0 DRAD DOKAR TDWA Document Types MANDT
0 DRAD DOKAR TDWA Document Types DOKAR
1 DRAD DOKNR DRAW Document Info Record DOKNR
1 DRAD DOKNR DRAW Document Info Record DOKVR
1 DRAD DOKNR DRAW Document Info Record DOKTL
0 DRAD DOKOB TDWO Document Management Object Link MANDT
0 DRAD DOKOB TDWO Document Management Object Link DOKOB
1 DRAD MANDT T000 Clients MANDT