SAP CFX_GRP Collaboration Folders: User Groups Table data and field list

CFX_GRP is a standard SAP Table which is used to store Collaboration Folders: User Groups data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CFX_GRP table consists of various fields, each holding specific information or linking keys about Collaboration Folders: User Groups data available in SAP. These include USER_GRP_ID (User Group ID), NAME (External Name of Object), DESCRIPTION (Object Short Text), CREATED_BY (Created By)... 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. .

CFX_GRP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP CFX_GRP 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 CFX_GRP 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
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
USER_GRP_ID	User Group ID	CFX_USERGRPID	RAW	16			SYSUUID
NAME	External Name of Object	CFX_NAME_SELECTION	CHAR	150			CFX_NAME_SELECTION
DESCRIPTION	Object Short Text	CFX_DESCRIPTION	STRG	0			CFX_STRING
CREATED_BY	Created By	CFX_CREATED_BY	CHAR	12			USNAM
CREATED_ON	Created on	CFX_CREATED_ON	DEC	15			TZNTSTMPS
CHANGED_BY	Changed by	CFX_CHANGED_BY	CHAR	12			USNAM
CHANGED_ON	Changed on	CFX_CHANGED_ON	DEC	15			TZNTSTMPS

Key field

Non-key field

< CFX_GENER_OBJECT - Mapping Between Object Type and Class Name CFX_GRP_HIER - Collaboration Folders: User in User Groups >

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

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

SELECT SINGLE *
FROM CFX_GRP
INTO CORRESPONDING FIELDS OF WA_CFX_GRP
WHERE...

How to access SAP table CFX_GRP

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

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