Which tables does Sadl_V_Cds_Db_Cache use?

Sadl_V_Cds_Db_Cache reads from 1 data source(s): sflight.

How many fields does Sadl_V_Cds_Db_Cache have?

Sadl_V_Cds_Db_Cache has 4 fields. Key fields: carrid, connid.

Sadl_V_Cds_Db_Cache

DDL: SADL_V_CDS_DB_CACHE SQL: SADL_V_DB_CACHE Type: view

Test entity for DB cache control

Sadl_V_Cds_Db_Cache is a CDS View that provides data about "Test entity for DB cache control" in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 4 fields with key fields carrid, connid.

Data Sources (1)

Source	Alias	Join Type
sflight	sflight	from

Annotations (5)

Name	Value	Level
AbapCatalog.sqlViewName	SADL_V_DB_CACHE	view
ClientDependent	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Test entity for DB cache control	view

Fields (4)

Key	Field	Source Field
KEY	carrid	carrid
KEY	connid	connid
	planetype	planetype
	price

@AbapCatalog.sqlViewName: 'SADL_V_DB_CACHE'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Test entity for DB cache control'
//@OData.publish: true

define view Sadl_V_Cds_Db_Cache as select from sflight {
  key carrid,
  key connid,
  planetype,
  @DefaultAggregation: #SUM
  sum(price) as price
  } 
  group by carrid, connid, planetype 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SFLIGHT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Depth:

Sadl_V_Cds_Db_Cache view

sflight