I_GLAccountYearToDateBalanceC

DDL: I_GLACCOUNTYEARTODATEBALANCEC Type: view_entity COMPOSITE Package: FINS_FIS_FICO

G/L Account Balances - Cube

I_GLAccountYearToDateBalanceC (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_GLAccountYearToDateBalanceC is a Composite CDS View (Cube) that provides data about "G/L Account Balances - Cube" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 560 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 11 associations to related views. Part of development package FINS_FIS_FICO.

SAP Help Documentation

CategoryCDS Views for Transaction Data
Data CategoryCube
Purpose
This CDS view is designed to provide a comprehensive analytical cube for General Ledger (G/L) account balances, aggregating financial data across various dimensions and currencies. It serves as a composite view that integrates detailed line item data from the General Ledger, enabling users to analyze financial transactions and balances year-to-date. This CDS view provides the data to answer the following business questions: What are the year-to-date balances for specific G/L accounts across different currencies? How do financial transactions aggregate by fiscal year, period, and quarter? What is the impact of specific business transactions on G/L account balances? How do balances vary across different organizational units such as cost centers, profit centers, and segments? What are the debit and credit amounts in various currencies for specific G/L accounts? How do balances relate to specific projects, orders, and WBS elements? What are the financial impacts of specific asset transactions and depreciation areas? How do balances correlate with specific sales and purchasing documents? What are the balances associated with specific financial services products and branches? How do balances align with specific joint ventures and real estate contracts? What are the balances related to specific accrual objects and financial valuation objects? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations The corresponding restriction types must be set to read access. For a list of restriction types please see Authorizations in Analytics for Universal Journal . These restriction types are maintained in the Maintain Business Roles app.

Structure
Measures and Dimension The documentation includes all relevant dimensions and their associations with interface views for most dimensions. It contains measures such as the amount field for available currencies, along with debit and credit amounts for all available currencies. Needed Fields These fields are only technical and not needed for business logic. Key SourceLedger Key CompanyCode Key FiscalYear Key AccountingDocument Key LedgerGLLineItem Key Ledger Filter Fields Ledger CompanyCode LedgerFiscalYear PostingDate (as keydate) More Important Fields ChartOfAccounts GLAccount ControllingArea CostCenter ProfitCenter FiscalYearVariant FiscalYearPeriod FiscalQuarter FiscalPeriod DebitCreditCode CompanyCodeCurrency AmountInCompanyCodeCurrency (or any other amount in this view) – Measure CreditAmountInCoCodeCrcy – Measure DebitAmountInCoCodeCrcy – Measure More Fields Segment WBSElementInternalID WBSElementExternalID ProjectInternalID ProjectExternalID If you want to build a view on this view, these fields are at least recommended. In a query on top of this view or your own view you should not use the fields AccountingDocument , LedgerGLLineItem , DocumentItemText , AccountingDocCreatedByUser , LastChangeDateTime , CreationDateTime , CreationDate because these fields are Line item dependent and are not needed for a balance.

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-IS-2CL
CapabilitiesData Provider for Analytical Queries,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)Yes
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view is designed to provide a comprehensive analytical cube for General Ledger (G/L) account balances, aggregating financial data across various dimensions and currencies. It serves as a composite view that integrates detailed line item data from the General Ledger, enabling users to analyze financial transactions and balances year-to-date.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the year-to-date balances for specific G/L accounts across different currencies?</p></li> <li><p>How do financial transactions aggregate by fiscal year, period, and quarter?</p></li> <li><p>What is the impact of specific business transactions on G/L account balances?</p></li> <li><p>How do balances vary across different organizational units such as cost centers, profit centers, and segments?</p></li> <li><p>What are the debit and credit amounts in various currencies for specific G/L accounts?</p></li> <li><p>How do balances relate to specific projects, orders, and WBS elements?</p></li> <li><p>What are the financial impacts of specific asset transactions and depreciation areas?</p></li> <li><p>How do balances correlate with specific sales and purchasing documents?</p></li> <li><p>What are the balances associated with specific financial services products and branches?</p></li> <li><p>How do balances align with specific joint ventures and real estate contracts?</p></li> <li><p>What are the balances related to specific accrual objects and financial valuation objects?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem from

Associations (11)

CardinalityTargetAliasCondition
[0..1] I_ProjectByExternalID _ProjectExternalID $projection.ProjectExternalID = _ProjectExternalID.ProjectExternalID
[0..1] I_ProjectByExternalID _PartnerProjectExternalID $projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID
[0..1] I_WBSElementByExternalID _WBSElementExternalID $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID
[0..1] I_WBSElementByExternalID _PartnerWBSElementExternalID $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID
[0..1] I_JournalEntry _ClearingAccountingDocument $projection.CompanyCode = _ClearingAccountingDocument.CompanyCode and $projection.FiscalYear = _ClearingAccountingDocument.FiscalYear and $projection.ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument
[0..1] I_Order _PartnerOrder_2 $projection.PartnerOrder = _PartnerOrder_2.OrderID
[0..1] I_InternalOrder _PartnerOrder $projection.PartnerOrder = _PartnerOrder.InternalOrder
[0..1] I_FinServicesProductGroup _FinServicesProductGroup $projection.FinancialServicesProductGroup = _FinServicesProductGroup.FinancialServicesProductGroup
[0..1] I_FinancialServicesBranch _FinancialServicesBranch $projection.FinancialServicesBranch = _FinancialServicesBranch.FinancialServicesBranch
[0..1] I_FinancialDataSource _FinancialDataSource $projection.FinancialDataSource = _FinancialDataSource.FinancialDataSource
[0..1] I_CustomerSupplierIndustry _CustomerSupplierIndustry $projection.CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry

Annotations (17)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey LedgerGLLineItem view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.technicalName IFIGLACCTYTDBALC view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label G/L Account Balances - Cube view
AccessControl.auditFilter #ENABLED view
Environment.sql.passValueForClient true view

Fields (560)

KeyFieldSource TableSource FieldDescription
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 General Ledger Journal Entry Line Item
KEY Ledger I_GLAccountLineItem Ledger Ledger in General Ledger Accounting
LedgerFiscalYear I_GLAccountLineItem LedgerFiscalYear Fiscal Year of Ledger
GLRecordType I_GLAccountLineItem GLRecordType Record Type
ChartOfAccounts I_GLAccountLineItem ChartOfAccounts Chart of Accounts
ControllingArea I_GLAccountLineItem ControllingArea Controlling Area
FinancialTransactionType I_GLAccountLineItem FinancialTransactionType Financial Transaction Type
GLBusinessTransactionType I_GLAccountLineItem GLBusinessTransactionType Transaction Type for General Ledger
BusinessTransactionCategory I_GLAccountLineItem BusinessTransactionCategory Business Transaction Category
BusinessTransactionType I_GLAccountLineItem BusinessTransactionType Business Transaction Type
ControllingBusTransacType I_GLAccountLineItem ControllingBusTransacType CO Business Transaction
ReferenceDocumentType I_GLAccountLineItem ReferenceDocumentType Reference Document Type
LogicalSystem I_GLAccountLineItem LogicalSystem Logical System
ReferenceDocumentContext I_GLAccountLineItem ReferenceDocumentContext Reference Document Context
ReferenceDocument I_GLAccountLineItem ReferenceDocument Reference Doc. Number
ReferenceDocumentItem I_GLAccountLineItem ReferenceDocumentItem Reference Document Item
ReferenceDocumentItemGroup I_GLAccountLineItem ReferenceDocumentItemGroup Reference Document Item Group
TransactionSubitem I_GLAccountLineItem TransactionSubitem Partial Document to be balanced to zero
IsReversal I_GLAccountLineItem IsReversal Indicator: Item is Reversing Another Item
IsReversed I_GLAccountLineItem IsReversed Indicator: Item is Reversed
ReversalReferenceDocumentCntxt I_GLAccountLineItem ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument I_GLAccountLineItem ReversalReferenceDocument Reversal Reference Document
ReversalTransactionSubitem I_GLAccountLineItem ReversalTransactionSubitem Reversal Transaction Sub Item
IsSettlement I_GLAccountLineItem IsSettlement Indicator: Item is Settling or Transferring Another Item
IsSettled I_GLAccountLineItem IsSettled Indicator: Line Item is Settled or Transferred
PredecessorReferenceDocType I_GLAccountLineItem PredecessorReferenceDocType Predecessor Reference Document Type
PredecessorReferenceDocCntxt I_GLAccountLineItem PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocument I_GLAccountLineItem PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem I_GLAccountLineItem PredecessorReferenceDocItem Predecessor Reference Document Item
PrdcssrJournalEntryCompanyCode I_GLAccountLineItem PrdcssrJournalEntryCompanyCode Predecessor Journal Entry Company Code
PrdcssrJournalEntryFiscalYear I_GLAccountLineItem PrdcssrJournalEntryFiscalYear Predecessor Journal Entry Fiscal Year
PredecessorJournalEntry I_GLAccountLineItem PredecessorJournalEntry Preceding Journal Entry Document Number
PredecessorJournalEntryItem I_GLAccountLineItem PredecessorJournalEntryItem Preceding Journal Entry Line Item
SourceReferenceDocumentType I_GLAccountLineItem SourceReferenceDocumentType Source Reference Document Type
SourceLogicalSystem I_GLAccountLineItem SourceLogicalSystem Source Logical System
SourceReferenceDocumentCntxt I_GLAccountLineItem SourceReferenceDocumentCntxt Source Reference Document Context
SourceReferenceDocument I_GLAccountLineItem SourceReferenceDocument Source Reference Document
SourceReferenceDocumentItem I_GLAccountLineItem SourceReferenceDocumentItem Source Reference Document Item
SourceReferenceDocSubitem I_GLAccountLineItem SourceReferenceDocSubitem Source Reference Document Subitem
IsCommitment I_GLAccountLineItem IsCommitment Indicator: Is Commitment
JrnlEntryItemObsoleteReason I_GLAccountLineItem JrnlEntryItemObsoleteReason Journal Entry Item Obsolete Reason
JrnlPeriodEndClosingRunLogUUID I_GLAccountLineItem JrnlPeriodEndClosingRunLogUUID UUID of Financial Closing Run
OrganizationalChange I_GLAccountLineItem OrganizationalChange Organizational Change
GLAccount I_GLAccountLineItem GLAccount General Ledger
CostCenter I_GLAccountLineItem CostCenter Cost Center
ProfitCenter I_GLAccountLineItem ProfitCenter Profit Center
FunctionalArea I_GLAccountLineItem FunctionalArea Sendr Fctl Area
BusinessArea I_GLAccountLineItem BusinessArea Business Area
Segment I_GLAccountLineItem Segment Segment for Segmental Reporting
PartnerCostCenter I_GLAccountLineItem PartnerCostCenter Partner Cost Center
PartnerProfitCenter I_GLAccountLineItem PartnerProfitCenter Partner Profit Center
PartnerFunctionalArea I_GLAccountLineItem PartnerFunctionalArea Partner Functional Area
PartnerBusinessArea I_GLAccountLineItem PartnerBusinessArea Partner Business Area
PartnerCompany I_GLAccountLineItem PartnerCompany Company ID of Trading Partner
PartnerSegment I_GLAccountLineItem PartnerSegment Partner Segment for Segmental Reporting
BalanceTransactionCurrency I_GLAccountLineItem BalanceTransactionCurrency Balance Transaction Currency
AmountInBalanceTransacCrcy I_GLAccountLineItem AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
TransactionCurrency I_GLAccountLineItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_GLAccountLineItem AmountInTransactionCurrency Amount in Transaction Currency
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Company Code Currency
AmountInCompanyCodeCurrency I_GLAccountLineItem AmountInCompanyCodeCurrency Amount in Company Code Currency
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency I_GLAccountLineItem AmountInGlobalCurrency Amount in Global Currency
FunctionalCurrency I_GLAccountLineItem FunctionalCurrency Functional Currency
AmountInFunctionalCurrency I_GLAccountLineItem AmountInFunctionalCurrency Amount in Functional Currency
FreeDefinedCurrency1 I_GLAccountLineItem FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 I_GLAccountLineItem AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 I_GLAccountLineItem FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 I_GLAccountLineItem AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 I_GLAccountLineItem FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 I_GLAccountLineItem AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 I_GLAccountLineItem FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 I_GLAccountLineItem AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 I_GLAccountLineItem FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 I_GLAccountLineItem AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 I_GLAccountLineItem FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 I_GLAccountLineItem AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 I_GLAccountLineItem FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 I_GLAccountLineItem AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 I_GLAccountLineItem FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 I_GLAccountLineItem AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
FixedAmountInGlobalCrcy I_GLAccountLineItem FixedAmountInGlobalCrcy Fixed Amount in Global Currency
GrpValnFixedAmtInGlobCrcy I_GLAccountLineItem GrpValnFixedAmtInGlobCrcy Group Valuation Fixed Amount in Global Currency
PrftCtrValnFxdAmtInGlobCrcy I_GLAccountLineItem PrftCtrValnFxdAmtInGlobCrcy Profit Center Valuation Fixed Amount in Global Currency
TotalPriceVarcInGlobalCrcy I_GLAccountLineItem TotalPriceVarcInGlobalCrcy Total Price Variance in Global Currency
GrpValnTotPrcVarcInGlobCrcy I_GLAccountLineItem GrpValnTotPrcVarcInGlobCrcy Group Valuation Total Price Variance in Global Currency
PrftCtrValnTotPrcVarcInGlbCrcy I_GLAccountLineItem PrftCtrValnTotPrcVarcInGlbCrcy Profit Center Valuation Total Price Variance in Global Cur.
FixedPriceVarcInGlobalCrcy I_GLAccountLineItem FixedPriceVarcInGlobalCrcy Fixed Price Variance in Global Currency
GrpValnFixedPrcVarcInGlobCrcy I_GLAccountLineItem GrpValnFixedPrcVarcInGlobCrcy Group Valuation Fixed Price Variance in Global Currency
PrftCtrValnFxdPrcVarcInGlbCrcy I_GLAccountLineItem PrftCtrValnFxdPrcVarcInGlbCrcy Profit Center Valuation Fixed Price Variance in Global Cur.
FixedAmountInCoCodeCrcy I_GLAccountLineItem FixedAmountInCoCodeCrcy Fixed Amount in Company Currency
ControllingObjectCurrency I_GLAccountLineItem ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency I_GLAccountLineItem AmountInObjectCurrency Amount in Object Currency
GrantCurrency I_GLAccountLineItem GrantCurrency Grant Currency
AmountInGrantCurrency I_GLAccountLineItem AmountInGrantCurrency Grant Amount in Grant Currency
BaseUnit I_GLAccountLineItem BaseUnit Base Unit of Measure
Quantity I_GLAccountLineItem Quantity Quantity
FixedQuantity I_GLAccountLineItem FixedQuantity Fixed Quantity
CostSourceUnit I_GLAccountLineItem CostSourceUnit Cost Source Unit
ValuationQuantity I_GLAccountLineItem ValuationQuantity Valuation Quantity
ValuationFixedQuantity I_GLAccountLineItem ValuationFixedQuantity Valuation Fixed Quantity
ReferenceQuantityUnit I_GLAccountLineItem ReferenceQuantityUnit Unit of Measure for Reference Quantity
ReferenceQuantity I_GLAccountLineItem ReferenceQuantity Comm Refer Quantity
AdditionalQuantity1Unit I_GLAccountLineItem AdditionalQuantity1Unit Additional Quantity 1 Unit
AdditionalQuantity1 I_GLAccountLineItem AdditionalQuantity1 Additional Quantity 1
AdditionalQuantity2Unit I_GLAccountLineItem AdditionalQuantity2Unit Additional Quantity 2 Unit
AdditionalQuantity2 I_GLAccountLineItem AdditionalQuantity2 Additional Quantity 2
AdditionalQuantity3Unit I_GLAccountLineItem AdditionalQuantity3Unit Additional Quantity 3 Unit
AdditionalQuantity3 I_GLAccountLineItem AdditionalQuantity3 Additional Quantity 3
DebitCreditCode I_GLAccountLineItem DebitCreditCode Single-Character Flag
FiscalPeriod I_GLAccountLineItem FiscalPeriod Fiscal Period
FiscalYearVariant I_GLAccountLineItem FiscalYearVariant Fiscal Year Variant
FiscalYearPeriod I_GLAccountLineItem FiscalYearPeriod Fiscal Year Period
PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
FiscalQuarter Fiscal Quarter
DocumentDate I_GLAccountLineItem DocumentDate Journal Entry Date
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
AccountingDocumentItem I_GLAccountLineItem AccountingDocumentItem Journal Entry Posting View Item
AssignmentReference I_GLAccountLineItem AssignmentReference Assignment Reference
AccountingDocumentCategory I_GLAccountLineItem AccountingDocumentCategory Journal Entry Category
PostingKey I_GLAccountLineItem PostingKey Posting Key
TransactionTypeDetermination I_GLAccountLineItem TransactionTypeDetermination Transaction Key
SubLedgerAcctLineItemType I_GLAccountLineItem SubLedgerAcctLineItemType Subledger-Specific Line Item Type
AccountingDocCreatedByUser I_GLAccountLineItem AccountingDocCreatedByUser User which created overhead document
LastChangeDateTime I_GLAccountLineItem LastChangeDateTime Last Change Date Time
CreationDateTime I_GLAccountLineItem CreationDateTime Creation Date Time
CreationDate I_GLAccountLineItem CreationDate Creation Date
EliminationProfitCenter I_GLAccountLineItem EliminationProfitCenter Elimination Profit Center
OriginObjectType I_GLAccountLineItem OriginObjectType Type of Origin Object
GLAccountType I_GLAccountLineItem GLAccountType Type of a General Ledger Account
AlternativeGLAccount I_GLAccountLineItem AlternativeGLAccount Alternative G/L Account Number In Company Code
CountryChartOfAccounts I_GLAccountLineItem CountryChartOfAccounts Alternative Chart of Accounts for Country/Region
ItemIsSplit I_GLAccountLineItem ItemIsSplit Item changed by document splitting
ConsolidationUnit I_GLAccountLineItem ConsolidationUnit Consolidation Unit
PartnerConsolidationUnit I_GLAccountLineItem PartnerConsolidationUnit Partner Consolidation Unit
Company I_GLAccountLineItem Company Company
ConsolidationChartOfAccounts I_GLAccountLineItem ConsolidationChartOfAccounts Consolidation Chart of Accounts
CnsldtnFinancialStatementItem I_GLAccountLineItem CnsldtnFinancialStatementItem Consolidation Financial Statement Item
CnsldtnSubitemCategory I_GLAccountLineItem CnsldtnSubitemCategory Consolidation Subitem Category
CnsldtnSubitem I_GLAccountLineItem CnsldtnSubitem Consolidation Subitem
InvoiceReference I_GLAccountLineItem InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear I_GLAccountLineItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
FollowOnDocumentType I_GLAccountLineItem FollowOnDocumentType Follow-On Document Type
InvoiceItemReference I_GLAccountLineItem InvoiceItemReference Invoice Item Reference
ReferencePurchaseOrderCategory I_GLAccountLineItem ReferencePurchaseOrderCategory Category of Reference Purchase Order
PurchasingDocument I_GLAccountLineItem PurchasingDocument Purchasing Document
PurchasingDocumentItem I_GLAccountLineItem PurchasingDocumentItem Purchasing Document Item
AccountAssignmentNumber I_GLAccountLineItem AccountAssignmentNumber Account Assignment Number
DocumentItemText I_GLAccountLineItem DocumentItemText Item Text
SalesDocument I_GLAccountLineItem SalesDocument Sales Document
SalesDocumentItem I_GLAccountLineItem SalesDocumentItem Sales Document Item
Product I_GLAccountLineItem Product Product Sold
Plant I_GLAccountLineItem Plant Valuation Area
Supplier I_GLAccountLineItem Supplier Supplier
Customer I_GLAccountLineItem Customer Customer Number
ServicesRenderedDate I_GLAccountLineItem ServicesRenderedDate Date on which services are rendered
ConditionContract I_GLAccountLineItem ConditionContract Condition Contract
FinancialAccountType I_GLAccountLineItem FinancialAccountType Fin. Account Type
SpecialGLCode I_GLAccountLineItem SpecialGLCode Special G/L Indicator
TaxCode I_GLAccountLineItem TaxCode Tax on Sales/Purchases Code
TaxCountry I_GLAccountLineItem TaxCountry Tax Reporting Country/Region
HouseBank I_GLAccountLineItem HouseBank House Bank Key
HouseBankAccount I_GLAccountLineItem HouseBankAccount House Bank Account
ClearingDate I_GLAccountLineItem ClearingDate Clearing Date
ClearingAccountingDocument I_GLAccountLineItem ClearingAccountingDocument Clearing Journal Entry (Deprecated)
ClearingDocFiscalYear I_GLAccountLineItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry (Deprecated)
ClearingJournalEntry ClearingJournalEntry Clearing Journal Entry
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ValueDate I_GLAccountLineItem ValueDate Value Date
AssetDepreciationArea I_GLAccountLineItem AssetDepreciationArea Asset Depreciation Area (Real or Derived)
MasterFixedAsset I_GLAccountLineItem MasterFixedAsset Fixed Asset (Main Asset Number)
FixedAsset I_GLAccountLineItem FixedAsset Asset Subnumber
AssetValueDate I_GLAccountLineItem AssetValueDate Asset Value Date
AssetTransactionType I_GLAccountLineItem AssetTransactionType Asset Transaction Type
AssetAcctTransClassfctn I_GLAccountLineItem AssetAcctTransClassfctn Transaction Type Category
DepreciationFiscalPeriod I_GLAccountLineItem DepreciationFiscalPeriod Fiscal Period of Depreciation
GroupMasterFixedAsset I_GLAccountLineItem GroupMasterFixedAsset Group Asset
GroupFixedAsset I_GLAccountLineItem GroupFixedAsset Group Asset Subnumber
AssetClass I_GLAccountLineItem AssetClass Asset Class
PartnerMasterFixedAsset I_GLAccountLineItem PartnerMasterFixedAsset Partner Fixed Asset (Partner Main Asset Number)
PartnerFixedAsset I_GLAccountLineItem PartnerFixedAsset Partner Asset Subnumber
CostEstimate I_GLAccountLineItem CostEstimate Cost EstimateNo
InventorySpecialStockValnType I_GLAccountLineItem InventorySpecialStockValnType Inventory Special Stock Valuation Type (Deprecated)
InventorySpecialStockType I_GLAccountLineItem InventorySpecialStockType Inventory Special Stock Type
InventorySpclStkSalesDocument I_GLAccountLineItem InventorySpclStkSalesDocument Inventory Special Stock Sales Document
InventorySpclStkSalesDocItm I_GLAccountLineItem InventorySpclStkSalesDocItm Inventory Special Stock Sales Document Item
InvtrySpclStockWBSElmntIntID I_GLAccountLineItem InvtrySpclStockWBSElmntIntID Inventory Special Stock WBS Element Internal ID
InventorySpecialStockSupplier I_GLAccountLineItem InventorySpecialStockSupplier Supplier of Inventory Special Stock
InventoryValuationType I_GLAccountLineItem InventoryValuationType Inventory Valuation Type
ValuationArea I_GLAccountLineItem ValuationArea Valuation Area
SenderGLAccount I_GLAccountLineItem SenderGLAccount Sender G/L Account
SenderAccountAssignment I_GLAccountLineItem SenderAccountAssignment Sender Account Assignment
SenderAccountAssignmentType I_GLAccountLineItem SenderAccountAssignmentType Account Assignment Type in Sender System
CostOriginGroup I_GLAccountLineItem CostOriginGroup Origin Group as Subdivision of Cost Element
OriginSenderObject I_GLAccountLineItem OriginSenderObject Origin Sender Object
ControllingDebitCreditCode I_GLAccountLineItem ControllingDebitCreditCode Controlling Debit Credit Code
ControllingObjectDebitType I_GLAccountLineItem ControllingObjectDebitType Controlling Object Debit Type
QuantityIsIncomplete I_GLAccountLineItem QuantityIsIncomplete Indicator: Quantity is Incomplete
OffsettingAccount I_GLAccountLineItem OffsettingAccount Offsetting Account
OffsettingAccountType I_GLAccountLineItem OffsettingAccountType Offsetting Account Type
OffsettingChartOfAccounts I_GLAccountLineItem OffsettingChartOfAccounts Offsetting Chart of Accounts
LineItemIsCompleted I_GLAccountLineItem LineItemIsCompleted Indicator: Line Item is Completed
PersonnelNumber I_GLAccountLineItem PersonnelNumber Personnel Number
ControllingObjectClass I_GLAccountLineItem ControllingObjectClass Controlling Object Class
PartnerCompanyCode I_GLAccountLineItem PartnerCompanyCode Partner Company Code
PartnerControllingObjectClass I_GLAccountLineItem PartnerControllingObjectClass Partner Controlling Object Class
OriginCostCenter I_GLAccountLineItem OriginCostCenter Origin Cost Center
OriginProfitCenter I_GLAccountLineItem OriginProfitCenter Origin Profit Center
OriginCostCtrActivityType I_GLAccountLineItem OriginCostCtrActivityType Origin Cost Center Activity Type
OriginProduct I_GLAccountLineItem OriginProduct Origin Product
VarianceOriginGLAccount I_GLAccountLineItem VarianceOriginGLAccount Origin G/L Account of a Variance
AccountAssignment I_GLAccountLineItem AccountAssignment Sender Acct Assgmt
AccountAssignmentType I_GLAccountLineItem AccountAssignmentType Account Assignment Type
CostCtrActivityType I_GLAccountLineItem CostCtrActivityType Activity Type
OrderID I_GLAccountLineItem OrderID Order ID
OrderCategory I_GLAccountLineItem OrderCategory Order Category
WBSElementInternalID I_GLAccountLineItem WBSElementInternalID WBS Element Internal ID
WBSElementExternalID WBS Element External ID
PartnerWBSElementInternalID I_GLAccountLineItem PartnerWBSElementInternalID Partner WBS Element Internal ID
PartnerWBSElementExternalID Partner WBS Element External ID
ProjectInternalID I_GLAccountLineItem ProjectInternalID Project Internal ID
ProjectExternalID Project External ID
PartnerProjectInternalID I_GLAccountLineItem PartnerProjectInternalID Partner Project Internal ID
PartnerProjectExternalID Partner Project External ID
OperatingConcern I_GLAccountLineItem OperatingConcern Operating concern
ProjectNetwork I_GLAccountLineItem ProjectNetwork Network Number for Account Assignment
BusinessProcess I_GLAccountLineItem BusinessProcess Business Process
CostObject I_GLAccountLineItem CostObject Cost Object
BillableControl I_GLAccountLineItem BillableControl Billable Control
CostAnalysisResource I_GLAccountLineItem CostAnalysisResource Cost Analysis Resource
CustomerServiceNotification I_GLAccountLineItem CustomerServiceNotification Customer Service Notification
ServiceDocumentType I_GLAccountLineItem ServiceDocumentType Service Document Type
ServiceDocument I_GLAccountLineItem ServiceDocument Service Document ID
ServiceDocumentItem I_GLAccountLineItem ServiceDocumentItem Service Document Item ID
PartnerServiceDocumentType I_GLAccountLineItem PartnerServiceDocumentType Partner Service Document Type
PartnerServiceDocument I_GLAccountLineItem PartnerServiceDocument Partner Service Document
PartnerServiceDocumentItem I_GLAccountLineItem PartnerServiceDocumentItem Partner Service Document Item
ServiceContractType I_GLAccountLineItem ServiceContractType Service Contract Type
ServiceContract I_GLAccountLineItem ServiceContract Service Contract ID
ServiceContractItem I_GLAccountLineItem ServiceContractItem Service Contract Item ID
BusinessSolutionOrder I_GLAccountLineItem BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem I_GLAccountLineItem BusinessSolutionOrderItem Solution Order Item
ProviderContract I_GLAccountLineItem ProviderContract Provider Contract
ProviderContractItem I_GLAccountLineItem ProviderContractItem Provider Contract Item
TimeSheetOvertimeCategory I_GLAccountLineItem TimeSheetOvertimeCategory Overtime Category
PartnerAccountAssignment I_GLAccountLineItem PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType I_GLAccountLineItem PartnerAccountAssignmentType Partner Account Assignment Type
PartnerCostCtrActivityType I_GLAccountLineItem PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerOrder I_GLAccountLineItem PartnerOrder_2 Partner Order
PartnerOrderCategory I_GLAccountLineItem PartnerOrderCategory Partner Order Category
PartnerSalesDocument I_GLAccountLineItem PartnerSalesDocument Partner Sales Document
PartnerSalesDocumentItem I_GLAccountLineItem PartnerSalesDocumentItem Partner Sales Document Item
PartnerProjectNetwork I_GLAccountLineItem PartnerProjectNetwork Partner Project Network
PartnerBusinessProcess I_GLAccountLineItem PartnerBusinessProcess Partner Business Process
PartnerCostObject I_GLAccountLineItem PartnerCostObject Partner Cost Object
ControllingDocumentItem I_GLAccountLineItem ControllingDocumentItem Controlling Document Item
BillingDocumentType I_GLAccountLineItem BillingDocumentType Billing Type
SalesOrganization I_GLAccountLineItem SalesOrganization Sales Organization
DistributionChannel I_GLAccountLineItem DistributionChannel Distribution Channel
OrganizationDivision I_GLAccountLineItem OrganizationDivision Org. Division
SoldProduct I_GLAccountLineItem SoldProduct Product Sold
SoldProductGroup I_GLAccountLineItem SoldProductGroup Product Sold Group
CustomerGroup I_GLAccountLineItem CustomerGroup Customer Group
CustomerSupplierCountry I_GLAccountLineItem CustomerSupplierCountry Customer or Supplier Country/Region
CustomerSupplierIndustry I_GLAccountLineItem CustomerSupplierIndustry Customer Supplier Industry
SalesDistrict I_GLAccountLineItem SalesDistrict Sales District
BillToParty I_GLAccountLineItem BillToParty Inv. Recipient
ShipToParty I_GLAccountLineItem ShipToParty Ship-To Party (obsolete)
CustomerSupplierCorporateGroup I_GLAccountLineItem CustomerSupplierCorporateGroup Customer Supplier Corporate Group
CashLedgerCompanyCode I_GLAccountLineItem CashLedgerCompanyCode Cash Origin Company Code
CashLedgerAccount I_GLAccountLineItem CashLedgerAccount Cash Origin Account
FinancialManagementArea I_GLAccountLineItem FinancialManagementArea Financial Management Area
FundsCenter I_GLAccountLineItem FundsCenter Funds Management Center
FundedProgram I_GLAccountLineItem FundedProgram Funded Program
Fund I_GLAccountLineItem Fund Sender Fund
GrantID I_GLAccountLineItem GrantID Sender Grant
BudgetPeriod I_GLAccountLineItem BudgetPeriod Budget Period
PartnerFund I_GLAccountLineItem PartnerFund Receiver Fund
PartnerGrant I_GLAccountLineItem PartnerGrant Receiver Grant
PartnerBudgetPeriod I_GLAccountLineItem PartnerBudgetPeriod FM: Partner Budget Period
PubSecBudgetAccount I_GLAccountLineItem PubSecBudgetAccount Budget Account
PubSecBudgetAccountCoCode I_GLAccountLineItem PubSecBudgetAccountCoCode Company Code for Budget Account
PubSecBudgetCnsmpnDate I_GLAccountLineItem PubSecBudgetCnsmpnDate Budget Consumption Date
PubSecBudgetCnsmpnFsclPeriod I_GLAccountLineItem PubSecBudgetCnsmpnFsclPeriod CC Fiscal Period for Budget Consumption Date
PubSecBudgetCnsmpnFsclYear I_GLAccountLineItem PubSecBudgetCnsmpnFsclYear CC Fiscal Year for Budget Consumption Date
PubSecBudgetIsRelevant I_GLAccountLineItem PubSecBudgetIsRelevant Budget-Relevant Indicator
PubSecBudgetCnsmpnType I_GLAccountLineItem PubSecBudgetCnsmpnType Budget Consumption Type
PubSecBudgetCnsmpnAmtType I_GLAccountLineItem PubSecBudgetCnsmpnAmtType Budget Consumption Amount Type
SponsoredProgram I_GLAccountLineItem SponsoredProgram Sponsored Program
SponsoredClass I_GLAccountLineItem SponsoredClass Sponsored Class
GteeMBudgetValidityNumber I_GLAccountLineItem GteeMBudgetValidityNumber Budget Validity Number
FinancialServicesProductGroup I_GLAccountLineItem FinancialServicesProductGroup Financial Services Product Group
FinancialServicesBranch I_GLAccountLineItem FinancialServicesBranch Financial Services Branch
FinancialDataSource I_GLAccountLineItem FinancialDataSource Financial Data Source
JointVenture I_GLAccountLineItem JointVenture Joint venture
JointVentureEquityGroup I_GLAccountLineItem JointVentureEquityGroup Joint Venture Equity Group
JointVentureCostRecoveryCode I_GLAccountLineItem JointVentureCostRecoveryCode Joint Venture Cost Recovery Code
JointVenturePartner I_GLAccountLineItem JointVenturePartner Joint Venture Partner
JointVentureBillingType I_GLAccountLineItem JointVentureBillingType Joint Venture Billing Type
JointVentureEquityType I_GLAccountLineItem JointVentureEquityType Joint Venture Equity Type
JointVentureProductionDate I_GLAccountLineItem JointVentureProductionDate Joint Venture Production Date
JointVentureBillingDate I_GLAccountLineItem JointVentureBillingDate Joint Venture Billing Date
JointVentureOperationalDate I_GLAccountLineItem JointVentureOperationalDate Joint Venture Operational Date
JointVentureAccountingActivity I_GLAccountLineItem JointVentureAccountingActivity Joint Venture Accounting Activity
PartnerVenture I_GLAccountLineItem PartnerVenture Partner Venture
PartnerEquityGroup I_GLAccountLineItem PartnerEquityGroup Partner Equity Group
SenderCostRecoveryCode I_GLAccountLineItem SenderCostRecoveryCode Sender Cost Recovery Code
REBusinessEntity I_GLAccountLineItem REBusinessEntity RE Business Entity
RealEstateBuilding I_GLAccountLineItem RealEstateBuilding Real Estate Building
RealEstateProperty I_GLAccountLineItem RealEstateProperty Real Estate Property
RERentalObject I_GLAccountLineItem RERentalObject RE Rental Object
RealEstateContract I_GLAccountLineItem RealEstateContract Real Estate Contract Number
REServiceChargeKey I_GLAccountLineItem REServiceChargeKey RE Service Charge Key
RESettlementUnitID I_GLAccountLineItem RESettlementUnitID RE Settlement Unit
SettlementReferenceDate I_GLAccountLineItem SettlementReferenceDate Settlement Reference Date
REPartnerBusinessEntity I_GLAccountLineItem REPartnerBusinessEntity RE Partner Business Entity
RealEstatePartnerBuilding I_GLAccountLineItem RealEstatePartnerBuilding Real Estate Partner Building
RealEstatePartnerProperty I_GLAccountLineItem RealEstatePartnerProperty Real Estate Partner Property
REPartnerRentalObject I_GLAccountLineItem REPartnerRentalObject RE Partner Rental Object
RealEstatePartnerContract I_GLAccountLineItem RealEstatePartnerContract Real Estate Partner Contract
REPartnerServiceChargeKey I_GLAccountLineItem REPartnerServiceChargeKey RE Partner Service Charge Key
REPartnerSettlementUnitID I_GLAccountLineItem REPartnerSettlementUnitID RE Partner Settlement Unit
PartnerSettlementReferenceDate I_GLAccountLineItem PartnerSettlementReferenceDate Partner Reference Date for Settlement
AccrualObjectType I_GLAccountLineItem AccrualObjectType Type of the Accrual Object
AccrualObject I_GLAccountLineItem AccrualObject External Reference of Accrual Object
AccrualSubobject I_GLAccountLineItem AccrualSubobject External Reference of Accrual Subobject
AccrualItemType I_GLAccountLineItem AccrualItemType Type of the Item of the Accrual Subobject
AccrualValueDate I_GLAccountLineItem AccrualValueDate Accrual Value Date
FinancialValuationObjectType I_GLAccountLineItem FinancialValuationObjectType Financial Valuation Object Type
FinancialValuationObject I_GLAccountLineItem FinancialValuationObject Financial Valuation Object
FinancialValuationSubobject I_GLAccountLineItem FinancialValuationSubobject Financial Valuation Subobject
NetDueDate I_GLAccountLineItem NetDueDate Net Due Date
CreditRiskClass I_GLAccountLineItem CreditRiskClass Credit Risk Class
WorkCenterInternalID I_GLAccountLineItem WorkCenterInternalID Object ID of the resource
OrderItem I_GLAccountLineItem OrderItem Number of Order Item
PartnerOrderItem I_GLAccountLineItem PartnerOrderItem Partner Order Item Number
Equipment I_GLAccountLineItem Equipment Equipment Number
FunctionalLocation I_GLAccountLineItem FunctionalLocation Functional Location
Assembly I_GLAccountLineItem Assembly Pegged Reqmt
MaintenanceActivityType I_GLAccountLineItem MaintenanceActivityType Maintenance activity type
MaintenanceOrderPlanningCode I_GLAccountLineItem MaintenanceOrderPlanningCode Maintenance order planning indicator
MaintPriorityType I_GLAccountLineItem MaintPriorityType Priority Type
MaintPriority I_GLAccountLineItem MaintPriority Priority
SuperiorOrder I_GLAccountLineItem SuperiorOrder Number of Superior Order
ProductGroup I_GLAccountLineItem ProductGroup Product Group for Maintenance Orders
MaintenanceOrderIsPlanned I_GLAccountLineItem MaintenanceOrderIsPlanned Planned Parts/Work
DebitAmountInCoCodeCrcy I_GLAccountLineItem DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy I_GLAccountLineItem CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
DebitAmountInTransCrcy I_GLAccountLineItem DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy I_GLAccountLineItem CreditAmountInTransCrcy Credit Amount in Transaction Currency
DebitAmountInBalanceTransCrcy I_GLAccountLineItem DebitAmountInBalanceTransCrcy Debit Amount in Balance Transaction Currency
CreditAmountInBalanceTransCrcy I_GLAccountLineItem CreditAmountInBalanceTransCrcy Credit Amount in Balance Transaction Currency
DebitAmountInGlobalCrcy I_GLAccountLineItem DebitAmountInGlobalCrcy Debit Amount in Global Currency
CreditAmountInGlobalCrcy I_GLAccountLineItem CreditAmountInGlobalCrcy Credit Amount in Global Currency
DebitAmountInFunctionalCrcy I_GLAccountLineItem DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy I_GLAccountLineItem CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
DebitAmountInFreeDfndCrcy1 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy1 Debit Amount in Free Defined Currency 1
CreditAmountInFreeDfndCrcy1 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy1 Credit Amount in Free Defined Currency 1
DebitAmountInFreeDfndCrcy2 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy2 Debit Amount in Free Defined Currency 2
CreditAmountInFreeDfndCrcy2 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy2 Credit Amount in Free Defined Currency 2
DebitAmountInFreeDfndCrcy3 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy3 Debit Amount in Free Defined Currency 3
CreditAmountInFreeDfndCrcy3 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy3 Credit Amount in Free Defined Currency 3
DebitAmountInFreeDfndCrcy4 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy4 Debit Amount in Free Defined Currency 4
CreditAmountInFreeDfndCrcy4 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy4 Credit Amount in Free Defined Currency 4
DebitAmountInFreeDfndCrcy5 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy5 Debit Amount in Free Defined Currency 5
CreditAmountInFreeDfndCrcy5 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy5 Credit Amount in Free Defined Currency 5
DebitAmountInFreeDfndCrcy6 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy6 Debit Amount in Free Defined Currency 6
CreditAmountInFreeDfndCrcy6 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy6 Credit Amount in Free Defined Currency 6
DebitAmountInFreeDfndCrcy7 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy7 Debit Amount in Free Defined Currency 7
CreditAmountInFreeDfndCrcy7 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy7 Credit Amount in Free Defined Currency 7
DebitAmountInFreeDfndCrcy8 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy8 Debit Amount in Free Defined Currency 8
CreditAmountInFreeDfndCrcy8 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy8 Credit Amount in Free Defined Currency 8
IsStatisticalOrder I_GLAccountLineItem IsStatisticalOrder Indicator: Internal Order is Statistical Account Assignment
IsStatisticalCostCenter I_GLAccountLineItem IsStatisticalCostCenter Indicator: Cost Center is Statistical Account Assignment
IsStatisticalSalesDocument I_GLAccountLineItem IsStatisticalSalesDocument Sales Document is statistical
WBSIsStatisticalWBSElement I_GLAccountLineItem WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment
CalendarYear I_GLAccountLineItem CalendarYear Calendar Year
CalendarQuarter I_GLAccountLineItem CalendarQuarter Calendar Quarter
CalendarYearQuarter I_GLAccountLineItem CalendarYearQuarter Year Quarter
CalendarMonth I_GLAccountLineItem CalendarMonth Calendar Month
CalendarYearMonth I_GLAccountLineItem CalendarYearMonth Year Month
CalendarWeek I_GLAccountLineItem CalendarWeek Calendar Week
CalendarYearWeek I_GLAccountLineItem CalendarYearWeek Year Week
_Assembly I_GLAccountLineItem _Assembly
_AlternativeGLAccount I_GLAccountLineItem _AlternativeGLAccount
_AdditionalQuantity3Unit I_GLAccountLineItem _AdditionalQuantity3Unit
_AssetTransactionType I_GLAccountLineItem _AssetTransactionType
_BalanceTransactionCurrency I_GLAccountLineItem _BalanceTransactionCurrency
_BaseUnit I_GLAccountLineItem _BaseUnit
_AdditionalQuantity2Unit I_GLAccountLineItem _AdditionalQuantity2Unit
_AdditionalQuantity1Unit I_GLAccountLineItem _AdditionalQuantity1Unit
_AccountingDocumentType I_GLAccountLineItem _AccountingDocumentType
_AccountingDocumentCategory I_GLAccountLineItem _AccountingDocumentCategory
_BillableControl I_GLAccountLineItem _BillableControl
_BillingDocumentType I_GLAccountLineItem _BillingDocumentType
_BudgetPeriod I_GLAccountLineItem _BudgetPeriod
_BusinessArea I_GLAccountLineItem _BusinessArea
_BusinessProcess I_GLAccountLineItem _BusinessProcess
_BusinessTransactionCategory I_GLAccountLineItem _BusinessTransactionCategory
_BusinessTransactionType I_GLAccountLineItem _BusinessTransactionType
_CashLedgerAccount I_GLAccountLineItem _CashLedgerAccount
_CashLedgerCompanyCode I_GLAccountLineItem _CashLedgerCompanyCode
_ChartOfAccounts I_GLAccountLineItem _ChartOfAccounts
_ClearingJrnlEntryFiscalYear I_GLAccountLineItem _ClearingJrnlEntryFiscalYear
_ClearingJournalEntry I_GLAccountLineItem _ClearingJournalEntry
_ClearingAccountingDocument _ClearingAccountingDocument
_CnsldtnFinancialStatementItem I_GLAccountLineItem _CnsldtnFinancialStatementItem
_CnsldtnSubitem I_GLAccountLineItem _CnsldtnSubitem
_CnsldtnSubitemCategory I_GLAccountLineItem _CnsldtnSubitemCategory
_Company I_GLAccountLineItem _Company
_CompanyCode I_GLAccountLineItem _CompanyCode
_CompanyCodeCurrency I_GLAccountLineItem _CompanyCodeCurrency
_ConditionContract I_GLAccountLineItem _ConditionContract
_ConsolidationChartOfAccounts I_GLAccountLineItem _ConsolidationChartOfAccounts
_ConsolidationUnit I_GLAccountLineItem _ConsolidationUnit
_ControllingArea I_GLAccountLineItem _ControllingArea
_ControllingDebitCreditCode I_GLAccountLineItem _ControllingDebitCreditCode
_ControllingObjectClass I_GLAccountLineItem _ControllingObjectClass
_CostAnalysisResource I_GLAccountLineItem _CostAnalysisResource
_CostCenter I_GLAccountLineItem _CostCenter
_CostCtrActivityType I_GLAccountLineItem _CostCtrActivityType
_CostOriginGroup I_GLAccountLineItem _CostOriginGroup
_CostSourceUnit I_GLAccountLineItem _CostSourceUnit
_CountryChartOfAccounts I_GLAccountLineItem _CountryChartOfAccounts
_CurrentProfitCenter I_GLAccountLineItem _CurrentProfitCenter
_CurrentCostCenter I_GLAccountLineItem _CurrentCostCenter
_Customer I_GLAccountLineItem _Customer
_CustomerCompany I_GLAccountLineItem _CustomerCompany
_CustomerGroup I_GLAccountLineItem _CustomerGroup
_DebitCreditCode I_GLAccountLineItem _DebitCreditCode
_DistributionChannel I_GLAccountLineItem _DistributionChannel
_EliminationProfitCenter I_GLAccountLineItem _EliminationProfitCenter
_Equipment I_GLAccountLineItem _Equipment
_FinancialAccountType I_GLAccountLineItem _FinancialAccountType
_FinancialManagementArea I_GLAccountLineItem _FinancialManagementArea
_FinancialTransactionType I_GLAccountLineItem _FinancialTransactionType
_FiscalPeriodForVariant I_GLAccountLineItem _FiscalPeriodForVariant
_FiscalYear I_GLAccountLineItem _FiscalYear
_FiscalYearPeriodForVariant I_GLAccountLineItem _FiscalYearPeriodForVariant
_FiscalYearVariant I_GLAccountLineItem _FiscalYearVariant
_FixedAsset I_GLAccountLineItem _FixedAsset
_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
_FunctionalArea I_GLAccountLineItem _FunctionalArea
_FunctionalCurrency I_GLAccountLineItem _FunctionalCurrency
_FunctionalLocation I_GLAccountLineItem _FunctionalLocation
_Fund I_GLAccountLineItem _Fund
_FundedProgram I_GLAccountLineItem _FundedProgram
_GLAccountInChartOfAccounts I_GLAccountLineItem _GLAccountInChartOfAccounts
_GLAccountInCompanyCode I_GLAccountLineItem _GLAccountInCompanyCode
_GLAccountType I_GLAccountLineItem _GLAccountType
_GlobalCurrency I_GLAccountLineItem _GlobalCurrency
_Grant I_GLAccountLineItem _Grant
_GroupFixedAsset I_GLAccountLineItem _GroupFixedAsset
_GroupMasterFixedAsset I_GLAccountLineItem _GroupMasterFixedAsset
_HouseBank I_GLAccountLineItem _HouseBank
_InventorySpclStkSalesDocItm I_GLAccountLineItem _InventorySpclStkSalesDocItm
_InventorySpclStkSalesDocument I_GLAccountLineItem _InventorySpclStkSalesDocument
_InventorySpecialStockType I_GLAccountLineItem _InventorySpecialStockType
_InventoryValuationType I_GLAccountLineItem _InventoryValuationType
_InvtrySpclStkWBSElmntBscData I_GLAccountLineItem _InvtrySpclStkWBSElmntBscData
_JournalEntry I_GLAccountLineItem _JournalEntry
_Ledger I_GLAccountLineItem _Ledger
_LedgerFiscalYearForVariant I_GLAccountLineItem _LedgerFiscalYearForVariant
_MaintenanceActivityType I_GLAccountLineItem _MaintenanceActivityType
_MaintOrdPlngDegreeCode I_GLAccountLineItem _MaintOrdPlngDegreeCode
_MasterFixedAsset I_GLAccountLineItem _MasterFixedAsset
_MovementCategory I_GLAccountLineItem _MovementCategory
_OffsettingAccountType I_GLAccountLineItem _OffsettingAccountType
_OffsettingAccountWithBP I_GLAccountLineItem _OffsettingAccountWithBP
_OffsettingChartOfAccounts I_GLAccountLineItem _OffsettingChartOfAccounts
_Order I_GLAccountLineItem _Order
_OrderCategory I_GLAccountLineItem _OrderCategory
_OriginCostCenter I_GLAccountLineItem _OriginCostCenter
_OriginCostCtrActivityType I_GLAccountLineItem _OriginCostCtrActivityType
_OriginProfitCenter I_GLAccountLineItem _OriginProfitCenter
_OriginSenderObject I_GLAccountLineItem _OriginSenderObject
_PartnerBudgetPeriod I_GLAccountLineItem _PartnerBudgetPeriod
_PartnerBusinessArea I_GLAccountLineItem _PartnerBusinessArea
_PartnerBusinessProcess I_GLAccountLineItem _PartnerBusinessProcess
_PartnerCompany I_GLAccountLineItem _PartnerCompany
_PartnerCompanyCode I_GLAccountLineItem _PartnerCompanyCode
_PartnerConsolidationUnit I_GLAccountLineItem _PartnerConsolidationUnit
_PartnerControllingObjectClass I_GLAccountLineItem _PartnerControllingObjectClass
_PartnerCostCenter I_GLAccountLineItem _PartnerCostCenter
_PartnerProjectBasicData I_GLAccountLineItem _PartnerProjectBasicData
_PartnerProfitCenter I_GLAccountLineItem _PartnerProfitCenter
_PartnerSalesDocument I_GLAccountLineItem _PartnerSalesDocument
_PartnerOrderCategory I_GLAccountLineItem _PartnerOrderCategory
_PartnerOrder _PartnerOrder
_PartnerOrder_2 _PartnerOrder_2
_PartnerMasterFixedAsset I_GLAccountLineItem _PartnerMasterFixedAsset
_PartnerGrant I_GLAccountLineItem _PartnerGrant
_PartnerFund I_GLAccountLineItem _PartnerFund
_PartnerFunctionalArea I_GLAccountLineItem _PartnerFunctionalArea
_PartnerFixedAsset I_GLAccountLineItem _PartnerFixedAsset
_PartnerCostCtrActivityType I_GLAccountLineItem _PartnerCostCtrActivityType
_PartnerProjectExternalID _PartnerProjectExternalID
_PartnerSalesDocumentItem I_GLAccountLineItem _PartnerSalesDocumentItem
_PartnerServiceDocument I_GLAccountLineItem _PartnerServiceDocument
_PartnerServiceDocumentItem I_GLAccountLineItem _PartnerServiceDocumentItem
_PartnerServiceDocumentType I_GLAccountLineItem _PartnerServiceDocumentType
_PartnerWBSElementBasicData I_GLAccountLineItem _PartnerWBSElementBasicData
_PartnerWBSElementExternalID _PartnerWBSElementExternalID
_Plant I_GLAccountLineItem _Plant
_PostingKey I_GLAccountLineItem _PostingKey
_PredecessorReferenceDocType I_GLAccountLineItem _PredecessorReferenceDocType
_Product I_GLAccountLineItem _Product
_ProductGroup_2 I_GLAccountLineItem _ProductGroup_2
_ProfitCenter I_GLAccountLineItem _ProfitCenter
_ProjectBasicData I_GLAccountLineItem _ProjectBasicData
_ProjectExternalID _ProjectExternalID
_ProviderContract I_GLAccountLineItem _ProviderContract
_ProviderContractItem I_GLAccountLineItem _ProviderContractItem
_PubSecBudgetAccount I_GLAccountLineItem _PubSecBudgetAccount
_PubSecBudgetAccountCoCode I_GLAccountLineItem _PubSecBudgetAccountCoCode
_PubSecBudgetCnsmpnAmtType I_GLAccountLineItem _PubSecBudgetCnsmpnAmtType
_PubSecBudgetCnsmpnDate I_GLAccountLineItem _PubSecBudgetCnsmpnDate
_PubSecBudgetCnsmpnFsclPeriod I_GLAccountLineItem _PubSecBudgetCnsmpnFsclPeriod
_PubSecBudgetCnsmpnFsclYear I_GLAccountLineItem _PubSecBudgetCnsmpnFsclYear
_PubSecBudgetCnsmpnType I_GLAccountLineItem _PubSecBudgetCnsmpnType
_ReferenceDocumentType I_GLAccountLineItem _ReferenceDocumentType
_ReferenceQuantityUnit I_GLAccountLineItem _ReferenceQuantityUnit
_SalesDocument I_GLAccountLineItem _SalesDocument
_SalesDocumentItem I_GLAccountLineItem _SalesDocumentItem
_SalesOrganization I_GLAccountLineItem _SalesOrganization
_Segment I_GLAccountLineItem _Segment
_ServiceContract I_GLAccountLineItem _ServiceContract
_ServiceContractItem I_GLAccountLineItem _ServiceContractItem
_ServiceContractType I_GLAccountLineItem _ServiceContractType
_ServiceDocument I_GLAccountLineItem _ServiceDocument
_ServiceDocumentItem I_GLAccountLineItem _ServiceDocumentItem
_ServiceDocumentType I_GLAccountLineItem _ServiceDocumentType
_SoldProduct I_GLAccountLineItem _SoldProduct
_SoldProductGroup_2 I_GLAccountLineItem _SoldProductGroup_2
_SourceLedger I_GLAccountLineItem _SourceLedger
_SpecialGLCode I_GLAccountLineItem _SpecialGLCode
_SubLedgerAccLineItemType I_GLAccountLineItem _SubLedgerAccLineItemType
_Supplier I_GLAccountLineItem _Supplier
_SupplierCompany I_GLAccountLineItem _SupplierCompany
_TaxCountry I_GLAccountLineItem _TaxCountry
_TimeSheetOvertimeCat I_GLAccountLineItem _TimeSheetOvertimeCat
_TransactionCurrency I_GLAccountLineItem _TransactionCurrency
_WBSElementBasicData I_GLAccountLineItem _WBSElementBasicData
_WBSElementExternalID _WBSElementExternalID
_FinServicesProductGroup _FinServicesProductGroup
_FinancialServicesBranch _FinancialServicesBranch
_FinancialDataSource _FinancialDataSource
_CustomerSupplierCountry I_GLAccountLineItem _CustomerSupplierCountry
_CustomerSupplierIndustry _CustomerSupplierIndustry

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_GLAccountYearToDateBalanceC.
-- 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_GLAccountYearToDateBalanceC AS
SELECT
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountLineItem.GLRecordType AS GLRecordType,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItem.ControllingArea AS ControllingArea,
  I_GLAccountLineItem.FinancialTransactionType AS FinancialTransactionType,
  I_GLAccountLineItem.GLBusinessTransactionType AS GLBusinessTransactionType,
  I_GLAccountLineItem.BusinessTransactionCategory AS BusinessTransactionCategory,
  I_GLAccountLineItem.BusinessTransactionType AS BusinessTransactionType,
  I_GLAccountLineItem.ControllingBusTransacType AS ControllingBusTransacType,
  I_GLAccountLineItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_GLAccountLineItem.LogicalSystem AS LogicalSystem,
  I_GLAccountLineItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_GLAccountLineItem.ReferenceDocument AS ReferenceDocument,
  I_GLAccountLineItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_GLAccountLineItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  I_GLAccountLineItem.TransactionSubitem AS TransactionSubitem,
  I_GLAccountLineItem.IsReversal AS IsReversal,
  I_GLAccountLineItem.IsReversed AS IsReversed,
  I_GLAccountLineItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  I_GLAccountLineItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  I_GLAccountLineItem.ReversalTransactionSubitem AS ReversalTransactionSubitem,
  I_GLAccountLineItem.IsSettlement AS IsSettlement,
  I_GLAccountLineItem.IsSettled AS IsSettled,
  I_GLAccountLineItem.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  I_GLAccountLineItem.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  I_GLAccountLineItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  I_GLAccountLineItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  I_GLAccountLineItem.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  I_GLAccountLineItem.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  I_GLAccountLineItem.PredecessorJournalEntry AS PredecessorJournalEntry,
  I_GLAccountLineItem.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  I_GLAccountLineItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  I_GLAccountLineItem.SourceLogicalSystem AS SourceLogicalSystem,
  I_GLAccountLineItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  I_GLAccountLineItem.SourceReferenceDocument AS SourceReferenceDocument,
  I_GLAccountLineItem.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  I_GLAccountLineItem.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  I_GLAccountLineItem.IsCommitment AS IsCommitment,
  I_GLAccountLineItem.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  I_GLAccountLineItem.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  I_GLAccountLineItem.OrganizationalChange AS OrganizationalChange,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItem.BusinessArea AS BusinessArea,
  I_GLAccountLineItem.Segment AS Segment,
  I_GLAccountLineItem.PartnerCostCenter AS PartnerCostCenter,
  I_GLAccountLineItem.PartnerProfitCenter AS PartnerProfitCenter,
  I_GLAccountLineItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  I_GLAccountLineItem.PartnerBusinessArea AS PartnerBusinessArea,
  I_GLAccountLineItem.PartnerCompany AS PartnerCompany,
  I_GLAccountLineItem.PartnerSegment AS PartnerSegment,
  I_GLAccountLineItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountLineItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountLineItem.TransactionCurrency AS TransactionCurrency,
  I_GLAccountLineItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountLineItem.FunctionalCurrency AS FunctionalCurrency,
  I_GLAccountLineItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  I_GLAccountLineItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  I_GLAccountLineItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  I_GLAccountLineItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  I_GLAccountLineItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  I_GLAccountLineItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  I_GLAccountLineItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  I_GLAccountLineItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  I_GLAccountLineItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  I_GLAccountLineItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_GLAccountLineItem.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
  I_GLAccountLineItem.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
  I_GLAccountLineItem.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  I_GLAccountLineItem.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
  I_GLAccountLineItem.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
  I_GLAccountLineItem.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  I_GLAccountLineItem.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
  I_GLAccountLineItem.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  I_GLAccountLineItem.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  I_GLAccountLineItem.ControllingObjectCurrency AS ControllingObjectCurrency,
  I_GLAccountLineItem.AmountInObjectCurrency AS AmountInObjectCurrency,
  I_GLAccountLineItem.GrantCurrency AS GrantCurrency,
  I_GLAccountLineItem.AmountInGrantCurrency AS AmountInGrantCurrency,
  I_GLAccountLineItem.BaseUnit AS BaseUnit,
  I_GLAccountLineItem.Quantity AS Quantity,
  I_GLAccountLineItem.FixedQuantity AS FixedQuantity,
  I_GLAccountLineItem.CostSourceUnit AS CostSourceUnit,
  I_GLAccountLineItem.ValuationQuantity AS ValuationQuantity,
  I_GLAccountLineItem.ValuationFixedQuantity AS ValuationFixedQuantity,
  I_GLAccountLineItem.ReferenceQuantityUnit AS ReferenceQuantityUnit,
  I_GLAccountLineItem.ReferenceQuantity AS ReferenceQuantity,
  I_GLAccountLineItem.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  I_GLAccountLineItem.AdditionalQuantity1 AS AdditionalQuantity1,
  I_GLAccountLineItem.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  I_GLAccountLineItem.AdditionalQuantity2 AS AdditionalQuantity2,
  I_GLAccountLineItem.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  I_GLAccountLineItem.AdditionalQuantity3 AS AdditionalQuantity3,
  I_GLAccountLineItem.DebitCreditCode AS DebitCreditCode,
  I_GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItem.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItem.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAccountLineItem.PostingDate AS PostingDate,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  I_GLAccountLineItem.DocumentDate AS DocumentDate,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem.AccountingDocumentItem AS AccountingDocumentItem,
  I_GLAccountLineItem.AssignmentReference AS AssignmentReference,
  I_GLAccountLineItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAccountLineItem.PostingKey AS PostingKey,
  I_GLAccountLineItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_GLAccountLineItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  I_GLAccountLineItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_GLAccountLineItem.LastChangeDateTime AS LastChangeDateTime,
  I_GLAccountLineItem.CreationDateTime AS CreationDateTime,
  I_GLAccountLineItem.CreationDate AS CreationDate,
  I_GLAccountLineItem.EliminationProfitCenter AS EliminationProfitCenter,
  I_GLAccountLineItem.OriginObjectType AS OriginObjectType,
  I_GLAccountLineItem.GLAccountType AS GLAccountType,
  I_GLAccountLineItem.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAccountLineItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_GLAccountLineItem.ItemIsSplit AS ItemIsSplit,
  I_GLAccountLineItem.ConsolidationUnit AS ConsolidationUnit,
  I_GLAccountLineItem.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  I_GLAccountLineItem.Company AS Company,
  I_GLAccountLineItem.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  I_GLAccountLineItem.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  I_GLAccountLineItem.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  I_GLAccountLineItem.CnsldtnSubitem AS CnsldtnSubitem,
  I_GLAccountLineItem.InvoiceReference AS InvoiceReference,
  I_GLAccountLineItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  I_GLAccountLineItem.FollowOnDocumentType AS FollowOnDocumentType,
  I_GLAccountLineItem.InvoiceItemReference AS InvoiceItemReference,
  I_GLAccountLineItem.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  I_GLAccountLineItem.PurchasingDocument AS PurchasingDocument,
  I_GLAccountLineItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GLAccountLineItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_GLAccountLineItem.DocumentItemText AS DocumentItemText,
  I_GLAccountLineItem.SalesDocument AS SalesDocument,
  I_GLAccountLineItem.SalesDocumentItem AS SalesDocumentItem,
  I_GLAccountLineItem.Product AS Product,
  I_GLAccountLineItem.Plant AS Plant,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.Customer AS Customer,
  I_GLAccountLineItem.ServicesRenderedDate AS ServicesRenderedDate,
  I_GLAccountLineItem.ConditionContract AS ConditionContract,
  I_GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItem.SpecialGLCode AS SpecialGLCode,
  I_GLAccountLineItem.TaxCode AS TaxCode,
  I_GLAccountLineItem.TaxCountry AS TaxCountry,
  I_GLAccountLineItem.HouseBank AS HouseBank,
  I_GLAccountLineItem.HouseBankAccount AS HouseBankAccount,
  I_GLAccountLineItem.ClearingDate AS ClearingDate,
  I_GLAccountLineItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  I_GLAccountLineItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  I_GLAccountLineItem.ValueDate AS ValueDate,
  I_GLAccountLineItem.AssetDepreciationArea AS AssetDepreciationArea,
  I_GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItem.FixedAsset AS FixedAsset,
  I_GLAccountLineItem.AssetValueDate AS AssetValueDate,
  I_GLAccountLineItem.AssetTransactionType AS AssetTransactionType,
  I_GLAccountLineItem.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  I_GLAccountLineItem.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  I_GLAccountLineItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  I_GLAccountLineItem.GroupFixedAsset AS GroupFixedAsset,
  I_GLAccountLineItem.AssetClass AS AssetClass,
  I_GLAccountLineItem.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  I_GLAccountLineItem.PartnerFixedAsset AS PartnerFixedAsset,
  I_GLAccountLineItem.CostEstimate AS CostEstimate,
  I_GLAccountLineItem.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_GLAccountLineItem.InventorySpecialStockType AS InventorySpecialStockType,
  I_GLAccountLineItem.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  I_GLAccountLineItem.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  I_GLAccountLineItem.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  I_GLAccountLineItem.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  I_GLAccountLineItem.InventoryValuationType AS InventoryValuationType,
  I_GLAccountLineItem.ValuationArea AS ValuationArea,
  I_GLAccountLineItem.SenderGLAccount AS SenderGLAccount,
  I_GLAccountLineItem.SenderAccountAssignment AS SenderAccountAssignment,
  I_GLAccountLineItem.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  I_GLAccountLineItem.CostOriginGroup AS CostOriginGroup,
  I_GLAccountLineItem.OriginSenderObject AS OriginSenderObject,
  I_GLAccountLineItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  I_GLAccountLineItem.ControllingObjectDebitType AS ControllingObjectDebitType,
  I_GLAccountLineItem.QuantityIsIncomplete AS QuantityIsIncomplete,
  I_GLAccountLineItem.OffsettingAccount AS OffsettingAccount,
  I_GLAccountLineItem.OffsettingAccountType AS OffsettingAccountType,
  I_GLAccountLineItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  I_GLAccountLineItem.LineItemIsCompleted AS LineItemIsCompleted,
  I_GLAccountLineItem.PersonnelNumber AS PersonnelNumber,
  I_GLAccountLineItem.ControllingObjectClass AS ControllingObjectClass,
  I_GLAccountLineItem.PartnerCompanyCode AS PartnerCompanyCode,
  I_GLAccountLineItem.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  I_GLAccountLineItem.OriginCostCenter AS OriginCostCenter,
  I_GLAccountLineItem.OriginProfitCenter AS OriginProfitCenter,
  I_GLAccountLineItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  I_GLAccountLineItem.OriginProduct AS OriginProduct,
  I_GLAccountLineItem.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  I_GLAccountLineItem.AccountAssignment AS AccountAssignment,
  I_GLAccountLineItem.AccountAssignmentType AS AccountAssignmentType,
  I_GLAccountLineItem.CostCtrActivityType AS CostCtrActivityType,
  I_GLAccountLineItem.OrderID AS OrderID,
  I_GLAccountLineItem.OrderCategory AS OrderCategory,
  I_GLAccountLineItem.WBSElementInternalID AS WBSElementInternalID,
  cast( I_GLAccountLineItem._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) AS WBSElementExternalID,
  I_GLAccountLineItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  cast( I_GLAccountLineItem._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) AS PartnerWBSElementExternalID,
  I_GLAccountLineItem.ProjectInternalID AS ProjectInternalID,
  cast( I_GLAccountLineItem._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) AS ProjectExternalID,
  I_GLAccountLineItem.PartnerProjectInternalID AS PartnerProjectInternalID,
  cast( I_GLAccountLineItem._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) AS PartnerProjectExternalID,
  I_GLAccountLineItem.OperatingConcern AS OperatingConcern,
  I_GLAccountLineItem.ProjectNetwork AS ProjectNetwork,
  I_GLAccountLineItem.BusinessProcess AS BusinessProcess,
  I_GLAccountLineItem.CostObject AS CostObject,
  I_GLAccountLineItem.BillableControl AS BillableControl,
  I_GLAccountLineItem.CostAnalysisResource AS CostAnalysisResource,
  I_GLAccountLineItem.CustomerServiceNotification AS CustomerServiceNotification,
  I_GLAccountLineItem.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountLineItem.ServiceDocument AS ServiceDocument,
  I_GLAccountLineItem.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAccountLineItem.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  I_GLAccountLineItem.PartnerServiceDocument AS PartnerServiceDocument,
  I_GLAccountLineItem.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  I_GLAccountLineItem.ServiceContractType AS ServiceContractType,
  I_GLAccountLineItem.ServiceContract AS ServiceContract,
  I_GLAccountLineItem.ServiceContractItem AS ServiceContractItem,
  I_GLAccountLineItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  I_GLAccountLineItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  I_GLAccountLineItem.ProviderContract AS ProviderContract,
  I_GLAccountLineItem.ProviderContractItem AS ProviderContractItem,
  I_GLAccountLineItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  I_GLAccountLineItem.PartnerAccountAssignment AS PartnerAccountAssignment,
  I_GLAccountLineItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_GLAccountLineItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  I_GLAccountLineItem.PartnerOrder_2 AS PartnerOrder,
  I_GLAccountLineItem.PartnerOrderCategory AS PartnerOrderCategory,
  I_GLAccountLineItem.PartnerSalesDocument AS PartnerSalesDocument,
  I_GLAccountLineItem.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  I_GLAccountLineItem.PartnerProjectNetwork AS PartnerProjectNetwork,
  I_GLAccountLineItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAccountLineItem.PartnerCostObject AS PartnerCostObject,
  I_GLAccountLineItem.ControllingDocumentItem AS ControllingDocumentItem,
  I_GLAccountLineItem.BillingDocumentType AS BillingDocumentType,
  I_GLAccountLineItem.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItem.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItem.SoldProduct AS SoldProduct,
  I_GLAccountLineItem.SoldProductGroup AS SoldProductGroup,
  I_GLAccountLineItem.CustomerGroup AS CustomerGroup,
  I_GLAccountLineItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAccountLineItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAccountLineItem.SalesDistrict AS SalesDistrict,
  I_GLAccountLineItem.BillToParty AS BillToParty,
  I_GLAccountLineItem.ShipToParty AS ShipToParty,
  I_GLAccountLineItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  I_GLAccountLineItem.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  I_GLAccountLineItem.CashLedgerAccount AS CashLedgerAccount,
  I_GLAccountLineItem.FinancialManagementArea AS FinancialManagementArea,
  I_GLAccountLineItem.FundsCenter AS FundsCenter,
  I_GLAccountLineItem.FundedProgram AS FundedProgram,
  I_GLAccountLineItem.Fund AS Fund,
  I_GLAccountLineItem.GrantID AS GrantID,
  I_GLAccountLineItem.BudgetPeriod AS BudgetPeriod,
  I_GLAccountLineItem.PartnerFund AS PartnerFund,
  I_GLAccountLineItem.PartnerGrant AS PartnerGrant,
  I_GLAccountLineItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  I_GLAccountLineItem.PubSecBudgetAccount AS PubSecBudgetAccount,
  I_GLAccountLineItem.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  I_GLAccountLineItem.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  I_GLAccountLineItem.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  I_GLAccountLineItem.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  I_GLAccountLineItem.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  I_GLAccountLineItem.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  I_GLAccountLineItem.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  I_GLAccountLineItem.SponsoredProgram AS SponsoredProgram,
  I_GLAccountLineItem.SponsoredClass AS SponsoredClass,
  I_GLAccountLineItem.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  I_GLAccountLineItem.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  I_GLAccountLineItem.FinancialServicesBranch AS FinancialServicesBranch,
  I_GLAccountLineItem.FinancialDataSource AS FinancialDataSource,
  I_GLAccountLineItem.JointVenture AS JointVenture,
  I_GLAccountLineItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_GLAccountLineItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  I_GLAccountLineItem.JointVenturePartner AS JointVenturePartner,
  I_GLAccountLineItem.JointVentureBillingType AS JointVentureBillingType,
  I_GLAccountLineItem.JointVentureEquityType AS JointVentureEquityType,
  I_GLAccountLineItem.JointVentureProductionDate AS JointVentureProductionDate,
  I_GLAccountLineItem.JointVentureBillingDate AS JointVentureBillingDate,
  I_GLAccountLineItem.JointVentureOperationalDate AS JointVentureOperationalDate,
  I_GLAccountLineItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  I_GLAccountLineItem.PartnerVenture AS PartnerVenture,
  I_GLAccountLineItem.PartnerEquityGroup AS PartnerEquityGroup,
  I_GLAccountLineItem.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  I_GLAccountLineItem.REBusinessEntity AS REBusinessEntity,
  I_GLAccountLineItem.RealEstateBuilding AS RealEstateBuilding,
  I_GLAccountLineItem.RealEstateProperty AS RealEstateProperty,
  I_GLAccountLineItem.RERentalObject AS RERentalObject,
  I_GLAccountLineItem.RealEstateContract AS RealEstateContract,
  I_GLAccountLineItem.REServiceChargeKey AS REServiceChargeKey,
  I_GLAccountLineItem.RESettlementUnitID AS RESettlementUnitID,
  I_GLAccountLineItem.SettlementReferenceDate AS SettlementReferenceDate,
  I_GLAccountLineItem.REPartnerBusinessEntity AS REPartnerBusinessEntity,
  I_GLAccountLineItem.RealEstatePartnerBuilding AS RealEstatePartnerBuilding,
  I_GLAccountLineItem.RealEstatePartnerProperty AS RealEstatePartnerProperty,
  I_GLAccountLineItem.REPartnerRentalObject AS REPartnerRentalObject,
  I_GLAccountLineItem.RealEstatePartnerContract AS RealEstatePartnerContract,
  I_GLAccountLineItem.REPartnerServiceChargeKey AS REPartnerServiceChargeKey,
  I_GLAccountLineItem.REPartnerSettlementUnitID AS REPartnerSettlementUnitID,
  I_GLAccountLineItem.PartnerSettlementReferenceDate AS PartnerSettlementReferenceDate,
  I_GLAccountLineItem.AccrualObjectType AS AccrualObjectType,
  I_GLAccountLineItem.AccrualObject AS AccrualObject,
  I_GLAccountLineItem.AccrualSubobject AS AccrualSubobject,
  I_GLAccountLineItem.AccrualItemType AS AccrualItemType,
  I_GLAccountLineItem.AccrualValueDate AS AccrualValueDate,
  I_GLAccountLineItem.FinancialValuationObjectType AS FinancialValuationObjectType,
  I_GLAccountLineItem.FinancialValuationObject AS FinancialValuationObject,
  I_GLAccountLineItem.FinancialValuationSubobject AS FinancialValuationSubobject,
  I_GLAccountLineItem.NetDueDate AS NetDueDate,
  I_GLAccountLineItem.CreditRiskClass AS CreditRiskClass,
  I_GLAccountLineItem.WorkCenterInternalID AS WorkCenterInternalID,
  I_GLAccountLineItem.OrderItem AS OrderItem,
  I_GLAccountLineItem.PartnerOrderItem AS PartnerOrderItem,
  I_GLAccountLineItem.Equipment AS Equipment,
  I_GLAccountLineItem.FunctionalLocation AS FunctionalLocation,
  I_GLAccountLineItem.Assembly AS Assembly,
  I_GLAccountLineItem.MaintenanceActivityType AS MaintenanceActivityType,
  I_GLAccountLineItem.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
  I_GLAccountLineItem.MaintPriorityType AS MaintPriorityType,
  I_GLAccountLineItem.MaintPriority AS MaintPriority,
  I_GLAccountLineItem.SuperiorOrder AS SuperiorOrder,
  I_GLAccountLineItem.ProductGroup AS ProductGroup,
  I_GLAccountLineItem.MaintenanceOrderIsPlanned AS MaintenanceOrderIsPlanned,
  I_GLAccountLineItem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  I_GLAccountLineItem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  I_GLAccountLineItem.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  I_GLAccountLineItem.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  I_GLAccountLineItem.DebitAmountInBalanceTransCrcy AS DebitAmountInBalanceTransCrcy,
  I_GLAccountLineItem.CreditAmountInBalanceTransCrcy AS CreditAmountInBalanceTransCrcy,
  I_GLAccountLineItem.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  I_GLAccountLineItem.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  I_GLAccountLineItem.DebitAmountInFunctionalCrcy AS DebitAmountInFunctionalCrcy,
  I_GLAccountLineItem.CreditAmountInFunctionalCrcy AS CreditAmountInFunctionalCrcy,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy1 AS DebitAmountInFreeDfndCrcy1,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy1 AS CreditAmountInFreeDfndCrcy1,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy2 AS DebitAmountInFreeDfndCrcy2,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy2 AS CreditAmountInFreeDfndCrcy2,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy3 AS DebitAmountInFreeDfndCrcy3,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy3 AS CreditAmountInFreeDfndCrcy3,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy4 AS DebitAmountInFreeDfndCrcy4,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy4 AS CreditAmountInFreeDfndCrcy4,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy5 AS DebitAmountInFreeDfndCrcy5,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy5 AS CreditAmountInFreeDfndCrcy5,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy6 AS DebitAmountInFreeDfndCrcy6,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy6 AS CreditAmountInFreeDfndCrcy6,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy7 AS DebitAmountInFreeDfndCrcy7,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy7 AS CreditAmountInFreeDfndCrcy7,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy8 AS DebitAmountInFreeDfndCrcy8,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy8 AS CreditAmountInFreeDfndCrcy8,
  I_GLAccountLineItem.IsStatisticalOrder AS IsStatisticalOrder,
  I_GLAccountLineItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  I_GLAccountLineItem.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  I_GLAccountLineItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  I_GLAccountLineItem.CalendarYear AS CalendarYear,
  I_GLAccountLineItem.CalendarQuarter AS CalendarQuarter,
  I_GLAccountLineItem.CalendarYearQuarter AS CalendarYearQuarter,
  I_GLAccountLineItem.CalendarMonth AS CalendarMonth,
  I_GLAccountLineItem.CalendarYearMonth AS CalendarYearMonth,
  I_GLAccountLineItem.CalendarWeek AS CalendarWeek,
  I_GLAccountLineItem.CalendarYearWeek AS CalendarYearWeek,
  I_GLAccountLineItem._Assembly AS _Assembly,
  I_GLAccountLineItem._AlternativeGLAccount AS _AlternativeGLAccount,
  I_GLAccountLineItem._AdditionalQuantity3Unit AS _AdditionalQuantity3Unit,
  I_GLAccountLineItem._AssetTransactionType AS _AssetTransactionType,
  I_GLAccountLineItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  I_GLAccountLineItem._BaseUnit AS _BaseUnit,
  I_GLAccountLineItem._AdditionalQuantity2Unit AS _AdditionalQuantity2Unit,
  I_GLAccountLineItem._AdditionalQuantity1Unit AS _AdditionalQuantity1Unit,
  I_GLAccountLineItem._AccountingDocumentType AS _AccountingDocumentType,
  I_GLAccountLineItem._AccountingDocumentCategory AS _AccountingDocumentCategory,
  I_GLAccountLineItem._BillableControl AS _BillableControl,
  I_GLAccountLineItem._BillingDocumentType AS _BillingDocumentType,
  I_GLAccountLineItem._BudgetPeriod AS _BudgetPeriod,
  I_GLAccountLineItem._BusinessArea AS _BusinessArea,
  I_GLAccountLineItem._BusinessProcess AS _BusinessProcess,
  I_GLAccountLineItem._BusinessTransactionCategory AS _BusinessTransactionCategory,
  I_GLAccountLineItem._BusinessTransactionType AS _BusinessTransactionType,
  I_GLAccountLineItem._CashLedgerAccount AS _CashLedgerAccount,
  I_GLAccountLineItem._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  I_GLAccountLineItem._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountLineItem._ClearingJrnlEntryFiscalYear AS _ClearingJrnlEntryFiscalYear,
  I_GLAccountLineItem._ClearingJournalEntry AS _ClearingJournalEntry,
  I_GLAccountLineItem._CnsldtnFinancialStatementItem AS _CnsldtnFinancialStatementItem,
  I_GLAccountLineItem._CnsldtnSubitem AS _CnsldtnSubitem,
  I_GLAccountLineItem._CnsldtnSubitemCategory AS _CnsldtnSubitemCategory,
  I_GLAccountLineItem._Company AS _Company,
  I_GLAccountLineItem._CompanyCode AS _CompanyCode,
  I_GLAccountLineItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_GLAccountLineItem._ConditionContract AS _ConditionContract,
  I_GLAccountLineItem._ConsolidationChartOfAccounts AS _ConsolidationChartOfAccounts,
  I_GLAccountLineItem._ConsolidationUnit AS _ConsolidationUnit,
  I_GLAccountLineItem._ControllingArea AS _ControllingArea,
  I_GLAccountLineItem._ControllingDebitCreditCode AS _ControllingDebitCreditCode,
  I_GLAccountLineItem._ControllingObjectClass AS _ControllingObjectClass,
  I_GLAccountLineItem._CostAnalysisResource AS _CostAnalysisResource,
  I_GLAccountLineItem._CostCenter AS _CostCenter,
  I_GLAccountLineItem._CostCtrActivityType AS _CostCtrActivityType,
  I_GLAccountLineItem._CostOriginGroup AS _CostOriginGroup,
  I_GLAccountLineItem._CostSourceUnit AS _CostSourceUnit,
  I_GLAccountLineItem._CountryChartOfAccounts AS _CountryChartOfAccounts,
  I_GLAccountLineItem._CurrentProfitCenter AS _CurrentProfitCenter,
  I_GLAccountLineItem._CurrentCostCenter AS _CurrentCostCenter,
  I_GLAccountLineItem._Customer AS _Customer,
  I_GLAccountLineItem._CustomerCompany AS _CustomerCompany,
  I_GLAccountLineItem._CustomerGroup AS _CustomerGroup,
  I_GLAccountLineItem._DebitCreditCode AS _DebitCreditCode,
  I_GLAccountLineItem._DistributionChannel AS _DistributionChannel,
  I_GLAccountLineItem._EliminationProfitCenter AS _EliminationProfitCenter,
  I_GLAccountLineItem._Equipment AS _Equipment,
  I_GLAccountLineItem._FinancialAccountType AS _FinancialAccountType,
  I_GLAccountLineItem._FinancialManagementArea AS _FinancialManagementArea,
  I_GLAccountLineItem._FinancialTransactionType AS _FinancialTransactionType,
  I_GLAccountLineItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  I_GLAccountLineItem._FiscalYear AS _FiscalYear,
  I_GLAccountLineItem._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  I_GLAccountLineItem._FiscalYearVariant AS _FiscalYearVariant,
  I_GLAccountLineItem._FixedAsset AS _FixedAsset,
  I_GLAccountLineItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  I_GLAccountLineItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  I_GLAccountLineItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  I_GLAccountLineItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  I_GLAccountLineItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  I_GLAccountLineItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  I_GLAccountLineItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  I_GLAccountLineItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  I_GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  I_GLAccountLineItem._FunctionalCurrency AS _FunctionalCurrency,
  I_GLAccountLineItem._FunctionalLocation AS _FunctionalLocation,
  I_GLAccountLineItem._Fund AS _Fund,
  I_GLAccountLineItem._FundedProgram AS _FundedProgram,
  I_GLAccountLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAccountLineItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_GLAccountLineItem._GLAccountType AS _GLAccountType,
  I_GLAccountLineItem._GlobalCurrency AS _GlobalCurrency,
  I_GLAccountLineItem._Grant AS _Grant,
  I_GLAccountLineItem._GroupFixedAsset AS _GroupFixedAsset,
  I_GLAccountLineItem._GroupMasterFixedAsset AS _GroupMasterFixedAsset,
  I_GLAccountLineItem._HouseBank AS _HouseBank,
  I_GLAccountLineItem._InventorySpclStkSalesDocItm AS _InventorySpclStkSalesDocItm,
  I_GLAccountLineItem._InventorySpclStkSalesDocument AS _InventorySpclStkSalesDocument,
  I_GLAccountLineItem._InventorySpecialStockType AS _InventorySpecialStockType,
  I_GLAccountLineItem._InventoryValuationType AS _InventoryValuationType,
  I_GLAccountLineItem._InvtrySpclStkWBSElmntBscData AS _InvtrySpclStkWBSElmntBscData,
  I_GLAccountLineItem._JournalEntry AS _JournalEntry,
  I_GLAccountLineItem._Ledger AS _Ledger,
  I_GLAccountLineItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  I_GLAccountLineItem._MaintenanceActivityType AS _MaintenanceActivityType,
  I_GLAccountLineItem._MaintOrdPlngDegreeCode AS _MaintOrdPlngDegreeCode,
  I_GLAccountLineItem._MasterFixedAsset AS _MasterFixedAsset,
  I_GLAccountLineItem._MovementCategory AS _MovementCategory,
  I_GLAccountLineItem._OffsettingAccountType AS _OffsettingAccountType,
  I_GLAccountLineItem._OffsettingAccountWithBP AS _OffsettingAccountWithBP,
  I_GLAccountLineItem._OffsettingChartOfAccounts AS _OffsettingChartOfAccounts,
  I_GLAccountLineItem._Order AS _Order,
  I_GLAccountLineItem._OrderCategory AS _OrderCategory,
  I_GLAccountLineItem._OriginCostCenter AS _OriginCostCenter,
  I_GLAccountLineItem._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  I_GLAccountLineItem._OriginProfitCenter AS _OriginProfitCenter,
  I_GLAccountLineItem._OriginSenderObject AS _OriginSenderObject,
  I_GLAccountLineItem._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  I_GLAccountLineItem._PartnerBusinessArea AS _PartnerBusinessArea,
  I_GLAccountLineItem._PartnerBusinessProcess AS _PartnerBusinessProcess,
  I_GLAccountLineItem._PartnerCompany AS _PartnerCompany,
  I_GLAccountLineItem._PartnerCompanyCode AS _PartnerCompanyCode,
  I_GLAccountLineItem._PartnerConsolidationUnit AS _PartnerConsolidationUnit,
  I_GLAccountLineItem._PartnerControllingObjectClass AS _PartnerControllingObjectClass,
  I_GLAccountLineItem._PartnerCostCenter AS _PartnerCostCenter,
  I_GLAccountLineItem._PartnerProjectBasicData AS _PartnerProjectBasicData,
  I_GLAccountLineItem._PartnerProfitCenter AS _PartnerProfitCenter,
  I_GLAccountLineItem._PartnerSalesDocument AS _PartnerSalesDocument,
  I_GLAccountLineItem._PartnerOrderCategory AS _PartnerOrderCategory,
  I_GLAccountLineItem._PartnerMasterFixedAsset AS _PartnerMasterFixedAsset,
  I_GLAccountLineItem._PartnerGrant AS _PartnerGrant,
  I_GLAccountLineItem._PartnerFund AS _PartnerFund,
  I_GLAccountLineItem._PartnerFunctionalArea AS _PartnerFunctionalArea,
  I_GLAccountLineItem._PartnerFixedAsset AS _PartnerFixedAsset,
  I_GLAccountLineItem._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  I_GLAccountLineItem._PartnerSalesDocumentItem AS _PartnerSalesDocumentItem,
  I_GLAccountLineItem._PartnerServiceDocument AS _PartnerServiceDocument,
  I_GLAccountLineItem._PartnerServiceDocumentItem AS _PartnerServiceDocumentItem,
  I_GLAccountLineItem._PartnerServiceDocumentType AS _PartnerServiceDocumentType,
  I_GLAccountLineItem._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData,
  I_GLAccountLineItem._Plant AS _Plant,
  I_GLAccountLineItem._PostingKey AS _PostingKey,
  I_GLAccountLineItem._PredecessorReferenceDocType AS _PredecessorReferenceDocType,
  I_GLAccountLineItem._Product AS _Product,
  I_GLAccountLineItem._ProductGroup_2 AS _ProductGroup_2,
  I_GLAccountLineItem._ProfitCenter AS _ProfitCenter,
  I_GLAccountLineItem._ProjectBasicData AS _ProjectBasicData,
  I_GLAccountLineItem._ProviderContract AS _ProviderContract,
  I_GLAccountLineItem._ProviderContractItem AS _ProviderContractItem,
  I_GLAccountLineItem._PubSecBudgetAccount AS _PubSecBudgetAccount,
  I_GLAccountLineItem._PubSecBudgetAccountCoCode AS _PubSecBudgetAccountCoCode,
  I_GLAccountLineItem._PubSecBudgetCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType,
  I_GLAccountLineItem._PubSecBudgetCnsmpnDate AS _PubSecBudgetCnsmpnDate,
  I_GLAccountLineItem._PubSecBudgetCnsmpnFsclPeriod AS _PubSecBudgetCnsmpnFsclPeriod,
  I_GLAccountLineItem._PubSecBudgetCnsmpnFsclYear AS _PubSecBudgetCnsmpnFsclYear,
  I_GLAccountLineItem._PubSecBudgetCnsmpnType AS _PubSecBudgetCnsmpnType,
  I_GLAccountLineItem._ReferenceDocumentType AS _ReferenceDocumentType,
  I_GLAccountLineItem._ReferenceQuantityUnit AS _ReferenceQuantityUnit,
  I_GLAccountLineItem._SalesDocument AS _SalesDocument,
  I_GLAccountLineItem._SalesDocumentItem AS _SalesDocumentItem,
  I_GLAccountLineItem._SalesOrganization AS _SalesOrganization,
  I_GLAccountLineItem._Segment AS _Segment,
  I_GLAccountLineItem._ServiceContract AS _ServiceContract,
  I_GLAccountLineItem._ServiceContractItem AS _ServiceContractItem,
  I_GLAccountLineItem._ServiceContractType AS _ServiceContractType,
  I_GLAccountLineItem._ServiceDocument AS _ServiceDocument,
  I_GLAccountLineItem._ServiceDocumentItem AS _ServiceDocumentItem,
  I_GLAccountLineItem._ServiceDocumentType AS _ServiceDocumentType,
  I_GLAccountLineItem._SoldProduct AS _SoldProduct,
  I_GLAccountLineItem._SoldProductGroup_2 AS _SoldProductGroup_2,
  I_GLAccountLineItem._SourceLedger AS _SourceLedger,
  I_GLAccountLineItem._SpecialGLCode AS _SpecialGLCode,
  I_GLAccountLineItem._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
  I_GLAccountLineItem._Supplier AS _Supplier,
  I_GLAccountLineItem._SupplierCompany AS _SupplierCompany,
  I_GLAccountLineItem._TaxCountry AS _TaxCountry,
  I_GLAccountLineItem._TimeSheetOvertimeCat AS _TimeSheetOvertimeCat,
  I_GLAccountLineItem._TransactionCurrency AS _TransactionCurrency,
  I_GLAccountLineItem._WBSElementBasicData AS _WBSElementBasicData,
  I_GLAccountLineItem._CustomerSupplierCountry AS _CustomerSupplierCountry
FROM I_GLAccountLineItem
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _ClearingAccountingDocument ON CompanyCode = _ClearingAccountingDocument.CompanyCode AND FiscalYear = _ClearingAccountingDocument.FiscalYear AND ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_Order AS _PartnerOrder_2 ON PartnerOrder = _PartnerOrder_2.OrderID  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _PartnerOrder ON PartnerOrder = _PartnerOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_FinServicesProductGroup AS _FinServicesProductGroup ON FinancialServicesProductGroup = _FinServicesProductGroup.FinancialServicesProductGroup  -- association [0..1]
LEFT OUTER JOIN I_FinancialServicesBranch AS _FinancialServicesBranch ON FinancialServicesBranch = _FinancialServicesBranch.FinancialServicesBranch  -- association [0..1]
LEFT OUTER JOIN I_FinancialDataSource AS _FinancialDataSource ON FinancialDataSource = _FinancialDataSource.FinancialDataSource  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustry AS _CustomerSupplierIndustry ON CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry  -- association [0..1]
;