CFIN_IDX_ACDOC

Transparent Table Application Table
52 Fields 1 CDS Views

Central Finance: AIF Index Table for Accounting Documents

CFIN_IDX_ACDOC is an SAP database table in S/4HANA. Central Finance: AIF Index Table for Accounting Documents. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CFinRpldTransactionDocument view_entity from BASIC CFIN Replicated Transaction Document

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY msgguid GUID_32 GUID 16
KEY counter INT4 INT4
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
bukrs_sender BUKRS_SENDER Sender CoCode
belnr_sender BELNR_SENDER Sender Doc.No.
gjahr_sender GJAHR_SENDER Sender FiscalYr
logsystem_sender LOGSYSTEM_SENDER Sender Log Sys.
transaction_type FIN_CFIN_TRANSACTION_TYPE CFIN Trans.type
bukrs BUKRS Company Code
gjahr GJAHR Fiscal Year
blart BLART Document Type
bldat BLDAT Document Date
budat BUDAT Posting Date
docamt_10 FINS_CFIN_DOCAMT_10 Amount LocCurr
currkey_10 FAGL_CURRKEY_10 CCode Currency
docamt_30 FINS_CFIN_DOCAMT_30 Amount in GCurr
currkey_30 FAGL_CURRKEY_30 Group Currency
bstat BSTAT_D Document Status
correction_state FINS_CFIN_TMP_POST_STATE Current Status
rap_last_changed_at ABP_LOCINST_LASTCHANGE_TSTMPL Changed On

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 Index Table for Accounting Documents
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_IDX_ACDOC (
    MANDT,                 -- Client [MANDT]
    MSGGUID,               -- GUID 16 [GUID_32]
    COUNTER,               -- INT4 [INT4]
    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]
    BUKRS_SENDER,          -- Sender CoCode [BUKRS_SENDER]
    BELNR_SENDER,          -- Sender Doc.No. [BELNR_SENDER]
    GJAHR_SENDER,          -- Sender FiscalYr [GJAHR_SENDER]
    LOGSYSTEM_SENDER,      -- Sender Log Sys. [LOGSYSTEM_SENDER]
    TRANSACTION_TYPE,      -- CFIN Trans.type [FIN_CFIN_TRANSACTION_TYPE]
    BUKRS,                 -- Company Code [BUKRS]
    GJAHR,                 -- Fiscal Year [GJAHR]
    BLART,                 -- Document Type [BLART]
    BLDAT,                 -- Document Date [BLDAT]
    BUDAT,                 -- Posting Date [BUDAT]
    DOCAMT_10,             -- Amount LocCurr [FINS_CFIN_DOCAMT_10]
    CURRKEY_10,            -- CCode Currency [FAGL_CURRKEY_10]
    DOCAMT_30,             -- Amount in GCurr [FINS_CFIN_DOCAMT_30]
    CURRKEY_30,            -- Group Currency [FAGL_CURRKEY_30]
    BSTAT,                 -- Document Status [BSTAT_D]
    CORRECTION_STATE,      -- Current Status [FINS_CFIN_TMP_POST_STATE]
    RAP_LAST_CHANGED_AT,   -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    PRIMARY KEY (MANDT, MSGGUID, COUNTER)
);

Learn More