sycm_aps_i_note_text

DDL: SYCM_APS_I_NOTE_TEXT SQL: SYCMVINOTESTEXT Type: view
2 Fields 2 Data Sources

SAP notes - text provider

sycm_aps_i_note_text is a CDS View that provides data about "SAP notes - text provider" in SAP S/4HANA. It reads from 2 data sources (Sycm_Simplification_Note_Attr, Sycm_Simplification_Note_Attr) and exposes 2 fields with key field note_number.

Data Sources (2)

SourceAliasJoin Type
Sycm_Simplification_Note_Attr Sycm_Simplification_Note_Attr from
Sycm_Simplification_Note_Attr Sycm_Simplification_Note_Attr union

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SYCMVINOTESTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label SAP notes - text provider view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY note_number
note_text

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 sycm_aps_i_note_text.
-- 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: SYCMVINOTESTEXT

CREATE VIEW sycm_aps_i_note_text AS
SELECT
  ltrim(note_number, '0') AS note_number,
  'ABAP custom code migration for SAP HANA' AS note_text
FROM Sycm_Simplification_Note_Attr
-- UNION with additional select branch(es): Sycm_Simplification_Note_Attr
;

Learn More