/AIF/I_CustomText

DDL: /AIF/I_CUSTOMTEXT SQL: /AIF/ICUSTTEXT Type: view BASIC Package: /AIF/MONITORING_CDS
16 Fields 2 Data Sources

Custom Text

/AIF/I_CustomText is a Basic CDS View that provides data about "Custom Text" in SAP S/4HANA. It reads from 2 data sources (/aif/ctext_user, /aif/ctext) and exposes 16 fields with key fields ns, ifname, ifver, ctextid, authuser. Part of development package /AIF/MONITORING_CDS.

Data Sources (2)

SourceAliasJoin Type
/aif/ctext_user ctext_user left_outer
/aif/ctext custom_text from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName /AIF/ICUSTTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Custom Text view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ns /aif/ctext ns Namespace
KEY ifname /aif/ctext ifname Interface Name
KEY ifver /aif/ctext ifver Interface Version
KEY ctextid /aif/ctext ctextid Custom Text ID
KEY authuser /aif/ctext_user authuser User
msgid /aif/ctext msgid Message ID
msgno /aif/ctext msgno Message Number
create_user /aif/ctext create_user User Name
create_date /aif/ctext create_date Time Stamp
create_timeendasCreateTime
visibility /aif/ctext visibility Visibility
scope /aif/ctext scope Visibility
last_user /aif/ctext last_user User ID
last_dateendasLast_Date
last_timeendasLast_Time
logsys /aif/ctext logsys Source system

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 /AIF/I_CustomText.
-- 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: /AIF/ICUSTTEXT

CREATE VIEW /AIF/I_CustomText AS
SELECT
  custom_text.ns AS ns,
  custom_text.ifname AS ifname,
  custom_text.ifver AS ifver,
  custom_text.ctextid AS ctextid,
  ctext_user.authuser AS authuser,
  custom_text.msgid AS msgid,
  custom_text.msgno AS msgno,
  custom_text.create_user AS create_user,
  custom_text.create_date AS create_date,
  case length(custom_text.create_time) when 0 then '000000' else custom_text.create_time end as CreateTime AS create_timeendasCreateTime,
  custom_text.visibility AS visibility,
  custom_text.scope AS scope,
  custom_text.last_user AS last_user,
  case when custom_text.last_date < custom_text.create_date then custom_text.create_date else custom_text.last_date end as Last_Date AS last_dateendasLast_Date,
  case when custom_text.last_date < custom_text.create_date then custom_text.create_time else custom_text.last_time end as Last_Time AS last_timeendasLast_Time,
  custom_text.logsys AS logsys
FROM /aif/ctext AS custom_text
LEFT OUTER JOIN /aif/ctext_user AS ctext_user ON /* join condition not captured in parsed metadata */
;

Learn More