Test_Cds_Astcheck_03

DDL: TEST_CDS_ASTCHECK_03 SQL: testcdsac3 Type: view
5 Fields 1 Data Sources

test 1

Test_Cds_Astcheck_03 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 5 fields with key fields so_id, created_by.

Data Sources (1)

SourceAliasJoin Type
Test_Cds_Astcheck_01 Test_Cds_Astcheck_01 from

Annotations (3)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY so_id so_id Sales Order ID
KEY 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_Cds_Astcheck_03.
-- 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: testcdsac3

CREATE VIEW Test_Cds_Astcheck_03 AS
SELECT
  so_id,
  created_by,
  created_at,
  changed_by,
  changed_at
FROM Test_Cds_Astcheck_01
;

Learn More