CUAN_SEARCH_RULEARTEFACT

DDL: CUAN_SEARCH_RULEARTEFACT SQL: CUAN_RLARTFCT Type: view Package: PROD_RECO_CDS

Prod Reco Rule Artifact Search

CUAN_SEARCH_RULEARTEFACT is a CDS View that provides data about "Prod Reco Rule Artifact Search" in SAP S/4HANA. It reads from 3 data sources (preco_d_model, preco_d_rlartfct, preco_d_task) and exposes 9 fields with key field db_key. Part of development package PROD_RECO_CDS.

Data Sources (3)

SourceAliasJoin Type
preco_d_model model inner
preco_d_rlartfct ruleartefact from
preco_d_task task inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CUAN_RLARTFCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Prod Reco Rule Artifact Search view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY db_key preco_d_rlartfct db_key UUID
root_key preco_d_rlartfct root_key UUID
parent_key preco_d_rlartfct parent_key UUID
engine_id preco_d_model engine_id Engine Id
model_id preco_d_model model_id WS ID
task_id task_id TaskID
content content Trusted Site Content
version version XML Vers.
lchg_uname lchg_uname User Name

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_SEARCH_RULEARTEFACT.
-- 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_RLARTFCT

CREATE VIEW CUAN_SEARCH_RULEARTEFACT AS
SELECT
  ruleartefact.db_key AS db_key,
  ruleartefact.root_key AS root_key,
  ruleartefact.parent_key AS parent_key,
  model.engine_id AS engine_id,
  model.model_id AS model_id,
  task_id,
  content,
  version,
  lchg_uname
FROM preco_d_rlartfct AS ruleartefact
INNER JOIN preco_d_model AS model ON /* join condition not captured in parsed metadata */
INNER JOIN preco_d_task AS task ON /* join condition not captured in parsed metadata */
;