SAP table DRAO (Originals for documents)

SAP table DRAO has 7 primary key fields being MANDT,DOKAR,DOKNR,DOKVR,DOKTL,APPNR,ZAEHL.

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
APPNR Application number 1 or 2 CHAR 1 0 APPNR
1 Application 1 or Application 2
ZAEHL Counter key NUMC 4 0 OBZAE
ORLN File length of original NUMC 12 0 ORLN
ORBKL Block length for original INT2 5 0 ORBKL
ORBLK Data block for original data LRAW 2550 0 ORBLK

DRAO foreign key relationships

Table Field Check Table Check Field
0 DRAO DOKAR TDWA Document Types MANDT
0 DRAO DOKAR TDWA Document Types DOKAR
1 DRAO DOKNR DRAW Document Info Record DOKNR
1 DRAO DOKNR DRAW Document Info Record DOKVR
1 DRAO DOKNR DRAW Document Info Record DOKTL
0 DRAO MANDT T000 Clients MANDT