I_InvgCsMRelationshipMemo

DDL: I_INVGCSMRELATIONSHIPMEMO SQL: IICMRELSHPMEMO Type: view BASIC
13 Fields 1 Data Sources

Basic View for Relationship Note

I_InvgCsMRelationshipMemo is a Basic CDS View that provides data about "Basic View for Relationship Note" in SAP S/4HANA. It reads from 1 data source (stxh) and exposes 13 fields with key fields InvgCsMTextObjectType, InvgCsMTextObjectID, InvgCsMTextTypeCode, InvgCsMTextLanguageCode.

Data Sources (1)

SourceAliasJoin Type
stxh _stxh from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IICMRELSHPMEMO view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic View for Relationship 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 _icmtext 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_InvgCsMRelationshipMemo.
-- 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: IICMRELSHPMEMO

CREATE VIEW I_InvgCsMRelationshipMemo 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
;

Learn More