The ARS_L_API_STATE table in SAP ERP or S/4HANA stores API State History Data data. There are total 20 fields in ARS_L_API_STATE table. The API State History Data table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ARS_L_API_STATE table. It is in API Release: API State Persistence (S_ARS_DB) ABAP package and is part of the Extensibility: Release of APIs (BC-SRV-APS-EXT-REL) module.
SAP ARS_L_API_STATE Table Fields
Following is the list of fields that are available in SAP ARS_L_API_STATE table. The primary key fields of the table are OBJECT_ID (API Object ID), OBJECT_TYPE (Object Type), SUB_OBJECT_TYPE (Type of API Subobject), SUB_OBJECT_NAME (Name of API Subobject), COMPATIBILITY_CONTRACT (Release Contract), TIMESTAMP (UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| OBJECT_ID | API Object ID | ARS_OBJECT_ID | * | CHAR (36) |
| OBJECT_TYPE | Object Type | TROBJTYPE | CHAR (4) | |
| SUB_OBJECT_TYPE | Type of API Subobject | ARS_SUB_OBJECT_TYPE | CHAR (20) | |
| SUB_OBJECT_NAME | Name of API Subobject | ARS_SUB_OBJECT_NAME | CHAR (120) | |
| COMPATIBILITY_CONTRACT | Release Contract | ARS_RELEASE_CONTRACT | CHAR (2) | |
| TIMESTAMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC (21) | |
| OBJECT_NAME | Object Name in Object Directory | SOBJ_NAME | CHAR (40) | |
| RELEASE_STATE | API Release: Release State of an Object | ARS_RELEASE_STATE | CHAR (30) | |
| USE_IN_KEY_USER_APPS | Truth Value: True/False | ABAP_BOOLEAN | CHAR (1) | |
| USE_IN_SAP_CLOUD_PLATFORM | Truth Value: True/False | ABAP_BOOLEAN | CHAR (1) | |
| SOFTWARE_RELEASE_NAME | API Release: Software Release Name | ARS_SOFTWARE_RELEASE_NAME | CHAR (4) | |
| FEATURE_TOGGLE_ID | Feature Toggle ID | SFTGL_FT_ID | CHAR (40) | |
| SUCCESSOR_CLASSIFICATION | Classification of Successor | ARS_SUCCESSOR_CLASSIFICATION | CHAR (1) | |
| SUCCESSOR_OBJECT_TYPE | Object Type | TROBJTYPE | CHAR (4) | |
| SUCCESSOR_OBJECT_NAME | Object Name in Object Directory | SOBJ_NAME | CHAR (40) | |
| SUCCESSOR_SUB_OBJECT_TYPE | Type of API Subobject | ARS_SUB_OBJECT_TYPE | CHAR (20) | |
| SUCCESSOR_SUB_OBJECT_NAME | Name of API Subobject | ARS_SUB_OBJECT_NAME | CHAR (120) | |
| ORIGIN | API Release: Origin of API State Entry | ARS_API_STATE_ORIGIN | CHAR (3) | |
| CREATED_BY | User Name | SYUNAME | CHAR (12) | |
| LAST_CHANGED_BY | User Name | SYUNAME | CHAR (12) |
