I_InvgCsMNote

DDL: I_INVGCSMNOTE SQL: IINVGCSMNOTE Type: view BASIC
13 Fields 2 Data Sources

Basic View For ICM Object Note

I_InvgCsMNote is a Basic CDS View that provides data about "Basic View For ICM Object Note" in SAP S/4HANA. It reads from 2 data sources (crms4t_text_temp, stxh) and exposes 13 fields with key fields InvgCsMTextObjectType, InvgCsMTextObjectID, InvgCsMTextTypeCode, InvgCsMTextLanguageCode.

Data Sources (2)

SourceAliasJoin Type
crms4t_text_temp _icmtext left_outer
stxh _stxh from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINVGCSMNOTE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic View For ICM Object Note view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMTextObjectType tdobject Text object
KEY InvgCsMTextObjectID Text Name
KEY InvgCsMTextTypeCode tdid Text ID Header
KEY InvgCsMTextLanguageCode tdspras Language
InvgCsMTextTitle tdtitle Short Title
InvgCsMTextCreatedByUserID tdfuser Created By
InvgCsMTextCreatedDate tdfdate Date
InvgCsMTextCreatedTime tdftime Time
InvgCsMTextChangedByUserID tdluser Changed by
InvgCsMTextChangedDate tdldate Date
InvgCsMTextChangedTime tdltime Time
InvgCsMTextDateTime
InvgCsMTextContent crms4t_text_temp text User Group

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 I_InvgCsMNote.
-- 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: IINVGCSMNOTE

CREATE VIEW I_InvgCsMNote AS
SELECT
  tdobject AS InvgCsMTextObjectType,
  cast( tdname as char32 ) AS InvgCsMTextObjectID,
  tdid AS InvgCsMTextTypeCode,
  tdspras AS InvgCsMTextLanguageCode,
  tdtitle AS InvgCsMTextTitle,
  tdfuser AS InvgCsMTextCreatedByUserID,
  tdfdate AS InvgCsMTextCreatedDate,
  tdftime AS InvgCsMTextCreatedTime,
  tdluser AS InvgCsMTextChangedByUserID,
  tdldate AS InvgCsMTextChangedDate,
  tdltime AS InvgCsMTextChangedTime,
  LEFT(RIGHT(tdname,17),14) AS InvgCsMTextDateTime,
  _icmtext.text AS InvgCsMTextContent
FROM stxh AS _stxh
LEFT OUTER JOIN crms4t_text_temp AS _icmtext ON /* join condition not captured in parsed metadata */
;

Learn More