I_InvgCsMRelationshipNote

DDL: I_INVGCSMRELATIONSHIPNOTE SQL: IICMRELNOTE Type: view BASIC
14 Fields 2 Data Sources

Basic View for ICM Relationship Note

I_InvgCsMRelationshipNote is a Basic CDS View that provides data about "Basic View for ICM Relationship Note" in SAP S/4HANA. It reads from 2 data sources (I_InvgCsMRelationshipMemo, I_InvgCsMNoteMaxChgdTime) and exposes 14 fields with key fields InvgCsMTextObjectType, InvgCsMTextObjectID, InvgCsMTextTypeCode, InvgCsMTextLanguageCode.

Data Sources (2)

SourceAliasJoin Type
I_InvgCsMRelationshipMemo _note from
I_InvgCsMNoteMaxChgdTime _notemaxchgdtime inner

Annotations (10)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMTextObjectType I_InvgCsMNoteMaxChgdTime InvgCsMTextObjectType Text object
KEY InvgCsMTextObjectID
KEY InvgCsMTextTypeCode I_InvgCsMNoteMaxChgdTime InvgCsMTextTypeCode Text ID Header
KEY InvgCsMTextLanguageCode I_InvgCsMNoteMaxChgdTime InvgCsMTextLanguageCode Language
InvgCsMTextTitle InvgCsMTextTitle Short Title
InvgCsMTextCreatedByUserID InvgCsMTextCreatedByUserID Created By
InvgCsMTextCreatedDate InvgCsMTextCreatedDate Date
InvgCsMTextCreatedTime InvgCsMTextCreatedTime Time
InvgCsMTextChangedByUserID InvgCsMTextChangedByUserID Changed by
InvgCsMTextChangedDate InvgCsMTextChangedDate Date
InvgCsMTextChangedTime InvgCsMTextChangedTime Time
InvgCsMTextDateTime InvgCsMTextDateTime
InvgCsMTextContent InvgCsMTextContent User Group
InvgCsMTextMaxDateTime I_InvgCsMNoteMaxChgdTime InvgCsMTextMaxDateTime

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_InvgCsMRelationshipNote.
-- 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: IICMRELNOTE

CREATE VIEW I_InvgCsMRelationshipNote AS
SELECT
  _notemaxchgdtime.InvgCsMTextObjectType AS InvgCsMTextObjectType,
  hextobin( _notemaxchgdtime.InvgCsMTextObjectID ) AS InvgCsMTextObjectID,
  _notemaxchgdtime.InvgCsMTextTypeCode AS InvgCsMTextTypeCode,
  _notemaxchgdtime.InvgCsMTextLanguageCode AS InvgCsMTextLanguageCode,
  InvgCsMTextTitle,
  InvgCsMTextCreatedByUserID,
  InvgCsMTextCreatedDate,
  InvgCsMTextCreatedTime,
  InvgCsMTextChangedByUserID,
  InvgCsMTextChangedDate,
  InvgCsMTextChangedTime,
  InvgCsMTextDateTime,
  InvgCsMTextContent,
  _notemaxchgdtime.InvgCsMTextMaxDateTime AS InvgCsMTextMaxDateTime
FROM I_InvgCsMRelationshipMemo AS _note
INNER JOIN I_InvgCsMNoteMaxChgdTime AS _notemaxchgdtime ON /* join condition not captured in parsed metadata */
;

Learn More