BALHDR
Application log: log header
BALHDR is an SAP database table in S/4HANA. Application log: log header. It contains 43 fields. 39 CDS views read from this table.
CDS Views using this table (39)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /BSNAGT/C_LOG_MESSAGES | view | from | Log Messages | |
| /PF1/C_LOG_MESSAGES | view | from | Log Messages | |
| /UIF/LREP_BALHDR_SDM_STATUS | view | from | LRep entry relevance for SDM | |
| APJ_V_BAL_HDR | view | from | Access to application log header for application jobs | |
| APJ_V_JOB_RUN_HAS_APPL_LOG | view | inner | ||
| APL_V_APPL_LOG_OVERVIEW | view | from | Application log list | |
| APOC_BALHDR_SDM_STATUS | view | from | Output Control entry relevance for SDM | |
| CRMS4_IU_I_LOG | view | from | Utilities Message Log Header | |
| FCCX_V_TASK_EXEC_R_BAL | view | inner | Analyze Task Task Exec Results | |
| FINOC_BCF_BALHDR_SDM_STATUS | view | from | Output Control entry relevance for SDM | |
| I_BalCarryfwdStsApplicationLog | view_entity | from | BASIC | BCF Status application log |
| I_CAMassActivityApplicationLog | view | from | BASIC | Composite view for JobInfo of MassRun |
| I_IHBEndOfDayProcessApplLog | view_entity | from | BASIC | IHB Process Application Log |
| I_JITApplicationLog | view_entity | from | BASIC | JIT Application Log |
| I_JITCallApplicationLog | view_entity | from | BASIC | JIT Call Application Log |
| I_JITOutbCallApplicationLog | view | from | BASIC | JIT Outbound Application Log |
| I_OrglChangeApplicationLog | view_entity | from | BASIC | Organizational Change application log |
| I_PMRPJobHeaderDetails | view | from | BASIC | Job Header Information |
| I_SrvcMaintPlnMassSchedIssSitn | view | from | BASIC | Service Maint. Plan Mass Schedule Issue |
| I_WrntyClaimApplicationLog | view | from | BASIC | Warranty claim application log |
| P_ACE_BALHDR_SDM_STATUS | view | from | BASIC | Accrual Engine Entries relevance for SDM |
| P_CSPRApplicationLog | view | from | BASIC | |
| P_EBRRPrvdrContrApplLog | view | from | CONSUMPTION | EBRR: Applog headers for Prvdr.Contr. |
| P_EventBasedWIPLogHeaderData | view | from | BASIC | |
| P_EvtBsdProdnCostErrorLog | view | from | BASIC | |
| P_EvtBsdRevnRecProjectAppLog | view | from | CONSUMPTION | Headers of appl. log for projects |
| P_EvtBsdRevnRecSrvcDocAppLog | view | from | CONSUMPTION | Headers of appl. log for service doc. |
| P_EvtBsdRevRecSalesOrderAppLog | view | from | CONSUMPTION | Headers of application log |
| P_EvtRevnRecgnRealTmeApplLog | view | from | CONSUMPTION | Headers of appl log |
| P_FAC_BALHDR_SDM_STATUS | view | from | BASIC | |
| P_FinSubstnValdtnLogHdr | view_entity | from | BASIC | |
| P_MBTPAYMENTLOGINFO | view | from | BASIC | |
| P_ProjRevnRecgnRealTmeApplLog | view | from | CONSUMPTION | Headers of appl log NPI |
| P_RealTimeMfgOrderLogData | view | from | BASIC | |
| R_ApplicationLogHeader | view_entity | from | BASIC | Application Log Header |
| R_PPDSMntrRcptApplLogBase | view_entity | from | BASIC | Application Log Base |
| SATC_RT_APP_LOG_DDLV | view | from | ATC Display ID -> Application Log Attributes | |
| SDM_SDBIL_BALHDR_ALDATE_DEL | view | from | Billing Output entry relevance for SDM | |
| sycm_aps_i_log_handle | view | from | Log handle for projects |
Fields (43)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandant | MANDT | Client | |||
| KEY | lognumber | BALOGNR | Log Number | |||
| object | BALOBJ_D | Object | ||||
| subobject | BALSUBOBJ | Subobject | ||||
| extnumber | BALNREXT | External ID | ||||
| aldate | BALDATE | Date | ||||
| altime | BALTIME | Time | ||||
| aluser | BALUSER | User | ||||
| altcode | BALTCODE | Transaction | ||||
| alprog | BALPROG | Program | ||||
| almode | BALMODE | Operating mode | ||||
| altext | BALTEXT | Standard text | ||||
| userexitp | BALUEP | Callback: Progr | ||||
| userexitf | BALUEF | Callback: Name | ||||
| probclass | BALPROBCLH | Max. prob. cl. | ||||
| aldate_del | ALDATE_DEL | Expiration Date | ||||
| del_before | DEL_BEFORE | Keep til expiry | ||||
| alstate | ALSTATE | Status | ||||
| userexitt | BALUET | Callback: Type | ||||
| alchdate | BALCHDATE | Changed on | ||||
| alchtime | BALCHTIME | Changed at | ||||
| alchuser | BALCHUSER | Changed by | ||||
| log_handle | BALLOGHNDL | Handle | ||||
| tabname | BALTABNAME | Structure | ||||
| msg_cnt_al | BALDBCNTAL | Total Messages | ||||
| msg_cnt_a | BALDBCNTA | Terminations | ||||
| msg_cnt_e | BALDBCNTE | Error Messages | ||||
| msg_cnt_w | BALDBCNTW | No. of Warnings | ||||
| msg_cnt_i | BALDBCNTI | Information | ||||
| msg_cnt_s | BALDBCNTS | Successful | ||||
| last_msgnr | BAL_LASTNR | Message no. | ||||
| tim_stmp | BALCONTSMP | Time Stamp | ||||
| db_version | BALDBVER | DB format | ||||
| msg_cnt_p1 | BALDBCNTP1 | very high | ||||
| msg_cnt_p2 | BALDBCNTP2 | High | ||||
| msg_cnt_p3 | BALDBCNTP3 | Medium | ||||
| msg_cnt_p4 | BALDBCNTP4 | low | ||||
| client_cre | BALCLIENTC | Client | ||||
| char_size | BALCHARSIZ | Bytes | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| epp_root_context_id | EPP_ROOT_CONTEXT_ID | Root ID | ||||
| epp_connection_id | EPP_CONNECTION_ID | Connection ID | ||||
| epp_transaction_id | EPP_TRANSACTION_ID | Transaction |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Application log: log header
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BALHDR (
MANDANT, -- Client [MANDT]
LOGNUMBER, -- Log Number [BALOGNR]
OBJECT, -- Object [BALOBJ_D]
SUBOBJECT, -- Subobject [BALSUBOBJ]
EXTNUMBER, -- External ID [BALNREXT]
ALDATE, -- Date [BALDATE]
ALTIME, -- Time [BALTIME]
ALUSER, -- User [BALUSER]
ALTCODE, -- Transaction [BALTCODE]
ALPROG, -- Program [BALPROG]
ALMODE, -- Operating mode [BALMODE]
ALTEXT, -- Standard text [BALTEXT]
USEREXITP, -- Callback: Progr [BALUEP]
USEREXITF, -- Callback: Name [BALUEF]
PROBCLASS, -- Max. prob. cl. [BALPROBCLH]
ALDATE_DEL, -- Expiration Date [ALDATE_DEL]
DEL_BEFORE, -- Keep til expiry [DEL_BEFORE]
ALSTATE, -- Status [ALSTATE]
USEREXITT, -- Callback: Type [BALUET]
ALCHDATE, -- Changed on [BALCHDATE]
ALCHTIME, -- Changed at [BALCHTIME]
ALCHUSER, -- Changed by [BALCHUSER]
LOG_HANDLE, -- Handle [BALLOGHNDL]
TABNAME, -- Structure [BALTABNAME]
MSG_CNT_AL, -- Total Messages [BALDBCNTAL]
MSG_CNT_A, -- Terminations [BALDBCNTA]
MSG_CNT_E, -- Error Messages [BALDBCNTE]
MSG_CNT_W, -- No. of Warnings [BALDBCNTW]
MSG_CNT_I, -- Information [BALDBCNTI]
MSG_CNT_S, -- Successful [BALDBCNTS]
LAST_MSGNR, -- Message no. [BAL_LASTNR]
TIM_STMP, -- Time Stamp [BALCONTSMP]
DB_VERSION, -- DB format [BALDBVER]
MSG_CNT_P1, -- very high [BALDBCNTP1]
MSG_CNT_P2, -- High [BALDBCNTP2]
MSG_CNT_P3, -- Medium [BALDBCNTP3]
MSG_CNT_P4, -- low [BALDBCNTP4]
CLIENT_CRE, -- Client [BALCLIENTC]
CHAR_SIZE, -- Bytes [BALCHARSIZ]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
EPP_ROOT_CONTEXT_ID, -- Root ID [EPP_ROOT_CONTEXT_ID]
EPP_CONNECTION_ID, -- Connection ID [EPP_CONNECTION_ID]
EPP_TRANSACTION_ID, -- Transaction [EPP_TRANSACTION_ID]
PRIMARY KEY (MANDANT, LOGNUMBER)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA