SAP SIC_SRC_RETRIEVE Search: Retrieve fields from the search engine Table data and field list

SIC_SRC_RETRIEVE is a standard SAP Table which is used to store Search: Retrieve fields from the search engine data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The SIC_SRC_RETRIEVE table consists of various fields, each holding specific information or linking keys about Search: Retrieve fields from the search engine data available in SAP. These include SERVICE_PROFILE (Service Profile), NODE_NAME (Node Name), FIELDNAME (Field Name), NORM_TYPE (Normalization 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. .

SIC_SRC_RETRIEVE 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: Cannot Be Enhanced

SAP SIC_SRC_RETRIEVE 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 SIC_SRC_RETRIEVE 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
SERVICE_PROFILE	Service Profile	SIC_SERVICE_PROFILE	CHAR	30			CHAR30
NODE_NAME	Node Name	SIC_NODE_NAME	CHAR	30			CHAR30
FIELDNAME	Field Name	FIELDNAME	CHAR	30	Assigned to domain		FDNAME	DFD
NORM_TYPE	Normalization Type	SIC_NORM_TYPE	CHAR	20			SIC_NORM_TYPE

Key field

Non-key field

< SIC_SRC_PROFT - Search: Profiles (text table) SIC_SRC_STRATEGY - Search: strategy >

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

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

SELECT SINGLE *
FROM SIC_SRC_RETRIEVE
INTO CORRESPONDING FIELDS OF WA_SIC_SRC_RETRIEVE
WHERE...

How to access SAP table SIC_SRC_RETRIEVE

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

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