RSODP_SAPI_Extraction

DDL: RSODP_SAPI_EXTRACTION SQL: RSODP_SAPI_EXTR Type: view
4 Fields 3 Data Sources

ODP SAPI Extraction

RSODP_SAPI_Extraction is a CDS View that provides data about "ODP SAPI Extraction" in SAP S/4HANA. It reads from 3 data sources (roosattr, roosource, roosourcet) and exposes 4 fields.

Data Sources (3)

SourceAliasJoin Type
roosattr a inner
roosource o from
roosourcet t left_outer

Parameters (1)

NameTypeDefault
p_langu abap.lang

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName RSODP_SAPI_EXTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label ODP SAPI Extraction view

Fields (4)

KeyFieldSource TableSource FieldDescription
name roosource oltpsource DataSource
langu roosourcet langu Primary lang.
descr roosourcet txtlg Long Text
appl_comp roosource applnm Application comp.

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 RSODP_SAPI_Extraction.
-- 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: RSODP_SAPI_EXTR
-- Parameters: p_langu : abap.lang

CREATE VIEW RSODP_SAPI_Extraction AS
SELECT
  o.oltpsource AS name,
  t.langu AS langu,
  t.txtlg AS descr,
  o.applnm AS appl_comp
FROM roosource AS o
LEFT OUTER JOIN roosourcet AS t ON /* join condition not captured in parsed metadata */
INNER JOIN roosattr AS a ON /* join condition not captured in parsed metadata */
;

Learn More