SAP DPR_ENTITY_LINK Role Assignments Table data and field list

DPR_ENTITY_LINK is a standard SAP Table which is used to store Role Assignments data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The DPR_ENTITY_LINK table consists of various fields, each holding specific information or linking keys about Role Assignments data available in SAP. These include GUID (Application Object GUID), CREATED_BY (Created By), CREATED_ON (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)), CHANGED_BY (Last Changed By)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

DPR_ENTITY_LINK table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP DPR_ENTITY_LINK table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the DPR_ENTITY_LINK table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
CREATED_BYCreated By DPR_TV_CREATED_BYCHAR12Assigned to domainXUBNAME
CREATED_ONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) DPR_TV_TIMESTAMPDEC15TSTPSBCOS_TSTMP
CHANGED_BYLast Changed By DPR_TV_CHANGED_BYCHAR12Assigned to domainXUBNAME
CHANGED_ONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) DPR_TV_TIMESTAMPDEC15TSTPSBCOS_TSTMP
SORT_NUMBERSort Number DPR_TV_SORT_NUMBERNUMC5
PARTICIPANT_GUIDApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
ENTITY_TYPEObject Type in Project Planning CGPL_OBJECT_TYPECHAR3CHAR3
ENTITY_GUIDApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
BEG_TMSTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) DPR_TV_TIMESTAMPDEC15TSTPSBCOS_TSTMP
END_TMSTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) DPR_TV_TIMESTAMPDEC15TSTPSBCOS_TSTMP
WORK_EFFORTAssigned Work DPR_TV_ASSIGNED_WORKQUAN9(2) DPR_WORK
WORK_UNITUnit DPR_TV_UNITUNIT3Assigned to domainCUNITMEINS
RESPONSIBLEResponsibility DPR_TV_RESPONSIBILITYCHAR1DPR_BOOLEAN
CONCRETE_ROLEShadow Role (= Concrete Role) DPR_TV_CONCRETE_ROLECHAR1CHAR1
EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
COMMENTARYComment DPR_TV_COMMENTARYSTRG0

Key field Non-key field



How do I retrieve data from SAP table DPR_ENTITY_LINK using ABAP code

The following ABAP code Example will allow you to do a basic selection on DPR_ENTITY_LINK to SELECT all data from the table
DATA: WA_DPR_ENTITY_LINK TYPE DPR_ENTITY_LINK.

SELECT SINGLE *
FROM DPR_ENTITY_LINK
INTO CORRESPONDING FIELDS OF WA_DPR_ENTITY_LINK
WHERE...

How to access SAP table DPR_ENTITY_LINK

Within an ECC or HANA version of SAP you can also view further information about DPR_ENTITY_LINK and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).