GRPCRTA_DBTABLOG SAP (GRC Table of log records for table changes) Table details

Dictionary Type: Table
Description: GRC Table of log records for table changes




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




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

GRPCRTA_DBTABLOG is a standard SAP Table which is used to store GRC Table of log records for table changes data and is available within R/3 SAP systems depending on the version and release level.

The GRPCRTA_DBTABLOG table consists of various fields, each holding specific information or linking keys about GRC Table of log records for table changes data available in SAP. These include LOGDATE ((8-character) Date for SYST), LOGTIME (TIME Data Element for SYST), TABNAME (Table Name), LOGID (Unique identification of an entry in DBTABLOG).. 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: Not classified


SAP GRPCRTA_DBTABLOG 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
LOGDATE(8-character) Date for SYST SYDATSDATS8SYDATS
LOGTIMETIME Data Element for SYST SYTIMETIMS6SYTIME
TABNAMETable Name TABNAMECHAR30Assigned to domainAS4TABDTB
LOGIDUnique identification of an entry in DBTABLOG LOGIDCHAR18CHAR18
TABKEYTable Key TABKEYCHAR120CHAR120
FNAMEField Name FIELDNAMECHAR30Assigned to domainFDNAMEDFD
SCRTEXTExplanatory short text DDTEXTCHAR60DDTEXT
VALUE_OLDOld contents of changed field CDFLDVALOCHAR254FIELDVAL
VALUE_NEWNew contents of changed field CDFLDVALNCHAR254FIELDVAL
CHNGINDChange Type (U, I, S, D) CDCHNGINDCHAR1CDCHNGIND
USERNAMEUser name of the person responsible in change document CDUSERNAMECHAR12CHAR12

Key field Non-key field



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

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

SELECT SINGLE *
FROM GRPCRTA_DBTABLOG
INTO CORRESPONDING FIELDS OF WA_GRPCRTA_DBTABLOG
WHERE...

How to access SAP table GRPCRTA_DBTABLOG

Within an ECC or HANA version of SAP you can also view further information about GRPCRTA_DBTABLOG 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!