SAP APS_CCV_D_JOIN Custom CDS View Data Source Join-Condition Table

Overview

APS_CCV_D_JOIN is a standard SAP S/4HANA table that stores Custom CDS View Data Source Join-Condition data. There are total 12 fields in the APS_CCV_D_JOIN 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_JOIN 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_JOIN to other SAP tables and standard CDS views available based on APS_CCV_D_JOIN table in S/4HANA 2020.

Techincal Settings of APS_CCV_D_JOIN

Below are technical details of the table APS_CCV_D_JOIN

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

List of APS_CCV_D_JOIN Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
ENTITY_NAMECustom CDS View: Entity NameAPS_CCV_ENTITY_NAMECHAR30
DATA_SOURCE_UUIDUUID in X form (binary)SYSUUID_XRAW16
JOIN_COND_UUIDUUID in X form (binary)SYSUUID_XRAW16
COUNTERCustom CDS View: CounterAPS_CCV_COUNTERINT25
DATA_SOURCE_FIELDCustom CDS View: Data Source FieldAPS_CCV_DATA_SOURCE_FIELDCHAR30
OPERATORCustom CDS View: Comparison OperatorAPS_CCV_COMP_OPERATORCHAR2
FIELD_VALUE_CONSTANTCustom CDS View: Field ValueAPS_CCV_FIELD_VALUESTRG
FIELD_VALUE_PATHCustom CDS View: Field ValueAPS_CCV_FIELD_VALUESTRG
FIELD_VALUE_PATH_DS_UUIDUUID in X form (binary)SYSUUID_XRAW16
FIELD_VALUE_SESSION_VARCustom CDS View: cds session variableAPS_CCV_CDS_SESSION_VARIABLECHAR4
FIELD_VALUE_PARAM_UUIDUUID in X form (binary)SYSUUID_XRAW16
VALUE_TYPECustom CDS View: Value TypeAPS_CCV_VALUE_TYPECHAR1

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_JOIN

Other References