GRFNDMCN SAP (DataMart: Control) Table details

Dictionary Type: Table
Description: DataMart: Control




ABAP Code to SELECT data from GRFNDMCN
Related tables to GRFNDMCN
Access table GRFNDMCN




Table field list including key, data, relationships and ABAP select examples

GRFNDMCN is a standard SAP Table which is used to store DataMart: Control data and is available within R/3 SAP systems depending on the version and release level.

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

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 GRFNDMCN table fields - Full list of fields found in SAP data dictionary

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
RERegulation ID GRFN_REP_REGULATIONNUMC8NUMC08
CNControl ID GRFN_REP_CONTROL_IDCHAR9
CN_CENTRALCentral control id GRFN_REP_CONTROL_CENTRALNUMC8NUMC08
CN_SIGSignificance ID GRFN_REP_CONTROL_SIGCHAR10GRFN_ATTRVALUE
CN_IS_CONTROLIs Control ID GRFN_REP_CONTROL_IS_CONTROLCHAR1GRFN_XFELD
CN_PURPControl Purpose ID GRFN_REP_CONTROL_PURPCHAR10GRFN_ATTRVALUE
CN_MATARControl Maturity Target ID GRFN_REP_CONTROL_MATARCHAR10GRFN_ATTRVALUE
CN_AUTOMAutomation ID GRFN_REP_CONTROL_AUTOMCHAR10GRFN_ATTRVALUE
CN_FREQFrequency ID GRFN_REP_CONTROL_FREQCHAR10GRFN_ATTRVALUE
CN_NATURENature ID GRFN_REP_CONTROL_NATURECHAR10GRFN_ATTRVALUE
CN_TESTControl To Be Tested ID GRFN_REP_CONTROL_TESTCHAR1GRFN_XFELD
CN_TTECHTesting Technique ID GRFN_REP_CONTROL_TTECHNQCHAR10GRFN_ATTRVALUE
CN_TSTAUTTest Automation ID GRFN_REP_CONTROL_TEST_AUTOMCHAR10GRFN_ATTRVALUE
CN_DTEVTTrigger ID GRFN_REP_CONTROL_DATE_EVENTCHAR1GRFN_REP_CONTROL_DATE_EVENT
CN_VALID_FROMValid From GRFN_REP_CONTROL_VALID_FROMDATS8DATUM
CN_VALID_TOValid to GRFN_REP_CONTROL_VALID_TODATS8DATUM
CN_TEST_PLANControl test plan GRFN_REP_CONTROL_TEST_PLANNUMC8NUMC08
CN_ALLOW_REFERAllow reference ID GRFN_REP_CONTROL_ALLOW_REFERCHAR1GRFN_XFELD
CN_RESP_USEROwner ID GRFN_REP_CONTROL_RESP_USERCHAR12GRFN_REP_RESP_USER
CN_CATEGORYControl Category ID GRFN_REP_CONTROL_CATEGORYCHAR10
CN_EVIDENCELevel of Evidence ID GRFN_REP_CONTROL_EVIDENCECHAR10GRFN_ATTRVALUE
CN_EVIDENCE_SSLevel of Evidence - System Suggested ID GRFN_REP_CONTROL_EVIDENCE_SSCHAR1GRFN_REP_YES_NO
CN_CNTR_RISKControl Risk ID GRFN_REP_CONTROL_RISKCHAR10GRFN_ATTRVALUE
CN_CNTR_RISK_SSControl Risk - System Sugested ID GRFN_REP_CONTROL_RISK_SSCHAR1GRFN_REP_YES_NO
CN_CNGROUPControl Group ID GRFN_REP_CONTROL_CNGROUPCHAR10GRFN_ATTRVALUE
CN_ORIGINControl origin ID GRFN_REP_CONTROL_ORIGINCHAR1GRFN_REP_CONTROL_ORIGIN
CN_SS_OUShared Service Organization ID GRFN_REP_CONTROL_SS_OUNUMC8NUMC08
CN_SS_CNShared Service Control ID GRFN_REP_CONTROL_SS_CNCHAR9
CN_IS_MONITORIs relevant for monitoring (ID) GRFN_REP_CONTROL_IS_MONITORCHAR1GRFN_XFELD
CN_IS_COMPLIENCIs control relevant for compliance (ID) GRFN_REP_CONTROL_IS_COMPLCHAR1XFELD
CN_REG_SPECIFICRegulation Specific ID GRFN_REP_CONTROL_REG_SPECCHAR1GRFN_XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM GRFNDMCN
INTO CORRESPONDING FIELDS OF WA_GRFNDMCN
WHERE...

How to access SAP table GRFNDMCN

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!