Microsoft Sentinel
Cloud and workloads

Log and table reference for the Microsoft Sentinel solution for SAP applications

In brief

The article no longer includes connection-agent guidance, preview notices, collection and ingestion details, navigation, or detailed schemas for the documented SAP logs. It adds an ABAP Security Audit Log anchor and updates metadata.

What Defender admins need to know

Administrators using this page for SAP log tables, schemas, or connector-agent behavior will no longer find those details here. No administrator action is stated.

Summaries are generated from the documentation change itself.

Documentation change

The comparison below shows only the changed extract. Use the full-page view for complete context.

Log and table reference for the Microsoft Sentinel solution for SAP applications

This article describes the logs and tables available as part of the Microsoft Sentinel solution for SAP applications and its data connector.

:::zone pivot="connection-agent"

Some logs, noted in this article, aren't sent to Microsoft Sentinel by default, but you can manually add them as needed. For more information, see Define the SAP logs that are sent to Microsoft Sentinel

:::zone-end

Content in this article is intended for your SAP BASIS teams.

Use functions in your queries instead of underlying logs or tables

We strongly recommend that you use available functions as the subjects of their analysis whenever possible, instead of the underlying logs or tables.

  • Database layer: Ingest database logs into Microsoft Sentinel to monitor database activities, such as database administration activities and changes to table data. The Microsoft Sentinel solution for SAP applications is database-agnostic.

:::zone pivot="connection-agent"

All logs collected by the data connector agent are stored first on the data collector agent machine, at /opt/sapcon/<sid>/log folder in the container instance. The logs are then forwarded to your Log Analytics workspace, where you can view, audit, and query them from Microsoft Sentinel.

Audit logs are collected and ingested every minute, while other logs might be ingested less frequently. Microsoft Sentinel also monitors the data connector agent heartbeat to ensure that logs are being collected and sent to the Log Analytics workspace.

:::zone-end

:::zone pivot="connection-agentless"

Logs collected by the agentless data connector

The following built-in Log Analytics tables are collected by the agentless data connector:

:::zone-end

:::zone pivot="connection-agent"

Log reference for the data connector agent

The following sections describe the SAP logs available from the Microsoft Sentinel solution for SAP applications data connector, including the table names in Microsoft Sentinel, the log purposes, and detailed log schemas.

Schema field descriptions are based on the field descriptions in the relevant SAP documentation.

ABAP Application log

  • Microsoft Sentinel function for querying this log: SAPAppLog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Records the progress of an application execution so that you can reconstruct it later as needed.

    Available by using RFC based on standard SAP table and standard services of XBP interface. This log is generated per client.

    This log is ingested only with the data connector agent.

ABAPAppLog_CL log schema

FieldDescription
AppLogDateTimeApplication log date time
CallbackProgramCallback program
CallbackRoutineCallback routine
CallbackTypeCallback type
ClientIDABAP client ID (MANDT)
ContextDDICContext DDIC structure
ExternalIDExternal log ID
HostHost
InstanceABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
InternalMessageSerialApplication log message serial
LevelofDetailLevel of detail
LogHandleApplication log handle
LogNumberLog number
MessageClassMessage class
MessageNumberMessage number
MessageTextMessage text
MessageTypeMessage type
ObjectApplication log object
OperationModeOperation mode
ProblemClassProblem class
ProgramNameProgram name
SortCriterionSort criterion
StandardTextStandard text
SubObjectApplication log sub object
SystemIDSystem ID
SystemNumberSystem number
TransactionCodeTransaction code
UserUser
UserChangeUser change

ABAP Change Documents log

  • Microsoft Sentinel function for querying this log: SAPChangeDocsLog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Records:

    • SAP NetWeaver Application Server (AS) ABAP log changes to business data objects in change documents.

    • Other entities in the SAP system, such as user data, roles, addresses.

    Available by using RFC based on standard SAP tables. This log is generated per client.

ABAPChangeDocsLog_CL log schema

FieldDescription
ActualChangeNumActual change number
ChangedTableKeyChanged table key
ChangeNumberChange number
ClientIDABAP client ID (MANDT)
CreatedfromPlannedChangeCreated from planned change, in the following syntax: (‘X’ , ‘ ‘)
CurrencyKeyNewCurrency key: new value
CurrencyKeyOldCurrency key: old value
FieldNameField name
FlagTextFlag text
HostHost
InstanceABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
LanguageLanguage
ObjectClassObject class, such as BELEG, BPAR, PFCG, IDENTITY
ObjectIDObject ID
PlannedChangeNumPlanned change number
SystemIDSystem ID
SystemNumberSystem number
TableNameTable name
TransactionCodeTransaction code
TypeofChange_HeaderHeader type of change, including:
U = Change; I = Insert; E = Delete Single Docu; D = Delete; J = Insert Single Docu
TypeofChange_ItemItem type of change, including:
U = Change; I = Insert; E = Delete Single Docu; D = Delete; J = Insert Single Docu
UOMNewUnit of measure: new value
UOMOldUnit of measure: old value
UserUser
ValueNewField content: new value
ValueOldField content: old value
VersionVersion

ABAP CR log

  • Microsoft Sentinel function for querying this log: SAPCRLog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Includes the Change & Transport System (CTS) logs, including the directory objects and customizations where changes were made.

    Available by using RFC based on standard tables and standard SAP services. This log is generated with data across all clients.

ABAPCRLog_CL log schema

Field Description
Category Category (Workbench, Customizing)
ClientID ABAP client ID (MANDT)
Description Description
Host Host
Instance ABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
ObjectName Object name
ObjectType Object type
Owner Owner
Request Change request
Status Status
SystemID System ID
SystemNumber System number
TableKey Table key
TableName Table name
ViewName View name

ABAP DB table data log (PREVIEW)

To have this log sent to Microsoft Sentinel, you must add it manually to the systemconfig.json file. This log isn't supported when using the recommended procedure to install the data connector agent from the portal.

  • Microsoft Sentinel function for querying this log: SAPTableDataLog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Provides logging for those tables that are critical or susceptible to audits.

    Available by using RFC with a custom service. This log is generated with data across all clients.

ABAPTableDataLog_CL log schema

FieldDescription
DBLogIDDB log ID
HostHost
InstanceABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
LanguageLanguage
LogKeyLog key
NewValueField new value
OldValueField old value
OperationTypeSQLOperation type, Insert, Update, Delete
ProgramProgram name
SystemIDSystem ID
SystemNumberSystem number
TableFieldTable field
TableNameTable name
TransactionCodeTransaction code
UserNameUser
VersionNumberVersion number

ABAP Gateway log (PREVIEW)

To have this log sent to Microsoft Sentinel, you must add it manually to the systemconfig.json file. This log isn't supported when using the recommended procedure to install the data connector agent from the portal.

  • Microsoft Sentinel function for querying this log: SAPOS_GW

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Monitors Gateway activities. Available by the SAP Control web service. This log is generated with data across all clients.

ABAPOS_GW_CL log schema

FieldDescription
HostHost
InstanceABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
MessageTextMessage text
SeverityMessage severity: Debug, Info, Warning, Error
SystemIDSystem ID
SystemNumberSystem number

ABAP ICM log (PREVIEW)

To have this log sent to Microsoft Sentinel, you must add it manually to the systemconfig.json file. This log isn't supported when using the recommended procedure to install the data connector agent from the portal.

  • Microsoft Sentinel function for querying this log: SAPOS_ICM

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Records inbound and outbound requests and compiles statistics of the HTTP requests.

    Available by the SAP Control web service. This log is generated with data across all clients.

ABAPOS_ICM_CL log schema

FieldDescription
HostHost
InstanceABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
MessageTextMessage text
SeverityMessage severity, including: Debug, Info, Warning, Error
SystemIDSystem ID
SystemNumberSystem number

ABAP Job log

  • Microsoft Sentinel function for querying this log: SAPJobLog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Combines all background processing job logs (SM37).

    Available by using RFC based on standard SAP table and standard services of XBP interfaces. This log is generated with data across all clients.

ABAPJobLog_CL log schema

FieldDescription
ABAPProgramABAP program
BgdEventParametersBackground event parameters
BgdProcessingEventBackground processing event
ClientIDABAP client ID (MANDT)
DynproNumberDynpro number
GUIStatusGUI status
HostHost
InstanceABAP instance (HOST_SYSID_SYSNR), in the following syntax: <HOST>_<SYSID>_<SYSNR>
JobClassificationJob classification
JobCountJob count
JobGroupJob group
JobNameJob name
JobPriorityJob priority
MessageClassMessage class
MessageNumberMessage number
MessageTextMessage text
MessageTypeMessage type
ReleaseUserJob release user
SchedulingDateTimeScheduling date time
StartDateTimeStart date time
SystemIDSystem ID
SystemNumberSystem number
TargetServerTarget server
UserUser
UserReleaseInstanceABAP instance - user release
WorkProcessIDWork process ID
WorkProcessNumberWork process Number

ABAP Security Audit log

  • Microsoft Sentinel function for querying this log: SAPAuditLog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Records the following data:

    • Security-related changes to the SAP system environment, such as changes to main user records
    • Information that provides a higher level of data, such as successful and unsuccessful sign-in attempts
    • Information that enables the reconstruction of a series of events, such as successful or unsuccessful transaction starts

    Available by using RFC XAL/SAL interfaces. SAL is available starting from version Basis 7.50. This log is generated with data across all clients.

ABAPAuditLog_CL log schema

FieldDescription
ABAPProgramNameProgram name, SAL only
AlertSeverityAlert severity
AlertSeverityTextAlert severity text, SAL only
AlertValueAlert value
AuditClassIDAudit class ID, SAL only
ClientIDABAP client ID (MANDT)
ComputerUser machine, SAL only
EmailUser email
HostHost
InstanceABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
MessageClassMessage class
MessageContainerIDMessage container ID, XAL Only
MessageIDMessage ID, such as ‘AU1’,’AU2’…
MessageTextMessage text
MonitoringObjectNameMTE Monitor object name, XAL only
MonitorShortNameMTE Monitor short name, XAL only
SAPProcessTypeSystem Log: SAP process type, SAL only
B* - Background Processing
D* - Dialog Processing
U* - Update Tasks
SAPWPNameSystem Log: Work process number, SAL only
SystemIDSystem ID
SystemNumberSystem number
TerminalIPv6User machine IP, SAL only
TransactionCodeTransaction code, SAL only
UserUser
Variable1Message variable 1
Variable2Message variable 2
Variable3Message variable 3
Variable4Message variable 4

ABAP Spool log

  • Microsoft Sentinel function for querying this log: SAPSpoolLog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Serves as the main log for SAP printing with the history of spool requests. (SP01).

    Available by using RFC based on standard SAP table. This log is generated with data across all clients.

ABAPSpoolLog_CL log schema

FieldDescription
ArchiveStatusArchive status
ArchiveTypeArchive type
ArchivingDeviceArchiving device
AutoRereouteAuto reroute
ClientIDABAP client ID (MANDT)
CountryKeyCountry/region key
DeleteSpoolRequestAutoDelete spool request auto
DelFlagDeletion flag
DepartmentDepartment
DocumentTypeDocument type
ExternalModeExternal mode
FormatTypeFormat type
HostHost
InstanceABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
NumofCopiesNumber of copies
OutputDeviceOutput device
PrinterLongNamePrinter long name
PrintImmediatelyPrint immediately
PrintOSCoverPagePrint OSCover page
PrintSAPCoverPagePrint SAPCover page
PriorityPriority
RecipientofSpoolRequestRecipient of spool request
SpoolErrorStatusSpool error status
SpoolRequestCompletedSpool request completed
SpoolRequestisALogForAnotherRequestSpool request is a log for another request
SpoolRequestNameSpool request name
SpoolRequestNumberSpool request number
SpoolRequestSuffix1Spool request suffix1
SpoolRequestSuffix2Spool request suffix2
SpoolRequestTitleSpool request title
SystemIDSystem ID
SystemNumberSystem number
TelecommunicationsPartnerTelecommunications partner
TelecommunicationsPartnerETelecommunications partner E
TemSeGeneralcounterTemse counter
TemseNumAddProtectionRuleTemse number add protection rule
TemseNumChangeProtectionRuleTemse number change protection rule
TemseNumDeleteProtectionRuleTemse number delete protection rule
TemSeObjectNameTemse object name
TemSeObjectPartTemSe object part
TemseReadProtectionRuleTemse read protection rule
UserUser
ValueAuthCheckValue auth check

APAB Spool Output log

  • Microsoft Sentinel function for querying this log: SAPSpoolOutputLog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Serves as the main log for SAP Printing with the history of spool output requests. (SP02).

    Available by using RFC with a custom service based on standard tables. This log is generated with data across all clients.

ABAPSpoolOutputLog_CL log schema

FieldDescription
AppServerApplication server
ClientIDABAP client ID (MANDT)
CommentComment
CopyCountCopy count
CopyCounterCopy counter
DepartmentDepartment
ErrorSpoolRequestNumberError request number
FormatTypeFormat type
HostHost
HostNameHost name
HostSpoolerIDHost spooler ID
InstanceABAP instance
LastPageLast page
NumofCopiesNumber of copies
OutputDeviceOutput device
OutputRequestNumberOutput request number
OutputRequestStatusOutput request status
PhysicalFormatTypePhysical format type
PrinterLongNamePrinter long name
PrintRequestSizePrint request size
PriorityPriority
ReasonforOutputRequestReason for output request
RecipientofSpoolRequestRecipient of spool request
SpoolNumberofOutputReqProcessedNumber of output requests - processed
SpoolNumberofOutputReqWithErrorsNumber of output requests - with errors
SpoolNumberofOutputReqWithProblemsNumber of output requests - with problems
SpoolRequestNumberSpool request number
StartPageStart page
SystemIDSystem ID
SystemNumberSystem number
TelecommunicationsPartnerTelecommunications partner
TemSeGeneralcounterTemse counter
TitleTitle
UserUser

ABAP Syslog

To have this log sent to Microsoft Sentinel, you must add it manually to the systemconfig.json file. This log isn't supported when using the recommended procedure to install the data connector agent from the portal.

  • Microsoft Sentinel function for querying this log: SAPOS_Syslog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Records all SAP NetWeaver Application Server (SAP NetWeaver AS) ABAP system errors, warnings, user locks because of failed sign-in attempts from known users, and process messages.

    Available by the SAP Control web service. This log is generated with data across all clients.

ABAPOS_Syslog_CL log schema

FieldDescription
ClientIDABAP client ID (MANDT)
HostHost
InstanceABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
MessageNumberMessage number
MessageTextMessage text
SeverityMessage severity, one of the following values: Debug, Info, Warning, Error
SystemIDSystem ID
SystemNumberSystem number
TransacationCodeTransaction code
TypeSAP process type
UserUser

ABAP Workflow log

  • Microsoft Sentinel function for querying this log: SAPWorkflowLog

  • Related SAP documentation: SAP Help Portal

  • Log purpose: The SAP Business Workflow (WebFlow Engine) enables you to define business processes that aren't yet mapped in the SAP system.

    For example, unmapped business processes might be simple release or approval procedures, or more complex business processes such as creating base material and then coordinating the associated departments.

    Available by using RFC based on standard SAP tables. This log is generated per client.

ABAPWorkflowLog_CL log schema

FieldDescription
ActualAgentActual agent
AddressAddress
ApplicationAreaApplication area
CallbackFunctionCallback function
ClientIDABAP client ID (MANDT)
CreationDateTimeCreation date time
CreatorCreator
CreatorAddressCreator address
ErrorTypeError type
ExceptionforMethodException for method
HostHost
InstanceABAP instance (HOST_SYSID_SYSNR), in the following syntax: <HOST>_<SYSID>_<SYSNR>
LanguageLanguage
LogCounterLog counter
MessageNumberMessage number
MessageTypeMessage type
MethodUserMethod user
PriorityPriority
SimpleContainerSimple container, packed as a list of key-value entities for the work item
StatusStatus
SuperWISuper WI
SystemIDSystem ID
SystemNumberSystem number
TaskIDTask ID
TasksClassificationTask classifications
TaskTextTask text
TopTaskIDTop task ID
UserCreatedUser created
WITextWork item text
WITypeWork item type
WorkflowActionWorkflow action
WorkItemIDWork item ID

ABAP WorkProcess log

To have this log sent to Microsoft Sentinel, you must add it manually to the systemconfig.json file. This log isn't supported when using the recommended procedure to install the data connector agent from the portal.

  • Microsoft Sentinel function for querying this log: SAPOS_WP

  • Related SAP documentation: SAP Help Portal

  • Log purpose: Combines all work process logs. (default: dev_*).

    Available by the SAP Control web service. This log is generated with data across all clients.

ABAPOS_WP_CL log schema

FieldDescription
HostHost
InstanceABAP instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
MessageTextMessage text
SeverityMessage severity: Debug, Info, Warning, Error
SystemIDSystem ID
SystemNumberSystem number
WPNumberWork process number

HANA DB Audit Trail

Collecting the HANA DB Audit Trail log is an example of how Microsoft Sentinel collects database layer activities. To have this log sent to Microsoft Sentinel, you must deploy Azure Monitor Agent to gather Syslog data from the machine running HANA DB.

  • Microsoft Sentinel function for querying this log: SAPSyslog

  • Related SAP documentation: General | Audit Trail

  • Log purpose: Records user actions, or attempted actions in the SAP HANA database. For example, enables you to log and monitor read access to sensitive data.

    Available by the Microsoft Sentinel Linux Agent for Syslog. This log is generated with data across all clients.

Syslog log schema

FieldDescription
ComputerHost name
HostIPHost IP
HostNameHost name
ProcessIDProcess ID
ProcessNameProcess name: HDB*
SeverityLevelAlert
SourceSystemSource system OS, Linux
SyslogMessageMessage, an unparsed audit trail message

JAVA files

To have this log sent to Microsoft Sentinel, you must add it manually to the systemconfig.json file. This log isn't supported when using the recommended procedure to install the data connector agent from the portal.

  • Microsoft Sentinel function for querying this log: SAPJAVAFilesLogs

  • Related SAP documentation: General | Java Security Audit Log

  • Log purpose: Combines all Java files-based logs, including the Security Audit Log, and System (cluster and server process), Performance, and Gateway logs. Also includes Developer Traces and Default Trace logs.

    Available by the SAP Control web service. This log is generated with data across all clients.

JavaFilesLogsCL log schema

FieldDescription
ApplicationJava application
ClientIDClient ID
CSNComponentCSN component, such as BC-XI-IBD
DCComponentDC component, such as com.sap.xi.util.misc
DSRCounterDSR counter
DSRRootContentIDDSR context GUID
DSRTransactionDSR transaction GUID
HostHost
InstanceJava instance, in the following syntax: <HOST>_<SYSID>_<SYSNR>
LocationJava class
LogNameJava logName, such as: Available, defaulttrace, dev*, security, and so on
MessageTextMessage text
MNoMessage number
PidProcess ID
ProgramProgram name
SessionSession
SeverityMessage severity, including: Debug,Info,Warning,Error
SolutionSolution
SystemIDSystem ID
SystemNumberSystem number
ThreadNameThread name
ThrownException thrown
TimeZoneTimezone
UserUser

SAP Heartbeat Log

  • Microsoft Sentinel function for querying this log: SAPConnectorHealth

  • Log purpose: Provides heartbeat and other health information on the connectivity between the agents and the different SAP systems.

    Automatically created for any agents of the Microsoft Sentinel for SAP data connector.

SAP_HeartBeat_CL log schema

FieldDescription
TimeGeneratedTime of log posting event
agent_id_sAgent ID in agent's configuration (automatically generated)
agent_ver_sAgent version
host_sThe agent's host name
system_id_sNetweaver ABAP System ID /
Netweaver SAPControl Host (preview) /
Java SAPControl host (preview)
push_timestamp_dTimestamp of the extraction, according to the agent's time zone
agent_timezone_sAgent's time zone

Reference of tables retrieved directly from SAP systems

This section lists the data tables that are retrieved directly from the SAP system and ingested into Microsoft Sentinel exactly as they are.

The data retrieved from these tables provides a clear view of the authorization structure, group membership, and user profiles. It also allows you to track the process of authorization grants and revokes, and identify and govern the risks associated with those processes.

The tables listed below are required to enable functions that identify privileged users, map users to roles, groups, and authorizations.

For best results, refer to these tables using the name in the Microsoft Sentinel function name column in the following table:

Table nameTable descriptionMicrosoft Sentinel function name
USR01User master record (runtime data)SAP_USR01
USR02Sign-in data (kernel-side use)SAP_USR02
UST04User masters
Maps users to profiles
SAP_UST04
AGR_USERSAssignment of roles to usersSAP_AGR_USERS
AGR_1251Authorization data for the activity groupSAP_AGR_1251
USGRP_USERAssignment of users to user groupsSAP_USGRP_USER
USR21User name / Address key assignmentSAP_USR21
ADR6Email addresses (business address services)SAP_ADR6
USRSTAMPTime stamp for all changes to the userSAP_USRSTAMP
ADCPPerson / Address assignment (business address services)SAP_ADCP
USR05User master parameter IDSAP_USR05
AGR_PROFProfile name for roleSAP_AGR_PROF
AGR_FLAGSRole attributesSAP_AGR_FLAGS
DEVACCESSTable for development userSAP_DEVACCESS
AGR_DEFINERole definitionSAP_AGR_DEFINE
AGR_AGRSRoles in composite rolesSAP_AGR_AGRS
PAHIHistory of the system, database, and SAP parametersSAP_PAHI
SNCSYSACL (PREVIEW)SNC Access Control List (ACL): SystemsSAP_SNCSYSACL
USRACL (PREVIEW)SNC Access Control List (ACL): UserSAP_USRACL

:::zone-end

Related content