PPS_T_BZ_WS_SIDX

Transparent Table Temporary Data
51 Fields 3 CDS Views

FR PD Integration Single AIF Index Table

PPS_T_BZ_WS_SIDX is an SAP database table in S/4HANA. FR PD Integration Single AIF Index Table. It contains 51 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PPSBusinessWorkspaceAIFIndex view_entity from BASIC Business workspace AIF index
P_PPSBizWrkspcErrAIFIndexHex view_entity from BASIC
P_PPSBusinessWorkspaceAIFIndex view_entity from BASIC

Fields (51)

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
pps_linked_object PPS_E_LINKED_OBJECT Linked Object
pps_linked_object_type PPS_E_LINKED_OBJ_TYPE Linked Object Type

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.

-- FR PD Integration Single AIF Index Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_T_BZ_WS_SIDX (
    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]
    PPS_LINKED_OBJECT,       -- Linked Object [PPS_E_LINKED_OBJECT]
    PPS_LINKED_OBJECT_TYPE,  -- Linked Object Type [PPS_E_LINKED_OBJ_TYPE]
    PRIMARY KEY (MANDT, MSGGUID)
);

Learn More