APS_CCV_D_ROOT
Custom CDS View Root
APS_CCV_D_ROOT is an SAP database table in S/4HANA. Custom CDS View Root. It contains 19 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| APS_V_GKE_VIEW_LIST_RELEASED | view | left_outer | List of released CDS views) | |
| CCV_LANG_VRS_OBJ_ACTIVE_SCCV | view_entity | from | SCCV: ALV of Acitve Objects | |
| CCV_LANG_VRS_OBJ_EDIT_SCCV | view_entity | from | SCCV: ALV of Edited Objects | |
| I_CCV_ATO_ITEMS_EXPORTED | view | from | CCV - ATO Exported | |
| I_CCV_NOT_MIGRATED | view_entity | left_outer | View for not migrated Custom CDS Views | |
| I_CustomCDSViewRoot | view | from | Custom CDS View Root |
Fields (19)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | entity_name | aps_ccv_entity_name | Name | |||
| KEY | version_number | aps_ccv_version_number | Version Number | |||
| camel_case_entity_name | aps_ccv_camel_case_entity_name | Entity Name | ||||
| draft_entity_name | aps_ccv_entity_name | Name | ||||
| view_name | aps_ccv_view_name | View Name | ||||
| authorization_check | aps_ccv_authorization_check | Custom CDS View Authorization Check | ||||
| scenario | aps_ccv_scenario | Scenario | ||||
| type | aps_ccv_view_type | View Type | ||||
| entity_label | aps_ccv_entity_label | Entity Label | ||||
| representative_key_uuid | sysuuid_x | UUID | ||||
| db_hints | aps_ccv_db_hints | |||||
| filter_comparison_operator | aps_ccv_ll_ops | Operator | ||||
| filter_manual_changed_ind | boolean | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| filter | aps_ccv_filter | Filter | ||||
| generation_state | aps_ccv_generation_state | Generation state | ||||
| generation_log_handle | balloghndl | Handle | ||||
| migrated_ind | boolean | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| ddl_impl_vers | aps_ccv_ddl_impl_version | DDL version | ||||
| dcl_impl_vers | aps_ccv_dcl_impl_version | DCL implementation v |
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.
-- Custom CDS View Root
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_CCV_D_ROOT (
ENTITY_NAME, -- Name [aps_ccv_entity_name]
VERSION_NUMBER, -- Version Number [aps_ccv_version_number]
CAMEL_CASE_ENTITY_NAME, -- Entity Name [aps_ccv_camel_case_entity_name]
DRAFT_ENTITY_NAME, -- Name [aps_ccv_entity_name]
VIEW_NAME, -- View Name [aps_ccv_view_name]
AUTHORIZATION_CHECK, -- Custom CDS View Authorization Check [aps_ccv_authorization_check]
SCENARIO, -- Scenario [aps_ccv_scenario]
TYPE, -- View Type [aps_ccv_view_type]
ENTITY_LABEL, -- Entity Label [aps_ccv_entity_label]
REPRESENTATIVE_KEY_UUID, -- UUID [sysuuid_x]
DB_HINTS, -- aps_ccv_db_hints
FILTER_COMPARISON_OPERATOR, -- Operator [aps_ccv_ll_ops]
FILTER_MANUAL_CHANGED_IND, -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
FILTER, -- Filter [aps_ccv_filter]
GENERATION_STATE, -- Generation state [aps_ccv_generation_state]
GENERATION_LOG_HANDLE, -- Handle [balloghndl]
MIGRATED_IND, -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
DDL_IMPL_VERS, -- DDL version [aps_ccv_ddl_impl_version]
DCL_IMPL_VERS, -- DCL implementation v [aps_ccv_dcl_impl_version]
PRIMARY KEY (ENTITY_NAME, VERSION_NUMBER)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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