DD_DYNP_CACHE_CONFIG_DETAIL

DDL: DD_DYNP_CACHE_CONFIG_DETAIL SQL: DD_DYNP_CACHE_D Type: view
11 Fields 2 Data Sources

Dynpro-DB Cache Config details provider

DD_DYNP_CACHE_CONFIG_DETAIL is a CDS View that provides data about "Dynpro-DB Cache Config details provider" in SAP S/4HANA. It reads from 2 data sources (DD_DCV_CONFIG_PROVIDER, DD_DTSC_CONFIG_PROVIDER) and exposes 11 fields.

Data Sources (2)

SourceAliasJoin Type
DD_DCV_CONFIG_PROVIDER DD_DCV_CONFIG_PROVIDER from
DD_DTSC_CONFIG_PROVIDER DD_DTSC_CONFIG_PROVIDER union_all

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName DD_DYNP_CACHE_D view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Dynpro-DB Cache Config details provider view

Fields (11)

KeyFieldSource TableSource FieldDescription
cache_name dtdc_name Dynamic Cache
package package Service Assgt
sw_component sw_component Softw. Comp.
responsible responsible User Name
memory_size memory_size
record_count record_count Value
package package Service Assgt
sw_component sw_component Softw. Comp.
responsible responsible User Name
memory_size memory_size
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_DYNP_CACHE_CONFIG_DETAIL.
-- 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_DYNP_CACHE_D

CREATE VIEW DD_DYNP_CACHE_CONFIG_DETAIL AS
SELECT
  dtdc_name AS cache_name,
  package,
  sw_component,
  responsible,
  memory_size,
  record_count
FROM DD_DCV_CONFIG_PROVIDER
-- UNION ALL with additional select branch(es): DD_DTSC_CONFIG_PROVIDER
;

Learn More