SAP GRFN_S_API_SURVEY_DATA Survey API Data Table data and field list

GRFN_S_API_SURVEY_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Survey API Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_GRFN_S_API_SURVEY_DATA TYPE GRFN_S_API_SURVEY_DATA.

The GRFN_S_API_SURVEY_DATA table consists of various fields, each holding specific information or linking keys about Survey API Data data available in SAP. These include TASKPLANID (Object ID), SVYTMPLID (Object ID), OBJECTID (Object ID), SVY_TYPE (Survey Type)... 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. .

GRFN_S_API_SURVEY_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP GRFN_S_API_SURVEY_DATA structure 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 GRFN_S_API_SURVEY_DATA 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
SVYINSTIDObject ID GRFN_API_OBJECT_IDCHAR50CHAR50
TASKPLANIDObject ID GRFN_API_OBJECT_IDCHAR50CHAR50
SVYTMPLIDObject ID GRFN_API_OBJECT_IDCHAR50CHAR50
OBJECTIDObject ID GRFN_API_OBJECT_IDCHAR50CHAR50
SVY_TYPESurvey Type GRFN_SURVEY_TYPECHAR2GRFN_SURVEY_TYPE
AIF_FORMName of Form Object FPNAMECHAR30FPNAME
CREATED_BYCreating user GRRM_CREATED_BYCHAR12UNAME
CREATED_ATCreated on GRRM_CREATED_ATDEC15TSTLCGRFN_TIMESTAMP_LOCAL
DUEDATEDue Date in Survey GRRM_SVY_DUEDATEDATS8DATUM
SCOMMENTSurvey Comment GRRM_SVY_COMMENTSTRG0
SENT_ATTimestamp of survey sending out GRRM_SVY_SEND_ATDEC15TZNTSTMPS
RECIPIENTSurvey recipient GRRM_SVY_RECIPIENTCHAR12UNAME
E_MAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
EMAIL_SEARCHCapitalized E-Mail Address EMAIL_SEARCHCHAR241SXIDNAD_SMTPADR
COMPLETED_ATTimestamp of survey completion GRRM_SVY_COMPLETE_ATDEC15TSTLCGRFN_TIMESTAMP_LOCAL
TITLESurvey text GRPC_STEXTCHAR100TEXT100
DESCRIPTIONSurvey description GRPC_SDESCRIPTIONCHAR1024TEXTA1024
OBJECT_TITLETitle/Short Name GRFN_TITLECHAR40GRFN_TITLE
RECIPIENT_NAMERecipient's full name GRRM_RECIPIENT_NAMECHAR80TEXT80
REGULATIONObject ID GRFN_OBJECT_IDNUMC8NUM08
SVYGRPIDUUID of the GRC object (char32) GRFN_GUIDCHAR32GRFN_GUID
SURVEY_OFFLINEIndicator GRFN_BOOLEANCHAR1GRFN_BOOLEAN
SCORE_ABSOLUTEScore GRFN_SCOREDEC13(5) RMSCRGRFN_SCORE
SCORE_PERCENTAGEPercentage GRFN_APERCENTAGEDEC7(4)
REFERENCE_IDObject ID GRFN_API_OBJECT_IDCHAR50CHAR50
CANCELCancel Survey GRFN_CANCEL_SURVEYCHAR1BOOLE
SINGLE_REPLYSurvey Single Reply GRFN_SINGLE_REPLYCHAR1BOOLE

Key field Non-key field



How do I retrieve data from SAP structure GRFN_S_API_SURVEY_DATA using ABAP code?

As GRFN_S_API_SURVEY_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on GRFN_S_API_SURVEY_DATA as there is no data to select.

How to access SAP table GRFN_S_API_SURVEY_DATA

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

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