S/4HANA 2020 - SAP SURREFS Survey: Array references Table

Overview

SAP SURREFS table is a standard SAP S/4HANA transparent table which stores Survey: Array references data. There are total 12 fields in the SURREFS table. The following is a list of the fields that make up this table.

The table SURREFS belongs to Controlling (CO) module and is located in Survey Main Components (KSUR) package.

In addition, below links provide an overview of foreign key relationships, if any, that link SURREFS to other SAP tables and standard CDS views available based on SURREFS table in SAP S/4HANA.

SURREFS Techincal Settings

Below are technical details of the table SURREFS

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of SURREFS Fields

The table below provides an overview of the fields available in SURREFS. Key fields are marked in blue.

FieldDescriptionData ElementCheck TableData Type
CLIENTClientMANDTT000CLNT(3)
Q_IDnumc06NUMC06SURQUESTQEXTNUMC(6)
QUEST_QCATALOGNumeric valueNUMC_3NUMC(3)
QUEST_GROUPTwo digit numberNUMC2NUMC(2)
QUEST_IDNumeric field length 5NUMC05NUMC(5)
QUEST_OCCURNumeric valueNUMC_3NUMC(3)
COMPARE_FLAGSurvey: field with comparison valueSUR_COMPARE_FLAGCHAR(1)
REF_QUEST_QCATALNumeric valueNUMC_3NUMC(3)
REF_QUEST_GROUPTwo digit numberNUMC2NUMC(2)
REF_QUEST_IDNumeric field length 5NUMC05NUMC(5)
REF_QUEST_OCCURNumeric valueNUMC_3NUMC(3)
REF_FLAGSurvey: Flag - Reference ('X') or constant (' ')SUR_REF_FLAGCHAR(1)

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for SURREFS table.

Table NameFieldCardinalityCheck Table
SURREFSCLIENT:T000
SURREFSQ_ID:SURQUESTQEXT
SURREFSV_IDX:SURAPPLVECTOR

Other References

The table below lists SAP S/4HANA tcodes that read or modify the SURREFS table.

Transaction CodeDescription