CFIN_AIF_IDX_TBL

Transparent Table Application Table
44 Fields 1 CDS Views

Central Finance: AIF Message Key Fields

CFIN_AIF_IDX_TBL is an SAP database table in S/4HANA. Central Finance: AIF Message Key Fields. It contains 44 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CFinReplicatedTransaction view_entity from BASIC CFIN Replicated Transaction

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY msgguid GUID_32 GUID 16
ns /AIF/NS Namespace
ifname /AIF/IFNAME Interface Name
ifver /AIF/IFVERSION Interface Version
numberofaborts /AIF/NUMBEROFABORTS Abort Number
numberoferrors /AIF/NUMBEROFERRORS Error Number
numberofwarnings /AIF/NUMBEROFWARNINGS Warning Number
numberofsuccess /AIF/NUMBEROFSUCCESS Success Number
numberofinfos /AIF/NUMBEROFINFOS Informati Number
nsrecip /AIF/NS Namespace
recipient /AIF/ALRT_REC Recipient for Alert
status /AIF/PROC_STATUS Processing Status
sub_status /AIF/PROC_SUB_STATUS Sub Status
aif_location /AIF/MESSAGE_LOCATION Message Location
lognumber BALOGNR Log Number
trace_level /AIF/TRACE_LEVEL Trace Level
tl_exp_date /AIF/EXP_DATE Expiration Date
tl_exp_time /AIF/EXP_TIME Expiration Time
create_user /AIF/CREATE_USER Create User
create_date /AIF/CREATE_DATE Creation Date
create_time /AIF/CREATE_TIME Creation Time
last_user /AIF/LAST_USER Last User
last_date /AIF/LAST_DATE Last Date
last_time /AIF/LAST_TIME Last Time
end_user /AIF/END_USER End User
end_date /AIF/END_DATE End Date
end_time /AIF/END_TIME End Time
aif_alert_id SALRTEXTID External Alert ID
aif_variant_ns /AIF/VARIANT_NS Namespace
aif_variant_name /AIF/VARIANT_NAME Interface Variant
external_message /AIF/EXTERNAL_MESSAGE EXT_MESSAGE
time_zone TZNZONE Time Zone
processing_end_tstmp /AIF/PROCESSING_TSTMP UTC Timestamp
pid SXMSPID Pipeline ID
awtyp AWTYP Ref. procedure
awref AWREF Reference Doc.
aworg AWORG Refer. Org.Unit
awsys AWSYS Logical System
timestamp TZNTSTMPL Time Stamp
logsystem_sender LOGSYSTEM_SENDER Sender Log Sys.
bukrs_sender BUKRS_SENDER Sender CoCode
bukrs BUKRS Company Code
tcode TCODE Transaction Code

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.

-- Central Finance: AIF Message Key Fields
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AIF_IDX_TBL (
    MANDT,                 -- Client [MANDT]
    MSGGUID,               -- GUID 16 [GUID_32]
    NS,                    -- Namespace [/AIF/NS]
    IFNAME,                -- Interface Name [/AIF/IFNAME]
    IFVER,                 -- Interface Version [/AIF/IFVERSION]
    NUMBEROFABORTS,        -- Abort Number [/AIF/NUMBEROFABORTS]
    NUMBEROFERRORS,        -- Error Number [/AIF/NUMBEROFERRORS]
    NUMBEROFWARNINGS,      -- Warning Number [/AIF/NUMBEROFWARNINGS]
    NUMBEROFSUCCESS,       -- Success Number [/AIF/NUMBEROFSUCCESS]
    NUMBEROFINFOS,         -- Informati Number [/AIF/NUMBEROFINFOS]
    NSRECIP,               -- Namespace [/AIF/NS]
    RECIPIENT,             -- Recipient for Alert [/AIF/ALRT_REC]
    STATUS,                -- Processing Status [/AIF/PROC_STATUS]
    SUB_STATUS,            -- Sub Status [/AIF/PROC_SUB_STATUS]
    AIF_LOCATION,          -- Message Location [/AIF/MESSAGE_LOCATION]
    LOGNUMBER,             -- Log Number [BALOGNR]
    TRACE_LEVEL,           -- Trace Level [/AIF/TRACE_LEVEL]
    TL_EXP_DATE,           -- Expiration Date [/AIF/EXP_DATE]
    TL_EXP_TIME,           -- Expiration Time [/AIF/EXP_TIME]
    CREATE_USER,           -- Create User [/AIF/CREATE_USER]
    CREATE_DATE,           -- Creation Date [/AIF/CREATE_DATE]
    CREATE_TIME,           -- Creation Time [/AIF/CREATE_TIME]
    LAST_USER,             -- Last User [/AIF/LAST_USER]
    LAST_DATE,             -- Last Date [/AIF/LAST_DATE]
    LAST_TIME,             -- Last Time [/AIF/LAST_TIME]
    END_USER,              -- End User [/AIF/END_USER]
    END_DATE,              -- End Date [/AIF/END_DATE]
    END_TIME,              -- End Time [/AIF/END_TIME]
    AIF_ALERT_ID,          -- External Alert ID [SALRTEXTID]
    AIF_VARIANT_NS,        -- Namespace [/AIF/VARIANT_NS]
    AIF_VARIANT_NAME,      -- Interface Variant [/AIF/VARIANT_NAME]
    EXTERNAL_MESSAGE,      -- EXT_MESSAGE [/AIF/EXTERNAL_MESSAGE]
    TIME_ZONE,             -- Time Zone [TZNZONE]
    PROCESSING_END_TSTMP,  -- UTC Timestamp [/AIF/PROCESSING_TSTMP]
    PID,                   -- Pipeline ID [SXMSPID]
    AWTYP,                 -- Ref. procedure [AWTYP]
    AWREF,                 -- Reference Doc. [AWREF]
    AWORG,                 -- Refer. Org.Unit [AWORG]
    AWSYS,                 -- Logical System [AWSYS]
    TIMESTAMP,             -- Time Stamp [TZNTSTMPL]
    LOGSYSTEM_SENDER,      -- Sender Log Sys. [LOGSYSTEM_SENDER]
    BUKRS_SENDER,          -- Sender CoCode [BUKRS_SENDER]
    BUKRS,                 -- Company Code [BUKRS]
    TCODE,                 -- Transaction Code [TCODE]
    PRIMARY KEY (MANDT, MSGGUID)
);

Learn More