SAP SIC_PROF_TYPES Definition of Profile Types for Services Table data and field list

SIC_PROF_TYPES is a standard SAP Table which is used to store Definition of Profile Types for Services data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The SIC_PROF_TYPES table consists of various fields, each holding specific information or linking keys about Definition of Profile Types for Services data available in SAP. These include OWNER (Owner of Table Entries (Namespace Separation)), PROFILE_TYPE (Profile Type), COUNTER (Counter), REF_COUNTER (Reference Counter)... 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_PROF_TYPES 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_PROF_TYPES_T

SAP SIC_PROF_TYPES 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_PROF_TYPES 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
OWNER	Owner of Table Entries (Namespace Separation)	SIC_OWNER	CHAR	3			SIC_OWNER
PROFILE_TYPE	Profile Type	SIC_PROFILE_TYPE	CHAR	30			CHAR30
COUNTER	Counter	SIC_INT_COUNTER	INT4	10			SIC_INT_COUNTER
REF_COUNTER	Reference Counter	SIC_REFERENCE_COUNTER	INT4	10			SIC_INT_COUNTER
SERVICE_NAME	Name of Service	SIC_SERVICE_NAME	CHAR	30	Assigned to domain		SIC_SERVICE_NAME
SERVICE_COUNTER	Service Counter	SIC_SERVICE_COUNTER	NUMC	4			NUMC4
SUBSERVICE_NAME	Name of Service	SIC_SERVICE_NAME	CHAR	30	Assigned to domain		SIC_SERVICE_NAME

Key field

Non-key field

< SIC_PROFILE_NAME - Definition of Profile Names SIC_PROF_TYPES_T - Descriptive texts for profile types >

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

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

SELECT SINGLE *
FROM SIC_PROF_TYPES
INTO CORRESPONDING FIELDS OF WA_SIC_PROF_TYPES
WHERE...

How to access SAP table SIC_PROF_TYPES

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

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