APS_CCV_D_ROOT_D

Transparent Table Application Table
29 Fields 4 CDS Views

I_CUSTOMCDSVIEWROOT I_CUSTOMCDSVIEWROOT

APS_CCV_D_ROOT_D is an SAP database table in S/4HANA. I_CUSTOMCDSVIEWROOT I_CUSTOMCDSVIEWROOT. It contains 29 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
APS_V_GKE_VIEW_LIST_RELEASED view left_outer List of released CDS views)
CCV_LANG_VRS_OBJ_ACTIVE_SCCV view_entity union SCCV: ALV of Acitve Objects
CCV_LANG_VRS_OBJ_EDIT_SCCV view_entity union SCCV: ALV of Edited Objects
I_CCV_NOT_MIGRATED view_entity left_outer View for not migrated Custom CDS Views

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
entity_name APS_CCV_ENTITY_NAME Name
camel_case_entity_name APS_CCV_CAMEL_CASE_ENTITY_NAME Entity Name
draft_entity_name APS_CCV_ENTITY_NAME Name
authorization_check APS_CCV_AUTHORIZATION_CHECK Custom CDS View Authorization Check
scenario APS_CCV_SCENARIO Scenario
view_name APS_CCV_VIEW_NAME View Name
type APS_CCV_VIEW_TYPE View Type
entity_label APS_CCV_ENTITY_LABEL Entity Label
representative_key_uuid SYSUUID_X UUID
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
migrated_ind BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
generation_log_handle BALLOGHNDL Handle
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
ddl_impl_vers APS_CCV_DDL_IMPL_VERSION DDL version
dcl_impl_vers APS_CCV_DCL_IMPL_VERSION DCL implementation v
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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.

-- I_CUSTOMCDSVIEWROOT I_CUSTOMCDSVIEWROOT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_CCV_D_ROOT_D (
    MANDT,                          -- Client [MANDT]
    DRAFTUUID,                      -- Key [/BOBF/UUID]
    ENTITY_NAME,                    -- Name [APS_CCV_ENTITY_NAME]
    CAMEL_CASE_ENTITY_NAME,         -- Entity Name [APS_CCV_CAMEL_CASE_ENTITY_NAME]
    DRAFT_ENTITY_NAME,              -- Name [APS_CCV_ENTITY_NAME]
    AUTHORIZATION_CHECK,            -- Custom CDS View Authorization Check [APS_CCV_AUTHORIZATION_CHECK]
    SCENARIO,                       -- Scenario [APS_CCV_SCENARIO]
    VIEW_NAME,                      -- View Name [APS_CCV_VIEW_NAME]
    TYPE,                           -- View Type [APS_CCV_VIEW_TYPE]
    ENTITY_LABEL,                   -- Entity Label [APS_CCV_ENTITY_LABEL]
    REPRESENTATIVE_KEY_UUID,        -- UUID [SYSUUID_X]
    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]
    MIGRATED_IND,                   -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    GENERATION_LOG_HANDLE,          -- Handle [BALLOGHNDL]
    CREA_DATE_TIME,                 -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,                     -- User Name [UNAME]
    LCHG_DATE_TIME,                 -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,                     -- User Name [UNAME]
    DDL_IMPL_VERS,                  -- DDL version [APS_CCV_DDL_IMPL_VERSION]
    DCL_IMPL_VERS,                  -- DCL implementation v [APS_CCV_DCL_IMPL_VERSION]
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More