SAP CDC_TRIGGER Table subject to recording Table data and field list

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

The CDC_TRIGGER table consists of various fields, each holding specific information or linking keys about Table subject to recording data available in SAP. These include TABNAME (Table Name), TRIGGER_TYPE (Type of a DB trigger), TRIGGER_NAME (Name of a DB trigger), TRIGGER_STATUS (Status of a DB Trigger)... 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. .

CDC_TRIGGER table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CDC_TRIGGER 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 CDC_TRIGGER 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
RECORDER_IDUnique Identifier of a Recorder CDC_RECORDER_IDCHAR32
TABNAMETable Name TABNAMECHAR30Assigned to domainAS4TABDTB
TRIGGER_TYPEType of a DB trigger CDC_TRIGGER_TYPECHAR1CDC_TRIGGER_TYPE
TRIGGER_NAMEName of a DB trigger CDC_TRIGGER_NAMECHAR30
TRIGGER_STATUSStatus of a DB Trigger CDC_TRIGGER_STATUSCHAR1CDC_TRIGGER_STATUS

Key field Non-key field



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

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

SELECT SINGLE *
FROM CDC_TRIGGER
INTO CORRESPONDING FIELDS OF WA_CDC_TRIGGER
WHERE...

How to access SAP table CDC_TRIGGER

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

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