ARS_W_APIV

Transparent Table System Table (transport)
21 Fields 9 CDS Views

API Release: API Version Header

ARS_W_APIV is an SAP database table in S/4HANA. API Release: API Version Header. It contains 21 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
ARS_U_APIV view_entity union API Release: API Version UNION
ARS_V_API_VERSION view from API Release: API Version with Status
ARS_V_API_VERSION_API view_entity inner API Release: API Version – API
ARS_V_API_VERSION_CURRENT view from API Release: Current API Version
ARS_V_APIV_EXTRACTION_FAILED_B view left_outer API Versions Extraction State Fail Base
ARS_V_DISTR_API_OBJ_NAME_VH view left_outer API Snapshot Distrib.: Prod. API ObjType
ARS_V_DISTR_API_OBJ_TYPE_VH view left_outer API Snapshot Distrib.: Prod. API ObjType
ARS_V_DISTR_OBJECTS_IN_SNAP_BA view_entity left_outer API Release: Objects in transp. Snapshot
ARS_V_PRODUCTIVE_API_VERSION_W view_entity from API Release: API Version with Status

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY api_id ARS_API_ID API ID
KEY major_release SAPRELEASE SAP Release
KEY minor_release ARS_MINOR_RELEASE Minor Release
KEY version AS4LOCAL Activation State
object_type TROBJTYPE Object Type
object_name SOBJ_NAME Object Name
extraction_state ARS_OBJECT_EXTRACTION_STATE Extraction State
software_component DLVUNIT Softw. Comp.
is_extension ARS_IS_EXTENSION Is Extension
core_object_type TROBJTYPE Object Type
core_object_name SOBJ_NAME Object Name
core_software_component DLVUNIT Softw. Comp.
source_system_id SYSYSID SAP System ID
package_name DEVCLASS Package
object_source_system_id SYSYSID SAP System ID
created_by SYUNAME User Name
created_on abap.dats
created_at abap.tims
last_changed_by SYUNAME User Name
last_changed_on abap.dats
last_changed_at abap.tims

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: API Version Header
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ARS_W_APIV (
    API_ID,                   -- API ID [ARS_API_ID]
    MAJOR_RELEASE,            -- SAP Release [SAPRELEASE]
    MINOR_RELEASE,            -- Minor Release [ARS_MINOR_RELEASE]
    VERSION,                  -- Activation State [AS4LOCAL]
    OBJECT_TYPE,              -- Object Type [TROBJTYPE]
    OBJECT_NAME,              -- Object Name [SOBJ_NAME]
    EXTRACTION_STATE,         -- Extraction State [ARS_OBJECT_EXTRACTION_STATE]
    SOFTWARE_COMPONENT,       -- Softw. Comp. [DLVUNIT]
    IS_EXTENSION,             -- Is Extension [ARS_IS_EXTENSION]
    CORE_OBJECT_TYPE,         -- Object Type [TROBJTYPE]
    CORE_OBJECT_NAME,         -- Object Name [SOBJ_NAME]
    CORE_SOFTWARE_COMPONENT,  -- Softw. Comp. [DLVUNIT]
    SOURCE_SYSTEM_ID,         -- SAP System ID [SYSYSID]
    PACKAGE_NAME,             -- Package [DEVCLASS]
    OBJECT_SOURCE_SYSTEM_ID,  -- SAP System ID [SYSYSID]
    CREATED_BY,               -- User Name [SYUNAME]
    CREATED_ON,               -- abap.dats
    CREATED_AT,               -- abap.tims
    LAST_CHANGED_BY,          -- User Name [SYUNAME]
    LAST_CHANGED_ON,          -- abap.dats
    LAST_CHANGED_AT,          -- abap.tims
    PRIMARY KEY (API_ID, MAJOR_RELEASE, MINOR_RELEASE, VERSION)
);

Learn More