FAN_HDR

Transparent Table Application Table
27 Fields 1 CDS Views

Accounting Notification

FAN_HDR is an SAP database table in S/4HANA. Accounting Notification. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AccountingNotification view_entity from BASIC Accounting Notification

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY accounting_notification_uuid FAN_HDR_TECHNICAL_ID Accounting Notification UUID
accounting_notification_type FAN_HDR_TYPE Accounting Notification Object Type
reference_document_type FAN_AWTYP Reference Document Type
reference_document FIS_AWREF Ref. Document Number
reference_document_context FIS_AWORG Reference Document Context
reference_document_item FINS_AWITEM Ref. Doc. Item
ref_doc_logical_system FIS_AWSYS Ref. Doc. Lgcl Syst.
creation_datetime FIS_CREATION_DATETIME Creation Date Time
reference_document_oid FAN_HDR_REF_DOC_OID Reference Doc.OID
reference_document_display_id FAN_HDR_REF_DOC_DSP_ID Reference Document Display ID
ref_doc_last_change_datetime FIS_CHNG_TSTAMP Last Changed At
leading_company_code FAN_HDR_LDNG_BUKRS Leading Company Code
proposed_posting_date FJEP_PROPOSED_POSTING_DATE Proposed Posting Date
acctg_notif_processing_status FAN_HDR_PROCG_STATUS Accounting Notification Status
last_change_datetime FIS_LASTCHANGE_DATETIME Last Change Date Time
created_by_user FAN_HDR_CREATED_BY_USER Created By
last_changed_by_user FAN_HDR_LST_CHGD_BY_USER Last Changed By
application_log_handle BALLOGHNDL Handle
latest_message_class FAN_LATEST_MSG_CLASS Message Class
latest_message_number FAN_LATEST_MSG_NUMBER Message Number
latest_message_severity FAN_LATEST_MSG_SEVERITY Message Severity
latest_message_variable1_text FAN_LATEST_MSG_VARIABLE1 Message Variable 1
latest_message_variable2_text FAN_LATEST_MSG_VARIABLE2 Message Variable 2
latest_message_variable3_text FAN_LATEST_MSG_VARIABLE3 Message Variable 3
latest_message_variable4_text FAN_LATEST_MSG_VARIABLE4 Message Variable 4
is_reversal FAN_XREVERSING Reversal

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.

-- Accounting Notification
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAN_HDR (
    CLIENT,                         -- abap.clnt
    ACCOUNTING_NOTIFICATION_UUID,   -- Accounting Notification UUID [FAN_HDR_TECHNICAL_ID]
    ACCOUNTING_NOTIFICATION_TYPE,   -- Accounting Notification Object Type [FAN_HDR_TYPE]
    REFERENCE_DOCUMENT_TYPE,        -- Reference Document Type [FAN_AWTYP]
    REFERENCE_DOCUMENT,             -- Ref. Document Number [FIS_AWREF]
    REFERENCE_DOCUMENT_CONTEXT,     -- Reference Document Context [FIS_AWORG]
    REFERENCE_DOCUMENT_ITEM,        -- Ref. Doc. Item [FINS_AWITEM]
    REF_DOC_LOGICAL_SYSTEM,         -- Ref. Doc. Lgcl Syst. [FIS_AWSYS]
    CREATION_DATETIME,              -- Creation Date Time [FIS_CREATION_DATETIME]
    REFERENCE_DOCUMENT_OID,         -- Reference Doc.OID [FAN_HDR_REF_DOC_OID]
    REFERENCE_DOCUMENT_DISPLAY_ID,  -- Reference Document Display ID [FAN_HDR_REF_DOC_DSP_ID]
    REF_DOC_LAST_CHANGE_DATETIME,   -- Last Changed At [FIS_CHNG_TSTAMP]
    LEADING_COMPANY_CODE,           -- Leading Company Code [FAN_HDR_LDNG_BUKRS]
    PROPOSED_POSTING_DATE,          -- Proposed Posting Date [FJEP_PROPOSED_POSTING_DATE]
    ACCTG_NOTIF_PROCESSING_STATUS,  -- Accounting Notification Status [FAN_HDR_PROCG_STATUS]
    LAST_CHANGE_DATETIME,           -- Last Change Date Time [FIS_LASTCHANGE_DATETIME]
    CREATED_BY_USER,                -- Created By [FAN_HDR_CREATED_BY_USER]
    LAST_CHANGED_BY_USER,           -- Last Changed By [FAN_HDR_LST_CHGD_BY_USER]
    APPLICATION_LOG_HANDLE,         -- Handle [BALLOGHNDL]
    LATEST_MESSAGE_CLASS,           -- Message Class [FAN_LATEST_MSG_CLASS]
    LATEST_MESSAGE_NUMBER,          -- Message Number [FAN_LATEST_MSG_NUMBER]
    LATEST_MESSAGE_SEVERITY,        -- Message Severity [FAN_LATEST_MSG_SEVERITY]
    LATEST_MESSAGE_VARIABLE1_TEXT,  -- Message Variable 1 [FAN_LATEST_MSG_VARIABLE1]
    LATEST_MESSAGE_VARIABLE2_TEXT,  -- Message Variable 2 [FAN_LATEST_MSG_VARIABLE2]
    LATEST_MESSAGE_VARIABLE3_TEXT,  -- Message Variable 3 [FAN_LATEST_MSG_VARIABLE3]
    LATEST_MESSAGE_VARIABLE4_TEXT,  -- Message Variable 4 [FAN_LATEST_MSG_VARIABLE4]
    IS_REVERSAL,                    -- Reversal [FAN_XREVERSING]
    PRIMARY KEY (CLIENT, ACCOUNTING_NOTIFICATION_UUID)
);

Learn More