TEST_CDSRECV_1

DDL: TEST_CDSRECV_1 SQL: testcdsrvv1 Type: view Package: SDUT_DDLS
13 Fields 1 Data Sources 1 Associations

recursive view test

TEST_CDSRECV_1 is a CDS View that provides data about "recursive view test" in SAP S/4HANA. It reads from 1 data source (snwd_bpa) and exposes 13 fields. It has 1 association to related views. Part of development package SDUT_DDLS.

Data Sources (1)

SourceAliasJoin Type
snwd_bpa snwd_bpa from

Associations (1)

CardinalityTargetAliasCondition
[1] TEST_CDSRECV_3 _to3 $projection.node_key = _to3.node_key

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName testcdsrvv1 view
AbapCatalog.compiler.compareFilter true view

Fields (13)

KeyFieldSource TableSource FieldDescription
node_key node_key Tree Model: Node Key
bp_role bp_role Bus. Part. Role
phone_number phone_number Phone
fax_number fax_number Fax Number
web_address web_address URI
address_guid address_guid UUID
bp_id bp_id BusPartner
company_name company_name Company
legal_form legal_form Legal Form
created_by created_by Version Created By
created_at created_at Uploaded On
changed_by changed_by User Name
changed_at changed_at Timestamp

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 TEST_CDSRECV_1.
-- 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: testcdsrvv1

CREATE VIEW TEST_CDSRECV_1 AS
SELECT
  node_key,
  bp_role,
  phone_number,
  fax_number,
  web_address,
  address_guid,
  bp_id,
  company_name,
  legal_form,
  created_by,
  created_at,
  changed_by,
  changed_at
FROM snwd_bpa
LEFT OUTER JOIN TEST_CDSRECV_3 AS _to3 ON node_key = _to3.node_key  -- association [1]
;

Learn More