I_GLAccountLineItemCube

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_GLAccountLineItemCube.
-- 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_GLAccountLineItemCube AS
SELECT
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  cast( I_GLAccountLineItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountLineItem.GLRecordType AS GLRecordType,
  I_GLAccountLineItem.JrnlEntrAltvFYConsecutiveID AS JrnlEntrAltvFYConsecutiveID,
  I_GLAccountLineItem.ControllingArea AS ControllingArea,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItem.AccountingDocumentItem AS AccountingDocumentItem,
  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.DocumentDate AS DocumentDate,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem.AssignmentReference AS AssignmentReference,
  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.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAccountLineItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_GLAccountLineItem._ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  I_GLAccountLineItem._GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  I_GLAccountLineItem._GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  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.SalesOrder AS SalesOrder,
  I_GLAccountLineItem.SalesOrderItem AS SalesOrderItem,
  I_GLAccountLineItem.SalesDocument AS SalesDocument,
  I_GLAccountLineItem.SalesDocumentItem AS SalesDocumentItem,
  I_GLAccountLineItem.Material AS Material,
  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.ComponentBreakdown AS ComponentBreakdown,
  I_GLAccountLineItem.CompBreakdownScaleNumerator AS CompBreakdownScaleNumerator,
  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.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAccountLineItem.ClearingDate AS ClearingDate,
  I_GLAccountLineItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  I_GLAccountLineItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  I_GLAccountLineItem.ClearingJournalEntry AS ClearingJournalEntry,
  I_GLAccountLineItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  I_GLAccountLineItem.ValueDate AS ValueDate,
  I_GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItem.FixedAsset AS FixedAsset,
  AssetValueDate,
  I_GLAccountLineItem.AssetTransactionType AS AssetTransactionType,
  I_GLAccountLineItem.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_GLAccountLineItem.InvtrySpecialStockValnType_2 AS InvtrySpecialStockValnType_2,
  I_GLAccountLineItem.InventorySpecialStockType AS InventorySpecialStockType,
  I_GLAccountLineItem.InventoryValuationType AS InventoryValuationType,
  I_GLAccountLineItem.ValuationArea AS ValuationArea,
  I_GLAccountLineItem.OffsettingAccount AS OffsettingAccount,
  I_GLAccountLineItem._OffsettingAccountWithBP.OffsettingAccountName AS OffsettingAccountName,
  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.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  I_GLAccountLineItem.PartnerCompany AS PartnerCompany,
  I_GLAccountLineItem.CostCtrActivityType AS CostCtrActivityType,
  I_GLAccountLineItem.OrderID AS OrderID,
  I_GLAccountLineItem.OrderCategory AS OrderCategory,
  I_GLAccountLineItem.WBSElementInternalID AS WBSElementInternalID,
  I_GLAccountLineItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) AS WBSElementExternalID,
  cast( _PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) AS PartnerWBSElementExternalID,
  cast( I_GLAccountLineItem.WBSElement as fis_wbs ) AS WBSElement,
  I_GLAccountLineItem.OperatingConcern AS OperatingConcern,
  I_GLAccountLineItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  I_GLAccountLineItem.BillingDocumentType AS BillingDocumentType,
  I_GLAccountLineItem.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItem.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItem.Segment AS Segment,
  I_GLAccountLineItem.BusinessArea AS BusinessArea,
  I_GLAccountLineItem.AccountAssignment AS AccountAssignment,
  I_GLAccountLineItem.AccountAssignmentType AS AccountAssignmentType,
  I_GLAccountLineItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAccountLineItem.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  I_GLAccountLineItem.AssetDepreciationArea AS AssetDepreciationArea,
  I_GLAccountLineItem.BudgetPeriod AS BudgetPeriod,
  I_GLAccountLineItem.BusinessProcess AS BusinessProcess,
  I_GLAccountLineItem.BusinessTransactionCategory AS BusinessTransactionCategory,
  I_GLAccountLineItem.BusinessTransactionType AS BusinessTransactionType,
  I_GLAccountLineItem.ControllingBusTransacType AS ControllingBusTransacType,
  I_GLAccountLineItem.ControllingObjectDebitType AS ControllingObjectDebitType,
  I_GLAccountLineItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  I_GLAccountLineItem.CostEstimate AS CostEstimate,
  I_GLAccountLineItem.CostObject AS CostObject,
  I_GLAccountLineItem.BillableControl AS BillableControl,
  I_GLAccountLineItem.CustomerGroup AS CustomerGroup,
  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.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  I_GLAccountLineItem.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  I_GLAccountLineItem.EliminationProfitCenter AS EliminationProfitCenter,
  I_GLAccountLineItem.FinancialTransactionType AS FinancialTransactionType,
  I_GLAccountLineItem.Fund AS Fund,
  I_GLAccountLineItem.FinancialManagementArea AS FinancialManagementArea,
  I_GLAccountLineItem.CommitmentItem AS CommitmentItem,
  I_GLAccountLineItem.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_GLAccountLineItem.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  I_GLAccountLineItem.GLAccountType AS GLAccountType,
  I_GLAccountLineItem.GrantID AS GrantID,
  I_GLAccountLineItem.GroupFixedAsset AS GroupFixedAsset,
  I_GLAccountLineItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  I_GLAccountLineItem.AssetClass AS AssetClass,
  I_GLAccountLineItem.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  I_GLAccountLineItem.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  I_GLAccountLineItem.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  cast( _InvtrySpclStockWBSElmntBD.WBSElementExternalID as fis_invspstock_wbsext_no_conv ) AS InvtrySpclStockWBSElmntExtID,
  cast( _InvtrySpclStockWBSElmntBD.WBSElement as fis_invspstock_wbs ) AS InventorySpclStockWBSElement,
  I_GLAccountLineItem.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  I_GLAccountLineItem.IsReversal AS IsReversal,
  I_GLAccountLineItem.IsReversed AS IsReversed,
  I_GLAccountLineItem.IsSettled AS IsSettled,
  I_GLAccountLineItem.IsSettlement AS IsSettlement,
  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.CutbackRun AS CutbackRun,
  I_GLAccountLineItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  I_GLAccountLineItem.PartnerVenture AS PartnerVenture,
  I_GLAccountLineItem.PartnerEquityGroup AS PartnerEquityGroup,
  I_GLAccountLineItem.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  I_GLAccountLineItem.CutbackAccount AS CutbackAccount,
  I_GLAccountLineItem.CutbackCostObject AS CutbackCostObject,
  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.LogicalSystem AS LogicalSystem,
  I_GLAccountLineItem.MaterialGroup AS MaterialGroup,
  I_GLAccountLineItem.SoldProductGroup AS SoldProductGroup,
  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.OriginObjectType AS OriginObjectType,
  I_GLAccountLineItem.PartnerAccountAssignment AS PartnerAccountAssignment,
  I_GLAccountLineItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_GLAccountLineItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  I_GLAccountLineItem.PartnerBusinessArea AS PartnerBusinessArea,
  I_GLAccountLineItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAccountLineItem.PartnerCompanyCode AS PartnerCompanyCode,
  I_GLAccountLineItem.PartnerCostCenter AS PartnerCostCenter,
  I_GLAccountLineItem.PartnerCostObject AS PartnerCostObject,
  I_GLAccountLineItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  I_GLAccountLineItem.PartnerFund AS PartnerFund,
  I_GLAccountLineItem.PartnerGrant AS PartnerGrant,
  I_GLAccountLineItem.PartnerOrder AS PartnerOrder,
  I_GLAccountLineItem.PartnerOrder_2 AS PartnerOrder_2,
  I_GLAccountLineItem.PartnerOrderCategory AS PartnerOrderCategory,
  I_GLAccountLineItem.PartnerProfitCenter AS PartnerProfitCenter,
  cast( I_GLAccountLineItem.PartnerProject as fis_part_project ) AS PartnerProject,
  I_GLAccountLineItem.PartnerProjectNetwork AS PartnerProjectNetwork,
  I_GLAccountLineItem.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  I_GLAccountLineItem.PartnerSalesDocument AS PartnerSalesDocument,
  PartnerSalesDocumentItem,
  I_GLAccountLineItem.PartnerSegment AS PartnerSegment,
  cast( I_GLAccountLineItem.PartnerWBSElement as fis_partner_wbs ) AS PartnerWBSElement,
  I_GLAccountLineItem.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  I_GLAccountLineItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  I_GLAccountLineItem.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  I_GLAccountLineItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  I_GLAccountLineItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  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.ProjectInternalID AS ProjectInternalID,
  I_GLAccountLineItem.PartnerProjectInternalID AS PartnerProjectInternalID,
  cast( _ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) AS ProjectExternalID,
  cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) AS PartnerProjectExternalID,
  cast( I_GLAccountLineItem.Project as fis_project ) AS Project,
  I_GLAccountLineItem.ProjectNetwork AS ProjectNetwork,
  I_GLAccountLineItem.WorkPackage AS WorkPackage,
  I_GLAccountLineItem.WorkItem AS WorkItem,
  I_GLAccountLineItem.QuantityIsIncomplete AS QuantityIsIncomplete,
  I_GLAccountLineItem.ReferenceDocument AS ReferenceDocument,
  I_GLAccountLineItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_GLAccountLineItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_GLAccountLineItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  I_GLAccountLineItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_GLAccountLineItem.RelatedNetworkActivity AS RelatedNetworkActivity,
  I_GLAccountLineItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  I_GLAccountLineItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  I_GLAccountLineItem.SenderAccountAssignment AS SenderAccountAssignment,
  I_GLAccountLineItem.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  I_GLAccountLineItem.SenderGLAccount AS SenderGLAccount,
  I_GLAccountLineItem.SoldMaterial AS SoldMaterial,
  I_GLAccountLineItem.SoldProduct AS SoldProduct,
  I_GLAccountLineItem.CostOriginGroup AS CostOriginGroup,
  I_GLAccountLineItem.OriginSenderObject AS OriginSenderObject,
  I_GLAccountLineItem.CostAnalysisResource AS CostAnalysisResource,
  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.FundsCenter AS FundsCenter,
  I_GLAccountLineItem.FundedProgram AS FundedProgram,
  I_GLAccountLineItem.IsStatisticalOrder AS IsStatisticalOrder,
  I_GLAccountLineItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  I_GLAccountLineItem.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  I_GLAccountLineItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  I_GLAccountLineItem.WorkCenterInternalID AS WorkCenterInternalID,
  I_GLAccountLineItem.OrderOperation AS OrderOperation,
  I_GLAccountLineItem.OrderItem AS OrderItem,
  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.OrderSuboperation AS OrderSuboperation,
  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.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  I_GLAccountLineItem.FinancialServicesBranch AS FinancialServicesBranch,
  I_GLAccountLineItem.FinancialDataSource AS FinancialDataSource,
  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.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  I_GLAccountLineItem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  I_GLAccountLineItem.TransactionCurrency AS TransactionCurrency,
  I_GLAccountLineItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountLineItem.FunctionalCurrency AS FunctionalCurrency,
  I_GLAccountLineItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  I_GLAccountLineItem.DebitAmountInFunctionalCrcy AS DebitAmountInFunctionalCrcy,
  I_GLAccountLineItem.CreditAmountInFunctionalCrcy AS CreditAmountInFunctionalCrcy,
  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.ControllingObjectCurrency AS ControllingObjectCurrency,
  I_GLAccountLineItem.AmountInObjectCurrency AS AmountInObjectCurrency,
  I_GLAccountLineItem.BaseUnit AS BaseUnit,
  I_GLAccountLineItem.Quantity AS Quantity,
  I_GLAccountLineItem.CostSourceUnit AS CostSourceUnit,
  I_GLAccountLineItem.ValuationQuantity AS ValuationQuantity,
  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.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  I_GLAccountLineItem.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  I_GLAccountLineItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountLineItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountLineItem.CreditAmountInBalanceTransCrcy AS CreditAmountInBalanceTransCrcy,
  I_GLAccountLineItem.DebitAmountInBalanceTransCrcy AS DebitAmountInBalanceTransCrcy,
  I_GLAccountLineItem.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  I_GLAccountLineItem.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy1 AS DebitAmountInFreeDefinedCrcy1,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy1 AS CreditAmountInFreeDefinedCrcy1,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy2 AS DebitAmountInFreeDefinedCrcy2,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy2 AS CreditAmountInFreeDefinedCrcy2,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy3 AS DebitAmountInFreeDefinedCrcy3,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy3 AS CreditAmountInFreeDefinedCrcy3,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy4 AS DebitAmountInFreeDefinedCrcy4,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy4 AS CreditAmountInFreeDefinedCrcy4,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy5 AS DebitAmountInFreeDefinedCrcy5,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy5 AS CreditAmountInFreeDefinedCrcy5,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy6 AS DebitAmountInFreeDefinedCrcy6,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy6 AS CreditAmountInFreeDefinedCrcy6,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy7 AS DebitAmountInFreeDefinedCrcy7,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy7 AS CreditAmountInFreeDefinedCrcy7,
  I_GLAccountLineItem.DebitAmountInFreeDefinedCrcy8 AS DebitAmountInFreeDefinedCrcy8,
  I_GLAccountLineItem.CreditAmountInFreeDefinedCrcy8 AS CreditAmountInFreeDefinedCrcy8,
  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.FixedQuantity AS FixedQuantity,
  I_GLAccountLineItem.ValuationFixedQuantity AS ValuationFixedQuantity,
  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._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  I_GLAccountLineItem._JournalEntry AS _JournalEntry,
  I_GLAccountLineItem._CompanyCode AS _CompanyCode,
  I_GLAccountLineItem._FiscalYear AS _FiscalYear,
  I_GLAccountLineItem._FiscalPeriod AS _FiscalPeriod,
  I_GLAccountLineItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  I_GLAccountLineItem._LedgerFiscalYear AS _LedgerFiscalYear,
  I_GLAccountLineItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  I_GLAccountLineItem._FiscalYearVariant AS _FiscalYearVariant,
  I_GLAccountLineItem._FiscalYearPeriod AS _FiscalYearPeriod,
  I_GLAccountLineItem._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  I_GLAccountLineItem._ControllingArea AS _ControllingArea,
  I_GLAccountLineItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  I_GLAccountLineItem._TransactionCurrency AS _TransactionCurrency,
  I_GLAccountLineItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_GLAccountLineItem._GlobalCurrency AS _GlobalCurrency,
  I_GLAccountLineItem._FunctionalCurrency AS _FunctionalCurrency,
  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._BaseUnit AS _BaseUnit,
  I_GLAccountLineItem._CostSourceUnit AS _CostSourceUnit,
  I_GLAccountLineItem._AdditionalQuantity1Unit AS _AdditionalQuantity1Unit,
  I_GLAccountLineItem._AdditionalQuantity2Unit AS _AdditionalQuantity2Unit,
  I_GLAccountLineItem._AdditionalQuantity3Unit AS _AdditionalQuantity3Unit,
  I_GLAccountLineItem._Segment AS _Segment,
  I_GLAccountLineItem._ProfitCenter AS _ProfitCenter,
  I_GLAccountLineItem._CurrentProfitCenter AS _CurrentProfitCenter,
  I_GLAccountLineItem._CostCenter AS _CostCenter,
  I_GLAccountLineItem._CurrentCostCenter AS _CurrentCostCenter,
  I_GLAccountLineItem._AccountAssignmentType AS _AccountAssignmentType,
  I_GLAccountLineItem._Material AS _Material,
  I_GLAccountLineItem._Product AS _Product,
  I_GLAccountLineItem._SoldMaterial AS _SoldMaterial,
  I_GLAccountLineItem._SoldProduct AS _SoldProduct,
  I_GLAccountLineItem._MaterialGroup AS _MaterialGroup,
  I_GLAccountLineItem._SoldProductGroup AS _SoldProductGroup,
  I_GLAccountLineItem._SoldProductGroup_2 AS _SoldProductGroup_2,
  I_GLAccountLineItem._ProductGroup AS _ProductGroup,
  I_GLAccountLineItem._ProductGroup_2 AS _ProductGroup_2,
  I_GLAccountLineItem._SalesOrder AS _SalesOrder,
  I_GLAccountLineItem._SalesDocument AS _SalesDocument,
  I_GLAccountLineItem._SalesOrderItem AS _SalesOrderItem,
  I_GLAccountLineItem._SalesDocumentItem AS _SalesDocumentItem,
  I_GLAccountLineItem._ProjectNetwork AS _ProjectNetwork,
  I_GLAccountLineItem._InternalOrder AS _InternalOrder,
  I_GLAccountLineItem._Order AS _Order,
  I_GLAccountLineItem._BusinessArea AS _BusinessArea,
  I_GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  I_GLAccountLineItem._CostCtrActivityType AS _CostCtrActivityType,
  I_GLAccountLineItem._CostAnalysisResource AS _CostAnalysisResource,
  I_GLAccountLineItem._BusinessProcess AS _BusinessProcess,
  I_GLAccountLineItem._OrderCategory AS _OrderCategory,
  I_GLAccountLineItem._ControllingObjectClass AS _ControllingObjectClass,
  I_GLAccountLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAccountLineItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_GLAccountLineItem._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountLineItem._AccountingDocumentType AS _AccountingDocumentType,
  I_GLAccountLineItem._FinancialAccountType AS _FinancialAccountType,
  I_GLAccountLineItem._DebitCreditCode AS _DebitCreditCode,
  I_GLAccountLineItem._Plant AS _Plant,
  I_GLAccountLineItem._Ledger AS _Ledger,
  I_GLAccountLineItem._SourceLedger AS _SourceLedger,
  I_GLAccountLineItem._Customer AS _Customer,
  I_GLAccountLineItem._CustomerCompany AS _CustomerCompany,
  I_GLAccountLineItem._CustomerGroup AS _CustomerGroup,
  I_GLAccountLineItem._Supplier AS _Supplier,
  I_GLAccountLineItem._SupplierCompany AS _SupplierCompany,
  I_GLAccountLineItem._Employment AS _Employment,
  I_GLAccountLineItem._PersonWorkAgreement_1 AS _PersonWorkAgreement_1,
  I_GLAccountLineItem._PostingKey AS _PostingKey,
  I_GLAccountLineItem._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
  I_GLAccountLineItem._AccountingDocumentCategory AS _AccountingDocumentCategory,
  I_GLAccountLineItem._FinancialTransactionType AS _FinancialTransactionType,
  I_GLAccountLineItem._BusinessTransactionCategory AS _BusinessTransactionCategory,
  I_GLAccountLineItem._BusinessTransactionType AS _BusinessTransactionType,
  I_GLAccountLineItem._ReferenceDocumentType AS _ReferenceDocumentType,
  I_GLAccountLineItem._PredecessorReferenceDocType AS _PredecessorReferenceDocType,
  I_GLAccountLineItem._PartnerControllingObjectClass AS _PartnerControllingObjectClass,
  I_GLAccountLineItem._PartnerCostCenter AS _PartnerCostCenter,
  I_GLAccountLineItem._PartnerProfitCenter AS _PartnerProfitCenter,
  I_GLAccountLineItem._PartnerBusinessArea AS _PartnerBusinessArea,
  I_GLAccountLineItem._PartnerFunctionalArea AS _PartnerFunctionalArea,
  I_GLAccountLineItem._PartnerCompanyCode AS _PartnerCompanyCode,
  I_GLAccountLineItem._PartnerSegment AS _PartnerSegment,
  I_GLAccountLineItem._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  I_GLAccountLineItem._PartnerOrder AS _PartnerOrder,
  I_GLAccountLineItem._PartnerOrder_2 AS _PartnerOrder_2,
  I_GLAccountLineItem._PartnerOrderCategory AS _PartnerOrderCategory,
  I_GLAccountLineItem._PartnerSalesDocument AS _PartnerSalesDocument,
  I_GLAccountLineItem._PartnerSalesDocumentItem AS _PartnerSalesDocumentItem,
  I_GLAccountLineItem._PartnerBusinessProcess AS _PartnerBusinessProcess,
  I_GLAccountLineItem._User AS _User,
  I_GLAccountLineItem._EliminationProfitCenter AS _EliminationProfitCenter,
  I_GLAccountLineItem._ControllingDebitCreditCode AS _ControllingDebitCreditCode,
  I_GLAccountLineItem._GLAccountType AS _GLAccountType,
  I_GLAccountLineItem._OffsettingAccountType AS _OffsettingAccountType,
  I_GLAccountLineItem._OffsettingChartOfAccounts AS _OffsettingChartOfAccounts,
  I_GLAccountLineItem._OffsettingAccount AS _OffsettingAccount,
  I_GLAccountLineItem._OffsettingAccountWithBP AS _OffsettingAccountWithBP,
  I_GLAccountLineItem._AlternativeGLAccount AS _AlternativeGLAccount,
  I_GLAccountLineItem._CountryChartOfAccounts AS _CountryChartOfAccounts,
  I_GLAccountLineItem._PurchasingDocument AS _PurchasingDocument,
  I_GLAccountLineItem._PurchasingDocumentItem AS _PurchasingDocumentItem,
  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._ClearingJrnlEntryFiscalYear AS _ClearingJrnlEntryFiscalYear,
  I_GLAccountLineItem._ClearingJournalEntry AS _ClearingJournalEntry,
  I_GLAccountLineItem._ClearingAccountingDocument AS _ClearingAccountingDocument,
  I_GLAccountLineItem._MasterFixedAsset AS _MasterFixedAsset,
  I_GLAccountLineItem._FixedAsset AS _FixedAsset,
  I_GLAccountLineItem._GroupMasterFixedAsset AS _GroupMasterFixedAsset,
  I_GLAccountLineItem._GroupFixedAsset AS _GroupFixedAsset,
  I_GLAccountLineItem._MovementCategory AS _MovementCategory,
  I_GLAccountLineItem._AssetTransactionType AS _AssetTransactionType,
  I_GLAccountLineItem._InventorySpecialStockValnType AS _InventorySpecialStockValnType,
  I_GLAccountLineItem._InventorySpclStockValnType AS _InventorySpclStockValnType,
  I_GLAccountLineItem._InventorySpecialStockType AS _InventorySpecialStockType,
  I_GLAccountLineItem._InventorySpclStkSalesDocument AS _InventorySpclStkSalesDocument,
  I_GLAccountLineItem._InventorySpclStkSalesDocItm AS _InventorySpclStkSalesDocItm,
  I_GLAccountLineItem._InventorySpecialStockSupplier AS _InventorySpecialStockSupplier,
  I_GLAccountLineItem._InventoryValuationType AS _InventoryValuationType,
  I_GLAccountLineItem._OriginSenderObject AS _OriginSenderObject,
  I_GLAccountLineItem._OriginCostCenter AS _OriginCostCenter,
  I_GLAccountLineItem._OriginProfitCenter AS _OriginProfitCenter,
  I_GLAccountLineItem._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  I_GLAccountLineItem._CostOriginGroup AS _CostOriginGroup,
  I_GLAccountLineItem._BillingDocumentType AS _BillingDocumentType,
  I_GLAccountLineItem._SalesOrganization AS _SalesOrganization,
  I_GLAccountLineItem._DistributionChannel AS _DistributionChannel,
  I_GLAccountLineItem._Division AS _Division,
  I_GLAccountLineItem._CustomerSupplierCountry AS _CustomerSupplierCountry,
  I_GLAccountLineItem._SalesDistrict AS _SalesDistrict,
  I_GLAccountLineItem._BillToParty AS _BillToParty,
  I_GLAccountLineItem._ShipToParty AS _ShipToParty,
  I_GLAccountLineItem._FundsCenter AS _FundsCenter,
  I_GLAccountLineItem._Fund AS _Fund,
  I_GLAccountLineItem._Grant AS _Grant,
  I_GLAccountLineItem._PartnerFund AS _PartnerFund,
  I_GLAccountLineItem._PartnerGrant AS _PartnerGrant,
  I_GLAccountLineItem._FinancialManagementArea AS _FinancialManagementArea,
  I_GLAccountLineItem._BudgetPeriod AS _BudgetPeriod,
  I_GLAccountLineItem._LogicalSystem AS _LogicalSystem,
  I_GLAccountLineItem._OperatingConcern AS _OperatingConcern,
  I_GLAccountLineItem._PartnerCompany AS _PartnerCompany,
  I_GLAccountLineItem._PurReqValuationArea AS _PurReqValuationArea,
  I_GLAccountLineItem._WorkCenter AS _WorkCenter,
  I_GLAccountLineItem._BillableControl AS _BillableControl,
  I_GLAccountLineItem._ConditionContract AS _ConditionContract,
  I_GLAccountLineItem._Equipment AS _Equipment,
  I_GLAccountLineItem._FunctionalLocation AS _FunctionalLocation,
  I_GLAccountLineItem._MaintenanceActivityType AS _MaintenanceActivityType,
  I_GLAccountLineItem._MaintOrdPlngDegreeCode AS _MaintOrdPlngDegreeCode,
  I_GLAccountLineItem._PMNotificationPriorityType AS _PMNotificationPriorityType,
  I_GLAccountLineItem._PMNotificationPriority AS _PMNotificationPriority,
  I_GLAccountLineItem._Assembly AS _Assembly,
  I_GLAccountLineItem._SuperiorOrder AS _SuperiorOrder,
  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._ServiceContract AS _ServiceContract,
  I_GLAccountLineItem._ServiceContractItem AS _ServiceContractItem,
  I_GLAccountLineItem._ServiceContractType AS _ServiceContractType,
  I_GLAccountLineItem._WorkPackage AS _WorkPackage,
  I_GLAccountLineItem._WorkPackageWorkItem AS _WorkPackageWorkItem,
  I_GLAccountLineItem._TimeSheetOvertimeCat AS _TimeSheetOvertimeCat,
  I_GLAccountLineItem._AccrualObjectType AS _AccrualObjectType,
  I_GLAccountLineItem._AccrualObject AS _AccrualObject,
  I_GLAccountLineItem._AccrualSubobject AS _AccrualSubobject,
  I_GLAccountLineItem._AccrualItemType AS _AccrualItemType,
  I_GLAccountLineItem._CreditRiskClass AS _CreditRiskClass,
  I_GLAccountLineItem._FinValuationObjectType AS _FinValuationObjectType,
  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.GLAccountAuthorizationGroup AS GLAccountAuthorizationGroup,
  I_GLAccountLineItem.SupplierBasicAuthorizationGrp AS SupplierBasicAuthorizationGrp,
  I_GLAccountLineItem.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
  I_GLAccountLineItem.AcctgDocTypeAuthorizationGroup AS AcctgDocTypeAuthorizationGroup,
  I_GLAccountLineItem.OrderType AS OrderType,
  I_GLAccountLineItem.SalesOrderType AS SalesOrderType
FROM I_GLAccountLineItem
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CorporateGroupAccount ON CorporateGroupChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CorporateGroupChartOfAccounts ON CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElementText ON WBSElement = _WBSElementText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _PartnerWBSElement ON PartnerWBSElement = _PartnerWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _PartnerWBSElementText ON PartnerWBSElement = _PartnerWBSElementText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _InventorySpclStockWBSElement ON InventorySpclStockWBSElement = _InventorySpclStockWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElemntBasicDataText ON PartnerWBSElementInternalID = _PartnerWBSElemntBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStockWBSElmntBD ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntBD.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Project AS _Project ON Project = _Project.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _ProjectText ON Project = _ProjectText.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _PartnerProject ON PartnerProject = _PartnerProject.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _PartnerProjectText ON PartnerProject = _PartnerProjectText.Project  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicDataText ON WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElementBasicData ON PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElmntBasicDataText ON PartnerWBSElementInternalID = _PartnerWBSElmntBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscData ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscDataT ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscDataT.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicDataText ON ProjectInternalID = _ProjectBasicDataText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicData ON PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicDataText ON PartnerProjectInternalID = _PartnerProjectBasicDataText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElemntExtrnalIDText ON PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _InvtrySpclStockWBSElmntExtID ON InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjctExtrnalIDText ON PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID  -- 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]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1..1]
LEFT OUTER JOIN I_CalendarQuarter AS _CalendarQuarter ON CalendarQuarter = _CalendarQuarter.CalendarQuarter  -- association [1..1]
LEFT OUTER JOIN I_YearMonth AS _CalendarYearMonth ON CalendarYearMonth = _CalendarYearMonth.YearMonth  -- association [1..1]
;