ARS_L_SNAP_STA_H

Transparent Table Temporary Data
17 Fields 4 CDS Views

API Release: History of Snapshot Creation and Distribution

ARS_L_SNAP_STA_H is an SAP database table in S/4HANA. API Release: History of Snapshot Creation and Distribution. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
ARS_V_CRP_SNAP view inner API Release: Generated API Snapshots
ARS_V_FLP_SNAP_BALLOG_BASE view from API Snapshot: Ballog
ARS_V_FLP_SNAP_STATE view left_outer API Snapshot: Snapshot State
ARS_V_FLP_SNAP_STATE_HIST_BASE view from API Snapshot: Snapshot State History

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY action ARS_SNAPSHOT_ACTION API Release: Snapshot Action
KEY software_component DLVUNIT Softw. Comp.
KEY major_release SAPRELEASE SAP Release
KEY minor_release ARS_MINOR_RELEASE Minor Release
KEY counter ARS_COUNTER Counter
KEY system_id SYST_SYSID SAP System ID
KEY timestamp TIMESTAMP Time Stamp
action_status ARS_SNAPSHOT_ACTION_STATUS API Release: Status of Snapshot Action
ballog_handle BALLOGHNDL Handle
last_successful_object_type TROBJTYPE Object Type
last_successful_object_name SOBJ_NAME Object Name
number_of_processed_objects INT4 INT4
total_number_of_objects INT4 INT4
last_changed_on abap.dats
last_changed_at abap.tims
snapshot_name ARS_SNAPSHOT_NAME Snapshot Name
last_changed_by SYUNAME User Name

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.

-- API Release: History of Snapshot Creation and Distribution
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ARS_L_SNAP_STA_H (
    ACTION,                       -- API Release: Snapshot Action [ARS_SNAPSHOT_ACTION]
    SOFTWARE_COMPONENT,           -- Softw. Comp. [DLVUNIT]
    MAJOR_RELEASE,                -- SAP Release [SAPRELEASE]
    MINOR_RELEASE,                -- Minor Release [ARS_MINOR_RELEASE]
    COUNTER,                      -- Counter [ARS_COUNTER]
    SYSTEM_ID,                    -- SAP System ID [SYST_SYSID]
    TIMESTAMP,                    -- Time Stamp [TIMESTAMP]
    ACTION_STATUS,                -- API Release: Status of Snapshot Action [ARS_SNAPSHOT_ACTION_STATUS]
    BALLOG_HANDLE,                -- Handle [BALLOGHNDL]
    LAST_SUCCESSFUL_OBJECT_TYPE,  -- Object Type [TROBJTYPE]
    LAST_SUCCESSFUL_OBJECT_NAME,  -- Object Name [SOBJ_NAME]
    NUMBER_OF_PROCESSED_OBJECTS,  -- INT4 [INT4]
    TOTAL_NUMBER_OF_OBJECTS,      -- INT4 [INT4]
    LAST_CHANGED_ON,              -- abap.dats
    LAST_CHANGED_AT,              -- abap.tims
    SNAPSHOT_NAME,                -- Snapshot Name [ARS_SNAPSHOT_NAME]
    LAST_CHANGED_BY,              -- User Name [SYUNAME]
    PRIMARY KEY (ACTION, SOFTWARE_COMPONENT, MAJOR_RELEASE, MINOR_RELEASE, COUNTER, SYSTEM_ID, TIMESTAMP)
);

Learn More