C_CnsldtnPstRlLogMessage

DDL: C_CNSLDTNPSTRLLOGMESSAGE Type: view_entity CONSUMPTION
20 Fields 1 Data Sources

Consolidation Posting Rule Log Messages

C_CnsldtnPstRlLogMessage is a Consumption CDS View that provides data about "Consolidation Posting Rule Log Messages" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnPostingRuleLogMessage) and exposes 20 fields with key fields CnsldtnPostingRuleLogUUID, CnsldtnPstRlLogMessageUUID, HierarchyNode.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnPostingRuleLogMessage I_CnsldtnPostingRuleLogMessage projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Consolidation Posting Rule Log Messages view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.sapObjectNodeType.name CnsldtnPostingRuleLogMessage view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.query.implementedBy ABAP:CL_FINCS_RULELOG_MESSAGE_QUERY view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnPostingRuleLogUUID CnsldtnPostingRuleLogUUID
KEY CnsldtnPstRlLogMessageUUID CnsldtnPstRlLogMessageUUID Result Message UUID
KEY HierarchyNode HierarchyNode Node
NodeType NodeType Object Type
SystemMessageIdentification SystemMessageIdentification Message ID
SystemMessageType SystemMessageType Message type
SystemMessageTypeName SystemMessageTypeName
SystemMessageTypeCriticality SystemMessageTypeCriticality
SystemMessageNumber SystemMessageNumber Message Number
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
ConsolidationPostingRule ConsolidationPostingRule Tick.nr.rule
ConsolidationPostingRuleText ConsolidationPostingRuleText
ConsolidationUnit ConsolidationUnit Consolidation Unit
ConsolidationUnitTextlocalized
CnsldtnPostgRuleSourceLine CnsldtnPostgRuleSourceLine Row No.
CnsldtnPostingRuleSequence CnsldtnPostingRuleSequence
SystemMessageTypeSortOrder SystemMessageTypeSortOrder

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 C_CnsldtnPstRlLogMessage.
-- 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.

CREATE VIEW C_CnsldtnPstRlLogMessage AS
SELECT
  CnsldtnPostingRuleLogUUID,
  CnsldtnPstRlLogMessageUUID,
  HierarchyNode,
  NodeType,
  SystemMessageIdentification,
  SystemMessageType,
  SystemMessageTypeName,
  SystemMessageTypeCriticality,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  ConsolidationPostingRule,
  ConsolidationPostingRuleText,
  ConsolidationUnit,
  _CnsldtnUnit._Text.ConsolidationUnitText : localized AS ConsolidationUnitTextlocalized,
  CnsldtnPostgRuleSourceLine,
  CnsldtnPostingRuleSequence,
  SystemMessageTypeSortOrder
FROM I_CnsldtnPostingRuleLogMessage
;

Learn More