SAP GRFN_S_DM_FPCAS DataMart: Facts PC Case + Rating URL Table data and field list

GRFN_S_DM_FPCAS 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 Case + Rating URL" 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_FPCAS TYPE GRFN_S_DM_FPCAS.

The GRFN_S_DM_FPCAS table consists of various fields, each holding specific information or linking keys about DataMart: Facts PC Case + Rating URL 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_FPCAS 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_FPCAS 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_FPCAS 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
EC	Indirect ELC ID	GRFN_REP_ECONTROL	NUMC	8			NUMC08
SP	Subprocess ID	GRFN_REP_SUBPROCESS_ID	NUMC	8			NUMC08
CN	Control ID	GRFN_REP_CONTROL_ID	CHAR	9
AS_GUID	Assessment Id	GRFN_REP_ASSMNT_ID	CHAR	32			SYSUUID_C
TL_GUID	Test Log ID	GRFN_REP_TESTLOG	CHAR	32			SYSUUID_C
IS_GUID	Issue ID	GRFN_REP_ISSUE_ID	CHAR	32			SYSUUID_C
PL_GUID	Remediation Plan ID	GRFN_REP_RMPLAN	CHAR	32			SYSUUID_C
CP_GUID	CAPA Plan ID	GRFN_REP_CPPLAN	CHAR	32			SYSUUID_C
RATING	Rating	GRFN_RATING	CHAR	1			GRFN_AS_RATING
STATUS	Case status	GRFN_CASE_STATUS	CHAR	5			CRM_J_STATUS
RATING_ICON	URL	GRFN_URL	CHAR	255			CHAR255_CASE

Key field

Non-key field

< GRFN_S_DM_AUTHORIZATION - List of Authorized objects GRFN_S_DM_FPCCN - DataMart: Facts PC Control + Rating URL >

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

As GRFN_S_DM_FPCAS 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_FPCAS as there is no data to select.

How to access SAP table GRFN_S_DM_FPCAS

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

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