What is I_CnsldtnPostingRuleLogItem in SAP S/4HANA?

I_CnsldtnPostingRuleLogItem is a composite CDS view in SAP S/4HANA. Consolidation Posting Rule Log Items It contains 144 fields.

Which tables does I_CnsldtnPostingRuleLogItem read from?

I_CnsldtnPostingRuleLogItem reads data from: P_CnsldtnPstRlLgGrpHierarchy.

What VDM layer is I_CnsldtnPostingRuleLogItem?

I_CnsldtnPostingRuleLogItem is classified as a Composite view that combines data from multiple basic views.

I_CnsldtnPostingRuleLogItem

DDL: I_CNSLDTNPOSTINGRULELOGITEM Type: view_entity COMPOSITE Package: FIN_CS_RT_LOG

144 Fields 1 Data Sources 31 Associations

Consolidation Posting Rule Log Items

I_CnsldtnPostingRuleLogItem is a Composite CDS View that provides data about "Consolidation Posting Rule Log Items" in SAP S/4HANA. It reads from 1 data source (P_CnsldtnPstRlLgGrpHierarchy) and exposes 144 fields with key fields CnsldtnPostingRuleLogUUID, FiscalYear, ConsolidationRunNumber, ConsolidationPostingRule, CnsldtnPostgRuleSourceLine. It has 31 associations to related views. Part of development package FIN_CS_RT_LOG.

Data Sources (1)

Source	Alias	Join Type
P_CnsldtnPstRlLgGrpHierarchy	P_CnsldtnPstRlLgGrpHierarchy	from

Associations (31)

Cardinality	Target	Alias	Condition
[0..1]	I_CnsldtnSubitemCategory_2	_SubItemCategory	`$projection.CnsldtnSubitemCategory = _SubItemCategory.CnsldtnSubitemCategory`
[0..1]	I_CnsldtnSubitem_2	_SubItem	`$projection.CnsldtnSubitemCategory = _SubItem.CnsldtnSubitemCategory and $projection.CnsldtnSubitem = _SubItem.CnsldtnSubitem`
[0..1]	I_CnsldtnDocumentType_2	_DocumentType	`$projection.ConsolidationDocumentType = _DocumentType.ConsolidationDocumentType`
[0..1]	I_CnsldtnUnit_4	_CnsldtnUnit	`$projection.ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit`
[0..1]	I_CnsldtnFinStmntItem	_FinStmntItm	`$projection.ConsolidationChartOfAccounts = _FinStmntItm.ConsolidationChartOfAccounts and $projection.FinancialStatementItem = _FinStmntItm.FinancialStatementItem`
[0..1]	I_ConsolidationPostingRule	_CnsldtnRule	`$projection.ConsolidationPostingRule = _CnsldtnRule.ConsolidationPostingRule`
[0..1]	I_CnsldtnPostingRuleGroup	_CnsldtnRuleGroup	`$projection.ConsolidationPostingRuleGroup = _CnsldtnRuleGroup.ConsolidationPostingRuleGroup`
[0..1]	I_CnsldtnUnit_4	_CnsldtnPartnerUnitText	`$projection.PartnerConsolidationUnit = _CnsldtnPartnerUnitText.ConsolidationUnit`
[0..1]	I_CnsldtnFinServicesBranch	_FinancialServicesBranchT	`$projection.FinancialServicesBranch = _FinancialServicesBranchT.FinancialServicesBranch`
[0..1]	I_CnsldtnFund	_FundText	`$projection.Fund = _FundText.Fund and $projection.FinancialManagementArea = _FundText.FinancialManagementArea`
[0..1]	I_CnsldtnFinManagementArea	_FinancialManagementAreaText	`$projection.FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea`
[0..1]	I_CnsldtnFinancialDataSource	_FinancialDataSourceT	`$projection.FinancialDataSource = _FinancialDataSourceT.FinancialDataSource`
[0..1]	I_CnsldtnGHGScope	_GHGScopeText	`$projection.GHGScope = _GHGScopeText.GHGScope`
[0..1]	I_CnsldtnGHGCategory	_GHGCategoryText	`$projection.GHGCategory = _GHGCategoryText.GHGCategory`
[0..1]	I_CnsldtnControllingArea	_ControllingArea	`$projection.ControllingArea = _ControllingArea.ControllingArea`
[0..1]	I_CnsldtnCostCenter	_CostCenter	`$projection.ControllingArea = _CostCenter.ControllingArea and $projection.CostCenter = _CostCenter.CostCenter`
[0..1]	I_CnsldtnProfitCenter	_ProfitCenter	`$projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter`
[0..1]	I_CnsldtnUnit_4	_InvesteeUnit	`$projection.InvesteeConsolidationUnit = _InvesteeUnit.ConsolidationUnit`
[0..1]	I_CnsldtnMaterial	_Material	`$projection.Material = _Material.Material`
[0..1]	I_CnsldtnFunctionalArea	_FunctionalArea	`$projection.FunctionalArea = _FunctionalArea.FunctionalArea`
[0..1]	I_CnsldtnFunctionalArea	_PartnerFunctionalArea	`$projection.PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea`
[0..1]	I_CnsldtnProfitCenter	_PartnerProfitCenter	`$projection.ControllingArea = _PartnerProfitCenter.ControllingArea and $projection.PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter`
[0..1]	I_CnsldtnCostCenter	_PartnerCostCenter	`$projection.ControllingArea = _PartnerCostCenter.ControllingArea and $projection.PartnerCostCenter = _PartnerCostCenter.CostCenter`
[0..1]	I_CnsldtnSegment	_PartnerSegment	`$projection.PartnerSegment = _PartnerSegment.Segment`
[0..1]	I_CnsldtnAdhocItem	_AdhocItem	`$projection.ConsolidationChartOfAccounts = _AdhocItem.ConsolidationChartOfAccounts and $projection.CnsldtnAdhocItem = _AdhocItem.CnsldtnAdhocItem`
[0..1]	I_CnsldtnAdhocSet	_AdhocSet	`$projection.ConsolidationChartOfAccounts = _AdhocSet.ConsolidationChartOfAccounts and $projection.CnsldtnAdhocSet = _AdhocSet.CnsldtnAdhocSet`
[0..1]	I_CnsldtnAdhocSetItem	_AdhocSetItem	`$projection.ConsolidationChartOfAccounts = _AdhocSetItem.ConsolidationChartOfAccounts and $projection.CnsldtnAdhocSet = _AdhocSetItem.CnsldtnAdhocSet and $projection.CnsldtnAdhocSetItem = _AdhocSetItem.CnsldtnAdhocSetItem`
[0..1]	I_CnsldtnSegment	_Segment	`$projection.Segment = _Segment.Segment`
[0..1]	I_CnsldtnSustModeOfTransport	_SustainabilityModeOfTransport	`$projection.SustainabilityModeOfTransport = _SustainabilityModeOfTransport.SustainabilityModeOfTransport`
[0..1]	I_CnsldtnUnit_4	_SrceCnsldtnUnit	`$projection.CnsldtnPstRlSrceCnsldtnUnt = _SrceCnsldtnUnit.ConsolidationUnit`
[0..1]	I_CnsldtnVersion	_SrceCnsldtnVers	`$projection.CnsldtnPstRlSrceCnsldtnVersion = _SrceCnsldtnVers.ConsolidationVersion`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Consolidation Posting Rule Log Items	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
VDM.viewType	#COMPOSITE	view

Fields (144)

Key	Field	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
	NodeType	NodeType	Object Type
	ConsolidationPostingRuleGroup	ConsolidationPostingRuleGroup
	CnsldtnPostingRuleSequence
	CnsldtnPostgRuleLogItemType	CnsldtnPostgRuleLogItemType
	CnsldtnTaskLogItemTypeTxt	CnsldtnTaskLogItemTypeTxt
	ConsolidationVersion	ConsolidationVersion	Version
	ConsolidationGroup	ConsolidationGroup	Cons. Group
	ConsolidationUnit	ConsolidationUnit	Consolidation Unit
	PartnerConsolidationUnit	PartnerConsolidationUnit	Partner Unit
	FinancialStatementItem	FinancialStatementItem	FS Item
	CnsldtnSubitemCategory	CnsldtnSubitemCategory
	CnsldtnSubitem	CnsldtnSubitem
	ConsolidationDocumentType	ConsolidationDocumentType	Document Type
	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
	CnsldtnAdhocSet	CnsldtnAdhocSet
	CnsldtnAdhocSetItem	CnsldtnAdhocSetItem
	ConsolidationPostgItemAutoFlag	ConsolidationPostgItemAutoFlag	Auto. ID
	BillingDocumentType	BillingDocumentType	Billing Type
	FinancialServicesBranch	FinancialServicesBranch	Branch (FS)
	GHGScope2CalculationMethod	GHGScope2CalculationMethod
	CashLedgerAccount	CashLedgerAccount	Cash Origin Account
	CnsldtnCashLedgerChartOfAccts	CnsldtnCashLedgerChartOfAccts
	PartnerFund	PartnerFund	Receiver Fund
	ControllingArea	ControllingArea	Controlling Area
	CostCenter	CostCenter	Cost Center
	CurrencyConversionsDiffType	CurrencyConversionsDiffType	CT Indicator
	Customer	Customer	Sold-to Party
	CustomerGroup	CustomerGroup	Customer Group
	FinancialDataSource	FinancialDataSource	Data Source
	FinancialManagementArea	FinancialManagementArea	FM Area
	FunctionalArea	FunctionalArea	Sendr Fctl Area
	Fund	Fund	Sender Fund
	GHGCategory	GHGCategory
	GrantID	GrantID	Sender Grant
	InvesteeConsolidationUnit	InvesteeConsolidationUnit	Investee Unit
	Material	Material	Vehicle Model
	SustainabilityModeOfTransport	SustainabilityModeOfTransport
	PartnerFunctionalArea	PartnerFunctionalArea	Rec. Fntcl Area
	PartnerProfitCenter	PartnerProfitCenter	Profit Center
	PartnerSegment	PartnerSegment	Partner Segment
	FinancialServicesProductGroup	FinancialServicesProductGroup	Product Group (FS)
	SoldMaterial	SoldMaterial	Product Sold
	ProductGroup	ProductGroup	Product Sold Group
	ProfitCenter	ProfitCenter	Profit Center
	GHGScope	GHGScope
	Segment	Segment	Segment number
	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)
	CnsldtnPostgRuleVariable1Value	CnsldtnPostgRuleVariable1Value
	CnsldtnPostingRuleVariable1	CnsldtnPostingRuleVariable1
	CnsldtnPostgRuleVariable2Value	CnsldtnPostgRuleVariable2Value
	CnsldtnPostingRuleVariable2	CnsldtnPostingRuleVariable2
	CnsldtnPostgRuleVariable3Value	CnsldtnPostgRuleVariable3Value
	CnsldtnPostingRuleVariable3	CnsldtnPostingRuleVariable3
	CnsldtnPostgRuleVariable4Value	CnsldtnPostgRuleVariable4Value
	CnsldtnPostingRuleVariable4	CnsldtnPostingRuleVariable4
	CnsldtnPostgRuleVariable5Value	CnsldtnPostgRuleVariable5Value
	CnsldtnPostingRuleVariable5	CnsldtnPostingRuleVariable5
	CnsldtnPostgRuleVariable6Value	CnsldtnPostgRuleVariable6Value
	CnsldtnPostingRuleVariable6	CnsldtnPostingRuleVariable6
	CnsldtnPostgRule1stExchRate	CnsldtnPostgRule1stExchRate
	CnsldtnPstRl1stExchRateText	CnsldtnPstRl1stExchRateText
	CnsldtnPostgRule2ndExchRate	CnsldtnPostgRule2ndExchRate
	CnsldtnPstRl2ndExchRateText	CnsldtnPstRl2ndExchRateText
	CnsldtnPostgRule3rdExchRate	CnsldtnPostgRule3rdExchRate
	CnsldtnPstRl3rdExchRateText	CnsldtnPstRl3rdExchRateText
	CnsldtnPostgRule4thExchRate	CnsldtnPostgRule4thExchRate
	CnsldtnPstRl4thExchRateText	CnsldtnPstRl4thExchRateText
	CnsldtnPostgRule5thExchRate	CnsldtnPostgRule5thExchRate
	CnsldtnPstRl5thExchRateText	CnsldtnPstRl5thExchRateText
	CnsldtnPostgRule6thExchRate	CnsldtnPostgRule6thExchRate
	CnsldtnPstRl6thExchRateText	CnsldtnPstRl6thExchRateText
	CnsldtnPstRlSrceCnsldtnVersion	CnsldtnPstRlSrceCnsldtnVersion
	CnsldtnPstRlSrceCnsldtnUnt	CnsldtnPstRlSrceCnsldtnUnt
	_SubItemCategory	_SubItemCategory
	_SubItem	_SubItem
	_DocumentType	_DocumentType
	_CnsldtnUnit	_CnsldtnUnit
	_FinStmntItm	_FinStmntItm
	_CnsldtnGrpHierarchy	_CnsldtnGrpHierarchy
	_CnsldtnRule	_CnsldtnRule
	_CnsldtnRuleGroup	_CnsldtnRuleGroup
	_CnsldtnPartnerUnitText	_CnsldtnPartnerUnitText
	_FinancialServicesBranchT	_FinancialServicesBranchT
	_FundText	_FundText
	_FinancialManagementAreaText	_FinancialManagementAreaText
	_FinancialDataSourceT	_FinancialDataSourceT
	_GHGScopeText	_GHGScopeText
	_GHGCategoryText	_GHGCategoryText
	_ControllingArea	_ControllingArea
	_CostCenter	_CostCenter
	_InvesteeUnit	_InvesteeUnit
	_Material	_Material
	_FunctionalArea	_FunctionalArea
	_PartnerFunctionalArea	_PartnerFunctionalArea
	_PartnerProfitCenter	_PartnerProfitCenter
	_PartnerCostCenter	_PartnerCostCenter
	_PartnerSegment	_PartnerSegment
	_AdhocItem	_AdhocItem
	_AdhocSet	_AdhocSet
	_AdhocSetItem	_AdhocSetItem
	_ProfitCenter	_ProfitCenter
	_Segment	_Segment
	_SustainabilityModeOfTransport	_SustainabilityModeOfTransport
	_SrceCnsldtnUnit	_SrceCnsldtnUnit
	_SrceCnsldtnVers	_SrceCnsldtnVers

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 I_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 I_CnsldtnPostingRuleLogItem AS
SELECT
  CnsldtnPostingRuleLogUUID,
  FiscalYear,
  ConsolidationRunNumber,
  ConsolidationPostingRule,
  CnsldtnPostgRuleSourceLine,
  CnsldtnPostingPackageNumber,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  ltrim( HierarchyNode,'0' ) AS HierarchyNode,
  NodeType,
  ConsolidationPostingRuleGroup,
  cast( CnsldtnPostingRuleSequence as abap.int8 ) AS CnsldtnPostingRuleSequence,
  CnsldtnPostgRuleLogItemType,
  CnsldtnTaskLogItemTypeTxt,
  ConsolidationVersion,
  ConsolidationGroup,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  FinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem,
  ConsolidationDocumentType,
  CnsldtnSrceAmtInTransCrcy,
  CnsldtnSrceAmtInLoclCrcy,
  CnsldtnSrceAmtInGrpCrcy,
  CnsldtnSrceQtyInBaseUnit,
  CnsldtnJrnlEntryAmtInTransCrcy,
  CnsldtnJrnlEntryAmtInLoclCrcy,
  CnsldtnJrnlEntryAmtInGrpCrcy,
  CnsldtnJrnlEntryQtyInBsUnt,
  BaseUnit,
  TransactionCurrency,
  GroupCurrency,
  LocalCurrency,
  GLAccount,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  ConsolidationPostgItemAutoFlag,
  BillingDocumentType,
  FinancialServicesBranch,
  GHGScope2CalculationMethod,
  CashLedgerAccount,
  CnsldtnCashLedgerChartOfAccts,
  PartnerFund,
  ControllingArea,
  CostCenter,
  CurrencyConversionsDiffType,
  Customer,
  CustomerGroup,
  FinancialDataSource,
  FinancialManagementArea,
  FunctionalArea,
  Fund,
  GHGCategory,
  GrantID,
  InvesteeConsolidationUnit,
  Material,
  SustainabilityModeOfTransport,
  PartnerFunctionalArea,
  PartnerProfitCenter,
  PartnerSegment,
  FinancialServicesProductGroup,
  SoldMaterial,
  ProductGroup,
  ProfitCenter,
  GHGScope,
  Segment,
  PartnerCostCenter,
  FinancialTransactionType,
  ConsolidationAcquisitionYear,
  Supplier,
  BillToParty,
  BusinessArea,
  ConsolidationChartOfAccounts,
  PartnerCompany,
  CustomerSupplierCountry,
  DistributionChannel,
  OrganizationDivision,
  CustomerSupplierCorporateGroup,
  CustomerSupplierIndustry,
  OrderID,
  Plant,
  SalesDistrict,
  SalesOrganization,
  ShipToParty,
  CnsldtnPostgRuleVariable1Value,
  CnsldtnPostingRuleVariable1,
  CnsldtnPostgRuleVariable2Value,
  CnsldtnPostingRuleVariable2,
  CnsldtnPostgRuleVariable3Value,
  CnsldtnPostingRuleVariable3,
  CnsldtnPostgRuleVariable4Value,
  CnsldtnPostingRuleVariable4,
  CnsldtnPostgRuleVariable5Value,
  CnsldtnPostingRuleVariable5,
  CnsldtnPostgRuleVariable6Value,
  CnsldtnPostingRuleVariable6,
  CnsldtnPostgRule1stExchRate,
  CnsldtnPstRl1stExchRateText,
  CnsldtnPostgRule2ndExchRate,
  CnsldtnPstRl2ndExchRateText,
  CnsldtnPostgRule3rdExchRate,
  CnsldtnPstRl3rdExchRateText,
  CnsldtnPostgRule4thExchRate,
  CnsldtnPstRl4thExchRateText,
  CnsldtnPostgRule5thExchRate,
  CnsldtnPstRl5thExchRateText,
  CnsldtnPostgRule6thExchRate,
  CnsldtnPstRl6thExchRateText,
  CnsldtnPstRlSrceCnsldtnVersion,
  CnsldtnPstRlSrceCnsldtnUnt
FROM P_CnsldtnPstRlLgGrpHierarchy
LEFT OUTER JOIN I_CnsldtnSubitemCategory_2 AS _SubItemCategory ON CnsldtnSubitemCategory = _SubItemCategory.CnsldtnSubitemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubitem_2 AS _SubItem ON CnsldtnSubitemCategory = _SubItem.CnsldtnSubitemCategory AND CnsldtnSubitem = _SubItem.CnsldtnSubitem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentType_2 AS _DocumentType ON ConsolidationDocumentType = _DocumentType.ConsolidationDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _CnsldtnUnit ON ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItem AS _FinStmntItm ON ConsolidationChartOfAccounts = _FinStmntItm.ConsolidationChartOfAccounts AND FinancialStatementItem = _FinStmntItm.FinancialStatementItem  -- association [0..1]
LEFT OUTER JOIN I_ConsolidationPostingRule AS _CnsldtnRule ON ConsolidationPostingRule = _CnsldtnRule.ConsolidationPostingRule  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnPostingRuleGroup AS _CnsldtnRuleGroup ON ConsolidationPostingRuleGroup = _CnsldtnRuleGroup.ConsolidationPostingRuleGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _CnsldtnPartnerUnitText ON PartnerConsolidationUnit = _CnsldtnPartnerUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinServicesBranch AS _FinancialServicesBranchT ON FinancialServicesBranch = _FinancialServicesBranchT.FinancialServicesBranch  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFund AS _FundText ON Fund = _FundText.Fund AND FinancialManagementArea = _FundText.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinManagementArea AS _FinancialManagementAreaText ON FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinancialDataSource AS _FinancialDataSourceT ON FinancialDataSource = _FinancialDataSourceT.FinancialDataSource  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScope AS _GHGScopeText ON GHGScope = _GHGScopeText.GHGScope  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGCategory AS _GHGCategoryText ON GHGCategory = _GHGCategoryText.GHGCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _InvesteeUnit ON InvesteeConsolidationUnit = _InvesteeUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMaterial AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenter AS _PartnerProfitCenter ON ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCostCenter AS _PartnerCostCenter ON ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSegment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnAdhocItem AS _AdhocItem ON ConsolidationChartOfAccounts = _AdhocItem.ConsolidationChartOfAccounts AND CnsldtnAdhocItem = _AdhocItem.CnsldtnAdhocItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnAdhocSet AS _AdhocSet ON ConsolidationChartOfAccounts = _AdhocSet.ConsolidationChartOfAccounts AND CnsldtnAdhocSet = _AdhocSet.CnsldtnAdhocSet  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnAdhocSetItem AS _AdhocSetItem ON ConsolidationChartOfAccounts = _AdhocSetItem.ConsolidationChartOfAccounts AND CnsldtnAdhocSet = _AdhocSetItem.CnsldtnAdhocSet AND CnsldtnAdhocSetItem = _AdhocSetItem.CnsldtnAdhocSetItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSegment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSustModeOfTransport AS _SustainabilityModeOfTransport ON SustainabilityModeOfTransport = _SustainabilityModeOfTransport.SustainabilityModeOfTransport  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _SrceCnsldtnUnit ON CnsldtnPstRlSrceCnsldtnUnt = _SrceCnsldtnUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnVersion AS _SrceCnsldtnVers ON CnsldtnPstRlSrceCnsldtnVersion = _SrceCnsldtnVers.ConsolidationVersion  -- association [0..1]
;

Depth:

I_CnsldtnPostingRuleLogItem view_entity

P_CnsldtnPstRlLgGrpHierarchy view_entity

C_CnsldtnPostingRuleLogItem view_entity