SAP AFX_ACTVT Activity log Table

Overview

AFX_ACTVT is a standard SAP S/4HANA table that stores Activity log data. There are total 14 fields in the AFX_ACTVT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AFX_ACTVT belongs to Generating, Monitoring for Mass Data Archiving Solutions (CA-GTF-TS-GMA) module and is located in the package Archiving Framework: Global Objects (AFX_GLOBAL).

In addition, following links provide an overview of foreign key relationships, if any, that link AFX_ACTVT to other SAP tables and standard CDS views available based on AFX_ACTVT table in S/4HANA 2020.

Techincal Settings of AFX_ACTVT

Below are technical details of the table AFX_ACTVT

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of AFX_ACTVT Fields

The following table gives you an overview of the fields available in AFX_ACTVT

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
ACTVT_IDActivity IDAFX_DTE_ACTVT_IDNUMC10
STARTTIMESTAMPTime Stamp of an Archiving Run (Start)AFX_DTE_STARTTIMESTAMPDEC15
ENDTIMESTAMP(End) Time Stamp of Archiving RunAFX_DTE_ENDTIMESTAMPDEC15
LOG_EXTNUMBERApplication Log: External IDBALNREXTCHAR100
LOG_ALPROGApplication log: Program nameBALPROGCHAR40
LOG_OBJECTApplication log: Object name (Application code)BALOBJ_DCHAR20
LOG_ALDATEApplication Log: Expiration DateALDATE_DELDATS8
PROG_TYPEProgram TypeAFX_DTE_PROG_TYPECHAR3
OBJECTArchiving ObjectOBJCT_TR01CHAR10
APPLCATGApplication Type in Parallel ProcessingBANK_DTE_PP_PAAPPLCATGCHAR10
ARMODEArchiving ModeAFX_DTE_ARCHMODECHAR1
RUNUSERUser who Started Program RunBANK_DTE_PP_RUNUSRCHAR12
RUNSTATUSStatus of an Archiving RunAFX_DTE_RUNSTATUSINT13

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFX_ACTVT

Other References