CUAN_ENGINE_DATASOURCETYPE

DDL: CUAN_ENGINE_DATASOURCETYPE SQL: CUAN_ENG_DSRCTYP Type: view Package: PROD_RECO_CDS

Engine to datasource type association

CUAN_ENGINE_DATASOURCETYPE is a CDS View that provides data about "Engine to datasource type association" in SAP S/4HANA. It reads from 3 data sources (preco_d_ds_typ, preco_d_engine, preco_d_engine_t) and exposes 6 fields with key field engine_id. Part of development package PROD_RECO_CDS.

Data Sources (3)

SourceAliasJoin Type
preco_d_ds_typ ds left_outer
preco_d_engine engine from
preco_d_engine_t engine_t left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CUAN_ENG_DSRCTYP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Engine to datasource type association view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY engine_id preco_d_engine engine_id Engine Id
is_template preco_d_engine is_template Template
result_type preco_d_engine result_type Result Type
cacheable preco_d_engine cacheable
dsrc_class dsrc_class
description preco_d_engine_t description Well Code Des.

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 CUAN_ENGINE_DATASOURCETYPE.
-- 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: CUAN_ENG_DSRCTYP

CREATE VIEW CUAN_ENGINE_DATASOURCETYPE AS
SELECT
  engine.engine_id AS engine_id,
  engine.is_template AS is_template,
  engine.result_type AS result_type,
  engine.cacheable AS cacheable,
  dsrc_class,
  engine_t.description AS description
FROM preco_d_engine AS engine
LEFT OUTER JOIN preco_d_engine_t AS engine_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN preco_d_ds_typ AS ds ON /* join condition not captured in parsed metadata */
;