SAP table DRAW (Document Info Record)

SAP table DRAW has 5 primary key fields being MANDT,DOKAR,DOKNR,DOKVR,DOKTL.

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 DOKNR
DOKVR Document Version CHAR 2 0 DOKVR
DOKTL Document Part CHAR 3 0 DOKTL_D
DWNAM Name of Person Responsible CHAR 12 0 DWNAM
DOKST Document Status CHAR 2 0 TDWS DOKST
LABOR Laboratory/design office CHAR 3 0 T024L LABOR
AENNR Change Number CHAR 12 0 AENR DAENR
WERKA Plant CHAR 4 0 T001W WERKA
LOEDK Deletion Indicator CHAR 1 0 LOEDK
CADKZ CAD Indicator CHAR 1 0 CADKZ
PRENR Document Number of Superior Document CHAR 25 0 PRENR
PREVR Document Version of Superior Document CHAR 2 0 PREVR
PRETL Document Part of Superior Document CHAR 3 0 PRETL
PREAR Document Type of Superior Document CHAR 3 0 TDWA PREAR
BEGRU Authorization Group CHAR 4 0 BEGRU
FILEP Original of Document CHAR 255 0 FILEP
DTTRG Name of Data Carrier CHAR 10 0 TDWD DTTRG
DAPPL Application CHAR 3 0 TDWP DAPPL
FILEP1 Original of Document CHAR 255 0 FILEP
DTTRG1 Name of Data Carrier CHAR 10 0 TDWD DTTRG
DAPPL1 Application CHAR 3 0 TDWP DAPPL
VRLDAT Due Date DATS 8 0 VRLDAT
VPRIOR Processing Priority NUMC 1 0 VPRIOR
RES1 Reserve Field DRAW CHAR 14 0 RESDRAW
RES2 Reserve Field DRAW CHAR 14 0 RESDRAW
RES3 Reserve Field DRAW CHAR 14 0 RESDRAW
RES4 Reserve Field DRAW CHAR 14 0 RESDRAW
MRK_FILEP Original of Document CHAR 255 0 FILEP
MRK_DTTRG Name of Data Carrier CHAR 10 0 DTTRG
MRK_FILEP1 Original of Document CHAR 255 0 FILEP
MRK_DTTRG1 Name of Data Carrier CHAR 10 0 DTTRG
ADATUM Output Date for Document DATS 8 0 ADATUM
DOKNR_VL Document Number of Source Document CHAR 25 0 DOKNR_VL
DOKTL_VL Document Part of Source Document CHAR 3 0 DOKTL_VL
DOKVR_VL Document Version of Source Document CHAR 2 0 DOKVR_VL
FILELEN File length of original NUMC 12 0 ORLN
FILELEN1 File length of original NUMC 12 0 ORLN
CM_RELEVANCE Relevant for Configuration Management CHAR 1 0 DE_CM_RELEVANCE_FLAG
CM_FIXED Document Fixed CHAR 1 0 DMS_CM_FIXED
DOCUMENT_INFO_RECORD_KEY Document Info Record key in concatenated form CHAR 70 0 DOCUMENT_INFO_RECORD_KEY
DUMMY_DRAW_INCL_EEW_PS Data Element for Document Data CHAR 1 0 DRAW_INCL_EEW

DRAW foreign key relationships

Table Field Check Table Check Field
0 DRAW AENNR AENR Change Master AENNR
1 DRAW DAPPL TDWP Workstation Applications MANDT
1 DRAW DAPPL TDWP Workstation Applications DAPPL
0 DRAW DAPPL1 TDWP Workstation Applications MANDT
0 DRAW DAPPL1 TDWP Workstation Applications DAPPL
1 DRAW DOKAR TDWA Document Types MANDT
1 DRAW DOKAR TDWA Document Types DOKAR
0 DRAW DOKST TDWS Document Status MANDT
0 DRAW DOKST TDWS Document Status DOKST
1 DRAW DTTRG TDWD Data Carrier/Network Nodes DTTRG
0 DRAW DTTRG1 TDWD Data Carrier/Network Nodes DTTRG
1 DRAW LABOR T024L Laboratory/office for material MANDT
0 DRAW MANDT T000 Clients MANDT
1 DRAW PREAR TDWA Document Types MANDT
1 DRAW PREAR TDWA Document Types DOKAR
0 DRAW WERKA T001W Plants/Branches WERKS