SAP SIC_INDEX_PROF Define the profiles to be used for indexing Table data and field list

SIC_INDEX_PROF is a standard SAP Table which is used to store Define the profiles to be used for indexing data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The SIC_INDEX_PROF table consists of various fields, each holding specific information or linking keys about Define the profiles to be used for indexing data available in SAP. These include SERVICE_PROFILE (Service Profile), APPLICATION (Application), OBJECT_TYPE (Object Type), OBJECT_SUBTYPE (Object Subtype)... 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_INDEX_PROF 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

Text table = SIC_INDEX_PROFT


SAP SIC_INDEX_PROF 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_INDEX_PROF 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
MANDTClient MANDTCLNT3T000MANDT
SERVICE_PROFILEService Profile SIC_SERVICE_PROFILECHAR30CHAR30
APPLICATIONApplication SIC_APPLICATIONCHAR20SIC_NODE_STRUCTVCHAR20
OBJECT_TYPEObject Type SIC_OBJECT_TYPECHAR30SIC_NODE_STRUCTVCHAR30
OBJECT_SUBTYPEObject Subtype SIC_OBJECT_SUBTYPECHAR30SIC_NODE_STRUCTVCHAR30
SEARCH_ENGINEDefine Index and Search Engine SIC_INDEX_SEARCH_ENGINECHAR10SIC_INDEX_SEARCH_ENGINE
QUEUETREX Indexing With/Without Queue SIC_INDEX_WITH_QUEUECHAR1BOOLE

Key field Non-key field



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

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

SELECT SINGLE *
FROM SIC_INDEX_PROF
INTO CORRESPONDING FIELDS OF WA_SIC_INDEX_PROF
WHERE...

How to access SAP table SIC_INDEX_PROF

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

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