C_CnsldtnPostingRuleLog

DDL: C_CNSLDTNPOSTINGRULELOG Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 1 Associations

Consolidation Posting Rule Log Header

C_CnsldtnPostingRuleLog is a Consumption CDS View that provides data about "Consolidation Posting Rule Log Header" in SAP S/4HANA. It reads from 1 data source (I_ConsolidationPostingRuleLog) and exposes 17 fields with key field CnsldtnPostingRuleLogUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ConsolidationPostingRuleLog I_ConsolidationPostingRuleLog projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_CnsldtnUserContactCard _UserContactCard $projection.CreatedByUser = _UserContactCard.ContactCardID

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Consolidation Posting Rule Log Header view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name ConsolidationPostingRuleLog view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnPostingRuleLogUUID _Header CnsldtnPostingRuleLogUUID
ConsolidationGroup _Header ConsolidationGroup Cons. Group
ConsolidationGroupTextlocalized
ConsolidationTaskType _Header ConsolidationTaskType
ConsolidationTaskCategoryTextlocalized
ConsolidationVersion _Header ConsolidationVersion Version
ConsolidationVersionTextlocalized
FiscalYear _Header FiscalYear G/L Fiscal Year
FiscalPeriod _Header FiscalPeriod Tax period
CreationDateTime _Header CreationDateTime Timestamp
CreatedByUser _Header CreatedByUser User Name
FiscalYearPeriod _Header FiscalYearPeriod Period/Year
ConsolidationTask _Header ConsolidationTask Task
ConsolidationTaskTextlocalized
ConsolidationTaskRunIsTest _Header ConsolidationTaskRunIsTest Test Run
ConsolidationChartOfAccounts _Header ConsolidationChartOfAccounts Cons. COA
_UserContactCard _UserContactCard

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_CnsldtnPostingRuleLog.
-- 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_CnsldtnPostingRuleLog AS
SELECT
  _Header.CnsldtnPostingRuleLogUUID AS CnsldtnPostingRuleLogUUID,
  _Header.ConsolidationGroup AS ConsolidationGroup,
  _Header._CnsldtnGroup._Text.ConsolidationGroupText : localized AS ConsolidationGroupTextlocalized,
  _Header.ConsolidationTaskType AS ConsolidationTaskType,
  _Header._CnsldtnTaskCat._Text.ConsolidationTaskCategoryText : localized AS ConsolidationTaskCategoryTextlocalized,
  _Header.ConsolidationVersion AS ConsolidationVersion,
  _Header._CnsldtnVers._Text.ConsolidationVersionText : localized AS ConsolidationVersionTextlocalized,
  _Header.FiscalYear AS FiscalYear,
  _Header.FiscalPeriod AS FiscalPeriod,
  _Header.CreationDateTime AS CreationDateTime,
  _Header.CreatedByUser AS CreatedByUser,
  _Header.FiscalYearPeriod AS FiscalYearPeriod,
  _Header.ConsolidationTask AS ConsolidationTask,
  _Header._CnsldtnTask._Text.ConsolidationTaskText : localized AS ConsolidationTaskTextlocalized,
  _Header.ConsolidationTaskRunIsTest AS ConsolidationTaskRunIsTest,
  _Header.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts
FROM I_ConsolidationPostingRuleLog
LEFT OUTER JOIN C_CnsldtnUserContactCard AS _UserContactCard ON CreatedByUser = _UserContactCard.ContactCardID  -- association [0..1]
;

Learn More