CFIN_CAA_AST_IDX

Transparent Table Temporary Data

CAA: Index Table for bgRFC

CFIN_CAA_AST_IDX is an SAP database table in S/4HANA. CAA: Index Table for bgRFC. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CFinAAPurgMngdAstCrtnMessage view_entity from BASIC CFinAA Managed Asset Creation Message

Fields (52)

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
bg_comm_kind /AIF/BG_COMM_KIND Kind of Bg.Comm.
dest RFCDEST Destination
qluwcnt ARFCLUWCNT Counter
fnam RS38L_FNAM Function Module
arfcipid ARFCIPID Host ID
arfcpid ARFCPID Process ID
arfctime ARFCTIME Time stamp
arfctidcnt ARFCTIDCNT Counter
qname TRFCQNAM Queue Name
trfctype SYINPUT Internal Data Element
unit_id BGRFC_UNIT_ID Unit ID
queue_name QRFC_QUEUE_NAME Queue Name
unit_kind BGRFC_UNIT_KIND RFC Unit Type
status_within_luw /AIF/STATUS_WITHIN_LUW_E LUW status
scenario_guid SYSUUID_X16 UUID
scenario_id FINS_CFIN_CAA_ASSET_SCEN_ID Scenario ID
scenario_key FINS_CFIN_CAA_ASSET_SCEN_KEY Scenario Key

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.

-- CAA: Index Table for bgRFC
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_CAA_AST_IDX (
    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]
    BG_COMM_KIND,          -- Kind of Bg.Comm. [/AIF/BG_COMM_KIND]
    DEST,                  -- Destination [RFCDEST]
    QLUWCNT,               -- Counter [ARFCLUWCNT]
    FNAM,                  -- Function Module [RS38L_FNAM]
    ARFCIPID,              -- Host ID [ARFCIPID]
    ARFCPID,               -- Process ID [ARFCPID]
    ARFCTIME,              -- Time stamp [ARFCTIME]
    ARFCTIDCNT,            -- Counter [ARFCTIDCNT]
    QNAME,                 -- Queue Name [TRFCQNAM]
    TRFCTYPE,              -- Internal Data Element [SYINPUT]
    UNIT_ID,               -- Unit ID [BGRFC_UNIT_ID]
    QUEUE_NAME,            -- Queue Name [QRFC_QUEUE_NAME]
    UNIT_KIND,             -- RFC Unit Type [BGRFC_UNIT_KIND]
    STATUS_WITHIN_LUW,     -- LUW status [/AIF/STATUS_WITHIN_LUW_E]
    SCENARIO_GUID,         -- UUID [SYSUUID_X16]
    SCENARIO_ID,           -- Scenario ID [FINS_CFIN_CAA_ASSET_SCEN_ID]
    SCENARIO_KEY,          -- Scenario Key [FINS_CFIN_CAA_ASSET_SCEN_KEY]
    PRIMARY KEY (MANDT, MSGGUID)
);