What is C_CnsldtnPostingRuleLogItem in SAP S/4HANA?

C_CnsldtnPostingRuleLogItem is a consumption CDS view in SAP S/4HANA. Consolidation Posting Rule Log Items It contains 109 fields.

Which tables does C_CnsldtnPostingRuleLogItem read from?

C_CnsldtnPostingRuleLogItem reads data from: I_CnsldtnPostingRuleLogItem.

What VDM layer is C_CnsldtnPostingRuleLogItem?

C_CnsldtnPostingRuleLogItem is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CnsldtnPostingRuleLogItem

DDL: C_CNSLDTNPOSTINGRULELOGITEM Type: view_entity CONSUMPTION

109 Fields 1 Data Sources

Consolidation Posting Rule Log Items

C_CnsldtnPostingRuleLogItem is a Consumption CDS View that provides data about "Consolidation Posting Rule Log Items" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnPostingRuleLogItem) and exposes 109 fields with key fields CnsldtnPostingRuleLogUUID, FiscalYear, ConsolidationRunNumber, ConsolidationPostingRule, CnsldtnPostgRuleSourceLine.

Data Sources (1)

Source	Alias	Join Type
I_CnsldtnPostingRuleLogItem	I_CnsldtnPostingRuleLogItem	projection

Annotations (11)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Consolidation Posting Rule Log Items	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.sapObjectNodeType.name	CnsldtnPostingRuleLogItem	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
OData.applySupportedForAggregation	#FULL	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view

Fields (109)

Key	Field	Source Table	Source Field	Description
KEY	CnsldtnPostingRuleLogUUID		CnsldtnPostingRuleLogUUID
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	ConsolidationRunNumber		ConsolidationRunNumber
KEY	ConsolidationPostingRule		ConsolidationPostingRule
KEY	CnsldtnPostgRuleSourceLine		CnsldtnPostgRuleSourceLine
KEY	CnsldtnPostingPackageNumber		CnsldtnPostingPackageNumber
KEY	ConsolidationDocumentNumber		ConsolidationDocumentNumber	Document Number
KEY	ConsolidationPostingItem		ConsolidationPostingItem	G/L Line Item
KEY	HierarchyNode		HierarchyNode	Node
	ConsolidationPostingRuleText	_CnsldtnRule	ConsolidationPostingRuleText
	NodeType		NodeType	Object Type
	ConsolidationPostingRuleGroup		ConsolidationPostingRuleGroup
	CnsldtnPostingRuleGroupText	_CnsldtnRuleGroup	CnsldtnPostingRuleGroupText
	CnsldtnPostingRuleSequence		CnsldtnPostingRuleSequence
	CnsldtnPostgRuleLogItemType		CnsldtnPostgRuleLogItemType
	CnsldtnTaskLogItemTypeTxt		CnsldtnTaskLogItemTypeTxt
	ConsolidationUnit		ConsolidationUnit	Consolidation Unit
	ConsolidationUnitTextlocalized
	PartnerConsolidationUnit		PartnerConsolidationUnit	Partner Unit
	FinancialStatementItem		FinancialStatementItem	FS Item
	FinancialStatementItemTextlocalized
	CnsldtnSubitemCategory		CnsldtnSubitemCategory
	CnsldtnSubitemCategoryTextlocalized
	CnsldtnSubitem		CnsldtnSubitem
	CnsldtnSubitemTextlocalized
	ConsolidationDocumentType		ConsolidationDocumentType	Document Type
	ConsolidationDocumentTypeTextlocalized
	CnsldtnSrceAmtInTransCrcy		CnsldtnSrceAmtInTransCrcy
	CnsldtnSrceAmtInLoclCrcy		CnsldtnSrceAmtInLoclCrcy
	CnsldtnSrceAmtInGrpCrcy		CnsldtnSrceAmtInGrpCrcy
	CnsldtnSrceQtyInBaseUnit		CnsldtnSrceQtyInBaseUnit
	CnsldtnJrnlEntryAmtInTransCrcy		CnsldtnJrnlEntryAmtInTransCrcy
	CnsldtnJrnlEntryAmtInLoclCrcy		CnsldtnJrnlEntryAmtInLoclCrcy
	CnsldtnJrnlEntryAmtInGrpCrcy		CnsldtnJrnlEntryAmtInGrpCrcy
	CnsldtnJrnlEntryQtyInBsUnt		CnsldtnJrnlEntryQtyInBsUnt
	BaseUnit		BaseUnit	Unit of Measure
	TransactionCurrency		TransactionCurrency	Transaction Currency
	GroupCurrency		GroupCurrency	Ledger curr.
	LocalCurrency		LocalCurrency	Local Currency
	GLAccount		GLAccount	General Ledger
	CnsldtnAdhocItem		CnsldtnAdhocItem
	CnsldtnAdhocItemTextlocalized
	CnsldtnAdhocSet		CnsldtnAdhocSet
	CnsldtnAdhocSetTextlocalized
	CnsldtnAdhocSetItem		CnsldtnAdhocSetItem
	CnsldtnAdhocSetItemText	_AdhocSetItem	CnsldtnAdhocSetItemText
	ConsolidationPostgItemAutoFlag		ConsolidationPostgItemAutoFlag	Auto. ID
	BillingDocumentType		BillingDocumentType	Billing Type
	FinancialServicesBranch		FinancialServicesBranch	Branch (FS)
	FinancialServicesBranchNamelocalized
	CashLedgerAccount		CashLedgerAccount	Cash Origin Account
	CnsldtnCashLedgerChartOfAccts		CnsldtnCashLedgerChartOfAccts
	PartnerFund		PartnerFund	Receiver Fund
	ControllingArea		ControllingArea	Controlling Area
	ControllingAreaNamelocalized
	CostCenter		CostCenter	Cost Center
	CostCenterNamelocalized
	CurrencyConversionsDiffType		CurrencyConversionsDiffType	CT Indicator
	Customer		Customer	Sold-to Party
	CustomerGroup		CustomerGroup	Customer Group
	FinancialDataSource		FinancialDataSource	Data Source
	FinancialDataSourceNamelocalized
	FinancialManagementArea		FinancialManagementArea	FM Area
	FinancialManagementAreaNamelocalized
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	FunctionalAreaNamelocalized
	Fund		Fund	Sender Fund
	FundNamelocalized
	GHGCategory		GHGCategory
	GHGCategoryNamelocalized
	GHGScope2CalculationMethod		GHGScope2CalculationMethod
	GHGScope		GHGScope
	GHGScopeNamelocalized
	GrantID		GrantID	Sender Grant
	InvesteeConsolidationUnit		InvesteeConsolidationUnit	Investee Unit
	Material		Material	Vehicle Model
	MaterialNamelocalized
	SustainabilityModeOfTransport		SustainabilityModeOfTransport
	SustModeOfTransportNamelocalized
	PartnerFunctionalArea		PartnerFunctionalArea	Rec. Fntcl Area
	PartnerProfitCenter		PartnerProfitCenter	Profit Center
	PartnerSegment		PartnerSegment	Partner Segment
	SegmentNameasPartnerSegmentNamelocalized
	FinancialServicesProductGroup		FinancialServicesProductGroup	Product Group (FS)
	SoldMaterial		SoldMaterial	Product Sold
	ProductGroup		ProductGroup	Product Sold Group
	ProfitCenter		ProfitCenter	Profit Center
	ProfitCenterNamelocalized
	Segment		Segment	Segment number
	SegmentNamelocalized
	PartnerCostCenter		PartnerCostCenter	Sender Cost Ctr
	FinancialTransactionType		FinancialTransactionType	Transact. Type
	ConsolidationAcquisitionYear		ConsolidationAcquisitionYear	Acquis. Year
	Supplier		Supplier	Supplier
	BillToParty		BillToParty	Inv. Recipient
	BusinessArea		BusinessArea	Business Area
	ConsolidationChartOfAccounts		ConsolidationChartOfAccounts	Cons. COA
	PartnerCompany		PartnerCompany	Trading Partner
	CustomerSupplierCountry		CustomerSupplierCountry	Customer or Supplier Country/Region
	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision		OrganizationDivision	Org. Division
	CustomerSupplierCorporateGroup		CustomerSupplierCorporateGroup	Group
	CustomerSupplierIndustry		CustomerSupplierIndustry	Industry
	OrderID		OrderID	Order ID
	Plant		Plant	Valuation Area
	SalesDistrict		SalesDistrict	Sales District
	SalesOrganization		SalesOrganization	Sales Organization
	ShipToParty		ShipToParty	Ship-To Party (obsolete)
	ConsolidationVersion		ConsolidationVersion	Version

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_CnsldtnPostingRuleLogItem.
-- 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_CnsldtnPostingRuleLogItem AS
SELECT
  CnsldtnPostingRuleLogUUID,
  FiscalYear,
  ConsolidationRunNumber,
  ConsolidationPostingRule,
  CnsldtnPostgRuleSourceLine,
  CnsldtnPostingPackageNumber,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  HierarchyNode,
  _CnsldtnRule.ConsolidationPostingRuleText AS ConsolidationPostingRuleText,
  NodeType,
  ConsolidationPostingRuleGroup,
  _CnsldtnRuleGroup.CnsldtnPostingRuleGroupText AS CnsldtnPostingRuleGroupText,
  CnsldtnPostingRuleSequence,
  CnsldtnPostgRuleLogItemType,
  CnsldtnTaskLogItemTypeTxt,
  ConsolidationUnit,
  _CnsldtnUnit._Text.ConsolidationUnitText : localized AS ConsolidationUnitTextlocalized,
  PartnerConsolidationUnit,
  FinancialStatementItem,
  _FinStmntItm._Text.FinancialStatementItemText : localized AS FinancialStatementItemTextlocalized,
  CnsldtnSubitemCategory,
  _SubItemCategory._Text.CnsldtnSubitemCategoryText : localized AS CnsldtnSubitemCategoryTextlocalized,
  CnsldtnSubitem,
  _SubItem._Text.CnsldtnSubitemText : localized AS CnsldtnSubitemTextlocalized,
  ConsolidationDocumentType,
  _DocumentType._Text.ConsolidationDocumentTypeText : localized AS ConsolidationDocumentTypeTextlocalized,
  CnsldtnSrceAmtInTransCrcy,
  CnsldtnSrceAmtInLoclCrcy,
  CnsldtnSrceAmtInGrpCrcy,
  CnsldtnSrceQtyInBaseUnit,
  CnsldtnJrnlEntryAmtInTransCrcy,
  CnsldtnJrnlEntryAmtInLoclCrcy,
  CnsldtnJrnlEntryAmtInGrpCrcy,
  CnsldtnJrnlEntryQtyInBsUnt,
  BaseUnit,
  TransactionCurrency,
  GroupCurrency,
  LocalCurrency,
  GLAccount,
  CnsldtnAdhocItem,
  _AdhocItem._Text.CnsldtnAdhocItemText : localized AS CnsldtnAdhocItemTextlocalized,
  CnsldtnAdhocSet,
  _AdhocSet._Text.CnsldtnAdhocSetText : localized AS CnsldtnAdhocSetTextlocalized,
  CnsldtnAdhocSetItem,
  _AdhocSetItem.CnsldtnAdhocSetItemText AS CnsldtnAdhocSetItemText,
  ConsolidationPostgItemAutoFlag,
  BillingDocumentType,
  FinancialServicesBranch,
  _FinancialServicesBranchT._Text.FinancialServicesBranchName : localized AS FinancialServicesBranchNamelocalized,
  CashLedgerAccount,
  CnsldtnCashLedgerChartOfAccts,
  PartnerFund,
  ControllingArea,
  _ControllingArea._Text.ControllingAreaName : localized AS ControllingAreaNamelocalized,
  CostCenter,
  _CostCenter._Text.CostCenterName : localized AS CostCenterNamelocalized,
  CurrencyConversionsDiffType,
  Customer,
  CustomerGroup,
  FinancialDataSource,
  _FinancialDataSourceT._Text.FinancialDataSourceName : localized AS FinancialDataSourceNamelocalized,
  FinancialManagementArea,
  _FinancialManagementAreaText._Text.FinancialManagementAreaName : localized AS FinancialManagementAreaNamelocalized,
  FunctionalArea,
  _FunctionalArea._Text.FunctionalAreaName : localized AS FunctionalAreaNamelocalized,
  Fund,
  _FundText._Text.FundName : localized AS FundNamelocalized,
  GHGCategory,
  _GHGCategoryText._Text.GHGCategoryName : localized AS GHGCategoryNamelocalized,
  GHGScope2CalculationMethod,
  GHGScope,
  _GHGScopeText._Text.GHGScopeName : localized AS GHGScopeNamelocalized,
  GrantID,
  InvesteeConsolidationUnit,
  Material,
  _Material._Text.MaterialName : localized AS MaterialNamelocalized,
  SustainabilityModeOfTransport,
  _SustainabilityModeOfTransport._Text.SustModeOfTransportName : localized AS SustModeOfTransportNamelocalized,
  PartnerFunctionalArea,
  PartnerProfitCenter,
  PartnerSegment,
  _PartnerSegment._Text.SegmentName as PartnerSegmentName : localized AS SegmentNameasPartnerSegmentNamelocalized,
  FinancialServicesProductGroup,
  SoldMaterial,
  ProductGroup,
  ProfitCenter,
  _ProfitCenter._Text.ProfitCenterName : localized AS ProfitCenterNamelocalized,
  Segment,
  _PartnerSegment._Text.SegmentName : localized AS SegmentNamelocalized,
  PartnerCostCenter,
  FinancialTransactionType,
  ConsolidationAcquisitionYear,
  Supplier,
  BillToParty,
  BusinessArea,
  ConsolidationChartOfAccounts,
  PartnerCompany,
  CustomerSupplierCountry,
  DistributionChannel,
  OrganizationDivision,
  CustomerSupplierCorporateGroup,
  CustomerSupplierIndustry,
  OrderID,
  Plant,
  SalesDistrict,
  SalesOrganization,
  ShipToParty,
  ConsolidationVersion
FROM I_CnsldtnPostingRuleLogItem
;

Depth:

C_CnsldtnPostingRuleLogItem view_entity

I_CnsldtnPostingRuleLogItem view_entity