P_IJE_LOG_MESSAGE

DDL: P_IJE_LOG_MESSAGE SQL: PIJEMSG Type: view BASIC

P_IJE_LOG_MESSAGE is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (fincs_log_item01, fincs_log_messag) and exposes 10 fields with key field CnsldtnTaskLogUUID.

Data Sources (2)

SourceAliasJoin Type
fincs_log_item01 ITEM left_outer
fincs_log_messag MSG from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PIJEMSG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnTaskLogUUID fincs_log_messag cnsldtnlognumber Consolidation Log GUID
entryid fincs_log_item01 entryid Entry ID
msgty fincs_log_messag msgty Msg.Type (E,I,W..)
MessageText
msgid fincs_log_messag msgid Message ID
msgno fincs_log_messag msgno Message Number
msgv1 fincs_log_messag msgv1 Message variable 1
msgv2 fincs_log_messag msgv2 Message variable 2
msgv3 fincs_log_messag msgv3 Message variable 3
msgv4 fincs_log_messag msgv4 Message variable 4

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 P_IJE_LOG_MESSAGE.
-- 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: PIJEMSG

CREATE VIEW P_IJE_LOG_MESSAGE AS
SELECT
  MSG.cnsldtnlognumber AS CnsldtnTaskLogUUID,
  ITEM.entryid AS entryid,
  MSG.msgty AS msgty,
  ' ' AS MessageText,
  MSG.msgid AS msgid,
  MSG.msgno AS msgno,
  MSG.msgv1 AS msgv1,
  MSG.msgv2 AS msgv2,
  MSG.msgv3 AS msgv3,
  MSG.msgv4 AS msgv4
FROM fincs_log_messag AS MSG
LEFT OUTER JOIN fincs_log_item01 AS ITEM ON /* join condition not captured in parsed metadata */
;