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