SNAPSHOT

SNAPSHOT is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
KEY api_context api_context 1
KEY counter counter 2
KEY major_release major_release 3
KEY minor_release minor_release 3
KEY software_component software_component 3
KEY software_component_id software_component_id 1
created_at created_at 1
created_by created_by,usr 2
created_on created_on 1
is_release_independent is_release_independent 1
last_changed_at last_changed_at 1
last_changed_by last_changed_by 1
last_changed_on last_changed_on 1
snapshot_name snapshot_name 2
source_system_id source_system_id 1
storage storage 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNAPSHOT (
    API_CONTEXT,
    COUNTER,
    MAJOR_RELEASE,
    MINOR_RELEASE,
    SOFTWARE_COMPONENT,
    SOFTWARE_COMPONENT_ID,
    CREATED_AT,
    CREATED_BY,
    CREATED_ON,
    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, SOFTWARE_COMPONENT_ID)
);