ARS_V_SNAPSHOT

CDS View
20 Fields 9 CDS Views

API Release: Snapshot with Status

ARS_V_SNAPSHOT is a CDS View in S/4HANA. API Release: Snapshot with Status. It contains 20 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
ARS_V_DISTR_SNAP_BASE view from API Snapshot Distrib.: Snapshots Base
ARS_V_DISTR_SNAP_BASE_L view_entity from API Snapshot Dist.: Snapshots Base L DB
ARS_V_DISTR_SNAP_BASE_T view from API Snapshot Distrib.: Snap Base Trg Sys
ARS_V_DISTR_SNAP_BASE_T_L view_entity from API Snap Dist.: Snap Base Trg Sys L DB
ARS_V_DISTR_VIRT_SNAP_BASE view left_outer API Snapshot Distrib.: Snapshots Base
ARS_V_DISTR_VIRT_SNAP_BASE_L view_entity left_outer API Snapshot Distrib.: Base from L DB
ARS_V_FLP_SNAPSHOT_BASE view from API Release: General Info of Snapshot
ARS_V_PRODUCTIVE_SNAPSHOT view from API Release: Productive Snapshot
ARS_V_RECENT_SNAPSHOT view from API Release: Recent Snapshot

Fields (20)

KeyField CDS FieldsUsed in Views
KEY api_context api_context 9
KEY counter counter 3
KEY major_release major_release 7
KEY minor_release minor_release 7
KEY software_component software_component 7
check_relevnce_last_changed_at check_relevnce_last_changed_at 6
check_relevnce_last_changed_by check_relevnce_last_changed_by 6
check_relevnce_last_changed_on check_relevnce_last_changed_on 6
created_at created_at 8
created_by created_by 9
created_on created_on 8
is_check_relevant is_check_relevant 7
is_outdated is_outdated 1
is_release_independent is_release_independent 2
last_changed_at last_changed_at 8
last_changed_by last_changed_by 8
last_changed_on last_changed_on 8
snapshot_name snapshot_name 3
source_system_id original_system,source_system_id 8
storage storage 7

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: Snapshot with Status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ARS_V_SNAPSHOT (
    API_CONTEXT,
    COUNTER,
    MAJOR_RELEASE,
    MINOR_RELEASE,
    SOFTWARE_COMPONENT,
    CHECK_RELEVNCE_LAST_CHANGED_AT,
    CHECK_RELEVNCE_LAST_CHANGED_BY,
    CHECK_RELEVNCE_LAST_CHANGED_ON,
    CREATED_AT,
    CREATED_BY,
    CREATED_ON,
    IS_CHECK_RELEVANT,
    IS_OUTDATED,
    IS_RELEASE_INDEPENDENT,
    LAST_CHANGED_AT,
    LAST_CHANGED_BY,
    LAST_CHANGED_ON,
    SNAPSHOT_NAME,
    SOURCE_SYSTEM_ID,
    STORAGE,
    PRIMARY KEY (API_CONTEXT, COUNTER, MAJOR_RELEASE, MINOR_RELEASE, SOFTWARE_COMPONENT)
);

Learn More