Test_Cds_Astcheck_29

DDL: TEST_CDS_ASTCHECK_29 SQL: testcdsac29 Type: view
3 Fields 1 Data Sources

test 1

Test_Cds_Astcheck_29 is a CDS View that provides data about "test 1" in SAP S/4HANA. It reads from 1 data source (Test_Cds_Astcheck_01) and exposes 3 fields with key fields short_id, so_id.

Data Sources (1)

SourceAliasJoin Type
Test_Cds_Astcheck_01 Test_Cds_Astcheck_01 from

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName testcdsac29 view
AbapCatalog.compiler.compareFilter true view
EndUserText.label test 1 view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY short_id
KEY so_id so_id Sales Order ID
address_guid _buyer address_guid UUID

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_Cds_Astcheck_29.
-- 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: testcdsac29

CREATE VIEW Test_Cds_Astcheck_29 AS
SELECT
  substring(so_id, 1, 5) AS short_id,
  so_id,
  _buyer.address_guid AS address_guid
FROM Test_Cds_Astcheck_01
;

Learn More