APS_OM_FORM_TMPL_DATASERVICE

DDL: APS_OM_FORM_TMPL_DATASERVICE SQL: APS_OM_V_FT_DS Type: view

APS_OM_FORM_TMPL_DATASERVICE is a CDS View in SAP S/4HANA. It reads from 2 data sources (fpcontext, /iwbep/i_sbo_es) and exposes 2 fields. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
fpcontext Context inner
/iwbep/i_sbo_es FormMaster left_outer

Parameters (1)

NameTypeDefault
p_Language sylangu

Associations (1)

CardinalityTargetAliasCondition
[1..1] /iwbep/i_mgw_srt _description _description.language = $parameters.p_Language and _description.technical_name = $projection.technical_name and _description.version = '0001'

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName APS_OM_V_FT_DS view
ClientDependent false view

Fields (2)

KeyFieldSource TableSource FieldDescription
project_name
description _description 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 APS_OM_FORM_TMPL_DATASERVICE.
-- 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: APS_OM_V_FT_DS
-- Parameters: p_Language : sylangu

CREATE VIEW APS_OM_FORM_TMPL_DATASERVICE AS
SELECT
  replace( Service.technical_name, '_SRV', '' ) AS project_name,
  _description.description AS description
INNER JOIN fpcontext AS Context ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /iwbep/i_sbo_es AS FormMaster ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /iwbep/i_mgw_srt AS _description ON _description.language = $parameters.p_Language AND _description.technical_name = technical_name AND _description.version = '0001'  -- association [1..1]
;