SAP GRFNDMIS DataMart: Issue Table data and field list

GRFNDMIS is a standard SAP Table which is used to store DataMart: Issue data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The GRFNDMIS table consists of various fields, each holding specific information or linking keys about DataMart: Issue data available in SAP. These include SNAPSHOT_ID (Datamart - Snapshot ID), OBJECT_ID (Object ID), IS_GUID (Issue ID), IS_PROCESSOR (Issue Processor 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. .

GRFNDMIS 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: Can Be Enhanced (Deep)


SAP GRFNDMIS 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 GRFNDMIS 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 MANDTCLNT3Assigned to domainMANDT
SNAPSHOT_IDDatamart - Snapshot ID GRFN_DM_SNAPSHOT_IDCHAR32SYSUUID_C
OBJECT_IDObject ID GRFN_API_OBJECT_IDCHAR50CHAR50
IS_GUIDIssue ID GRFN_REP_ISSUE_IDCHAR32SYSUUID_C
IS_PROCESSORIssue Processor ID GRFN_REP_ISSUE_PROCCHAR12Assigned to domainXUBNAME
IS_RESP_USERReported by ID GRFN_REP_ISSUE_RESPCHAR12Assigned to domainXUBNAME
IS_PRIORITYIssue Priority ID GRFN_REP_ISSUE_PRIORITYCHAR1GRFN_ISSUE_PRIORITY
IS_STATUSIssue Status ID GRFN_REP_ISSUE_STATUSCHAR5CRM_J_STATUS
IS_CF_STATUSCarryforward Status ID GRFN_REP_ISSUE_CF_STATUSCHAR1GRFN_REP_CF_STATUS
IS_DURATIONDuration in Days GRFN_REP_ISSUE_DURATIONINT410
IS_CREATED_ONIssue Created On (Date) GRFN_REP_ISSUE_CREATED_ONDATS8
IS_CREATED_ON_TMIssue Created On (Time) GRFN_REP_ISSUE_CREATED_ON_TMTIMS6
IS_CHANGED_ONIssue Changed On (Date) GRFN_REP_ISSUE_CHANGED_ONDATS8
IS_CHANGED_ON_TMIssue Changed On (Time) GRFN_REP_ISSUE_CHANGED_ON_TMTIMS6
IS_CLOSED_ONIssue Closed On (Date) GRFN_REP_ISSUE_CLOSED_ONDATS8
IS_CLOSED_ON_TMIssue Closed On (Time) GRFN_REP_ISSUE_CLOSED_ON_TMTIMS6
IS_CF_TFRAMEIssue: Timeframe bf Cfwd ID GRFN_REP_ISSUE_CF_TFRAMECHAR10GRFN_ATTRVALUE
IS_CF_YEARIssue: Year before Carryfwd GRFN_REP_ISSUE_CF_YEARCHAR4
IS_REIssue source regulation ID GRFN_REP_ISSUE_REGULATION_IDNUMC8NUMC08
IS_CATEGORYIssue Type ID GRFN_REP_ISSUE_CATEGORYCHAR4CHAR4
IS_TF_BEGDAIssue time frame start date GRFN_REP_ISSUE_DATE_BEGINDATS8DATUM
IS_TF_ENDDAIssue time frame end date GRFN_REP_ISSUE_DATE_ENDDATS8DATUM
IS_TFRAMETimeframe ID GRFN_REP_ISSUE_TIME_FRAMECHAR10GRFN_ATTRVALUE
IS_TF_YEARYear GRFN_REP_ISSUE_TF_YEARCHAR4CHAR4
IS_VAL_USERIssue validation user ID GRFN_REP_ISSUE_VAL_USERCHAR12GRFN_REP_RESP_USER
IS_VAL_DATEIssue validation date GRFN_REP_ISSUE_VAL_DATEDATS8DATUM
IS_SERIOUSIssue is serious GRFN_REP_ISSUE_IS_SERIOUSCHAR10GRFN_ATTRVALUE
IS_PRIORITYRAIssue priority RA ID GRFN_REP_ISSUE_PRIORITY_RACHAR1GRFN_ISSUE_PRIORITY
IS_IMPACTIssue impact GRFN_REP_ISSUE_IMPACTCHAR10GRFN_ATTRVALUE
IS_SO_RELEVANTSign-off Relevant (ID) GRFN_REP_ISSUE_SO_RELEVANTCHAR1GRFN_BOOLEAN
IS_DUE_DATEIssue Due Date GRFN_REP_ISSUE_DUE_DATEDATS8DATUM
IS_SCRIPTCATGScript Category GRFN_REP_ISSUE_SCRIPTCATGCHAR30CHAR30
IS_SCRIPTTYPEScript Type GRFN_REP_ISSUE_SCRIPTTYPECHAR20CHAR20
IS_DEFICIENCYOverall Deficiency Rating GRFN_REP_ISSUE_DEFICIENCYCHAR5Assigned to domainGRPC_DEFTYPE

Key field Non-key field



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

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

SELECT SINGLE *
FROM GRFNDMIS
INTO CORRESPONDING FIELDS OF WA_GRFNDMIS
WHERE...

How to access SAP table GRFNDMIS

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

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