DD_DB_CACHE_CONFIG_HELPER

DDL: DD_DB_CACHE_CONFIG_HELPER SQL: DD_DB_CACHE Type: view Package: S_APS_DB_CACHE_CONF_APP
13 Fields 1 Data Sources 4 Associations

Data definition for DB Cache Config

DD_DB_CACHE_CONFIG_HELPER is a CDS View that provides data about "Data definition for DB Cache Config" in SAP S/4HANA. It reads from 1 data source (DD_DCV_CONFIG_PROVIDER) and exposes 13 fields. It has 4 associations to related views. Part of development package S_APS_DB_CACHE_CONF_APP.

Data Sources (1)

SourceAliasJoin Type
DD_DCV_CONFIG_PROVIDER config from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_User _a_user_responsible _a_user_responsible.UserID = config.responsible
[0..1] I_User _a_user_changedBy _a_user_changedBy.UserID = config.options_changed_by
[0..1] I_User _a_user_dcv_changedby _a_user_dcv_changedby.UserID = config.changed_by
[0..1] DD_DB_CACHE_APP_COMPONENT _tdevc config.package = _tdevc.pkg

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName DD_DB_CACHE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Data definition for DB Cache Config view

Fields (13)

KeyFieldSource TableSource FieldDescription
dtdc_name dtdc_name Dynamic Cache
description description Well Code Des.
package package Service Assgt
sw_component sw_component Softw. Comp.
status status Workflow Status
responsible _a_user_responsible UserDescription Full Name
created_on created_on Variant created on
changed_by _a_user_dcv_changedby UserDescription Full Name
changed_on changed_on Variant Changed on
changed_at changed_at Timestamp
in_db_exists in_db_exists
memory_size memory_size
record_count record_count Value

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view DD_DB_CACHE_CONFIG_HELPER.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: DD_DB_CACHE

CREATE VIEW DD_DB_CACHE_CONFIG_HELPER AS
SELECT
  dtdc_name,
  description,
  package,
  sw_component,
  status,
  _a_user_responsible.UserDescription AS responsible,
  created_on,
  _a_user_dcv_changedby.UserDescription AS changed_by,
  changed_on,
  changed_at,
  in_db_exists,
  memory_size,
  record_count
FROM DD_DCV_CONFIG_PROVIDER AS config
LEFT OUTER JOIN I_User AS _a_user_responsible ON _a_user_responsible.UserID = config.responsible  -- association [0..1]
LEFT OUTER JOIN I_User AS _a_user_changedBy ON _a_user_changedBy.UserID = config.options_changed_by  -- association [0..1]
LEFT OUTER JOIN I_User AS _a_user_dcv_changedby ON _a_user_dcv_changedby.UserID = config.changed_by  -- association [0..1]
LEFT OUTER JOIN DD_DB_CACHE_APP_COMPONENT AS _tdevc ON config.package = _tdevc.pkg  -- association [0..1]
;

Learn More