C_CnsldtnPostingRuleLog

DDL: C_CNSLDTNPOSTINGRULELOG Type: view_entity CONSUMPTION Package: FIN_CS_RT_LOG
18 Fields 1 Data Sources 2 OData Services

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 18 fields with key field CnsldtnPostingRuleLogUUID. It is exposed through 2 OData services (ASQL_F8345, UI_FINCS_PSTRLLG_DISPLAY). Part of development package FIN_CS_RT_LOG.

Data Sources (1)

SourceAliasJoin Type
I_ConsolidationPostingRuleLog I_ConsolidationPostingRuleLog projection

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED 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

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F8345 ASQL_F8345 C2 NOT_RELEASED
UI_FINCS_PSTRLLG_DISPLAY UI_FINCS_PSTRLLG_DISPLAY V4 C1 NOT_RELEASED

Fields (18)

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
CnsldtnPstRlLgInvsteUntIsActv CnsldtnPstRlLgInvsteUntIsActv
_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,
  CnsldtnPstRlLgInvsteUntIsActv
FROM I_ConsolidationPostingRuleLog
;

Learn More