What is A_GLAccountLineItem in SAP S/4HANA?

A_GLAccountLineItem is a basic CDS view in SAP S/4HANA. API G/L Account Line Item It contains 257 fields.

Which tables does A_GLAccountLineItem read from?

A_GLAccountLineItem reads data from: I_CoCodeLedgerSourceLedger, I_GLAccountLineItemRawData.

What VDM layer is A_GLAccountLineItem?

A_GLAccountLineItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

A_GLAccountLineItem

DDL: A_GLACCOUNTLINEITEM SQL: AFIGLACCTLIT Type: view BASIC

257 Fields 2 Data Sources 5 Associations 1 OData Services

API G/L Account Line Item

A_GLAccountLineItem is a Basic CDS View that provides data about "API G/L Account Line Item" in SAP S/4HANA. It reads from 2 data sources (I_CoCodeLedgerSourceLedger, I_GLAccountLineItemRawData) and exposes 257 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 5 associations to related views. It is exposed through 1 OData service (API_GLACCOUNTLINEITEM).

Data Sources (2)

Source	Alias	Join Type
I_CoCodeLedgerSourceLedger	I_CoCodeLedgerSourceLedger	inner
I_GLAccountLineItemRawData	I_GLAccountLineItemRawData	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	A_Supplier	_Supplier	`$projection.Supplier = _Supplier.Supplier`
[0..1]	A_Customer	_Customer	`$projection.Customer = _Customer.Customer`
[0..1]	A_CostCenter	_CurrentCostCenter	`$projection.ControllingArea = _CurrentCostCenter.ControllingArea and $projection.CostCenter = _CurrentCostCenter.CostCenter and _CurrentCostCenter.ValidityStartDate <= $session.system_date and _CurrentCostCenter.ValidityEndDate >= $session.system_date`
[0..1]	A_ProfitCenter	_CurrentProfitCenter	`$projection.ControllingArea = _CurrentProfitCenter.ControllingArea and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter and _CurrentProfitCenter.ValidityStartDate <= $session.system_date and _CurrentProfitCenter.ValidityEndDate >= $session.system_date`
[1..1]	E_JournalEntryItem	_Extension	`$projection.SourceLedger = _Extension.SourceLedger and $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	AFIGLACCTLIT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	API G/L Account Line Item	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.personalData.blocking	#REQUIRED	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view

OData Services (1)

Service	Binding	Version	Contract	Release
API_GLACCOUNTLINEITEM	API_GLACCOUNTLINEITEM	V2	C2	C1

Fields (257)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	I_GLAccountLineItemRawData	SourceLedger	Source Ledger
KEY	CompanyCode	I_GLAccountLineItemRawData	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_GLAccountLineItemRawData	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_GLAccountLineItemRawData	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	I_GLAccountLineItemRawData	LedgerGLLineItem	Journal Entry Item
KEY	Ledger	I_CoCodeLedgerSourceLedger	Ledger	Ledger
	LedgerFiscalYear	I_GLAccountLineItemRawData	LedgerFiscalYear	Ref. Year1
	GLRecordType	I_GLAccountLineItemRawData	GLRecordType	Record Type
	ControllingArea	I_GLAccountLineItemRawData	ControllingArea	Controlling Area
	ChartOfAccounts	I_GLAccountLineItemRawData	ChartOfAccounts	Node Class
	GLAccount	I_GLAccountLineItemRawData	GLAccount	General Ledger
	FinancialTransactionType	I_GLAccountLineItemRawData	FinancialTransactionType	Transact. Type
	BusinessTransactionType	I_GLAccountLineItemRawData	BusinessTransactionType	Bus.transaction
	ControllingBusTransacType	I_GLAccountLineItemRawData	ControllingBusTransacType	CO Bus. Transaction
	ReferenceDocumentType	I_GLAccountLineItemRawData	ReferenceDocumentType	Reference Document Type
	LogicalSystem	I_GLAccountLineItemRawData	LogicalSystem	Logical System
	ReferenceDocumentContext	I_GLAccountLineItemRawData	ReferenceDocumentContext	Reference Document Context
	ReferenceDocument	I_GLAccountLineItemRawData	ReferenceDocument	Reference Document
	ReferenceDocumentItem	I_GLAccountLineItemRawData	ReferenceDocumentItem	Reference item
	ReferenceDocumentItemGroup	I_GLAccountLineItemRawData	ReferenceDocumentItemGroup	Reference Document Item Group
	TransactionSubitem	I_GLAccountLineItemRawData	TransactionSubitem	Sub Transaction
	IsReversal	I_GLAccountLineItemRawData	IsReversal	Reversal doc.
	IsReversed	I_GLAccountLineItemRawData	IsReversed	Reversed?
	ReversalReferenceDocumentCntxt	I_GLAccountLineItemRawData	ReversalReferenceDocumentCntxt	Reversal Reference Document Context
	ReversalReferenceDocument	I_GLAccountLineItemRawData	ReversalReferenceDocument	Reversal Reference Document
	IsSettlement	I_GLAccountLineItemRawData	IsSettlement	Is Settling
	IsSettled	I_GLAccountLineItemRawData	IsSettled	Is Settled
	PredecessorReferenceDocType	I_GLAccountLineItemRawData	PredecessorReferenceDocType	Predecessor Reference Document Type
	PredecessorReferenceDocCntxt	I_GLAccountLineItemRawData	PredecessorReferenceDocCntxt	Predecessor Reference Document Context
	PredecessorReferenceDocument	I_GLAccountLineItemRawData	PredecessorReferenceDocument	Predecessor Reference Document
	PredecessorReferenceDocItem	I_GLAccountLineItemRawData	PredecessorReferenceDocItem	Prec. Ref. Doc. Item
	PrdcssrJournalEntryCompanyCode	I_GLAccountLineItemRawData	PrdcssrJournalEntryCompanyCode	Predecessor Journal Entry Company Code
	PrdcssrJournalEntryFiscalYear	I_GLAccountLineItemRawData	PrdcssrJournalEntryFiscalYear	Predecessor Journal Entry Fiscal Year
	PredecessorJournalEntry	I_GLAccountLineItemRawData	PredecessorJournalEntry	Predecessor Journal Entry
	PredecessorJournalEntryItem	I_GLAccountLineItemRawData	PredecessorJournalEntryItem	Predecessor Journal Entry Item
	SourceReferenceDocumentType	I_GLAccountLineItemRawData	SourceReferenceDocumentType	Ref. procedure
	SourceLogicalSystem	I_GLAccountLineItemRawData	SourceLogicalSystem
	SourceReferenceDocumentCntxt	I_GLAccountLineItemRawData	SourceReferenceDocumentCntxt
	SourceReferenceDocument	I_GLAccountLineItemRawData	SourceReferenceDocument	Reference Doc.
	SourceReferenceDocumentItem	I_GLAccountLineItemRawData	SourceReferenceDocumentItem	Ref. Doc. Item
	SourceReferenceDocSubitem	I_GLAccountLineItemRawData	SourceReferenceDocSubitem
	IsCommitment	I_GLAccountLineItemRawData	IsCommitment
	JrnlEntryItemObsoleteReason	I_GLAccountLineItemRawData	JrnlEntryItemObsoleteReason	Obsolete Reason
	JrnlPeriodEndClosingRunLogUUID	I_GLAccountLineItemRawData	JrnlPeriodEndClosingRunLogUUID	Closing Run UUID
	CostCenter	I_GLAccountLineItemRawData	CostCenter	Cost Center
	ProfitCenter	I_GLAccountLineItemRawData	ProfitCenter	Profit Center
	FunctionalArea	I_GLAccountLineItemRawData	FunctionalArea	Sendr Fctl Area
	BusinessArea	I_GLAccountLineItemRawData	BusinessArea	Business Area
	Segment	I_GLAccountLineItemRawData	Segment	Segment number
	PartnerCostCenter	I_GLAccountLineItemRawData	PartnerCostCenter	Sender Cost Ctr
	PartnerProfitCenter	I_GLAccountLineItemRawData	PartnerProfitCenter	Profit Center
	PartnerFunctionalArea	I_GLAccountLineItemRawData	PartnerFunctionalArea	Rec. Fntcl Area
	PartnerBusinessArea	I_GLAccountLineItemRawData	PartnerBusinessArea	Trdg Part.BA
	PartnerCompany	I_GLAccountLineItemRawData	PartnerCompany	Trading Partner
	PartnerSegment	I_GLAccountLineItemRawData	PartnerSegment	Partner Segment
	BalanceTransactionCurrency	I_GLAccountLineItemRawData	BalanceTransactionCurrency	Currency
	AmountInBalanceTransacCrcy	I_GLAccountLineItemRawData	AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	TransactionCurrency	I_GLAccountLineItemRawData	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	I_GLAccountLineItemRawData	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency	I_GLAccountLineItemRawData	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	I_GLAccountLineItemRawData	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	I_GLAccountLineItemRawData	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	I_GLAccountLineItemRawData	AmountInGlobalCurrency	Amount in Global Currency
	FreeDefinedCurrency1	I_GLAccountLineItemRawData	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1	I_GLAccountLineItemRawData	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	I_GLAccountLineItemRawData	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2	I_GLAccountLineItemRawData	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	I_GLAccountLineItemRawData	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3	I_GLAccountLineItemRawData	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	I_GLAccountLineItemRawData	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4	I_GLAccountLineItemRawData	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	I_GLAccountLineItemRawData	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5	I_GLAccountLineItemRawData	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	I_GLAccountLineItemRawData	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6	I_GLAccountLineItemRawData	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	I_GLAccountLineItemRawData	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7	I_GLAccountLineItemRawData	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	I_GLAccountLineItemRawData	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8	I_GLAccountLineItemRawData	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	FixedAmountInGlobalCrcy	I_GLAccountLineItemRawData	FixedAmountInGlobalCrcy	Fixed Amnt in GC
	GrpValnFixedAmtInGlobCrcy	I_GLAccountLineItemRawData	GrpValnFixedAmtInGlobCrcy
	PrftCtrValnFxdAmtInGlobCrcy	I_GLAccountLineItemRawData	PrftCtrValnFxdAmtInGlobCrcy
	TotalPriceVarcInGlobalCrcy	I_GLAccountLineItemRawData	TotalPriceVarcInGlobalCrcy	Price Variance
	GrpValnTotPrcVarcInGlobCrcy	I_GLAccountLineItemRawData	GrpValnTotPrcVarcInGlobCrcy
	PrftCtrValnTotPrcVarcInGlbCrcy	I_GLAccountLineItemRawData	PrftCtrValnTotPrcVarcInGlbCrcy
	FixedPriceVarcInGlobalCrcy	I_GLAccountLineItemRawData	FixedPriceVarcInGlobalCrcy	Price Var. Fxd
	GrpValnFixedPrcVarcInGlobCrcy	I_GLAccountLineItemRawData	GrpValnFixedPrcVarcInGlobCrcy
	PrftCtrValnFxdPrcVarcInGlbCrcy	I_GLAccountLineItemRawData	PrftCtrValnFxdPrcVarcInGlbCrcy
	FixedAmountInCoCodeCrcy	I_GLAccountLineItemRawData	FixedAmountInCoCodeCrcy	Fixed Amnt in CC
	ControllingObjectCurrency	I_GLAccountLineItemRawData	ControllingObjectCurrency	CO Object Currency
	AmountInObjectCurrency	I_GLAccountLineItemRawData	AmountInObjectCurrency	Amount in Obj Crcy
	BaseUnit	I_GLAccountLineItemRawData	BaseUnit	Unit of Measure
	Quantity	I_GLAccountLineItemRawData	Quantity	Value
	FixedQuantity	I_GLAccountLineItemRawData	FixedQuantity	Fixed Quantity
	CostSourceUnit	I_GLAccountLineItemRawData	CostSourceUnit	Valuation UoM
	ValuationQuantity	I_GLAccountLineItemRawData	ValuationQuantity
	ValuationFixedQuantity	I_GLAccountLineItemRawData	ValuationFixedQuantity
	AdditionalQuantity1Unit	I_GLAccountLineItemRawData	AdditionalQuantity1Unit	Add Unit Meas 1
	AdditionalQuantity1	I_GLAccountLineItemRawData	AdditionalQuantity1
	AdditionalQuantity2Unit	I_GLAccountLineItemRawData	AdditionalQuantity2Unit	Add Unit Meas 2
	AdditionalQuantity2	I_GLAccountLineItemRawData	AdditionalQuantity2
	AdditionalQuantity3Unit	I_GLAccountLineItemRawData	AdditionalQuantity3Unit	Add Unit Meas 3
	AdditionalQuantity3	I_GLAccountLineItemRawData	AdditionalQuantity3
	DebitCreditCode	I_GLAccountLineItemRawData	DebitCreditCode	Single-Character Flag
	FiscalPeriod	I_GLAccountLineItemRawData	FiscalPeriod	Tax period
	FiscalYearVariant	I_GLAccountLineItemRawData	FiscalYearVariant	FY Variant
	FiscalYearPeriod	I_GLAccountLineItemRawData	FiscalYearPeriod	Period/Year
	PostingDate	I_GLAccountLineItemRawData	PostingDate	Posting Date for GR
	DocumentDate	I_GLAccountLineItemRawData	DocumentDate	Journal Entry Date
	AccountingDocumentType	I_GLAccountLineItemRawData	AccountingDocumentType	Journal Entry Type
	AccountingDocumentItem	I_GLAccountLineItemRawData	AccountingDocumentItem	Posting View Item
	AssignmentReference	I_GLAccountLineItemRawData	AssignmentReference	Assignment Reference
	AccountingDocumentCategory	I_GLAccountLineItemRawData	AccountingDocumentCategory	Journal Entry Category
	PostingKey	I_GLAccountLineItemRawData	PostingKey	Posting Key
	TransactionTypeDetermination	I_GLAccountLineItemRawData	TransactionTypeDetermination	Transaction Key
	SubLedgerAcctLineItemType	I_GLAccountLineItemRawData	SubLedgerAcctLineItemType	SLALineItemType
	AccountingDocCreatedByUser	I_GLAccountLineItemRawData	AccountingDocCreatedByUser	User which created overhead document
	LastChangeDateTime	I_GLAccountLineItemRawData	LastChangeDateTime	Timestamp
	CreationDateTime	I_GLAccountLineItemRawData	CreationDateTime	Timestamp
	CreationDate	I_GLAccountLineItemRawData	CreationDate	Time Stamp
	EliminationProfitCenter	I_GLAccountLineItemRawData	EliminationProfitCenter
	OriginObjectType	I_GLAccountLineItemRawData	OriginObjectType	Origin
	GLAccountType	I_GLAccountLineItemRawData	GLAccountType	G/L Account Type
	AlternativeGLAccount	I_GLAccountLineItemRawData	AlternativeGLAccount	Group Account
	CountryChartOfAccounts	I_GLAccountLineItemRawData	CountryChartOfAccounts	Chart of Accts
	ItemIsSplit	I_GLAccountLineItemRawData	ItemIsSplit
	ConsolidationUnit	I_GLAccountLineItemRawData	ConsolidationUnit	Consolidation Unit
	PartnerConsolidationUnit	I_GLAccountLineItemRawData	PartnerConsolidationUnit	Partner Unit
	Company	I_GLAccountLineItemRawData	Company	Owner
	ConsolidationChartOfAccounts	I_GLAccountLineItemRawData	ConsolidationChartOfAccounts	Cons. COA
	CnsldtnFinancialStatementItem	I_GLAccountLineItemRawData	CnsldtnFinancialStatementItem	Reporting Item
	CnsldtnSubitemCategory	I_GLAccountLineItemRawData	CnsldtnSubitemCategory	Trip Schedule Type
	CnsldtnSubitem	I_GLAccountLineItemRawData	CnsldtnSubitem	Subitem
	InvoiceReference	I_GLAccountLineItemRawData	InvoiceReference	Invoice Reference
	InvoiceReferenceFiscalYear	I_GLAccountLineItemRawData	InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
	FollowOnDocumentType	I_GLAccountLineItemRawData	FollowOnDocumentType	Follow-On Document Type
	InvoiceItemReference	I_GLAccountLineItemRawData	InvoiceItemReference	Item
	ReferencePurchaseOrderCategory	I_GLAccountLineItemRawData	ReferencePurchaseOrderCategory	PO Category
	PurchasingDocument	I_GLAccountLineItemRawData	PurchasingDocument	Purchasing Document
	PurchasingDocumentItem	I_GLAccountLineItemRawData	PurchasingDocumentItem	Purchasing Doc. Item
	AccountAssignmentNumber	I_GLAccountLineItemRawData	AccountAssignmentNumber	Account Assgmt No.
	DocumentItemText	I_GLAccountLineItemRawData	DocumentItemText	Text
	SalesDocument	I_GLAccountLineItemRawData	SalesDocument	SD Document
	SalesDocumentItem	I_GLAccountLineItemRawData	SalesDocumentItem	Sales Document Item
	Product	I_GLAccountLineItemRawData	Product	Product Sold
	Plant	I_GLAccountLineItemRawData	Plant	Valuation Area
	Supplier	I_GLAccountLineItemRawData	Supplier	Supplier
	Customer	I_GLAccountLineItemRawData	Customer	Sold-to Party
	ServicesRenderedDate	I_GLAccountLineItemRawData	ServicesRenderedDate	Services Rendered Date
	ConditionContract	I_GLAccountLineItemRawData	ConditionContract	Condition Contract
	GeneralLedgerAgingScope	I_GLAccountLineItemRawData	GeneralLedgerAgingScope	Aging
	GeneralLedgerAgingIncrement	I_GLAccountLineItemRawData	GeneralLedgerAgingIncrement	Increment
	FinancialAccountType	I_GLAccountLineItemRawData	FinancialAccountType	Fin. Account Type
	SpecialGLCode	I_GLAccountLineItemRawData	SpecialGLCode	Special G/L Ind
	TaxCode	I_GLAccountLineItemRawData	TaxCode	Tax Code
	HouseBank	I_GLAccountLineItemRawData	HouseBank	House Bank
	HouseBankAccount	I_GLAccountLineItemRawData	HouseBankAccount	House Bank Account
	IsOpenItemManaged	I_GLAccountLineItemRawData	IsOpenItemManaged	Open Item Management
	ClearingDate	I_GLAccountLineItemRawData	ClearingDate	Clearing Date
	ClearingAccountingDocument	I_GLAccountLineItemRawData	ClearingJournalEntry	Clrng doc.
	ClearingDocFiscalYear	I_GLAccountLineItemRawData	ClearingJournalEntryFiscalYear	Fiscal Year of Clearing Journal Entry
	ValueDate	I_GLAccountLineItemRawData	ValueDate	Value Date
	AssetDepreciationArea	I_GLAccountLineItemRawData	AssetDepreciationArea	Deprec. Area
	MasterFixedAsset	I_GLAccountLineItemRawData	MasterFixedAsset	Fixed Asset
	FixedAsset	I_GLAccountLineItemRawData	FixedAsset	Sub-number
	AssetValueDate	I_GLAccountLineItemRawData	AssetValueDate	Reference date
	AssetTransactionType	I_GLAccountLineItemRawData	AssetTransactionType	Trans.Type
	AssetAcctTransClassfctn	I_GLAccountLineItemRawData	AssetAcctTransClassfctn	Trans.Type Cat.
	DepreciationFiscalPeriod	I_GLAccountLineItemRawData	DepreciationFiscalPeriod	Deprec. Period
	GroupMasterFixedAsset	I_GLAccountLineItemRawData	GroupMasterFixedAsset	Group Asset
	GroupFixedAsset	I_GLAccountLineItemRawData	GroupFixedAsset	Subnumber
	AssetClass	I_GLAccountLineItemRawData	AssetClass	Asset Class
	CostEstimate	I_GLAccountLineItemRawData	CostEstimate	Cost EstimateNo
	InventorySpecialStockValnType	I_GLAccountLineItemRawData	InventorySpecialStockValnType	Valuation
	InventorySpecialStockType	I_GLAccountLineItemRawData	InventorySpecialStockType	Special Stock Type
	InventorySpclStkSalesDocument	I_GLAccountLineItemRawData	InventorySpclStkSalesDocument
	InventorySpclStkSalesDocItm	I_GLAccountLineItemRawData	InventorySpclStkSalesDocItm
	InvtrySpclStockWBSElmntIntID	I_GLAccountLineItemRawData	InvtrySpclStockWBSElmntIntID
	InventorySpecialStockSupplier	I_GLAccountLineItemRawData	InventorySpecialStockSupplier	Vendor of Inv.
	InventoryValuationType	I_GLAccountLineItemRawData	InventoryValuationType	Valuation Type
	ValuationArea	I_GLAccountLineItemRawData	ValuationArea	Valuation Area
	CostOriginGroup	I_GLAccountLineItemRawData	CostOriginGroup	Origin Group
	OriginSenderObject	I_GLAccountLineItemRawData	OriginSenderObject	Source Object
	ControllingDebitCreditCode
	OriginCtrlgDebitCreditCode
	ControllingObjectDebitType	I_GLAccountLineItemRawData	ControllingObjectDebitType
	QuantityIsIncomplete	I_GLAccountLineItemRawData	QuantityIsIncomplete	Qty Is Incomplete
	OffsettingAccount	I_GLAccountLineItemRawData	OffsettingAccount	Offsetting Acct
	OffsettingAccountType	I_GLAccountLineItemRawData	OffsettingAccountType	Offset Acct Type
	OffsettingChartOfAccounts	I_GLAccountLineItemRawData	OffsettingChartOfAccounts	Offsetting Chart of Accounts
	LineItemIsCompleted	I_GLAccountLineItemRawData	LineItemIsCompleted	Item Completed
	PersonnelNumber	I_GLAccountLineItemRawData	PersonnelNumber	Personnel No.
	ControllingObjectClass	I_GLAccountLineItemRawData	ControllingObjectClass	Object Class
	PartnerCompanyCode	I_GLAccountLineItemRawData	PartnerCompanyCode	Partner Company Code
	PartnerControllingObjectClass	I_GLAccountLineItemRawData	PartnerControllingObjectClass	PartnerObjClass
	OriginCostCenter	I_GLAccountLineItemRawData	OriginCostCenter	OrigCCtr
	OriginProfitCenter	I_GLAccountLineItemRawData	OriginProfitCenter	Origin Profit Center
	OriginCostCtrActivityType	I_GLAccountLineItemRawData	OriginCostCtrActivityType	OrigAct.
	AccountAssignment	I_GLAccountLineItemRawData	AccountAssignment	Sender Acct Assgmt
	AccountAssignmentType	I_GLAccountLineItemRawData	AccountAssignmentType	Sndr AcctAssgmt Type
	CostCtrActivityType	I_GLAccountLineItemRawData	CostCtrActivityType	Activity Type
	OrderID	I_GLAccountLineItemRawData	OrderID	Order ID
	OrderCategory	I_GLAccountLineItemRawData	OrderCategory	Order Category
	WBSElementInternalID	I_GLAccountLineItemRawData	WBSElementInternalID	WBS Internal ID
	PartnerWBSElementInternalID	I_GLAccountLineItemRawData	PartnerWBSElementInternalID	Partner WBS Element Internal ID
	ProjectInternalID	I_GLAccountLineItemRawData	ProjectInternalID	Project Def.
	PartnerProjectInternalID	I_GLAccountLineItemRawData	PartnerProjectInternalID
	OperatingConcern	I_GLAccountLineItemRawData	OperatingConcern	Operating concern
	ProjectNetwork	I_GLAccountLineItemRawData	ProjectNetwork	Order
	BusinessProcess	I_GLAccountLineItemRawData	BusinessProcess	Business Process
	CostObject	I_GLAccountLineItemRawData	CostObject	Cost Object
	BillableControl	I_GLAccountLineItemRawData	BillableControl	Billable Control
	CostAnalysisResource	I_GLAccountLineItemRawData	CostAnalysisResource	Resource
	CustomerServiceNotification	I_GLAccountLineItemRawData	CustomerServiceNotification
	ServiceDocumentType	I_GLAccountLineItemRawData	ServiceDocumentType	Transaction Type
	ServiceDocument	I_GLAccountLineItemRawData	ServiceDocument	Transaction ID
	ServiceDocumentItem	I_GLAccountLineItemRawData	ServiceDocumentItem	Service Document
	PartnerServiceDocumentType	I_GLAccountLineItemRawData	PartnerServiceDocumentType	Par. Service DocType
	PartnerServiceDocument	I_GLAccountLineItemRawData	PartnerServiceDocument	Partner Service Doc.
	PartnerServiceDocumentItem	I_GLAccountLineItemRawData	PartnerServiceDocumentItem	Par. Service DocItem
	ServiceContractType	I_GLAccountLineItemRawData	ServiceContractType	Serv. Contract Type
	ServiceContract	I_GLAccountLineItemRawData	ServiceContract	Transaction ID
	ServiceContractItem	I_GLAccountLineItemRawData	ServiceContractItem	Item Number in Doc.
	TimeSheetOvertimeCategory	I_GLAccountLineItemRawData	TimeSheetOvertimeCategory	Overtime Category
	PartnerAccountAssignment	I_GLAccountLineItemRawData	PartnerAccountAssignment	Partner Account Assignment
	PartnerAccountAssignmentType	I_GLAccountLineItemRawData	PartnerAccountAssignmentType	Partner Account Assignment Type
	PartnerCostCtrActivityType	I_GLAccountLineItemRawData	PartnerCostCtrActivityType	Partner Cost Center Activity Type
	PartnerOrder	I_GLAccountLineItemRawData	PartnerOrder	Partner Order
	PartnerOrderCategory	I_GLAccountLineItemRawData	PartnerOrderCategory	Prtnr Ord. Cat.
	PartnerSalesDocument	I_GLAccountLineItemRawData	PartnerSalesDocument	Partner Sales Doc.
	PartnerSalesDocumentItem	I_GLAccountLineItemRawData	PartnerSalesDocumentItem	Partner Sales Document Item
	PartnerProjectNetwork	I_GLAccountLineItemRawData	PartnerProjectNetwork	Part. Proj. Network
	PartnerBusinessProcess	I_GLAccountLineItemRawData	PartnerBusinessProcess	Part. Bus. Process
	PartnerCostObject	I_GLAccountLineItemRawData	PartnerCostObject	Partner Cost Object
	ControllingDocumentItem	I_GLAccountLineItemRawData	ControllingDocumentItem	Controlling Doc Item
	BillingDocumentType	I_GLAccountLineItemRawData	BillingDocumentType	Billing Type
	SalesOrganization	I_GLAccountLineItemRawData	SalesOrganization	Sales Organization
	DistributionChannel	I_GLAccountLineItemRawData	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	I_GLAccountLineItemRawData	OrganizationDivision	Org. Division
	SoldProduct	I_GLAccountLineItemRawData	SoldProduct	Product Sold
	SoldProductGroup	I_GLAccountLineItemRawData	SoldProductGroup	Product Sold Group
	CustomerGroup	I_GLAccountLineItemRawData	CustomerGroup	Customer Group
	CustomerSupplierCountry	I_GLAccountLineItemRawData	CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierIndustry	I_GLAccountLineItemRawData	CustomerSupplierIndustry	Industry
	SalesDistrict	I_GLAccountLineItemRawData	SalesDistrict	Sales District
	BillToParty	I_GLAccountLineItemRawData	BillToParty	Inv. Recipient
	ShipToParty	I_GLAccountLineItemRawData	ShipToParty	Ship-To Party (obsolete)
	CustomerSupplierCorporateGroup	I_GLAccountLineItemRawData	CustomerSupplierCorporateGroup	Group
	_Supplier		_Supplier
	_Customer		_Customer
	_AccountingDocumentType	I_GLAccountLineItemRawData	_AccountingDocumentType
	_GLAccountInCompanyCode	I_GLAccountLineItemRawData	_GLAccountInCompanyCode
	_Order	I_GLAccountLineItemRawData	_Order
	_SalesDocument	I_GLAccountLineItemRawData	_SalesDocument
	_ServiceDocument	I_GLAccountLineItemRawData	_ServiceDocument
	_CurrentCostCenter		_CurrentCostCenter
	_CurrentProfitCenter		_CurrentProfitCenter

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 A_GLAccountLineItem.
-- 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.
-- SQL view name: AFIGLACCTLIT

CREATE VIEW A_GLAccountLineItem AS
SELECT
  I_GLAccountLineItemRawData.SourceLedger AS SourceLedger,
  I_GLAccountLineItemRawData.CompanyCode AS CompanyCode,
  I_GLAccountLineItemRawData.FiscalYear AS FiscalYear,
  I_GLAccountLineItemRawData.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItemRawData.LedgerGLLineItem AS LedgerGLLineItem,
  I_CoCodeLedgerSourceLedger.Ledger AS Ledger,
  I_GLAccountLineItemRawData.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountLineItemRawData.GLRecordType AS GLRecordType,
  I_GLAccountLineItemRawData.ControllingArea AS ControllingArea,
  I_GLAccountLineItemRawData.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItemRawData.GLAccount AS GLAccount,
  I_GLAccountLineItemRawData.FinancialTransactionType AS FinancialTransactionType,
  I_GLAccountLineItemRawData.BusinessTransactionType AS BusinessTransactionType,
  I_GLAccountLineItemRawData.ControllingBusTransacType AS ControllingBusTransacType,
  I_GLAccountLineItemRawData.ReferenceDocumentType AS ReferenceDocumentType,
  I_GLAccountLineItemRawData.LogicalSystem AS LogicalSystem,
  I_GLAccountLineItemRawData.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_GLAccountLineItemRawData.ReferenceDocument AS ReferenceDocument,
  I_GLAccountLineItemRawData.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_GLAccountLineItemRawData.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  I_GLAccountLineItemRawData.TransactionSubitem AS TransactionSubitem,
  I_GLAccountLineItemRawData.IsReversal AS IsReversal,
  I_GLAccountLineItemRawData.IsReversed AS IsReversed,
  I_GLAccountLineItemRawData.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  I_GLAccountLineItemRawData.ReversalReferenceDocument AS ReversalReferenceDocument,
  I_GLAccountLineItemRawData.IsSettlement AS IsSettlement,
  I_GLAccountLineItemRawData.IsSettled AS IsSettled,
  I_GLAccountLineItemRawData.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  I_GLAccountLineItemRawData.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  I_GLAccountLineItemRawData.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  I_GLAccountLineItemRawData.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  I_GLAccountLineItemRawData.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  I_GLAccountLineItemRawData.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  I_GLAccountLineItemRawData.PredecessorJournalEntry AS PredecessorJournalEntry,
  I_GLAccountLineItemRawData.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  I_GLAccountLineItemRawData.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  I_GLAccountLineItemRawData.SourceLogicalSystem AS SourceLogicalSystem,
  I_GLAccountLineItemRawData.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  I_GLAccountLineItemRawData.SourceReferenceDocument AS SourceReferenceDocument,
  I_GLAccountLineItemRawData.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  I_GLAccountLineItemRawData.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  I_GLAccountLineItemRawData.IsCommitment AS IsCommitment,
  I_GLAccountLineItemRawData.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  I_GLAccountLineItemRawData.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  I_GLAccountLineItemRawData.CostCenter AS CostCenter,
  I_GLAccountLineItemRawData.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItemRawData.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItemRawData.BusinessArea AS BusinessArea,
  I_GLAccountLineItemRawData.Segment AS Segment,
  I_GLAccountLineItemRawData.PartnerCostCenter AS PartnerCostCenter,
  I_GLAccountLineItemRawData.PartnerProfitCenter AS PartnerProfitCenter,
  I_GLAccountLineItemRawData.PartnerFunctionalArea AS PartnerFunctionalArea,
  I_GLAccountLineItemRawData.PartnerBusinessArea AS PartnerBusinessArea,
  I_GLAccountLineItemRawData.PartnerCompany AS PartnerCompany,
  I_GLAccountLineItemRawData.PartnerSegment AS PartnerSegment,
  I_GLAccountLineItemRawData.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountLineItemRawData.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountLineItemRawData.TransactionCurrency AS TransactionCurrency,
  I_GLAccountLineItemRawData.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAccountLineItemRawData.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItemRawData.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItemRawData.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItemRawData.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountLineItemRawData.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  I_GLAccountLineItemRawData.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  I_GLAccountLineItemRawData.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  I_GLAccountLineItemRawData.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  I_GLAccountLineItemRawData.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  I_GLAccountLineItemRawData.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  I_GLAccountLineItemRawData.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  I_GLAccountLineItemRawData.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  I_GLAccountLineItemRawData.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_GLAccountLineItemRawData.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
  I_GLAccountLineItemRawData.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
  I_GLAccountLineItemRawData.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  I_GLAccountLineItemRawData.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
  I_GLAccountLineItemRawData.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
  I_GLAccountLineItemRawData.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  I_GLAccountLineItemRawData.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
  I_GLAccountLineItemRawData.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  I_GLAccountLineItemRawData.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  I_GLAccountLineItemRawData.ControllingObjectCurrency AS ControllingObjectCurrency,
  I_GLAccountLineItemRawData.AmountInObjectCurrency AS AmountInObjectCurrency,
  I_GLAccountLineItemRawData.BaseUnit AS BaseUnit,
  I_GLAccountLineItemRawData.Quantity AS Quantity,
  I_GLAccountLineItemRawData.FixedQuantity AS FixedQuantity,
  I_GLAccountLineItemRawData.CostSourceUnit AS CostSourceUnit,
  I_GLAccountLineItemRawData.ValuationQuantity AS ValuationQuantity,
  I_GLAccountLineItemRawData.ValuationFixedQuantity AS ValuationFixedQuantity,
  I_GLAccountLineItemRawData.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  I_GLAccountLineItemRawData.AdditionalQuantity1 AS AdditionalQuantity1,
  I_GLAccountLineItemRawData.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  I_GLAccountLineItemRawData.AdditionalQuantity2 AS AdditionalQuantity2,
  I_GLAccountLineItemRawData.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  I_GLAccountLineItemRawData.AdditionalQuantity3 AS AdditionalQuantity3,
  I_GLAccountLineItemRawData.DebitCreditCode AS DebitCreditCode,
  I_GLAccountLineItemRawData.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItemRawData.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItemRawData.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAccountLineItemRawData.PostingDate AS PostingDate,
  I_GLAccountLineItemRawData.DocumentDate AS DocumentDate,
  I_GLAccountLineItemRawData.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItemRawData.AccountingDocumentItem AS AccountingDocumentItem,
  I_GLAccountLineItemRawData.AssignmentReference AS AssignmentReference,
  I_GLAccountLineItemRawData.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAccountLineItemRawData.PostingKey AS PostingKey,
  I_GLAccountLineItemRawData.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_GLAccountLineItemRawData.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  I_GLAccountLineItemRawData.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_GLAccountLineItemRawData.LastChangeDateTime AS LastChangeDateTime,
  I_GLAccountLineItemRawData.CreationDateTime AS CreationDateTime,
  I_GLAccountLineItemRawData.CreationDate AS CreationDate,
  I_GLAccountLineItemRawData.EliminationProfitCenter AS EliminationProfitCenter,
  I_GLAccountLineItemRawData.OriginObjectType AS OriginObjectType,
  I_GLAccountLineItemRawData.GLAccountType AS GLAccountType,
  I_GLAccountLineItemRawData.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAccountLineItemRawData.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_GLAccountLineItemRawData.ItemIsSplit AS ItemIsSplit,
  I_GLAccountLineItemRawData.ConsolidationUnit AS ConsolidationUnit,
  I_GLAccountLineItemRawData.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  I_GLAccountLineItemRawData.Company AS Company,
  I_GLAccountLineItemRawData.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  I_GLAccountLineItemRawData.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  I_GLAccountLineItemRawData.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  I_GLAccountLineItemRawData.CnsldtnSubitem AS CnsldtnSubitem,
  I_GLAccountLineItemRawData.InvoiceReference AS InvoiceReference,
  I_GLAccountLineItemRawData.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  I_GLAccountLineItemRawData.FollowOnDocumentType AS FollowOnDocumentType,
  I_GLAccountLineItemRawData.InvoiceItemReference AS InvoiceItemReference,
  I_GLAccountLineItemRawData.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  I_GLAccountLineItemRawData.PurchasingDocument AS PurchasingDocument,
  I_GLAccountLineItemRawData.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GLAccountLineItemRawData.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_GLAccountLineItemRawData.DocumentItemText AS DocumentItemText,
  I_GLAccountLineItemRawData.SalesDocument AS SalesDocument,
  I_GLAccountLineItemRawData.SalesDocumentItem AS SalesDocumentItem,
  I_GLAccountLineItemRawData.Product AS Product,
  I_GLAccountLineItemRawData.Plant AS Plant,
  I_GLAccountLineItemRawData.Supplier AS Supplier,
  I_GLAccountLineItemRawData.Customer AS Customer,
  I_GLAccountLineItemRawData.ServicesRenderedDate AS ServicesRenderedDate,
  I_GLAccountLineItemRawData.ConditionContract AS ConditionContract,
  I_GLAccountLineItemRawData.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  I_GLAccountLineItemRawData.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  I_GLAccountLineItemRawData.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItemRawData.SpecialGLCode AS SpecialGLCode,
  I_GLAccountLineItemRawData.TaxCode AS TaxCode,
  I_GLAccountLineItemRawData.HouseBank AS HouseBank,
  I_GLAccountLineItemRawData.HouseBankAccount AS HouseBankAccount,
  I_GLAccountLineItemRawData.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAccountLineItemRawData.ClearingDate AS ClearingDate,
  I_GLAccountLineItemRawData.ClearingJournalEntry AS ClearingAccountingDocument,
  I_GLAccountLineItemRawData.ClearingJournalEntryFiscalYear AS ClearingDocFiscalYear,
  I_GLAccountLineItemRawData.ValueDate AS ValueDate,
  I_GLAccountLineItemRawData.AssetDepreciationArea AS AssetDepreciationArea,
  I_GLAccountLineItemRawData.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItemRawData.FixedAsset AS FixedAsset,
  I_GLAccountLineItemRawData.AssetValueDate AS AssetValueDate,
  I_GLAccountLineItemRawData.AssetTransactionType AS AssetTransactionType,
  I_GLAccountLineItemRawData.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  I_GLAccountLineItemRawData.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  I_GLAccountLineItemRawData.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  I_GLAccountLineItemRawData.GroupFixedAsset AS GroupFixedAsset,
  I_GLAccountLineItemRawData.AssetClass AS AssetClass,
  I_GLAccountLineItemRawData.CostEstimate AS CostEstimate,
  I_GLAccountLineItemRawData.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_GLAccountLineItemRawData.InventorySpecialStockType AS InventorySpecialStockType,
  I_GLAccountLineItemRawData.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  I_GLAccountLineItemRawData.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  I_GLAccountLineItemRawData.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  I_GLAccountLineItemRawData.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  I_GLAccountLineItemRawData.InventoryValuationType AS InventoryValuationType,
  I_GLAccountLineItemRawData.ValuationArea AS ValuationArea,
  I_GLAccountLineItemRawData.CostOriginGroup AS CostOriginGroup,
  I_GLAccountLineItemRawData.OriginSenderObject AS OriginSenderObject,
  cast( I_GLAccountLineItemRawData.ControllingDebitCreditCode as fis_co_belkz_conv preserving type ) AS ControllingDebitCreditCode,
  cast( I_GLAccountLineItemRawData.OriginCtrlgDebitCreditCode as fis_co_beknz_conv preserving type ) AS OriginCtrlgDebitCreditCode,
  I_GLAccountLineItemRawData.ControllingObjectDebitType AS ControllingObjectDebitType,
  I_GLAccountLineItemRawData.QuantityIsIncomplete AS QuantityIsIncomplete,
  I_GLAccountLineItemRawData.OffsettingAccount AS OffsettingAccount,
  I_GLAccountLineItemRawData.OffsettingAccountType AS OffsettingAccountType,
  I_GLAccountLineItemRawData.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  I_GLAccountLineItemRawData.LineItemIsCompleted AS LineItemIsCompleted,
  I_GLAccountLineItemRawData.PersonnelNumber AS PersonnelNumber,
  I_GLAccountLineItemRawData.ControllingObjectClass AS ControllingObjectClass,
  I_GLAccountLineItemRawData.PartnerCompanyCode AS PartnerCompanyCode,
  I_GLAccountLineItemRawData.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  I_GLAccountLineItemRawData.OriginCostCenter AS OriginCostCenter,
  I_GLAccountLineItemRawData.OriginProfitCenter AS OriginProfitCenter,
  I_GLAccountLineItemRawData.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  I_GLAccountLineItemRawData.AccountAssignment AS AccountAssignment,
  I_GLAccountLineItemRawData.AccountAssignmentType AS AccountAssignmentType,
  I_GLAccountLineItemRawData.CostCtrActivityType AS CostCtrActivityType,
  I_GLAccountLineItemRawData.OrderID AS OrderID,
  I_GLAccountLineItemRawData.OrderCategory AS OrderCategory,
  I_GLAccountLineItemRawData.WBSElementInternalID AS WBSElementInternalID,
  I_GLAccountLineItemRawData.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  I_GLAccountLineItemRawData.ProjectInternalID AS ProjectInternalID,
  I_GLAccountLineItemRawData.PartnerProjectInternalID AS PartnerProjectInternalID,
  I_GLAccountLineItemRawData.OperatingConcern AS OperatingConcern,
  I_GLAccountLineItemRawData.ProjectNetwork AS ProjectNetwork,
  I_GLAccountLineItemRawData.BusinessProcess AS BusinessProcess,
  I_GLAccountLineItemRawData.CostObject AS CostObject,
  I_GLAccountLineItemRawData.BillableControl AS BillableControl,
  I_GLAccountLineItemRawData.CostAnalysisResource AS CostAnalysisResource,
  I_GLAccountLineItemRawData.CustomerServiceNotification AS CustomerServiceNotification,
  I_GLAccountLineItemRawData.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountLineItemRawData.ServiceDocument AS ServiceDocument,
  I_GLAccountLineItemRawData.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAccountLineItemRawData.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  I_GLAccountLineItemRawData.PartnerServiceDocument AS PartnerServiceDocument,
  I_GLAccountLineItemRawData.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  I_GLAccountLineItemRawData.ServiceContractType AS ServiceContractType,
  I_GLAccountLineItemRawData.ServiceContract AS ServiceContract,
  I_GLAccountLineItemRawData.ServiceContractItem AS ServiceContractItem,
  I_GLAccountLineItemRawData.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  I_GLAccountLineItemRawData.PartnerAccountAssignment AS PartnerAccountAssignment,
  I_GLAccountLineItemRawData.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_GLAccountLineItemRawData.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  I_GLAccountLineItemRawData.PartnerOrder AS PartnerOrder,
  I_GLAccountLineItemRawData.PartnerOrderCategory AS PartnerOrderCategory,
  I_GLAccountLineItemRawData.PartnerSalesDocument AS PartnerSalesDocument,
  I_GLAccountLineItemRawData.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  I_GLAccountLineItemRawData.PartnerProjectNetwork AS PartnerProjectNetwork,
  I_GLAccountLineItemRawData.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAccountLineItemRawData.PartnerCostObject AS PartnerCostObject,
  I_GLAccountLineItemRawData.ControllingDocumentItem AS ControllingDocumentItem,
  I_GLAccountLineItemRawData.BillingDocumentType AS BillingDocumentType,
  I_GLAccountLineItemRawData.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItemRawData.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItemRawData.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItemRawData.SoldProduct AS SoldProduct,
  I_GLAccountLineItemRawData.SoldProductGroup AS SoldProductGroup,
  I_GLAccountLineItemRawData.CustomerGroup AS CustomerGroup,
  I_GLAccountLineItemRawData.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAccountLineItemRawData.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAccountLineItemRawData.SalesDistrict AS SalesDistrict,
  I_GLAccountLineItemRawData.BillToParty AS BillToParty,
  I_GLAccountLineItemRawData.ShipToParty AS ShipToParty,
  I_GLAccountLineItemRawData.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  I_GLAccountLineItemRawData._AccountingDocumentType AS _AccountingDocumentType,
  I_GLAccountLineItemRawData._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_GLAccountLineItemRawData._Order AS _Order,
  I_GLAccountLineItemRawData._SalesDocument AS _SalesDocument,
  I_GLAccountLineItemRawData._ServiceDocument AS _ServiceDocument
FROM I_GLAccountLineItemRawData
INNER JOIN I_CoCodeLedgerSourceLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN A_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN A_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN A_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;

Depth:

A_GLAccountLineItem view

I_GLAccountLineItemRawData view
I_CoCodeLedgerSourceLedger view_entity