SAP GRFN_S_DM_FPCSP DataMart: Facts PC Subprocess + URL to ICON Table data and field list

GRFN_S_DM_FPCSP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DataMart: Facts PC Subprocess + URL to ICON" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_GRFN_S_DM_FPCSP TYPE GRFN_S_DM_FPCSP.

The GRFN_S_DM_FPCSP table consists of various fields, each holding specific information or linking keys about DataMart: Facts PC Subprocess + URL to ICON data available in SAP. These include MANDT (Client), SNAPSHOT_ID (Datamart - Snapshot ID), RE (Regulation ID), OU (Organization ID)... 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. .

GRFN_S_DM_FPCSP structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP GRFN_S_DM_FPCSP structure 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 GRFN_S_DM_FPCSP 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
SNAPSHOT_ID	Datamart - Snapshot ID	GRFN_DM_SNAPSHOT_ID	CHAR	32			SYSUUID_C
RE	Regulation ID	GRFN_REP_REGULATION	NUMC	8			NUMC08
OU	Organization ID	GRFN_REP_ORGUNIT_ID	NUMC	8			NUMC08
PR	Process ID	GRFN_REP_PROCESS_ID	NUMC	8			NUMC08
SP	Subprocess ID	GRFN_REP_SUBPROCESS_ID	NUMC	8			NUMC08
CATEGORY	Category	SCMG_CATEGORY	CHAR	4			CHAR4
LEADING_CASE	Leading case	GRFN_REP_LEADING_CASE	CHAR	1			GRFN_REP_LEADING_CASE
REFERENCE	Leading case GUID	GRFN_CASE_ID	CHAR	32			GRFN_GUID
RATING	Rating	GRFN_RATING	CHAR	1			GRFN_AS_RATING
STATUS	Case status	GRFN_CASE_STATUS	CHAR	5			CRM_J_STATUS
OPEN_ISSUES	Open Issues	GRFN_CASE_OPEN_ISSUES	INT4	10
ISSUES	Issues	GRFN_CASE_ISSUES	INT4	10
RMPLANS	Remmediation Plans	GRFN_CASE_RMPLANS	INT4	10
CAPAPLANS	CAPA Plans	GRFN_CASE_CAPAPLANS	INT4	10
ISSUE_PRIO	Issue Priority ID	GRFN_REP_ISSUE_PRIORITY	CHAR	1			GRFN_ISSUE_PRIORITY
CASES	Cases	GRFN_CASE_CASES	INT4	10
CASES_FAILED	Failed Cases	GRFN_CASE_CASES_FAILED	INT4	10
CASES_REMED	Number of remediated cases	GRFN_REP_CASES_REMEDIATE	INT4	10
DUE_DATE	Cases Due Date	GRFN_REP_CASES_DUE_DATE	DATS	8			DATUM
RATING_ICON	URL	GRFN_URL	CHAR	255			CHAR255_CASE

Key field

Non-key field

< GRFN_S_DM_FPCEC - DataMart: Facts ELC + Rating Icon GRFN_S_DM_LOG_DETAIL - Log Details >

How do I retrieve data from SAP structure GRFN_S_DM_FPCSP using ABAP code?

As GRFN_S_DM_FPCSP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on GRFN_S_DM_FPCSP as there is no data to select.

How to access SAP table GRFN_S_DM_FPCSP

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

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