I_CnsldtnPstRlLgInvsteUntItem

DDL: I_CNSLDTNPSTRLLGINVSTEUNTITEM Type: view_entity COMPOSITE Package: FIN_CS_RT_LOG
144 Fields 1 Data Sources 31 Associations

Cnsldtn Pstg Rl Lg Invste Unt Items

I_CnsldtnPstRlLgInvsteUntItem is a Composite CDS View that provides data about "Cnsldtn Pstg Rl Lg Invste Unt Items" in SAP S/4HANA. It reads from 1 data source (P_CnsPstRlLgInvsteUntHierarchy) 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)

SourceAliasJoin Type
P_CnsPstRlLgInvsteUntHierarchy P_CnsPstRlLgInvsteUntHierarchy from

Associations (31)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cnsldtn Pstg Rl Lg Invste Unt 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)

KeyFieldSource TableSource FieldDescription
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
_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
_CnsldtnInvsteUntHierarchy _CnsldtnInvsteUntHierarchy
_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_CnsldtnPstRlLgInvsteUntItem.
-- 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_CnsldtnPstRlLgInvsteUntItem 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_CnsPstRlLgInvsteUntHierarchy
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]
;

Learn More