SAP table DRZA (DDS: Recipient list (document <-> recipient allocations))
SAP table DRZA has 3 primary key fields being MANDT,ASS_ID,ENTRYNO.
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
*
MANDT
ASS_ID
Recipient list ID
CHAR
20
0
CVDIASSID
ENTRYNO
Number of table entry
NUMC
20
0
CVDIENTRYNO
LOGSYS
Logical system
CHAR
10
0
TBDLS
LOGSYS
OBJTYPE
Object type for document distribution
CHAR
10
0
CVDIOBJTP
OBJKEY
Object ID
CHAR
70
0
CVDIOBJID
RECTP
Type of recipient ID
CHAR
2
0
CVDIRECTP
RECID
Recipient for document distribution
CHAR
70
0
CVDIRECNO
COM_TYPE
Distribution type
CHAR
3
0
TDICT
CVDICOMTP
SEQNO
Sequence Number
NUMC
3
0
CVDILFDNR
ORIGINAL
Originals
CHAR
4
0
CVDIORIG
Possible values
1
Original 1
2
Original 2
A
Original 1 and original 2
OFF_RECTP
Recipient type (SAPoffice)
CHAR
1
0
CVDIRTYPE
NUM_COPIES
Number of copies per recipient
NUMC
4
0
CVDINUMCOP
COPY_TYPE
Type of copy
CHAR
3
0
TDICO
CVDICPTP
DDM_ID
Medium Id for document distribution
CHAR
10
0
CVDIDDM
REC_ACTIVE
Indicator: recipient is inactive
CHAR
1
0
CVDIACT
APPLICATION
Application
CHAR
3
0
CVIAPP
DRZA foreign key relationships
Table
Field
Check Table
Check Field
0 DRZA
COM_TYPE
TDICT
DDS: communication type
MANDT
0 DRZA
COM_TYPE
TDICT
DDS: communication type
COM_TYPE
1 DRZA
COPY_TYPE
TDICO
DDS: type of copy
MANDT
0 DRZA
LOGSYS
TBDLS
Logical system
LOGSYS