RSRTS_CDS_DOCA_LIST

DDL: RSRTS_CDS_DOCA_LIST Type: view_entity Package: RSRTS_CDS_DOCA
3 Fields 5 Data Sources

Get All CDS document Stores

RSRTS_CDS_DOCA_LIST is a CDS View that provides data about "Get All CDS document Stores" in SAP S/4HANA. It reads from 5 data sources (ddheadanno, ddheadanno, ddddlsrc, tadir, ddddlsrc02bt) and exposes 3 fields with key field cdsViewname. Part of development package RSRTS_CDS_DOCA.

Data Sources (5)

SourceAliasJoin Type
ddheadanno h1 inner
ddheadanno h2 left_outer
ddddlsrc s from
tadir t1 inner
ddddlsrc02bt t2 left_outer

Parameters (1)

NameTypeDefault
langu sylangu

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get All CDS document Stores view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY cdsViewname ddheadanno strucobjn DD: Name of a structured object (e.g. entity, context)
valueendasrsdoc_appl_idasappl_Id
txtlg

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 RSRTS_CDS_DOCA_LIST.
-- 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.
-- Parameters: langu : sylangu

CREATE VIEW RSRTS_CDS_DOCA_LIST AS
SELECT
  h1.strucobjn AS cdsViewname,
  cast ( case when h2.value is null or h2.value = '' then concat( '2C', h1.strucobjn ) else concat( '2C', replace( upper( h2.value ), '''', '') ) end as rsdoc_appl_id ) as appl_Id AS valueendasrsdoc_appl_idasappl_Id,
  cast ( coalesce( t2.ddtext, h1.strucobjn ) as rstxtlg ) AS txtlg
FROM ddddlsrc AS s
INNER JOIN tadir AS t1 ON /* join condition not captured in parsed metadata */
INNER JOIN ddheadanno AS h1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddddlsrc02bt AS t2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS h2 ON /* join condition not captured in parsed metadata */
;

Learn More