SAP TDPR_ATTRFIELD Attribute: Field Description Table data and field list

TDPR_ATTRFIELD is a standard SAP Table which is used to store Attribute: Field Description data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TDPR_ATTRFIELD table consists of various fields, each holding specific information or linking keys about Attribute: Field Description data available in SAP. These include TABNAME (Table/Structure Name), FLDNAME (Field Name), XFIXED (Indicator for Closed/Open Lock for an Attribute), XFIXEDCHG (Indicator: Key Can Be Modified)... 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. .

TDPR_ATTRFIELD table Technical Details:

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TDPR_ATTRFIELD 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 TDPR_ATTRFIELD 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
ATTRNOAttribute ID TB_PR_ATTRNOCHAR16TDPR_ATTRIBUTET_PR_ATTRNO
TABNAMETable/Structure Name TB_PR_TABNAMECHAR30DD02LAS4TAB
FLDNAMEField Name TB_PR_FLDNAMECHAR30DD03LFDNAMEDFD
XFIXEDIndicator for Closed/Open Lock for an Attribute TB_PR_FIXEDATTRCHAR1T_PR_FIXEDATTR
XFIXEDCHGIndicator: Key Can Be Modified TB_PR_XFIXEDCHGCHAR1XFELD
XMULTIndicator: Multiple-Value Field TB_PR_XMULTCHAR1XFELD
XDEFAULTAllow Default Value TB_PR_XDEFAULTCHAR1XFELD
XFLDVALIndicator: Value Set Can Be Modified TB_PR_XFLDVALCHAR1XFELD
XDEF_ONLY_PRODIndicator: Fixed Values Only Exist for the Product TB_PR_XDEF_ONLY_PRODCHAR1XFELD
FMREQ_ALLOWEDStatus as Required Entry Field TB_PR_FMREQ_ALLOWEDNUMC1T_PR_FMOD_ALLOWED
FMOPT_ALLOWEDStatus as Optional Entry Field TB_PR_FMOPT_ALLOWEDNUMC1T_PR_FMOD_ALLOWED
FMDIS_ALLOWEDStatus as Display Field TB_PR_FMDIS_ALLOWEDNUMC1T_PR_FMOD_ALLOWED
FMSUP_ALLOWEDStatus as Hidden field TB_PR_FMSUP_ALLOWEDNUMC1T_PR_FMOD_ALLOWED
ATTRLIMSet Limit Values for an Attribute TB_PR_ATTRLIMCHAR1T_PR_ATTRLIM
XINHERIT_TOCan Pass on TB_PR_XINHERIT_TOCHAR1XFELD
INHERIT_FROMInherits from TB_PR_INHERIT_FROMCHAR16TDPR_ATTRIBUTET_PR_ATTRNO
DERIVATION_TYPEDerivation Types TB_PR_DERIVATION_TYPECHAR1T_PR_DERIVATION_TYPE
DERIV_FUNC_GETFunction Module: Read Attribute Derivation TB_PR_FUNCNAME_GET_DERIVCHAR30Assigned to domainFUNCNAME
DERIV_FUNC_SETFunction Module: Write Attribute Derivation TB_PR_FUNCNAME_SET_DERIVCHAR30Assigned to domainFUNCNAME
XDELETEIndicator TB_PR_DELETECHAR1XFELD
CHG_DATESystem Date SYDATUMDATS8SYDATS
CHG_TIMETIME Data Element for SYST SYTIMETIMS6SYTIME
CHG_SYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
CHG_CLIENTClient MANDTCLNT3Assigned to domainMANDT
CHG_CPROGCalling Program SYCPROGCHAR40Assigned to domainPROGRAMM
CHG_USERUser Name SYUNAMECHAR12SYCHAR12

Key field Non-key field



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

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

SELECT SINGLE *
FROM TDPR_ATTRFIELD
INTO CORRESPONDING FIELDS OF WA_TDPR_ATTRFIELD
WHERE...

How to access SAP table TDPR_ATTRFIELD

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

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