FFN_HEADER

Transparent Table Application Table
30 Fields 1 CDS Views

Finance Notification Header

FFN_HEADER is an SAP database table in S/4HANA. Finance Notification Header. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinanceNotification view_entity from BASIC Finance Notification

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY finance_notification_uuid FFN_HDR_TECHNICAL_ID Finance Notification UUID
finance_notification_type FFN_HDR_TYPE Finance Notification Object Type
reference_document_type FFN_AWTYP Reference Document Type
reference_document_oid FFN_HDR_REF_DOC_OID Reference Document OID
reference_document_display_id FFN_HDR_REF_DOC_DSP_ID Reference Document Display ID
reference_document_event_oid FFN_HDR_REF_DOC_EVT_OID Reference Document Event OID
ref_document_event_display_id FFN_HDR_REF_DOC_EVT_DSP_ID Reference Document Event Display ID
ref_doc_logical_system FFN_REF_DOC_LOGICAL_SYSTEM Reference Document Logical System
company_code BUKRS Company Code
company_code_oid FIS_COMPANY_CODE_OID Company Code OID
posting_date FIS_BUDAT Posting Date
fin_notif_processing_status FFN_HDR_PROCG_STATUS Status
is_reversal FFN_XREVERSING Reversal
created_by_user FFN_CREATION_USER Created By
creation_datetime FFN_CREATION_TSTMPL Created On
local_last_changed_by_user FFN_LOCINST_LASTCHANGE_USER Local Instance Last Changed By
local_last_change_datetime FFN_LOCINST_LASTCHANGE_TSTMPL Local Instance Last Changed On
last_changed_by_user FFN_LASTCHANGE_USER Last Changed By
last_change_datetime FFN_LASTCHANGE_TSTMPL Last Changed On
application_log_handle BALLOGHNDL Handle
message_text LE_MSG_TEXT Message
message_unique_key FFN_MESSAGE_UNIQUE_KEY Message Unique Key
latest_message_class FFN_LATEST_MSG_CLASS Message Class
latest_message_number FFN_LATEST_MSG_NUMBER Message Number
latest_message_severity FFN_LATEST_MSG_SEVERITY Message Severity
latest_message_variable1_text FFN_LATEST_MSG_VARIABLE1 Message Variable 1
latest_message_variable2_text FFN_LATEST_MSG_VARIABLE2 Message Variable 2
latest_message_variable3_text FFN_LATEST_MSG_VARIABLE3 Message Variable 3
latest_message_variable4_text FFN_LATEST_MSG_VARIABLE4 Message Variable 4

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.

-- Finance Notification Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FFN_HEADER (
    CLIENT,                         -- abap.clnt
    FINANCE_NOTIFICATION_UUID,      -- Finance Notification UUID [FFN_HDR_TECHNICAL_ID]
    FINANCE_NOTIFICATION_TYPE,      -- Finance Notification Object Type [FFN_HDR_TYPE]
    REFERENCE_DOCUMENT_TYPE,        -- Reference Document Type [FFN_AWTYP]
    REFERENCE_DOCUMENT_OID,         -- Reference Document OID [FFN_HDR_REF_DOC_OID]
    REFERENCE_DOCUMENT_DISPLAY_ID,  -- Reference Document Display ID [FFN_HDR_REF_DOC_DSP_ID]
    REFERENCE_DOCUMENT_EVENT_OID,   -- Reference Document Event OID [FFN_HDR_REF_DOC_EVT_OID]
    REF_DOCUMENT_EVENT_DISPLAY_ID,  -- Reference Document Event Display ID [FFN_HDR_REF_DOC_EVT_DSP_ID]
    REF_DOC_LOGICAL_SYSTEM,         -- Reference Document Logical System [FFN_REF_DOC_LOGICAL_SYSTEM]
    COMPANY_CODE,                   -- Company Code [BUKRS]
    COMPANY_CODE_OID,               -- Company Code OID [FIS_COMPANY_CODE_OID]
    POSTING_DATE,                   -- Posting Date [FIS_BUDAT]
    FIN_NOTIF_PROCESSING_STATUS,    -- Status [FFN_HDR_PROCG_STATUS]
    IS_REVERSAL,                    -- Reversal [FFN_XREVERSING]
    CREATED_BY_USER,                -- Created By [FFN_CREATION_USER]
    CREATION_DATETIME,              -- Created On [FFN_CREATION_TSTMPL]
    LOCAL_LAST_CHANGED_BY_USER,     -- Local Instance Last Changed By [FFN_LOCINST_LASTCHANGE_USER]
    LOCAL_LAST_CHANGE_DATETIME,     -- Local Instance Last Changed On [FFN_LOCINST_LASTCHANGE_TSTMPL]
    LAST_CHANGED_BY_USER,           -- Last Changed By [FFN_LASTCHANGE_USER]
    LAST_CHANGE_DATETIME,           -- Last Changed On [FFN_LASTCHANGE_TSTMPL]
    APPLICATION_LOG_HANDLE,         -- Handle [BALLOGHNDL]
    MESSAGE_TEXT,                   -- Message [LE_MSG_TEXT]
    MESSAGE_UNIQUE_KEY,             -- Message Unique Key [FFN_MESSAGE_UNIQUE_KEY]
    LATEST_MESSAGE_CLASS,           -- Message Class [FFN_LATEST_MSG_CLASS]
    LATEST_MESSAGE_NUMBER,          -- Message Number [FFN_LATEST_MSG_NUMBER]
    LATEST_MESSAGE_SEVERITY,        -- Message Severity [FFN_LATEST_MSG_SEVERITY]
    LATEST_MESSAGE_VARIABLE1_TEXT,  -- Message Variable 1 [FFN_LATEST_MSG_VARIABLE1]
    LATEST_MESSAGE_VARIABLE2_TEXT,  -- Message Variable 2 [FFN_LATEST_MSG_VARIABLE2]
    LATEST_MESSAGE_VARIABLE3_TEXT,  -- Message Variable 3 [FFN_LATEST_MSG_VARIABLE3]
    LATEST_MESSAGE_VARIABLE4_TEXT,  -- Message Variable 4 [FFN_LATEST_MSG_VARIABLE4]
    PRIMARY KEY (CLIENT, FINANCE_NOTIFICATION_UUID)
);

Learn More