BALHDR

Transparent Table Temporary Data

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)

ViewTypeJoinVDMDescription
/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)

KeyField Data ElementDescription DomainTypeLength
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)
);