What is I_CnsldtnGLAcctItemAttribute in SAP S/4HANA?

I_CnsldtnGLAcctItemAttribute is a composite CDS view in SAP S/4HANA. GL Account Line Item with GR attributes It contains 219 fields.

Which tables does I_CnsldtnGLAcctItemAttribute read from?

I_CnsldtnGLAcctItemAttribute reads data from: I_CnsldtnVersion, I_GLAccountLineItem, I_CnsldtnAcctgIntegLdgrMappg.

What VDM layer is I_CnsldtnGLAcctItemAttribute?

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

I_CnsldtnGLAcctItemAttribute

DDL: I_CNSLDTNGLACCTITEMATTRIBUTE Type: view_entity COMPOSITE Package: FIN_CS_ACCTG_INTEG

219 Fields 3 Data Sources 3 Associations

GL Account Line Item with GR attributes

I_CnsldtnGLAcctItemAttribute is a Composite CDS View that provides data about "GL Account Line Item with GR attributes" in SAP S/4HANA. It reads from 3 data sources (I_CnsldtnVersion, I_GLAccountLineItem, I_CnsldtnAcctgIntegLdgrMappg) and exposes 219 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 3 associations to related views. Part of development package FIN_CS_ACCTG_INTEG.

Data Sources (3)

Source	Alias	Join Type
I_CnsldtnVersion	_CnsldtnVersion	inner
I_GLAccountLineItem	_GLAccountLineItem	from
I_CnsldtnAcctgIntegLdgrMappg	_GRPLMapping	inner

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_CnsldtnFSItemByTimeVersion	_FSItemAttribute	`$projection.CnsldtnFinancialStatementItem = _FSItemAttribute.CnsldtnFinancialStatementItem and $projection.ConsolidationChartOfAccounts = _FSItemAttribute.ConsolidationChartOfAccounts and $projection.ConsolidationVersion = _FSItemAttribute.ConsolidationVersion and $projection.FiscalYearPeriod >= _FSItemAttribute.FromFiscalYearPeriod and $projection.FiscalYearPeriod <= _FSItemAttribute.ToFiscalYearPeriod`
[0..1]	I_CnsldtnUnitByTime_2	_CnsldtnUnitByTime	`$projection.ConsolidationUnit = _CnsldtnUnitByTime.ConsolidationUnit and $projection.FiscalYearPeriod >= _CnsldtnUnitByTime.FromFiscalYearPeriod and $projection.FiscalYearPeriod <= _CnsldtnUnitByTime.ToFiscalYearPeriod`
[0..1]	I_CnsldtnUnitByTimeVersion_2	_CnsldtnUnitByTimeVersion	`$projection.ConsolidationUnit = _CnsldtnUnitByTimeVersion.ConsolidationUnit and $projection.ConsolidationVersion = _CnsldtnUnitByTimeVersion.ConsolidationVersion and $projection.FiscalYearPeriod >= _CnsldtnUnitByTimeVersion.FromFiscalYearPeriod and $projection.FiscalYearPeriod <= _CnsldtnUnitByTimeVersion.ToFiscalYearPeriod`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	GL Account Line Item with GR attributes	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view

Fields (219)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	I_GLAccountLineItem	SourceLedger	Source Ledger
KEY	CompanyCode	I_GLAccountLineItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_GLAccountLineItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_GLAccountLineItem	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	I_GLAccountLineItem	LedgerGLLineItem	Journal Entry Item
KEY	Ledger	I_GLAccountLineItem	Ledger	Ledger
	FiscalPeriod	I_GLAccountLineItem	FiscalPeriod	Tax period
	FiscalYearVariant	I_GLAccountLineItem	FiscalYearVariant	FY Variant
	FiscalYearPeriod	I_GLAccountLineItem	FiscalYearPeriod	Period/Year
	Company	I_GLAccountLineItem	Company	Owner
	ConsolidationUnit	I_GLAccountLineItem	ConsolidationUnit	Consolidation Unit
	ConsolidationChartOfAccounts	I_GLAccountLineItem	ConsolidationChartOfAccounts	Cons. COA
	CnsldtnFinancialStatementItem	I_GLAccountLineItem	CnsldtnFinancialStatementItem
	CnsldtnSubitemCategory	I_GLAccountLineItem	CnsldtnSubitemCategory
	CnsldtnSubitem	I_GLAccountLineItem	CnsldtnSubitem
	PartnerConsolidationUnit	I_GLAccountLineItem	PartnerConsolidationUnit	Partner Unit
	ConsolidationVersion	I_CnsldtnVersion	ConsolidationVersion	Version
	ChartOfAccounts	I_GLAccountLineItem	ChartOfAccounts	Node Class
	GLAccount	I_GLAccountLineItem	GLAccount	General Ledger
	FinancialTransactionType	I_GLAccountLineItem	FinancialTransactionType	Transact. Type
	ControllingArea	I_GLAccountLineItem	ControllingArea	Controlling Area
	ProfitCenter	I_GLAccountLineItem	ProfitCenter	Profit Center
	Segment	I_GLAccountLineItem	Segment	Segment number
	FinancialAccountType	I_GLAccountLineItem	FinancialAccountType	Fin. Account Type
	AccountingDocumentType	I_GLAccountLineItem	AccountingDocumentType	Journal Entry Type
	SalesDocument	I_GLAccountLineItem	SalesDocument	SD Document
	ServiceDocumentType	I_GLAccountLineItem	ServiceDocumentType	Transaction Type
	ServiceDocument	I_GLAccountLineItem	ServiceDocument	Transaction ID
	ValuationArea	I_GLAccountLineItem	ValuationArea	Valuation Area
	PostingDate	I_GLAccountLineItem	PostingDate	Posting Date for GR
	AmountInBalanceTransacCrcy	I_GLAccountLineItem	AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	BalanceTransactionCurrency	I_GLAccountLineItem	BalanceTransactionCurrency	Currency
	AmountInCompanyCodeCurrency	I_GLAccountLineItem	AmountInCompanyCodeCurrency	Local Crcy Amt
	FixedAmountInCoCodeCrcy	I_GLAccountLineItem	FixedAmountInCoCodeCrcy
	CompanyCodeCurrency	I_GLAccountLineItem	CompanyCodeCurrency	Local Currency
	AmountInFreeDefinedCurrency1	I_GLAccountLineItem	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency1	I_GLAccountLineItem	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency2	I_GLAccountLineItem	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency2	I_GLAccountLineItem	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency3	I_GLAccountLineItem	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency3	I_GLAccountLineItem	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency4	I_GLAccountLineItem	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency4	I_GLAccountLineItem	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency5	I_GLAccountLineItem	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency5	I_GLAccountLineItem	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency6	I_GLAccountLineItem	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency6	I_GLAccountLineItem	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency7	I_GLAccountLineItem	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency7	I_GLAccountLineItem	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency8	I_GLAccountLineItem	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	FreeDefinedCurrency8	I_GLAccountLineItem	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFunctionalCurrency	I_GLAccountLineItem	AmountInFunctionalCurrency	Amount in Functional Currency
	FunctionalCurrency	I_GLAccountLineItem	FunctionalCurrency	Functional Currency
	AmountInGlobalCurrency	I_GLAccountLineItem	AmountInGlobalCurrency	Amount in Global Currency
	FixedAmountInGlobalCrcy	I_GLAccountLineItem	FixedAmountInGlobalCrcy
	FixedPriceVarcInGlobalCrcy	I_GLAccountLineItem	FixedPriceVarcInGlobalCrcy
	GrpValnFixedAmtInGlobCrcy	I_GLAccountLineItem	GrpValnFixedAmtInGlobCrcy
	GrpValnFixedPrcVarcInGlobCrcy	I_GLAccountLineItem	GrpValnFixedPrcVarcInGlobCrcy
	GrpValnTotPrcVarcInGlobCrcy	I_GLAccountLineItem	GrpValnTotPrcVarcInGlobCrcy
	PrftCtrValnFxdAmtInGlobCrcy	I_GLAccountLineItem	PrftCtrValnFxdAmtInGlobCrcy
	PrftCtrValnFxdPrcVarcInGlbCrcy	I_GLAccountLineItem	PrftCtrValnFxdPrcVarcInGlbCrcy
	PrftCtrValnTotPrcVarcInGlbCrcy	I_GLAccountLineItem	PrftCtrValnTotPrcVarcInGlbCrcy
	TotalPriceVarcInGlobalCrcy	I_GLAccountLineItem	TotalPriceVarcInGlobalCrcy
	GlobalCurrency	I_GLAccountLineItem	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGrantCurrency	I_GLAccountLineItem	AmountInGrantCurrency
	GrantCurrency	I_GLAccountLineItem	GrantCurrency	Grant Currency
	AmountInObjectCurrency	I_GLAccountLineItem	AmountInObjectCurrency	Amount in Obj Crcy
	ControllingObjectCurrency	I_GLAccountLineItem	ControllingObjectCurrency	CO Object Currency
	AdditionalQuantity1	I_GLAccountLineItem	AdditionalQuantity1
	AdditionalQuantity1Unit	I_GLAccountLineItem	AdditionalQuantity1Unit	Add Unit Meas 1
	AdditionalQuantity2	I_GLAccountLineItem	AdditionalQuantity2
	AdditionalQuantity2Unit	I_GLAccountLineItem	AdditionalQuantity2Unit	Add Unit Meas 2
	AdditionalQuantity3	I_GLAccountLineItem	AdditionalQuantity3
	AdditionalQuantity3Unit	I_GLAccountLineItem	AdditionalQuantity3Unit	Add Unit Meas 3
	Quantity	I_GLAccountLineItem	Quantity	Value
	FixedQuantity	I_GLAccountLineItem	FixedQuantity	Fixed Quantity
	BaseUnit	I_GLAccountLineItem	BaseUnit	Unit of Measure
	CostSourceUnit	I_GLAccountLineItem	CostSourceUnit
	ValuationQuantity	I_GLAccountLineItem	ValuationQuantity
	ValuationFixedQuantity	I_GLAccountLineItem	ValuationFixedQuantity
	AssetClass	I_GLAccountLineItem	AssetClass	Asset Class
	AssignmentReference	I_GLAccountLineItem	AssignmentReference	Assignment Reference
	BillToParty	I_GLAccountLineItem	BillToParty	Inv. Recipient
	BillableControl	I_GLAccountLineItem	BillableControl	Billable Control
	BillingDocumentType	I_GLAccountLineItem	BillingDocumentType	Billing Type
	BusinessArea	I_GLAccountLineItem	BusinessArea	Business Area
	CostAnalysisResource	I_GLAccountLineItem	CostAnalysisResource
	CostCenter	I_GLAccountLineItem	CostCenter	Cost Center
	CreditRiskClass	I_GLAccountLineItem	CreditRiskClass	Credit Risk Class
	Customer	I_GLAccountLineItem	Customer	Sold-to Party
	CustomerGroup	I_GLAccountLineItem	CustomerGroup	Customer Group
	CustomerSupplierCorporateGroup	I_GLAccountLineItem	CustomerSupplierCorporateGroup	Group
	CustomerSupplierCountry	I_GLAccountLineItem	CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierIndustry	I_GLAccountLineItem	CustomerSupplierIndustry	Industry
	DistributionChannel	I_GLAccountLineItem	DistributionChannel	RefDistCh-Cust/Mat.
	FixedAsset	I_GLAccountLineItem	FixedAsset	Sub-number
	FunctionalArea	I_GLAccountLineItem	FunctionalArea	Sendr Fctl Area
	GLAccountType	I_GLAccountLineItem	GLAccountType	G/L Account Type
	GLRecordType	I_GLAccountLineItem	GLRecordType	Record Type
	GeneralLedgerAgingIncrement	I_GLAccountLineItem	GeneralLedgerAgingIncrement	Increment
	GeneralLedgerAgingScope	I_GLAccountLineItem	GeneralLedgerAgingScope	Aging
	GroupMasterFixedAsset	I_GLAccountLineItem	GroupMasterFixedAsset
	JointVenture	I_GLAccountLineItem	JointVenture	Joint venture
	JointVentureEquityGroup	I_GLAccountLineItem	JointVentureEquityGroup	Joint Venture Equity Group
	LedgerFiscalYear	I_GLAccountLineItem	LedgerFiscalYear
	MasterFixedAsset	I_GLAccountLineItem	MasterFixedAsset	Fixed Asset
	OrderID	I_GLAccountLineItem	OrderID	Order ID
	OrderOperation	I_GLAccountLineItem	OrderOperation	Operation or Phase
	OrganizationDivision	I_GLAccountLineItem	OrganizationDivision	Org. Division
	PartnerBusinessArea	I_GLAccountLineItem	PartnerBusinessArea	Trdg Part.BA
	PartnerCompany	I_GLAccountLineItem	PartnerCompany	Trading Partner
	PartnerCostCenter	I_GLAccountLineItem	PartnerCostCenter	Sender Cost Ctr
	PartnerFixedAsset	I_GLAccountLineItem	PartnerFixedAsset	Partner Sub-No.
	PartnerFunctionalArea	I_GLAccountLineItem	PartnerFunctionalArea	Rec. Fntcl Area
	PartnerMasterFixedAsset	I_GLAccountLineItem	PartnerMasterFixedAsset	Partner Asset
	PartnerProfitCenter	I_GLAccountLineItem	PartnerProfitCenter	Profit Center
	PartnerSegment	I_GLAccountLineItem	PartnerSegment	Partner Segment
	Plant	I_GLAccountLineItem	Plant	Valuation Area
	Product	I_GLAccountLineItem	Product	Product Sold
	ProductGroup	I_GLAccountLineItem	ProductGroup	Product Sold Group
	Project
	SalesDistrict	I_GLAccountLineItem	SalesDistrict	Sales District
	SalesOrganization	I_GLAccountLineItem	SalesOrganization	Sales Organization
	SenderGLAccount	I_GLAccountLineItem	SenderGLAccount
	ShipToParty	I_GLAccountLineItem	ShipToParty	Ship-To Party (obsolete)
	SoldProduct	I_GLAccountLineItem	SoldProduct	Product Sold
	SoldProductGroup	I_GLAccountLineItem	SoldProductGroup	Product Sold Group
	Supplier	I_GLAccountLineItem	Supplier	Supplier
	TransactionSubitem	I_GLAccountLineItem	TransactionSubitem	Sub Transaction
	ValueDate	I_GLAccountLineItem	ValueDate	Value Date
	WBSElement
	WBSElementInternalID	I_GLAccountLineItem	WBSElementInternalID	WBS Internal ID
	_SourceLedger	I_GLAccountLineItem	_SourceLedger
	_CompanyCode	I_GLAccountLineItem	_CompanyCode
	_FiscalYear	I_GLAccountLineItem	_FiscalYear
	_JournalEntry	I_GLAccountLineItem	_JournalEntry
	_Ledger	I_GLAccountLineItem	_Ledger
	_FiscalPeriod	I_GLAccountLineItem	_FiscalPeriod
	_FiscalYearVariant	I_GLAccountLineItem	_FiscalYearVariant
	_Company	I_GLAccountLineItem	_Company
	_ConsolidationUnit	I_GLAccountLineItem	_ConsolidationUnit
	_ConsolidationChartOfAccounts	I_GLAccountLineItem	_ConsolidationChartOfAccounts
	_CnsldtnFinancialStatementItem	I_GLAccountLineItem	_CnsldtnFinancialStatementItem
	_CnsldtnSubitemCategory	I_GLAccountLineItem	_CnsldtnSubitemCategory
	_CnsldtnSubitem	I_GLAccountLineItem	_CnsldtnSubitem
	_PartnerConsolidationUnit	I_GLAccountLineItem	_PartnerConsolidationUnit
	_ChartOfAccounts	I_GLAccountLineItem	_ChartOfAccounts
	_GLAccountInChartOfAccounts	I_GLAccountLineItem	_GLAccountInChartOfAccounts
	_FinancialTransactionType	I_GLAccountLineItem	_FinancialTransactionType
	_ControllingArea	I_GLAccountLineItem	_ControllingArea
	_ProfitCenter	I_GLAccountLineItem	_ProfitCenter
	_Segment	I_GLAccountLineItem	_Segment
	_BalanceTransactionCurrency	I_GLAccountLineItem	_BalanceTransactionCurrency
	_CompanyCodeCurrency	I_GLAccountLineItem	_CompanyCodeCurrency
	_FreeDefinedCurrency1	I_GLAccountLineItem	_FreeDefinedCurrency1
	_FreeDefinedCurrency2	I_GLAccountLineItem	_FreeDefinedCurrency2
	_FreeDefinedCurrency3	I_GLAccountLineItem	_FreeDefinedCurrency3
	_FreeDefinedCurrency4	I_GLAccountLineItem	_FreeDefinedCurrency4
	_FreeDefinedCurrency5	I_GLAccountLineItem	_FreeDefinedCurrency5
	_FreeDefinedCurrency6	I_GLAccountLineItem	_FreeDefinedCurrency6
	_FreeDefinedCurrency7	I_GLAccountLineItem	_FreeDefinedCurrency7
	_FreeDefinedCurrency8	I_GLAccountLineItem	_FreeDefinedCurrency8
	_FunctionalCurrency	I_GLAccountLineItem	_FunctionalCurrency
	_GlobalCurrency	I_GLAccountLineItem	_GlobalCurrency
	_AdditionalQuantity1Unit	I_GLAccountLineItem	_AdditionalQuantity1Unit
	_AdditionalQuantity2Unit	I_GLAccountLineItem	_AdditionalQuantity2Unit
	_AdditionalQuantity3Unit	I_GLAccountLineItem	_AdditionalQuantity3Unit
	_BaseUnit	I_GLAccountLineItem	_BaseUnit
	_BillToParty	I_GLAccountLineItem	_BillToParty
	_BillableControl	I_GLAccountLineItem	_BillableControl
	_BillingDocumentType	I_GLAccountLineItem	_BillingDocumentType
	_BusinessArea	I_GLAccountLineItem	_BusinessArea
	_CostAnalysisResource	I_GLAccountLineItem	_CostAnalysisResource
	_CostCenter	I_GLAccountLineItem	_CostCenter
	_CreditRiskClass	I_GLAccountLineItem	_CreditRiskClass
	_Customer	I_GLAccountLineItem	_Customer
	_CustomerGroup	I_GLAccountLineItem	_CustomerGroup
	_CustomerSupplierCountry	I_GLAccountLineItem	_CustomerSupplierCountry
	_CustomerSupplierIndustry	I_GLAccountLineItem	_CustomerSupplierIndustry
	_DistributionChannel	I_GLAccountLineItem	_DistributionChannel
	_FixedAsset	I_GLAccountLineItem	_FixedAsset
	_FunctionalArea	I_GLAccountLineItem	_FunctionalArea
	_GLAccountType	I_GLAccountLineItem	_GLAccountType
	_GroupMasterFixedAsset	I_GLAccountLineItem	_GroupMasterFixedAsset
	_LedgerFiscalYear	I_GLAccountLineItem	_LedgerFiscalYear
	_MasterFixedAsset	I_GLAccountLineItem	_MasterFixedAsset
	_Order	I_GLAccountLineItem	_Order
	_Division	I_GLAccountLineItem	_Division
	_PartnerBusinessArea	I_GLAccountLineItem	_PartnerBusinessArea
	_PartnerCompany	I_GLAccountLineItem	_PartnerCompany
	_PartnerCostCenter	I_GLAccountLineItem	_PartnerCostCenter
	_PartnerFixedAsset	I_GLAccountLineItem	_PartnerFixedAsset
	_PartnerFunctionalArea	I_GLAccountLineItem	_PartnerFunctionalArea
	_PartnerMasterFixedAsset	I_GLAccountLineItem	_PartnerMasterFixedAsset
	_PartnerProfitCenter	I_GLAccountLineItem	_PartnerProfitCenter
	_PartnerSegment	I_GLAccountLineItem	_PartnerSegment
	_Plant	I_GLAccountLineItem	_Plant
	_Product	I_GLAccountLineItem	_Product
	_ProductGroup	I_GLAccountLineItem	_ProductGroup
	_Project	I_GLAccountLineItem	_Project
	_SalesDistrict	I_GLAccountLineItem	_SalesDistrict
	_SalesOrganization	I_GLAccountLineItem	_SalesOrganization
	_ShipToParty	I_GLAccountLineItem	_ShipToParty
	_SoldProduct	I_GLAccountLineItem	_SoldProduct
	_SoldProductGroup	I_GLAccountLineItem	_SoldProductGroup
	_Supplier	I_GLAccountLineItem	_Supplier
	_WBSElement	I_GLAccountLineItem	_WBSElement
	_WBSElementInternalID	I_GLAccountLineItem	_WBSElementInternalID
	_AccountingDocumentType	I_GLAccountLineItem	_AccountingDocumentType
	_FinancialAccountType	I_GLAccountLineItem	_FinancialAccountType
	_CurrentCostCenter	I_GLAccountLineItem	_CurrentCostCenter
	_CurrentProfitCenter	I_GLAccountLineItem	_CurrentProfitCenter
	_SalesDocument	I_GLAccountLineItem	_SalesDocument
	_ServiceDocumentType	I_GLAccountLineItem	_ServiceDocumentType
	_ServiceDocument	I_GLAccountLineItem	_ServiceDocument
	_GLAccountInCompanyCode	I_GLAccountLineItem	_GLAccountInCompanyCode
	_FSItemAttribute		_FSItemAttribute
	_CnsldtnUnitByTime		_CnsldtnUnitByTime
	_CnsldtnUnitByTimeVersion		_CnsldtnUnitByTimeVersion

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_CnsldtnGLAcctItemAttribute.
-- 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_CnsldtnGLAcctItemAttribute AS
SELECT
  _GLAccountLineItem.SourceLedger AS SourceLedger,
  _GLAccountLineItem.CompanyCode AS CompanyCode,
  _GLAccountLineItem.FiscalYear AS FiscalYear,
  _GLAccountLineItem.AccountingDocument AS AccountingDocument,
  _GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  _GLAccountLineItem.Ledger AS Ledger,
  _GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  _GLAccountLineItem.FiscalYearVariant AS FiscalYearVariant,
  _GLAccountLineItem.FiscalYearPeriod AS FiscalYearPeriod,
  _GLAccountLineItem.Company AS Company,
  _GLAccountLineItem.ConsolidationUnit AS ConsolidationUnit,
  _GLAccountLineItem.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _GLAccountLineItem.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  _GLAccountLineItem.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  _GLAccountLineItem.CnsldtnSubitem AS CnsldtnSubitem,
  _GLAccountLineItem.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  _CnsldtnVersion.ConsolidationVersion AS ConsolidationVersion,
  _GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  _GLAccountLineItem.GLAccount AS GLAccount,
  _GLAccountLineItem.FinancialTransactionType AS FinancialTransactionType,
  _GLAccountLineItem.ControllingArea AS ControllingArea,
  _GLAccountLineItem.ProfitCenter AS ProfitCenter,
  _GLAccountLineItem.Segment AS Segment,
  _GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  _GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  _GLAccountLineItem.SalesDocument AS SalesDocument,
  _GLAccountLineItem.ServiceDocumentType AS ServiceDocumentType,
  _GLAccountLineItem.ServiceDocument AS ServiceDocument,
  _GLAccountLineItem.ValuationArea AS ValuationArea,
  _GLAccountLineItem.PostingDate AS PostingDate,
  _GLAccountLineItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  _GLAccountLineItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  _GLAccountLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _GLAccountLineItem.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  _GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _GLAccountLineItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _GLAccountLineItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _GLAccountLineItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _GLAccountLineItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _GLAccountLineItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _GLAccountLineItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _GLAccountLineItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _GLAccountLineItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _GLAccountLineItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _GLAccountLineItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _GLAccountLineItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _GLAccountLineItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _GLAccountLineItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _GLAccountLineItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _GLAccountLineItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  _GLAccountLineItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _GLAccountLineItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _GLAccountLineItem.FunctionalCurrency AS FunctionalCurrency,
  _GLAccountLineItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _GLAccountLineItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  _GLAccountLineItem.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  _GLAccountLineItem.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
  _GLAccountLineItem.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
  _GLAccountLineItem.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
  _GLAccountLineItem.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
  _GLAccountLineItem.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  _GLAccountLineItem.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
  _GLAccountLineItem.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  _GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  _GLAccountLineItem.AmountInGrantCurrency AS AmountInGrantCurrency,
  _GLAccountLineItem.GrantCurrency AS GrantCurrency,
  _GLAccountLineItem.AmountInObjectCurrency AS AmountInObjectCurrency,
  _GLAccountLineItem.ControllingObjectCurrency AS ControllingObjectCurrency,
  _GLAccountLineItem.AdditionalQuantity1 AS AdditionalQuantity1,
  _GLAccountLineItem.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  _GLAccountLineItem.AdditionalQuantity2 AS AdditionalQuantity2,
  _GLAccountLineItem.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  _GLAccountLineItem.AdditionalQuantity3 AS AdditionalQuantity3,
  _GLAccountLineItem.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  _GLAccountLineItem.Quantity AS Quantity,
  _GLAccountLineItem.FixedQuantity AS FixedQuantity,
  _GLAccountLineItem.BaseUnit AS BaseUnit,
  _GLAccountLineItem.CostSourceUnit AS CostSourceUnit,
  _GLAccountLineItem.ValuationQuantity AS ValuationQuantity,
  _GLAccountLineItem.ValuationFixedQuantity AS ValuationFixedQuantity,
  _GLAccountLineItem.AssetClass AS AssetClass,
  _GLAccountLineItem.AssignmentReference AS AssignmentReference,
  _GLAccountLineItem.BillToParty AS BillToParty,
  _GLAccountLineItem.BillableControl AS BillableControl,
  _GLAccountLineItem.BillingDocumentType AS BillingDocumentType,
  _GLAccountLineItem.BusinessArea AS BusinessArea,
  _GLAccountLineItem.CostAnalysisResource AS CostAnalysisResource,
  _GLAccountLineItem.CostCenter AS CostCenter,
  _GLAccountLineItem.CreditRiskClass AS CreditRiskClass,
  _GLAccountLineItem.Customer AS Customer,
  _GLAccountLineItem.CustomerGroup AS CustomerGroup,
  _GLAccountLineItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  _GLAccountLineItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  _GLAccountLineItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  _GLAccountLineItem.DistributionChannel AS DistributionChannel,
  _GLAccountLineItem.FixedAsset AS FixedAsset,
  _GLAccountLineItem.FunctionalArea AS FunctionalArea,
  _GLAccountLineItem.GLAccountType AS GLAccountType,
  _GLAccountLineItem.GLRecordType AS GLRecordType,
  _GLAccountLineItem.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  _GLAccountLineItem.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  _GLAccountLineItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  _GLAccountLineItem.JointVenture AS JointVenture,
  _GLAccountLineItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  _GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  _GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  _GLAccountLineItem.OrderID AS OrderID,
  _GLAccountLineItem.OrderOperation AS OrderOperation,
  _GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  _GLAccountLineItem.PartnerBusinessArea AS PartnerBusinessArea,
  _GLAccountLineItem.PartnerCompany AS PartnerCompany,
  _GLAccountLineItem.PartnerCostCenter AS PartnerCostCenter,
  _GLAccountLineItem.PartnerFixedAsset AS PartnerFixedAsset,
  _GLAccountLineItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  _GLAccountLineItem.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  _GLAccountLineItem.PartnerProfitCenter AS PartnerProfitCenter,
  _GLAccountLineItem.PartnerSegment AS PartnerSegment,
  _GLAccountLineItem.Plant AS Plant,
  _GLAccountLineItem.Product AS Product,
  _GLAccountLineItem.ProductGroup AS ProductGroup,
  cast(_GLAccountLineItem.Project as ps_posid_edit preserving type) AS Project,
  _GLAccountLineItem.SalesDistrict AS SalesDistrict,
  _GLAccountLineItem.SalesOrganization AS SalesOrganization,
  _GLAccountLineItem.SenderGLAccount AS SenderGLAccount,
  _GLAccountLineItem.ShipToParty AS ShipToParty,
  _GLAccountLineItem.SoldProduct AS SoldProduct,
  _GLAccountLineItem.SoldProductGroup AS SoldProductGroup,
  _GLAccountLineItem.Supplier AS Supplier,
  _GLAccountLineItem.TransactionSubitem AS TransactionSubitem,
  _GLAccountLineItem.ValueDate AS ValueDate,
  cast(_GLAccountLineItem.WBSElement as ps_posid_edit preserving type) AS WBSElement,
  _GLAccountLineItem.WBSElementInternalID AS WBSElementInternalID,
  _GLAccountLineItem._SourceLedger AS _SourceLedger,
  _GLAccountLineItem._CompanyCode AS _CompanyCode,
  _GLAccountLineItem._FiscalYear AS _FiscalYear,
  _GLAccountLineItem._JournalEntry AS _JournalEntry,
  _GLAccountLineItem._Ledger AS _Ledger,
  _GLAccountLineItem._FiscalPeriod AS _FiscalPeriod,
  _GLAccountLineItem._FiscalYearVariant AS _FiscalYearVariant,
  _GLAccountLineItem._Company AS _Company,
  _GLAccountLineItem._ConsolidationUnit AS _ConsolidationUnit,
  _GLAccountLineItem._ConsolidationChartOfAccounts AS _ConsolidationChartOfAccounts,
  _GLAccountLineItem._CnsldtnFinancialStatementItem AS _CnsldtnFinancialStatementItem,
  _GLAccountLineItem._CnsldtnSubitemCategory AS _CnsldtnSubitemCategory,
  _GLAccountLineItem._CnsldtnSubitem AS _CnsldtnSubitem,
  _GLAccountLineItem._PartnerConsolidationUnit AS _PartnerConsolidationUnit,
  _GLAccountLineItem._ChartOfAccounts AS _ChartOfAccounts,
  _GLAccountLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  _GLAccountLineItem._FinancialTransactionType AS _FinancialTransactionType,
  _GLAccountLineItem._ControllingArea AS _ControllingArea,
  _GLAccountLineItem._ProfitCenter AS _ProfitCenter,
  _GLAccountLineItem._Segment AS _Segment,
  _GLAccountLineItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  _GLAccountLineItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  _GLAccountLineItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  _GLAccountLineItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  _GLAccountLineItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  _GLAccountLineItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  _GLAccountLineItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  _GLAccountLineItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  _GLAccountLineItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  _GLAccountLineItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  _GLAccountLineItem._FunctionalCurrency AS _FunctionalCurrency,
  _GLAccountLineItem._GlobalCurrency AS _GlobalCurrency,
  _GLAccountLineItem._AdditionalQuantity1Unit AS _AdditionalQuantity1Unit,
  _GLAccountLineItem._AdditionalQuantity2Unit AS _AdditionalQuantity2Unit,
  _GLAccountLineItem._AdditionalQuantity3Unit AS _AdditionalQuantity3Unit,
  _GLAccountLineItem._BaseUnit AS _BaseUnit,
  _GLAccountLineItem._BillToParty AS _BillToParty,
  _GLAccountLineItem._BillableControl AS _BillableControl,
  _GLAccountLineItem._BillingDocumentType AS _BillingDocumentType,
  _GLAccountLineItem._BusinessArea AS _BusinessArea,
  _GLAccountLineItem._CostAnalysisResource AS _CostAnalysisResource,
  _GLAccountLineItem._CostCenter AS _CostCenter,
  _GLAccountLineItem._CreditRiskClass AS _CreditRiskClass,
  _GLAccountLineItem._Customer AS _Customer,
  _GLAccountLineItem._CustomerGroup AS _CustomerGroup,
  _GLAccountLineItem._CustomerSupplierCountry AS _CustomerSupplierCountry,
  _GLAccountLineItem._CustomerSupplierIndustry AS _CustomerSupplierIndustry,
  _GLAccountLineItem._DistributionChannel AS _DistributionChannel,
  _GLAccountLineItem._FixedAsset AS _FixedAsset,
  _GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  _GLAccountLineItem._GLAccountType AS _GLAccountType,
  _GLAccountLineItem._GroupMasterFixedAsset AS _GroupMasterFixedAsset,
  _GLAccountLineItem._LedgerFiscalYear AS _LedgerFiscalYear,
  _GLAccountLineItem._MasterFixedAsset AS _MasterFixedAsset,
  _GLAccountLineItem._Order AS _Order,
  _GLAccountLineItem._Division AS _Division,
  _GLAccountLineItem._PartnerBusinessArea AS _PartnerBusinessArea,
  _GLAccountLineItem._PartnerCompany AS _PartnerCompany,
  _GLAccountLineItem._PartnerCostCenter AS _PartnerCostCenter,
  _GLAccountLineItem._PartnerFixedAsset AS _PartnerFixedAsset,
  _GLAccountLineItem._PartnerFunctionalArea AS _PartnerFunctionalArea,
  _GLAccountLineItem._PartnerMasterFixedAsset AS _PartnerMasterFixedAsset,
  _GLAccountLineItem._PartnerProfitCenter AS _PartnerProfitCenter,
  _GLAccountLineItem._PartnerSegment AS _PartnerSegment,
  _GLAccountLineItem._Plant AS _Plant,
  _GLAccountLineItem._Product AS _Product,
  _GLAccountLineItem._ProductGroup AS _ProductGroup,
  _GLAccountLineItem._Project AS _Project,
  _GLAccountLineItem._SalesDistrict AS _SalesDistrict,
  _GLAccountLineItem._SalesOrganization AS _SalesOrganization,
  _GLAccountLineItem._ShipToParty AS _ShipToParty,
  _GLAccountLineItem._SoldProduct AS _SoldProduct,
  _GLAccountLineItem._SoldProductGroup AS _SoldProductGroup,
  _GLAccountLineItem._Supplier AS _Supplier,
  _GLAccountLineItem._WBSElement AS _WBSElement,
  _GLAccountLineItem._WBSElementInternalID AS _WBSElementInternalID,
  _GLAccountLineItem._AccountingDocumentType AS _AccountingDocumentType,
  _GLAccountLineItem._FinancialAccountType AS _FinancialAccountType,
  _GLAccountLineItem._CurrentCostCenter AS _CurrentCostCenter,
  _GLAccountLineItem._CurrentProfitCenter AS _CurrentProfitCenter,
  _GLAccountLineItem._SalesDocument AS _SalesDocument,
  _GLAccountLineItem._ServiceDocumentType AS _ServiceDocumentType,
  _GLAccountLineItem._ServiceDocument AS _ServiceDocument,
  _GLAccountLineItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode
FROM I_GLAccountLineItem AS _GLAccountLineItem
INNER JOIN I_CnsldtnAcctgIntegLdgrMappg AS _GRPLMapping ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnVersion AS _CnsldtnVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CnsldtnFSItemByTimeVersion AS _FSItemAttribute ON CnsldtnFinancialStatementItem = _FSItemAttribute.CnsldtnFinancialStatementItem AND ConsolidationChartOfAccounts = _FSItemAttribute.ConsolidationChartOfAccounts AND ConsolidationVersion = _FSItemAttribute.ConsolidationVersion AND FiscalYearPeriod >= _FSItemAttribute.FromFiscalYearPeriod AND FiscalYearPeriod <= _FSItemAttribute.ToFiscalYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitByTime_2 AS _CnsldtnUnitByTime ON ConsolidationUnit = _CnsldtnUnitByTime.ConsolidationUnit AND FiscalYearPeriod >= _CnsldtnUnitByTime.FromFiscalYearPeriod AND FiscalYearPeriod <= _CnsldtnUnitByTime.ToFiscalYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitByTimeVersion_2 AS _CnsldtnUnitByTimeVersion ON ConsolidationUnit = _CnsldtnUnitByTimeVersion.ConsolidationUnit AND ConsolidationVersion = _CnsldtnUnitByTimeVersion.ConsolidationVersion AND FiscalYearPeriod >= _CnsldtnUnitByTimeVersion.FromFiscalYearPeriod AND FiscalYearPeriod <= _CnsldtnUnitByTimeVersion.ToFiscalYearPeriod  -- association [0..1]
;

Depth:

I_CnsldtnGLAcctItemAttribute view_entity