BALHDR SAP (Application log: log header) Table details
Dictionary Type: Table
Description: Application log: log header
Description: Application log: log header
Table field list including key, data, relationships and ABAP select examples
BALHDR is a standard SAP Table which is used to store Application log: log header data and is available within R/3 SAP systems depending on the version and release level.
The BALHDR table consists of various fields, each holding specific information or linking keys about Application log: log header data available in SAP. These include LOGNUMBER (Application log: log number), OBJECT (Application Log: Object Name (Application Code)), SUBOBJECT (Application Log: Subobject), 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: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP BALHDR 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 |
MANDANT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
LOGNUMBER | Application log: log number | BALOGNR | CHAR | 20 | BALOGNR | ||||
OBJECT | Application Log: Object Name (Application Code) | BALOBJ_D | CHAR | 20 | BALOBJ | BALOBJ | BALOBJ | ||
SUBOBJECT | Application Log: Subobject | BALSUBOBJ | CHAR | 20 | BALSUB | BALSUBOBJ | BALSUBOBJ | ||
EXTNUMBER | Application Log: External ID | BALNREXT | CHAR | 100 | BALNREXT | BALEXT | |||
ALDATE | Application log: date | BALDATE | DATS | 8 | DATUM | ||||
ALTIME | Application log: time | BALTIME | TIMS | 6 | UZEIT | ||||
ALUSER | Application log: user name | BALUSER | CHAR | 12 | Assigned to domain | XUBNAME | |||
ALTCODE | Application Log: Transaction code | BALTCODE | CHAR | 20 | TSTC | TCODE | |||
ALPROG | Application log: Program name | BALPROG | CHAR | 40 | TRDIR | PROGNAME | |||
ALMODE | Application Log: Operating mode (Batch,Batch Input,Dialog) | BALMODE | CHAR | 1 | BALMODE | ||||
ALTEXT | Application log: Standard text | BALTEXT | CHAR | 28 | CHAR28 | ||||
USEREXITP | Application Log: Callback: Program name | BALUEP | CHAR | 40 | TRDIR | PROGNAME | |||
USEREXITF | Application Log: Callback: Routine name | BALUEF | CHAR | 30 | CHAR30 | ||||
PROBCLASS | Application Log: Log problem class | BALPROBCLH | CHAR | 1 | BALPROBCL | ||||
ALDATE_DEL | Application log: expiry date | ALDATE_DEL | DATS | 8 | DATUM | ||||
DEL_BEFORE | Application Log: Keep log until expiry | DEL_BEFORE | CHAR | 1 | BALDELBEF | ||||
ALSTATE | Application log: processing status | ALSTATE | CHAR | 1 | ALSTATE | ||||
USEREXITT | Application Log: Callback: Type (Ext. Perform, FM, etc.) | BALUET | CHAR | 1 | BALUET | ||||
ALCHDATE | Application Log: Date of last change | BALCHDATE | DATS | 8 | DATUM | ||||
ALCHTIME | Application Log: Time of last change | BALCHTIME | TIMS | 6 | UZEIT | ||||
ALCHUSER | Application Log: User that changed the log | BALCHUSER | CHAR | 12 | Assigned to domain | XUBNAME | |||
LOG_HANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 | ||||
TABNAME | Application Log: Context: DDIC structure name | BALTABNAME | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
MSG_CNT_AL | Application Log: Total Number of Messages | BALDBCNTAL | NUMC | 6 | |||||
MSG_CNT_A | Application Log: Number of A Messages | BALDBCNTA | NUMC | 6 | |||||
MSG_CNT_E | Application Log: Number of E Messages | BALDBCNTE | NUMC | 6 | |||||
MSG_CNT_W | Application Log: Number of W Messages | BALDBCNTW | NUMC | 6 | |||||
MSG_CNT_I | Application Log: Number of I Messages | BALDBCNTI | NUMC | 6 | |||||
MSG_CNT_S | Application Log: Number of S Messages | BALDBCNTS | NUMC | 6 | |||||
LAST_MSGNR | ApplicationLog: Last message serial number assigned | BAL_LASTNR | NUMC | 6 | Assigned to domain | BALMNR | |||
TIM_STMP | Application log: Time basis for context nametab | BALCONTSMP | DEC | 15 | TZNTSTMPS | ||||
DB_VERSION | Application Log: Database repository format | BALDBVER | CHAR | 4 | BALDBVER | ||||
MSG_CNT_P1 | Application Log: Number of messages with problem class 1 | BALDBCNTP1 | NUMC | 6 | |||||
MSG_CNT_P2 | Application Log: Number of messages with problem class 2 | BALDBCNTP2 | NUMC | 6 | |||||
MSG_CNT_P3 | Application Log: Number of messages with problem class 3 | BALDBCNTP3 | NUMC | 6 | |||||
MSG_CNT_P4 | Application Log: Number of messages with problem class 4 | BALDBCNTP4 | NUMC | 6 | |||||
CLIENT_CRE | Application Log: Client in which a log was created | BALCLIENTC | CLNT | 3 | Assigned to domain | MANDT | |||
CHAR_SIZE | Application Log: Size of a Character in Bytes | BALCHARSIZ | NUMC | 1 | NUMC1 |
Key field | Non-key field |
How do I retrieve data from SAP table BALHDR using ABAP code
The following ABAP code Example will allow you to do a basic selection on BALHDR to SELECT all data from the tableDATA: WA_BALHDR TYPE BALHDR.
SELECT SINGLE *
FROM BALHDR
INTO CORRESPONDING FIELDS OF WA_BALHDR
WHERE...
How to access SAP table BALHDR
Within an ECC or HANA version of SAP you can also view further information about BALHDR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects