Fields (21)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | api_context | api_context | 1 |
| KEY | compatibility_contract | compatibility_contract,contract | 2 |
| KEY | major_release | major_release | 2 |
| KEY | minor_release | minor_release | 2 |
| KEY | object_name | object_name,tadir_obj_name | 10 |
| KEY | object_type | object_type,tadir_object | 10 |
| KEY | software_component | software_component | 2 |
| KEY | sub_object_name | object_key,sub_object_name | 7 |
| KEY | sub_object_type | object_type,sub_object_type | 7 |
| created_at | created_at | 1 | |
| created_by | created_by | 1 | |
| extraction_state | extraction_state | 1 | |
| feature_toggle_id | feature_toggle_id | 1 | |
| is_extension | is_extension | 2 | |
| last_changed_at | last_changed_at | 1 | |
| last_changed_by | last_changed_by | 1 | |
| object_id | object_id | 1 | |
| release_state | release_state,state | 2 | |
| software_release_name | software_release_name | 1 | |
| use_in_key_user_apps | use_in_key_user_apps | 1 | |
| use_in_sap_cloud_platform | use_in_sap_cloud_platform | 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 API (
API_CONTEXT,
COMPATIBILITY_CONTRACT,
MAJOR_RELEASE,
MINOR_RELEASE,
OBJECT_NAME,
OBJECT_TYPE,
SOFTWARE_COMPONENT,
SUB_OBJECT_NAME,
SUB_OBJECT_TYPE,
CREATED_AT,
CREATED_BY,
EXTRACTION_STATE,
FEATURE_TOGGLE_ID,
IS_EXTENSION,
LAST_CHANGED_AT,
LAST_CHANGED_BY,
OBJECT_ID,
RELEASE_STATE,
SOFTWARE_RELEASE_NAME,
USE_IN_KEY_USER_APPS,
USE_IN_SAP_CLOUD_PLATFORM,
PRIMARY KEY (API_CONTEXT, COMPATIBILITY_CONTRACT, MAJOR_RELEASE, MINOR_RELEASE, OBJECT_NAME, OBJECT_TYPE, SOFTWARE_COMPONENT, SUB_OBJECT_NAME, SUB_OBJECT_TYPE)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA