AFX_ACTVT SAP (Activity log) Table details

Dictionary Type: Table
Description: Activity log




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




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

AFX_ACTVT is a standard SAP Table which is used to store Activity log data and is available within R/3 SAP systems depending on the version and release level.

The AFX_ACTVT table consists of various fields, each holding specific information or linking keys about Activity log data available in SAP. These include ACTVT_ID (Activity ID), STARTTIMESTAMP (Time Stamp of an Archiving Run (Start)), ENDTIMESTAMP ((End) Time Stamp of Archiving Run), LOG_EXTNUMBER (Application Log: External 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: Cannot Be Enhanced


SAP AFX_ACTVT 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
ACTVT_IDActivity ID AFX_DTE_ACTVT_IDNUMC10AFX_ACTVT_ID
STARTTIMESTAMPTime Stamp of an Archiving Run (Start) AFX_DTE_STARTTIMESTAMPDEC15TZNTSTMPS
ENDTIMESTAMP(End) Time Stamp of Archiving Run AFX_DTE_ENDTIMESTAMPDEC15TZNTSTMPS
LOG_EXTNUMBERApplication Log: External ID BALNREXTCHAR100BALNREXTBALEXT
LOG_ALPROGApplication log: Program name BALPROGCHAR40PROGNAME
LOG_OBJECTApplication Log: Object Name (Application Code) BALOBJ_DCHAR20Assigned to domainBALOBJBALOBJ
LOG_ALDATEApplication log: expiry date ALDATE_DELDATS8DATUM
PROG_TYPEProgram Type AFX_DTE_PROG_TYPECHAR3AFX_PROG_TYPE
OBJECTArchiving Object OBJCT_TR01CHAR10Assigned to domainOBJCT_TR01OBT
APPLCATGApplication Type in Parallel Processing BANK_DTE_PP_PAAPPLCATGCHAR10BANK_PP_PAAPPLCATGBANK_SEARCH_APPLCATG
ARMODEArchiving Mode AFX_DTE_ARCHMODECHAR1AFX_ARCHMODE
RUNUSERUser who Started Program Run BANK_DTE_PP_RUNUSRCHAR12UNAME
RUNSTATUSStatus of an Archiving Run AFX_DTE_RUNSTATUSINT13AFX_RUNSTATUS

Key field Non-key field



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

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

SELECT SINGLE *
FROM AFX_ACTVT
INTO CORRESPONDING FIELDS OF WA_AFX_ACTVT
WHERE...

How to access SAP table AFX_ACTVT

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