SAP APS_CCV_D_ROOT Custom CDS View Root Table

Overview

APS_CCV_D_ROOT is a standard SAP S/4HANA table that stores Custom CDS View Root data. There are total 18 fields in the APS_CCV_D_ROOT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table APS_CCV_D_ROOT belongs to Generic CDS Key User Editor (BC-SRV-APS-GKE) module and is located in the package Custom CDS View Database (SAPS_CCV_DB).

In addition, following links provide an overview of foreign key relationships, if any, that link APS_CCV_D_ROOT to other SAP tables and standard CDS views available based on APS_CCV_D_ROOT table in S/4HANA 2020.

Techincal Settings of APS_CCV_D_ROOT

Below are technical details of the table APS_CCV_D_ROOT

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of APS_CCV_D_ROOT Fields

The following table gives you an overview of the fields available in APS_CCV_D_ROOT

FieldDescriptionData ElementCheck TableData TypeLength
ENTITY_NAMECustom CDS View: Entity NameAPS_CCV_ENTITY_NAMECHAR30
CAMEL_CASE_ENTITY_NAMECustom CDS View Entity Name (camel case)APS_CCV_CAMEL_CASE_ENTITY_NAMECHAR30
DRAFT_ENTITY_NAMECustom CDS View: Entity NameAPS_CCV_ENTITY_NAMECHAR30
VIEW_NAMECustom CDS View: Name of Custom CDS ViewAPS_CCV_VIEW_NAMECHAR16
AUTHORIZATION_CHECKCustom CDS View Authorization CheckAPS_CCV_AUTHORIZATION_CHECKCHAR1
TYPECustom CDS View: Type of Custom CDS ViewAPS_CCV_VIEW_TYPECHAR1
ENTITY_LABELCustom CDS View: Entity LabelAPS_CCV_ENTITY_LABELCHAR40
REPRESENTATIVE_KEY_UUIDUUID in X form (binary)SYSUUID_XRAW16
FILTER_COMPARISON_OPERATORCustom CDS View: Logical Link OperatorAPS_CCV_LL_OPSCHAR3
FILTER_MANUAL_CHANGED_INDBoolean Variable (X = True, - = False, Space = Unknown)BOOLEANCHAR1
FILTERCustom CDS View: FilterAPS_CCV_FILTERSTRG
GENERATION_STATECCV Generation stateAPS_CCV_GENERATION_STATECHAR2
GENERATION_LOG_HANDLEApplication Log: Log HandleBALLOGHNDLCHAR22
MIGRATED_INDBoolean Variable (X = True, - = False, Space = Unknown)BOOLEANCHAR1
CREA_DATE_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC21
CREA_UNAMEUser NameUNAMECHAR12
LCHG_DATE_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC21
LCHG_UNAMEUser NameUNAMECHAR12

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for APS_CCV_D_ROOT

Other References