KTD_CDS_TEST_1

DDL: KTD_CDS_TEST_1 SQL: KTD_S_CDS_TEST_1 Type: view
22 Fields 1 Data Sources

KTD CDS Test 1

KTD_CDS_TEST_1 is a CDS View that provides data about "KTD CDS Test 1" in SAP S/4HANA. It reads from 1 data source (tadir) and exposes 22 fields with key fields pgmid, object, obj_name.

Data Sources (1)

SourceAliasJoin Type
tadir tadir from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName KTD_S_CDS_TEST_1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label KTD CDS Test 1 view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY pgmid pgmid Program Name
KEY object object TRFM Object
KEY obj_name obj_name Object Name
korrnum korrnum Request/Task
srcsystem srcsystem Source system
author author User Name
srcdep srcdep Repair Flag
devclass devclass Package (Obsolete)
genflag genflag Generation Flag
edtflag edtflag Editable
cproject cproject Internal Use
masterlang masterlang Single-Character Flag
versid versid Version number
paknocheck paknocheck Check exception
objstablty objstablty Deployment Target
component component Softw. Comp.
crelease crelease SAP Release
delflag delflag Yes/No (X/ )
translttxt translttxt Translate
created_on created_on Variant created on
check_date check_date Ck Clr.Time
check_cfg check_cfg Check Configuration

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 KTD_CDS_TEST_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: KTD_S_CDS_TEST_1

CREATE VIEW KTD_CDS_TEST_1 AS
SELECT
  pgmid,
  object,
  obj_name,
  korrnum,
  srcsystem,
  author,
  srcdep,
  devclass,
  genflag,
  edtflag,
  cproject,
  masterlang,
  versid,
  paknocheck,
  objstablty,
  component,
  crelease,
  delflag,
  translttxt,
  created_on,
  check_date,
  check_cfg
FROM tadir
;

Learn More