P_EntProjLineItemSemTagGLAcct

DDL: P_ENTPROJLINEITEMSEMTAGGLACCT Type: view_entity COMPOSITE Package: FINS_COPA_REPORTING

EntProj Line Item with Semantic Tag

P_EntProjLineItemSemTagGLAcct is a Composite CDS View that provides data about "EntProj Line Item with Semantic Tag" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItem, I_SemTagGLAccount) and exposes 495 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 27 associations to related views. Part of development package FINS_COPA_REPORTING.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem from
I_SemTagGLAccount I_SemTagGLAccount inner

Associations (27)

CardinalityTargetAliasCondition
[0..1] I_SemanticTag _SemanticTag $projection.SemanticTag = _SemanticTag.SemanticTag
[0..*] I_GLAccountHierarchy _GLHierarchy $projection.GLAccountHierarchy = _GLHierarchy.GLAccountHierarchy
[0..1] I_WBSElement _WBSElement $projection.WBSElement = _WBSElement.WBSElement
[0..1] I_WBSElementByExternalID _WBSElementExternalID $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID
[0..1] I_WBSElementByExternalID _WBSElementExternalIDText $projection.WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID
[0..1] I_ProjectByExternalID _ProjectExternalID $projection.projectexternalid = _ProjectExternalID.ProjectExternalID
[0..1] I_ProjectByExternalID _ProjectExternalIDText $projection.projectexternalid = _ProjectExternalIDText.ProjectExternalID
[0..1] I_ProjectByExternalID _PartnerProjectExternalID $projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID
[0..1] I_ProjectByExternalID _PartnerProjectExternalIDText $projection.PartnerProjectExternalID = _PartnerProjectExternalIDText.ProjectExternalID
[0..1] I_WBSElementBasicData _InvtrySpclStkWBSElmntBscData $projection.InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID
[0..1] I_WBSElementByExternalID _InvtrySpclStockWBSElmntExtID $projection.InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID
[0..1] I_WBSElementByExternalID _PartnerWBSElementExternalID $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID
[0..1] I_WBSElementByExternalID _PartnerWBSElementExtIDText $projection.PartnerWBSElementExternalID = _PartnerWBSElementExtIDText.WBSElementExternalID
[0..1] I_ProjectBasicData _ProjectBasicData $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
[0..1] I_ProjectBasicData _ProjectBasicDataText $projection.ProjectInternalID = _ProjectBasicDataText.ProjectInternalID
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
[0..1] I_WBSElementBasicData _WBSElementBasicDataText $projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID
[0..1] I_WBSElementBasicData _PartnerWBSElementBasicData $projection.PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID
[0..1] I_WBSElementBasicData _PartnerWBSElementBscDataText $projection.PartnerWBSElementInternalID = _PartnerWBSElementBscDataText.WBSElementInternalID
[0..1] I_ProjectBasicData _PartnerProjectBasicData $projection.PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID
[0..1] I_ProjectBasicData _PartnerProjectBasicDataText $projection.PartnerProjectInternalID = _PartnerProjectBasicDataText.ProjectInternalID
[0..1] I_ProjectProfileCode _ProjectProfileCode $projection.projectprofilecode = _ProjectProfileCode.ProjectProfileCode
[0..1] I_EnterpriseProjectElement _ProjectTask $projection.WBSElementInternalID = _ProjectTask.WBSElementInternalID
[0..1] I_EntProjProcessingStatus _ProcessingStatus $projection.processingstatus = _ProcessingStatus.ProcessingStatus
[0..1] I_ActlHistSheetHierKeyFigSpec _AssetKeyFigureSpecification $projection.AssetAcctTransClassfctn = _AssetKeyFigureSpecification.AssetAcctAnlytlTransClassfctn and $projection.SubLedgerAcctLineItemType = _AssetKeyFigureSpecification.SubLedgerAcctLineItemType
[0..1] I_AssetKeyFigure _AssetKeyFigure $projection.AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure
[0..*] I_FinancialStatementHierarchy _Hierarchy $projection.GLAccountHierarchy = _Hierarchy.GLAccountHierarchy

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey LedgerGLLineItem view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (495)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_GLAccountLineItem Ledger Ledger
KEY SourceLedger I_GLAccountLineItem SourceLedger Source Ledger
KEY CompanyCode I_GLAccountLineItem CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItem LedgerGLLineItem Journal Entry Item
KEY GLAccountHierarchy I_SemTagGLAccount GLAccountHierarchy
KEY SemanticTag I_SemTagGLAccount SemanticTag Semantic Tag
KEY ValidityStartDate I_SemTagGLAccount ValidityStartDate Validity Start Date
KEY ValidityEndDate I_SemTagGLAccount ValidityEndDate ValidTo
LedgerFiscalYear I_GLAccountLineItem LedgerFiscalYear
GLRecordType I_GLAccountLineItem GLRecordType Record Type
ChartOfAccounts I_GLAccountLineItem ChartOfAccounts Node Class
ControllingArea I_GLAccountLineItem ControllingArea Controlling Area
FinancialTransactionType I_GLAccountLineItem FinancialTransactionType Transact. Type
BusinessTransactionCategory I_GLAccountLineItem BusinessTransactionCategory Business Transaction Category
BusinessTransactionType I_GLAccountLineItem BusinessTransactionType Bus.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 Document
ReferenceDocumentItem I_GLAccountLineItem ReferenceDocumentItem Reference item
ReferenceDocumentItemGroup I_GLAccountLineItem ReferenceDocumentItemGroup Reference Document Item Group
IsReversal I_GLAccountLineItem IsReversal Reversal doc.
IsReversed I_GLAccountLineItem IsReversed Reversed?
ReversalReferenceDocumentCntxt I_GLAccountLineItem ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument I_GLAccountLineItem ReversalReferenceDocument Reversal Reference Document
IsSettlement I_GLAccountLineItem IsSettlement Is Settling
IsSettled I_GLAccountLineItem IsSettled Is Settled
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 Prec. Ref. Doc. Item
SourceReferenceDocumentType I_GLAccountLineItem SourceReferenceDocumentType Ref. procedure
SourceLogicalSystem I_GLAccountLineItem SourceLogicalSystem
SourceReferenceDocumentCntxt I_GLAccountLineItem SourceReferenceDocumentCntxt
SourceReferenceDocument I_GLAccountLineItem SourceReferenceDocument Reference Doc.
SourceReferenceDocumentItem I_GLAccountLineItem SourceReferenceDocumentItem Ref. Doc. Item
SourceReferenceDocSubitem I_GLAccountLineItem SourceReferenceDocSubitem
IsCommitment I_GLAccountLineItem IsCommitment
JrnlEntryItemObsoleteReason I_GLAccountLineItem JrnlEntryItemObsoleteReason
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 number
PartnerCostCenter I_GLAccountLineItem PartnerCostCenter Sender Cost Ctr
PartnerProfitCenter I_GLAccountLineItem PartnerProfitCenter Profit Center
PartnerFunctionalArea I_GLAccountLineItem PartnerFunctionalArea Rec. Fntcl Area
PartnerBusinessArea I_GLAccountLineItem PartnerBusinessArea Trdg Part.BA
PartnerCompany I_GLAccountLineItem PartnerCompany Trading Partner
PartnerSegment I_GLAccountLineItem PartnerSegment Partner Segment
BalanceTransactionCurrency I_GLAccountLineItem BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy I_GLAccountLineItem AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
TransactionCurrency I_GLAccountLineItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_GLAccountLineItem AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_GLAccountLineItem AmountInCompanyCodeCurrency Local Crcy Amt
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
GrpValnFixedAmtInGlobCrcy I_GLAccountLineItem GrpValnFixedAmtInGlobCrcy
PrftCtrValnFxdAmtInGlobCrcy I_GLAccountLineItem PrftCtrValnFxdAmtInGlobCrcy
TotalPriceVarcInGlobalCrcy I_GLAccountLineItem TotalPriceVarcInGlobalCrcy
GrpValnTotPrcVarcInGlobCrcy I_GLAccountLineItem GrpValnTotPrcVarcInGlobCrcy
PrftCtrValnTotPrcVarcInGlbCrcy I_GLAccountLineItem PrftCtrValnTotPrcVarcInGlbCrcy
FixedPriceVarcInGlobalCrcy I_GLAccountLineItem FixedPriceVarcInGlobalCrcy
GrpValnFixedPrcVarcInGlobCrcy I_GLAccountLineItem GrpValnFixedPrcVarcInGlobCrcy
PrftCtrValnFxdPrcVarcInGlbCrcy I_GLAccountLineItem PrftCtrValnFxdPrcVarcInGlbCrcy
FixedAmountInCoCodeCrcy I_GLAccountLineItem FixedAmountInCoCodeCrcy
ControllingObjectCurrency I_GLAccountLineItem ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency I_GLAccountLineItem AmountInObjectCurrency Amount in Obj Crcy
BaseUnit I_GLAccountLineItem BaseUnit Unit of Measure
Quantity I_GLAccountLineItem Quantity Value
FixedQuantity I_GLAccountLineItem FixedQuantity Fixed Quantity
CostSourceUnit I_GLAccountLineItem CostSourceUnit
ValuationQuantity I_GLAccountLineItem ValuationQuantity
ValuationFixedQuantity I_GLAccountLineItem ValuationFixedQuantity
AdditionalQuantity1Unit I_GLAccountLineItem AdditionalQuantity1Unit Add Unit Meas 1
AdditionalQuantity1 I_GLAccountLineItem AdditionalQuantity1
AdditionalQuantity2Unit I_GLAccountLineItem AdditionalQuantity2Unit Add Unit Meas 2
AdditionalQuantity2 I_GLAccountLineItem AdditionalQuantity2
AdditionalQuantity3Unit I_GLAccountLineItem AdditionalQuantity3Unit Add Unit Meas 3
AdditionalQuantity3 I_GLAccountLineItem AdditionalQuantity3
DebitCreditCode I_GLAccountLineItem DebitCreditCode Single-Character Flag
FiscalPeriod I_GLAccountLineItem FiscalPeriod Tax period
FiscalYearVariant I_GLAccountLineItem FiscalYearVariant FY Variant
FiscalYearPeriod I_GLAccountLineItem FiscalYearPeriod Period/Year
PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
DocumentDate I_GLAccountLineItem DocumentDate Journal Entry Date
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
AccountingDocumentItem I_GLAccountLineItem AccountingDocumentItem 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 SLALineItemType
AccountingDocCreatedByUser I_GLAccountLineItem AccountingDocCreatedByUser User which created overhead document
LastChangeDateTime I_GLAccountLineItem LastChangeDateTime Timestamp
CreationDateTime I_GLAccountLineItem CreationDateTime Timestamp
CreationDate I_GLAccountLineItem CreationDate Time Stamp
EliminationProfitCenter I_GLAccountLineItem EliminationProfitCenter
OriginObjectType I_GLAccountLineItem OriginObjectType Origin
GLAccountType I_GLAccountLineItem GLAccountType G/L Account Type
AlternativeGLAccount I_GLAccountLineItem AlternativeGLAccount Group Account
CountryChartOfAccounts I_GLAccountLineItem CountryChartOfAccounts Chart of Accts
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 Item
ReferencePurchaseOrderCategory I_GLAccountLineItem ReferencePurchaseOrderCategory
PurchasingDocument I_GLAccountLineItem PurchasingDocument Purchasing Document
PurchasingDocumentItem I_GLAccountLineItem PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber I_GLAccountLineItem AccountAssignmentNumber Account Assgmt No.
DocumentItemText I_GLAccountLineItem DocumentItemText Text
SalesOrder I_GLAccountLineItem SalesOrder SD Document
SalesOrderItem I_GLAccountLineItem SalesOrderItem Sales Order Item
SalesDocument I_GLAccountLineItem SalesDocument SD Document
Material I_GLAccountLineItem Material Vehicle Model
Product I_GLAccountLineItem Product Product Sold
Plant I_GLAccountLineItem Plant Valuation Area
Supplier I_GLAccountLineItem Supplier Supplier
Customer I_GLAccountLineItem Customer Sold-to Party
ServicesRenderedDate I_GLAccountLineItem ServicesRenderedDate Services Rendered Date
ConditionContract I_GLAccountLineItem ConditionContract Condition Contract
ComponentBreakdown I_GLAccountLineItem ComponentBreakdown
CompBreakdownScaleNumerator I_GLAccountLineItem CompBreakdownScaleNumerator
FinancialAccountType I_GLAccountLineItem FinancialAccountType Fin. Account Type
SpecialGLCode I_GLAccountLineItem SpecialGLCode Special G/L Ind
TaxCode I_GLAccountLineItem TaxCode Tax Code
HouseBank I_GLAccountLineItem HouseBank House Bank
HouseBankAccount I_GLAccountLineItem HouseBankAccount House Bank Account
ClearingDate I_GLAccountLineItem ClearingDate Clearing Date
ClearingAccountingDocument I_GLAccountLineItem ClearingAccountingDocument Clearing Journal Entry
ClearingDocFiscalYear I_GLAccountLineItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
AssetDepreciationArea I_GLAccountLineItem AssetDepreciationArea Deprec. Area
MasterFixedAsset I_GLAccountLineItem MasterFixedAsset Fixed Asset
FixedAsset I_GLAccountLineItem FixedAsset Sub-number
AssetValueDate I_GLAccountLineItem AssetValueDate Reference date
AssetTransactionType I_GLAccountLineItem AssetTransactionType Trans.Type
AssetAcctTransClassfctn I_GLAccountLineItem AssetAcctTransClassfctn Trans.Type Cat.
DepreciationFiscalPeriod I_GLAccountLineItem DepreciationFiscalPeriod Deprec. Period
GroupMasterFixedAsset I_GLAccountLineItem GroupMasterFixedAsset
GroupFixedAsset I_GLAccountLineItem GroupFixedAsset
CostEstimate I_GLAccountLineItem CostEstimate Cost EstimateNo
InventorySpecialStockValnType I_GLAccountLineItem InventorySpecialStockValnType Valuation
InvtrySpecialStockValnType_2 I_GLAccountLineItem InvtrySpecialStockValnType_2 Valuation
InventorySpecialStockType I_GLAccountLineItem InventorySpecialStockType Special Stock Type
InventorySpclStkSalesDocument I_GLAccountLineItem InventorySpclStkSalesDocument
InventorySpclStkSalesDocItm I_GLAccountLineItem InventorySpclStkSalesDocItm
InvtrySpclStockWBSElmntIntID I_GLAccountLineItem InvtrySpclStockWBSElmntIntID
InvtrySpclStockWBSElmntExtID
InventorySpclStockWBSElement I_GLAccountLineItem InventorySpclStockWBSElement
InventorySpecialStockSupplier I_GLAccountLineItem InventorySpecialStockSupplier
InventoryValuationType I_GLAccountLineItem InventoryValuationType Valuation Type
ValuationArea I_GLAccountLineItem ValuationArea Valuation Area
SenderGLAccount I_GLAccountLineItem SenderGLAccount
SenderAccountAssignment I_GLAccountLineItem SenderAccountAssignment
SenderAccountAssignmentType I_GLAccountLineItem SenderAccountAssignmentType
CostOriginGroup I_GLAccountLineItem CostOriginGroup Origin Group
OriginSenderObject I_GLAccountLineItem OriginSenderObject
ControllingDebitCreditCode I_GLAccountLineItem ControllingDebitCreditCode Dr/Cr ind. CO
ControllingObjectDebitType I_GLAccountLineItem ControllingObjectDebitType
OffsettingAccount I_GLAccountLineItem OffsettingAccount Offsetting Acct
OffsettingAccountType I_GLAccountLineItem OffsettingAccountType Offset Acct Type
OffsettingChartOfAccounts I_GLAccountLineItem OffsettingChartOfAccounts Offsetting Chart of Accounts
LineItemIsCompleted I_GLAccountLineItem LineItemIsCompleted Item Completed
PersonnelNumber I_GLAccountLineItem PersonnelNumber Personnel No.
ControllingObjectClass I_GLAccountLineItem ControllingObjectClass Object Class
PartnerCompanyCode I_GLAccountLineItem PartnerCompanyCode Partner Company Code
PartnerControllingObjectClass I_GLAccountLineItem PartnerControllingObjectClass
OriginCostCenter I_GLAccountLineItem OriginCostCenter
OriginProfitCenter I_GLAccountLineItem OriginProfitCenter
OriginCostCtrActivityType I_GLAccountLineItem OriginCostCtrActivityType
AccountAssignment I_GLAccountLineItem AccountAssignment Sender Acct Assgmt
AccountAssignmentType I_GLAccountLineItem AccountAssignmentType Sndr AcctAssgmt Type
CostCtrActivityType I_GLAccountLineItem CostCtrActivityType Activity Type
OrderID I_GLAccountLineItem OrderID Order ID
OrderCategory I_GLAccountLineItem OrderCategory Order Category
WBSElementInternalID I_GLAccountLineItem WBSElementInternalID WBS Internal ID
WBSElementExternalID
ProcessingStatus _ProjectTask ProcessingStatus Worklist Status
WBSElement I_GLAccountLineItem WBSElement WBS Internal ID
PartnerWBSElementInternalID I_GLAccountLineItem PartnerWBSElementInternalID Partner WBS Element Internal ID
PartnerWBSElementExternalID
ProjectInternalID I_GLAccountLineItem ProjectInternalID Project Def.
ProjectExternalID _ProjectBasicData ProjectExternalID Project def.
project
ProjectProfileCode _ProjectBasicData ProjectProfileCode Project Profile
PartnerProjectInternalID I_GLAccountLineItem PartnerProjectInternalID
PartnerProjectExternalID
OperatingConcern I_GLAccountLineItem OperatingConcern Operating concern
ProjectNetwork I_GLAccountLineItem ProjectNetwork Order
RelatedNetworkActivity I_GLAccountLineItem RelatedNetworkActivity Netwk activity
BusinessProcess I_GLAccountLineItem BusinessProcess Business Process
CostObject I_GLAccountLineItem CostObject Cost Object
BillableControl I_GLAccountLineItem BillableControl Billable Control
CostAnalysisResource I_GLAccountLineItem CostAnalysisResource
CustomerServiceNotification I_GLAccountLineItem CustomerServiceNotification
ServiceDocumentType I_GLAccountLineItem ServiceDocumentType Transaction Type
ServiceDocument I_GLAccountLineItem ServiceDocument Transaction ID
ServiceDocumentItem I_GLAccountLineItem ServiceDocumentItem Service Document
ServiceContractType I_GLAccountLineItem ServiceContractType
ServiceContract I_GLAccountLineItem ServiceContract Transaction ID
ServiceContractItem I_GLAccountLineItem ServiceContractItem Item Number in Doc.
BusinessSolutionOrder I_GLAccountLineItem BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem I_GLAccountLineItem BusinessSolutionOrderItem Solution Order Item
ProviderContract I_GLAccountLineItem ProviderContract Contract
ProviderContractItem I_GLAccountLineItem ProviderContractItem Contract Item
TimeSheetOvertimeCategory I_GLAccountLineItem TimeSheetOvertimeCategory
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 Partner Order
PartnerOrder_2 I_GLAccountLineItem PartnerOrder_2
PartnerOrderCategory I_GLAccountLineItem PartnerOrderCategory
PartnerWBSElement I_GLAccountLineItem PartnerWBSElement WBS Element
PartnerProject I_GLAccountLineItem PartnerProject
PartnerSalesDocument I_GLAccountLineItem PartnerSalesDocument Partner Sales Doc.
PartnerSalesDocumentItem I_GLAccountLineItem PartnerSalesDocumentItem Partner Sales Document Item
PartnerProjectNetwork I_GLAccountLineItem PartnerProjectNetwork Part. Proj. Network
PartnerProjectNetworkActivity I_GLAccountLineItem PartnerProjectNetworkActivity Partner Project Network Activity
PartnerBusinessProcess I_GLAccountLineItem PartnerBusinessProcess Part. Bus. Process
PartnerCostObject I_GLAccountLineItem PartnerCostObject Partner Cost Object
BillingDocumentType I_GLAccountLineItem BillingDocumentType Billing Type
SalesOrganization I_GLAccountLineItem SalesOrganization Sales Organization
DistributionChannel I_GLAccountLineItem DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_GLAccountLineItem OrganizationDivision Org. Division
SoldMaterial I_GLAccountLineItem SoldMaterial Product Sold
SoldProduct I_GLAccountLineItem SoldProduct Product Sold
MaterialGroup I_GLAccountLineItem MaterialGroup Product Group
SoldProductGroup I_GLAccountLineItem SoldProductGroup Product Sold Group
ProductGroup I_GLAccountLineItem ProductGroup Product Sold Group
CustomerGroup I_GLAccountLineItem CustomerGroup Customer Group
CustomerSupplierCountry I_GLAccountLineItem CustomerSupplierCountry Customer or Supplier Country/Region
CustomerSupplierIndustry I_GLAccountLineItem CustomerSupplierIndustry 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 Group
FinancialManagementArea I_GLAccountLineItem FinancialManagementArea FM Area
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 Partner Budget Period
FundsCenter I_GLAccountLineItem FundsCenter Funds Center
FundedProgram I_GLAccountLineItem FundedProgram Funded Program
JointVenture I_GLAccountLineItem JointVenture Joint venture
JointVentureEquityGroup I_GLAccountLineItem JointVentureEquityGroup Joint Venture Equity Group
JointVentureCostRecoveryCode I_GLAccountLineItem JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityType I_GLAccountLineItem JointVentureEquityType Joint Venture Equity Type
SettlementReferenceDate I_GLAccountLineItem SettlementReferenceDate Reference date
WorkCenterInternalID I_GLAccountLineItem WorkCenterInternalID Work Center
OrderOperation I_GLAccountLineItem OrderOperation Operation or Phase
OrderItem I_GLAccountLineItem OrderItem
OrderSuboperation I_GLAccountLineItem OrderSuboperation
Equipment I_GLAccountLineItem Equipment Equipment check
Assembly I_GLAccountLineItem Assembly Pegged Reqmt
MaintenanceActivityType I_GLAccountLineItem MaintenanceActivityType MaintActivType
MaintenanceOrderPlanningCode I_GLAccountLineItem MaintenanceOrderPlanningCode OrderPlanInd.
MaintPriorityType I_GLAccountLineItem MaintPriorityType PriorityType
MaintPriority I_GLAccountLineItem MaintPriority Priority
SuperiorOrder I_GLAccountLineItem SuperiorOrder
MaintenanceOrderIsPlanned I_GLAccountLineItem MaintenanceOrderIsPlanned
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 Amt in DC
CreditAmountInTransCrcy I_GLAccountLineItem CreditAmountInTransCrcy Credit Amt in DC
DebitAmountInBalanceTransCrcy I_GLAccountLineItem DebitAmountInBalanceTransCrcy Debit Amount in Balance Trans. Currency
CreditAmountInBalanceTransCrcy I_GLAccountLineItem CreditAmountInBalanceTransCrcy Credit Amount in Balance Trans. Currency
DebitAmountInGlobalCrcy I_GLAccountLineItem DebitAmountInGlobalCrcy
CreditAmountInGlobalCrcy I_GLAccountLineItem CreditAmountInGlobalCrcy
DebitAmountInFunctionalCrcy I_GLAccountLineItem DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy I_GLAccountLineItem CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
IsStatisticalOrder I_GLAccountLineItem IsStatisticalOrder Statistical Order
IsStatisticalCostCenter I_GLAccountLineItem IsStatisticalCostCenter Cost Center Is Stat.
IsStatisticalSalesDocument I_GLAccountLineItem IsStatisticalSalesDocument
WBSIsStatisticalWBSElement I_GLAccountLineItem WBSIsStatisticalWBSElement Statistical
FiscalQuarter
FiscalYearQuarter
AssetAccountingKeyFigure
_JournalEntry I_GLAccountLineItem _JournalEntry
_CompanyCode I_GLAccountLineItem _CompanyCode
_FiscalYear I_GLAccountLineItem _FiscalYear
_FiscalPeriod I_GLAccountLineItem _FiscalPeriod
_FiscalPeriodForVariant I_GLAccountLineItem _FiscalPeriodForVariant
_LedgerFiscalYear I_GLAccountLineItem _LedgerFiscalYear
_LedgerFiscalYearForVariant I_GLAccountLineItem _LedgerFiscalYearForVariant
_FiscalYearVariant I_GLAccountLineItem _FiscalYearVariant
_FiscalYearPeriod I_GLAccountLineItem _FiscalYearPeriod
_FiscalYearPeriodForVariant I_GLAccountLineItem _FiscalYearPeriodForVariant
_CalendarDate I_GLAccountLineItem _CalendarDate
_FiscalCalendarDate I_GLAccountLineItem _FiscalCalendarDate
_ControllingArea I_GLAccountLineItem _ControllingArea
_BalanceTransactionCurrency I_GLAccountLineItem _BalanceTransactionCurrency
_TransactionCurrency I_GLAccountLineItem _TransactionCurrency
_CompanyCodeCurrency I_GLAccountLineItem _CompanyCodeCurrency
_GlobalCurrency I_GLAccountLineItem _GlobalCurrency
_FunctionalCurrency I_GLAccountLineItem _FunctionalCurrency
_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
_BaseUnit I_GLAccountLineItem _BaseUnit
_CostSourceUnit I_GLAccountLineItem _CostSourceUnit
_AdditionalQuantity1Unit I_GLAccountLineItem _AdditionalQuantity1Unit
_AdditionalQuantity2Unit I_GLAccountLineItem _AdditionalQuantity2Unit
_AdditionalQuantity3Unit I_GLAccountLineItem _AdditionalQuantity3Unit
_Segment I_GLAccountLineItem _Segment
_ProfitCenter I_GLAccountLineItem _ProfitCenter
_CurrentProfitCenter I_GLAccountLineItem _CurrentProfitCenter
_CostCenter I_GLAccountLineItem _CostCenter
_CurrentCostCenter I_GLAccountLineItem _CurrentCostCenter
_CostAnalysisResource I_GLAccountLineItem _CostAnalysisResource
_ProcessingStatus _ProcessingStatus
_WBSElement _WBSElement
_WBSElementInternalID I_GLAccountLineItem _WBSElementInternalID
_WBSElementExternalID _WBSElementExternalID
_Project I_GLAccountLineItem _Project
_ProjectProfileCode _ProjectProfileCode
_ProjectExternalID _ProjectExternalID
_BusinessArea I_GLAccountLineItem _BusinessArea
_FunctionalArea I_GLAccountLineItem _FunctionalArea
_GLAccountInChartOfAccounts I_GLAccountLineItem _GLAccountInChartOfAccounts
_GLAccountInCompanyCode I_GLAccountLineItem _GLAccountInCompanyCode
_ChartOfAccounts I_GLAccountLineItem _ChartOfAccounts
_AccountingDocumentType I_GLAccountLineItem _AccountingDocumentType
_FinancialAccountType I_GLAccountLineItem _FinancialAccountType
_DebitCreditCode I_GLAccountLineItem _DebitCreditCode
_Material I_GLAccountLineItem _Material
_Product I_GLAccountLineItem _Product
_Plant I_GLAccountLineItem _Plant
_Ledger I_GLAccountLineItem _Ledger
_SourceLedger I_GLAccountLineItem _SourceLedger
_Customer I_GLAccountLineItem _Customer
_CustomerGroup I_GLAccountLineItem _CustomerGroup
_Supplier I_GLAccountLineItem _Supplier
_MaterialGroup I_GLAccountLineItem _MaterialGroup
_ProductGroup I_GLAccountLineItem _ProductGroup
_SalesOrder I_GLAccountLineItem _SalesOrder
_SalesOrderItem I_GLAccountLineItem _SalesOrderItem
_SalesDocument I_GLAccountLineItem _SalesDocument
_InternalOrder I_GLAccountLineItem _InternalOrder
_Order I_GLAccountLineItem _Order
_FinancialTransactionType I_GLAccountLineItem _FinancialTransactionType
_BusinessTransactionCategory I_GLAccountLineItem _BusinessTransactionCategory
_BusinessTransactionType I_GLAccountLineItem _BusinessTransactionType
_ReferenceDocumentType I_GLAccountLineItem _ReferenceDocumentType
_PredecessorReferenceDocType I_GLAccountLineItem _PredecessorReferenceDocType
_PartnerCostCenter I_GLAccountLineItem _PartnerCostCenter
_PartnerProfitCenter I_GLAccountLineItem _PartnerProfitCenter
_PartnerBusinessArea I_GLAccountLineItem _PartnerBusinessArea
_PartnerFunctionalArea I_GLAccountLineItem _PartnerFunctionalArea
_PartnerCompanyCode I_GLAccountLineItem _PartnerCompanyCode
_PartnerSegment I_GLAccountLineItem _PartnerSegment
_AccountingDocumentCategory I_GLAccountLineItem _AccountingDocumentCategory
_PostingKey I_GLAccountLineItem _PostingKey
_User I_GLAccountLineItem _User
_EliminationProfitCenter I_GLAccountLineItem _EliminationProfitCenter
_GLAccountType I_GLAccountLineItem _GLAccountType
_OffsettingAccountType I_GLAccountLineItem _OffsettingAccountType
_OffsettingChartOfAccounts I_GLAccountLineItem _OffsettingChartOfAccounts
_OffsettingAccount I_GLAccountLineItem _OffsettingAccount
_OffsettingAccountWithBP I_GLAccountLineItem _OffsettingAccountWithBP
_AlternativeGLAccount I_GLAccountLineItem _AlternativeGLAccount
_CountryChartOfAccounts I_GLAccountLineItem _CountryChartOfAccounts
_PurchasingDocument I_GLAccountLineItem _PurchasingDocument
_PurchasingDocumentItem I_GLAccountLineItem _PurchasingDocumentItem
_SpecialGLCode I_GLAccountLineItem _SpecialGLCode
_TaxCode I_GLAccountLineItem _TaxCode
_HouseBank I_GLAccountLineItem _HouseBank
_ClearingAccountingDocument I_GLAccountLineItem _ClearingAccountingDocument
_FixedAsset I_GLAccountLineItem _FixedAsset
_MasterFixedAsset I_GLAccountLineItem _MasterFixedAsset
_GroupMasterFixedAsset I_GLAccountLineItem _GroupMasterFixedAsset
_GroupFixedAsset I_GLAccountLineItem _GroupFixedAsset
_InventorySpecialStockValnType I_GLAccountLineItem _InventorySpecialStockValnType
_InventorySpclStockValnType I_GLAccountLineItem _InventorySpclStockValnType
_InventorySpecialStockType I_GLAccountLineItem _InventorySpecialStockType
_InventorySpclStkSalesDocument I_GLAccountLineItem _InventorySpclStkSalesDocument
_InventorySpclStkSalesDocItm I_GLAccountLineItem _InventorySpclStkSalesDocItm
_InvtrySpclStockWBSElmntIntID I_GLAccountLineItem _InvtrySpclStockWBSElmntIntID
_InventorySpclStockWBSElement I_GLAccountLineItem _InventorySpclStockWBSElement
_InventorySpecialStockSupplier I_GLAccountLineItem _InventorySpecialStockSupplier
_InventoryValuationType I_GLAccountLineItem _InventoryValuationType
_ControllingDebitCreditCode I_GLAccountLineItem _ControllingDebitCreditCode
_OriginSenderObject I_GLAccountLineItem _OriginSenderObject
_ControllingObjectClass I_GLAccountLineItem _ControllingObjectClass
_PartnerControllingObjectClass I_GLAccountLineItem _PartnerControllingObjectClass
_OriginCostCenter I_GLAccountLineItem _OriginCostCenter
_OriginProfitCenter I_GLAccountLineItem _OriginProfitCenter
_CostCtrActivityType I_GLAccountLineItem _CostCtrActivityType
_OriginCostCtrActivityType I_GLAccountLineItem _OriginCostCtrActivityType
_OrderCategory I_GLAccountLineItem _OrderCategory
_BusinessProcess I_GLAccountLineItem _BusinessProcess
_PartnerCostCtrActivityType I_GLAccountLineItem _PartnerCostCtrActivityType
_PartnerOrder I_GLAccountLineItem _PartnerOrder
_PartnerOrder_2 I_GLAccountLineItem _PartnerOrder_2
_PartnerOrderCategory I_GLAccountLineItem _PartnerOrderCategory
_PartnerWBSElement I_GLAccountLineItem _PartnerWBSElement
_PartnerProject I_GLAccountLineItem _PartnerProject
_PartnerSalesDocument I_GLAccountLineItem _PartnerSalesDocument
_PartnerSalesDocumentItem I_GLAccountLineItem _PartnerSalesDocumentItem
_PartnerBusinessProcess I_GLAccountLineItem _PartnerBusinessProcess
_BillingDocumentType I_GLAccountLineItem _BillingDocumentType
_SalesOrganization I_GLAccountLineItem _SalesOrganization
_DistributionChannel I_GLAccountLineItem _DistributionChannel
_SoldMaterial I_GLAccountLineItem _SoldMaterial
_SoldProduct I_GLAccountLineItem _SoldProduct
_Fund I_GLAccountLineItem _Fund
_PartnerFund I_GLAccountLineItem _PartnerFund
_FundsCenter I_GLAccountLineItem _FundsCenter
_MovementCategory I_GLAccountLineItem _MovementCategory
_AssetTransactionType I_GLAccountLineItem _AssetTransactionType
_BudgetPeriod I_GLAccountLineItem _BudgetPeriod
_CostOriginGroup I_GLAccountLineItem _CostOriginGroup
_CustomerSupplierCountry I_GLAccountLineItem _CustomerSupplierCountry
_SalesDistrict I_GLAccountLineItem _SalesDistrict
_BillToParty I_GLAccountLineItem _BillToParty
_ShipToParty I_GLAccountLineItem _ShipToParty
_FinancialManagementArea I_GLAccountLineItem _FinancialManagementArea
_HouseBankAccount I_GLAccountLineItem _HouseBankAccount
_LogicalSystem I_GLAccountLineItem _LogicalSystem
_OperatingConcern I_GLAccountLineItem _OperatingConcern
_PartnerCompany I_GLAccountLineItem _PartnerCompany
_ProjectNetwork I_GLAccountLineItem _ProjectNetwork
_PurReqValuationArea I_GLAccountLineItem _PurReqValuationArea
_SemanticTag _SemanticTag
_Equipment I_GLAccountLineItem _Equipment
_MaintenanceActivityType I_GLAccountLineItem _MaintenanceActivityType
_MaintOrdPlngDegreeCode I_GLAccountLineItem _MaintOrdPlngDegreeCode
_PMNotificationPriorityType I_GLAccountLineItem _PMNotificationPriorityType
_PMNotificationPriority I_GLAccountLineItem _PMNotificationPriority
_MaintenanceOrderSubOperation I_GLAccountLineItem _MaintenanceOrderSubOperation
_Assembly I_GLAccountLineItem _Assembly
_SuperiorOrder I_GLAccountLineItem _SuperiorOrder
_ProjectInternalID I_GLAccountLineItem _ProjectInternalID
_ConditionContract I_GLAccountLineItem _ConditionContract
_SoldProductGroup I_GLAccountLineItem _SoldProductGroup
_ServiceDocumentType I_GLAccountLineItem _ServiceDocumentType
_ServiceDocument I_GLAccountLineItem _ServiceDocument
_ServiceDocumentItem I_GLAccountLineItem _ServiceDocumentItem
_ServiceContract I_GLAccountLineItem _ServiceContract
_ServiceContractItem I_GLAccountLineItem _ServiceContractItem
_ServiceContractType I_GLAccountLineItem _ServiceContractType
_ProviderContract I_GLAccountLineItem _ProviderContract
_ProviderContractItem I_GLAccountLineItem _ProviderContractItem
_TimeSheetOvertimeCat I_GLAccountLineItem _TimeSheetOvertimeCat
_WBSElementBasicData _WBSElementBasicData
_WBSElementBasicDataText _WBSElementBasicDataText
_ProjectBasicData _ProjectBasicData
_ProjectBasicDataText _ProjectBasicDataText
_PartnerProjectExternalID _PartnerProjectExternalID
_PartnerProjectExternalIDText _PartnerProjectExternalIDText
_PartnerWBSElementExternalID _PartnerWBSElementExternalID
_PartnerWBSElementExtIDText _PartnerWBSElementExtIDText
_PartnerProjectBasicData _PartnerProjectBasicData
_PartnerProjectBasicDataText _PartnerProjectBasicDataText
_PartnerWBSElementBasicData _PartnerWBSElementBasicData
_PartnerWBSElementBscDataText _PartnerWBSElementBscDataText
_InvtrySpclStkWBSElmntBscData _InvtrySpclStkWBSElmntBscData
_InvtrySpclStockWBSElmntExtID _InvtrySpclStockWBSElmntExtID
GLAccountAuthorizationGroup I_GLAccountLineItem GLAccountAuthorizationGroup
SupplierBasicAuthorizationGrp I_GLAccountLineItem SupplierBasicAuthorizationGrp
CustomerBasicAuthorizationGrp I_GLAccountLineItem CustomerBasicAuthorizationGrp
AcctgDocTypeAuthorizationGroup I_GLAccountLineItem AcctgDocTypeAuthorizationGroup
OrderType I_GLAccountLineItem OrderType Order Type
SalesOrderType I_GLAccountLineItem SalesOrderType Sales Order Type
AssetClass I_GLAccountLineItem AssetClass Asset Class
_AssetKeyFigure _AssetKeyFigure

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 P_EntProjLineItemSemTagGLAcct.
-- 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 P_EntProjLineItemSemTagGLAcct AS
SELECT
  I_GLAccountLineItem.Ledger AS Ledger,
  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_SemTagGLAccount.GLAccountHierarchy AS GLAccountHierarchy,
  I_SemTagGLAccount.SemanticTag AS SemanticTag,
  I_SemTagGLAccount.ValidityStartDate AS ValidityStartDate,
  I_SemTagGLAccount.ValidityEndDate AS ValidityEndDate,
  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.BusinessTransactionCategory AS BusinessTransactionCategory,
  I_GLAccountLineItem.BusinessTransactionType AS BusinessTransactionType,
  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.IsReversal AS IsReversal,
  I_GLAccountLineItem.IsReversed AS IsReversed,
  I_GLAccountLineItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  I_GLAccountLineItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  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.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.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.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.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.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.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.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.HouseBank AS HouseBank,
  I_GLAccountLineItem.HouseBankAccount AS HouseBankAccount,
  I_GLAccountLineItem.ClearingDate AS ClearingDate,
  I_GLAccountLineItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  I_GLAccountLineItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  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.CostEstimate AS CostEstimate,
  I_GLAccountLineItem.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_GLAccountLineItem.InvtrySpecialStockValnType_2 AS InvtrySpecialStockValnType_2,
  I_GLAccountLineItem.InventorySpecialStockType AS InventorySpecialStockType,
  I_GLAccountLineItem.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  I_GLAccountLineItem.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  I_GLAccountLineItem.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  I_GLAccountLineItem._InvtrySpclStkWBSElmntBscData.WBSElementExternalID AS InvtrySpclStockWBSElmntExtID,
  I_GLAccountLineItem.InventorySpclStockWBSElement AS InventorySpclStockWBSElement,
  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.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.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,
  I_GLAccountLineItem._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _ProjectTask.ProcessingStatus AS ProcessingStatus,
  I_GLAccountLineItem.WBSElement AS WBSElement,
  I_GLAccountLineItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  I_GLAccountLineItem._PartnerWBSElementBasicData.WBSElementExternalID AS PartnerWBSElementExternalID,
  I_GLAccountLineItem.ProjectInternalID AS ProjectInternalID,
  _ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  cast( I_GLAccountLineItem.Project as fis_rep_project preserving type ) AS project,
  _ProjectBasicData.ProjectProfileCode AS ProjectProfileCode,
  I_GLAccountLineItem.PartnerProjectInternalID AS PartnerProjectInternalID,
  I_GLAccountLineItem._PartnerProjectBasicData.ProjectExternalID AS PartnerProjectExternalID,
  I_GLAccountLineItem.OperatingConcern AS OperatingConcern,
  I_GLAccountLineItem.ProjectNetwork AS ProjectNetwork,
  I_GLAccountLineItem.RelatedNetworkActivity AS RelatedNetworkActivity,
  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.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 AS PartnerOrder,
  I_GLAccountLineItem.PartnerOrder_2 AS PartnerOrder_2,
  I_GLAccountLineItem.PartnerOrderCategory AS PartnerOrderCategory,
  I_GLAccountLineItem.PartnerWBSElement AS PartnerWBSElement,
  I_GLAccountLineItem.PartnerProject AS PartnerProject,
  I_GLAccountLineItem.PartnerSalesDocument AS PartnerSalesDocument,
  I_GLAccountLineItem.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  I_GLAccountLineItem.PartnerProjectNetwork AS PartnerProjectNetwork,
  I_GLAccountLineItem.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  I_GLAccountLineItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAccountLineItem.PartnerCostObject AS PartnerCostObject,
  I_GLAccountLineItem.BillingDocumentType AS BillingDocumentType,
  I_GLAccountLineItem.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItem.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItem.SoldMaterial AS SoldMaterial,
  I_GLAccountLineItem.SoldProduct AS SoldProduct,
  I_GLAccountLineItem.MaterialGroup AS MaterialGroup,
  I_GLAccountLineItem.SoldProductGroup AS SoldProductGroup,
  I_GLAccountLineItem.ProductGroup AS ProductGroup,
  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.FinancialManagementArea AS FinancialManagementArea,
  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.FundsCenter AS FundsCenter,
  I_GLAccountLineItem.FundedProgram AS FundedProgram,
  I_GLAccountLineItem.JointVenture AS JointVenture,
  I_GLAccountLineItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_GLAccountLineItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  I_GLAccountLineItem.JointVentureEquityType AS JointVentureEquityType,
  I_GLAccountLineItem.SettlementReferenceDate AS SettlementReferenceDate,
  I_GLAccountLineItem.WorkCenterInternalID AS WorkCenterInternalID,
  I_GLAccountLineItem.OrderOperation AS OrderOperation,
  I_GLAccountLineItem.OrderItem AS OrderItem,
  I_GLAccountLineItem.OrderSuboperation AS OrderSuboperation,
  I_GLAccountLineItem.Equipment AS Equipment,
  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.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.IsStatisticalOrder AS IsStatisticalOrder,
  I_GLAccountLineItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  I_GLAccountLineItem.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  I_GLAccountLineItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  cast(_AssetKeyFigureSpecification.AssetAccountingKeyFigure as fis_asset_key_figure) AS AssetAccountingKeyFigure,
  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._CalendarDate AS _CalendarDate,
  I_GLAccountLineItem._FiscalCalendarDate AS _FiscalCalendarDate,
  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._CostAnalysisResource AS _CostAnalysisResource,
  I_GLAccountLineItem._WBSElementInternalID AS _WBSElementInternalID,
  I_GLAccountLineItem._Project AS _Project,
  I_GLAccountLineItem._BusinessArea AS _BusinessArea,
  I_GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  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._Material AS _Material,
  I_GLAccountLineItem._Product AS _Product,
  I_GLAccountLineItem._Plant AS _Plant,
  I_GLAccountLineItem._Ledger AS _Ledger,
  I_GLAccountLineItem._SourceLedger AS _SourceLedger,
  I_GLAccountLineItem._Customer AS _Customer,
  I_GLAccountLineItem._CustomerGroup AS _CustomerGroup,
  I_GLAccountLineItem._Supplier AS _Supplier,
  I_GLAccountLineItem._MaterialGroup AS _MaterialGroup,
  I_GLAccountLineItem._ProductGroup AS _ProductGroup,
  I_GLAccountLineItem._SalesOrder AS _SalesOrder,
  I_GLAccountLineItem._SalesOrderItem AS _SalesOrderItem,
  I_GLAccountLineItem._SalesDocument AS _SalesDocument,
  I_GLAccountLineItem._InternalOrder AS _InternalOrder,
  I_GLAccountLineItem._Order AS _Order,
  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._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._AccountingDocumentCategory AS _AccountingDocumentCategory,
  I_GLAccountLineItem._PostingKey AS _PostingKey,
  I_GLAccountLineItem._User AS _User,
  I_GLAccountLineItem._EliminationProfitCenter AS _EliminationProfitCenter,
  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._HouseBank AS _HouseBank,
  I_GLAccountLineItem._ClearingAccountingDocument AS _ClearingAccountingDocument,
  I_GLAccountLineItem._FixedAsset AS _FixedAsset,
  I_GLAccountLineItem._MasterFixedAsset AS _MasterFixedAsset,
  I_GLAccountLineItem._GroupMasterFixedAsset AS _GroupMasterFixedAsset,
  I_GLAccountLineItem._GroupFixedAsset AS _GroupFixedAsset,
  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._InvtrySpclStockWBSElmntIntID AS _InvtrySpclStockWBSElmntIntID,
  I_GLAccountLineItem._InventorySpclStockWBSElement AS _InventorySpclStockWBSElement,
  I_GLAccountLineItem._InventorySpecialStockSupplier AS _InventorySpecialStockSupplier,
  I_GLAccountLineItem._InventoryValuationType AS _InventoryValuationType,
  I_GLAccountLineItem._ControllingDebitCreditCode AS _ControllingDebitCreditCode,
  I_GLAccountLineItem._OriginSenderObject AS _OriginSenderObject,
  I_GLAccountLineItem._ControllingObjectClass AS _ControllingObjectClass,
  I_GLAccountLineItem._PartnerControllingObjectClass AS _PartnerControllingObjectClass,
  I_GLAccountLineItem._OriginCostCenter AS _OriginCostCenter,
  I_GLAccountLineItem._OriginProfitCenter AS _OriginProfitCenter,
  I_GLAccountLineItem._CostCtrActivityType AS _CostCtrActivityType,
  I_GLAccountLineItem._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  I_GLAccountLineItem._OrderCategory AS _OrderCategory,
  I_GLAccountLineItem._BusinessProcess AS _BusinessProcess,
  I_GLAccountLineItem._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  I_GLAccountLineItem._PartnerOrder AS _PartnerOrder,
  I_GLAccountLineItem._PartnerOrder_2 AS _PartnerOrder_2,
  I_GLAccountLineItem._PartnerOrderCategory AS _PartnerOrderCategory,
  I_GLAccountLineItem._PartnerWBSElement AS _PartnerWBSElement,
  I_GLAccountLineItem._PartnerProject AS _PartnerProject,
  I_GLAccountLineItem._PartnerSalesDocument AS _PartnerSalesDocument,
  I_GLAccountLineItem._PartnerSalesDocumentItem AS _PartnerSalesDocumentItem,
  I_GLAccountLineItem._PartnerBusinessProcess AS _PartnerBusinessProcess,
  I_GLAccountLineItem._BillingDocumentType AS _BillingDocumentType,
  I_GLAccountLineItem._SalesOrganization AS _SalesOrganization,
  I_GLAccountLineItem._DistributionChannel AS _DistributionChannel,
  I_GLAccountLineItem._SoldMaterial AS _SoldMaterial,
  I_GLAccountLineItem._SoldProduct AS _SoldProduct,
  I_GLAccountLineItem._Fund AS _Fund,
  I_GLAccountLineItem._PartnerFund AS _PartnerFund,
  I_GLAccountLineItem._FundsCenter AS _FundsCenter,
  I_GLAccountLineItem._MovementCategory AS _MovementCategory,
  I_GLAccountLineItem._AssetTransactionType AS _AssetTransactionType,
  I_GLAccountLineItem._BudgetPeriod AS _BudgetPeriod,
  I_GLAccountLineItem._CostOriginGroup AS _CostOriginGroup,
  I_GLAccountLineItem._CustomerSupplierCountry AS _CustomerSupplierCountry,
  I_GLAccountLineItem._SalesDistrict AS _SalesDistrict,
  I_GLAccountLineItem._BillToParty AS _BillToParty,
  I_GLAccountLineItem._ShipToParty AS _ShipToParty,
  I_GLAccountLineItem._FinancialManagementArea AS _FinancialManagementArea,
  I_GLAccountLineItem._HouseBankAccount AS _HouseBankAccount,
  I_GLAccountLineItem._LogicalSystem AS _LogicalSystem,
  I_GLAccountLineItem._OperatingConcern AS _OperatingConcern,
  I_GLAccountLineItem._PartnerCompany AS _PartnerCompany,
  I_GLAccountLineItem._ProjectNetwork AS _ProjectNetwork,
  I_GLAccountLineItem._PurReqValuationArea AS _PurReqValuationArea,
  I_GLAccountLineItem._Equipment AS _Equipment,
  I_GLAccountLineItem._MaintenanceActivityType AS _MaintenanceActivityType,
  I_GLAccountLineItem._MaintOrdPlngDegreeCode AS _MaintOrdPlngDegreeCode,
  I_GLAccountLineItem._PMNotificationPriorityType AS _PMNotificationPriorityType,
  I_GLAccountLineItem._PMNotificationPriority AS _PMNotificationPriority,
  I_GLAccountLineItem._MaintenanceOrderSubOperation AS _MaintenanceOrderSubOperation,
  I_GLAccountLineItem._Assembly AS _Assembly,
  I_GLAccountLineItem._SuperiorOrder AS _SuperiorOrder,
  I_GLAccountLineItem._ProjectInternalID AS _ProjectInternalID,
  I_GLAccountLineItem._ConditionContract AS _ConditionContract,
  I_GLAccountLineItem._SoldProductGroup AS _SoldProductGroup,
  I_GLAccountLineItem._ServiceDocumentType AS _ServiceDocumentType,
  I_GLAccountLineItem._ServiceDocument AS _ServiceDocument,
  I_GLAccountLineItem._ServiceDocumentItem AS _ServiceDocumentItem,
  I_GLAccountLineItem._ServiceContract AS _ServiceContract,
  I_GLAccountLineItem._ServiceContractItem AS _ServiceContractItem,
  I_GLAccountLineItem._ServiceContractType AS _ServiceContractType,
  I_GLAccountLineItem._ProviderContract AS _ProviderContract,
  I_GLAccountLineItem._ProviderContractItem AS _ProviderContractItem,
  I_GLAccountLineItem._TimeSheetOvertimeCat AS _TimeSheetOvertimeCat,
  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,
  I_GLAccountLineItem.AssetClass AS AssetClass
FROM I_GLAccountLineItem
INNER JOIN I_SemTagGLAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SemanticTag AS _SemanticTag ON SemanticTag = _SemanticTag.SemanticTag  -- association [0..1]
LEFT OUTER JOIN I_GLAccountHierarchy AS _GLHierarchy ON GLAccountHierarchy = _GLHierarchy.GLAccountHierarchy  -- association [0..*]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- 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_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 _PartnerProjectExternalIDText ON PartnerProjectExternalID = _PartnerProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscData ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _InvtrySpclStockWBSElmntExtID ON InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExtIDText ON PartnerWBSElementExternalID = _PartnerWBSElementExtIDText.WBSElementExternalID  -- 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_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 _PartnerWBSElementBscDataText ON PartnerWBSElementInternalID = _PartnerWBSElementBscDataText.WBSElementInternalID  -- 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_ProjectProfileCode AS _ProjectProfileCode ON projectprofilecode = _ProjectProfileCode.ProjectProfileCode  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProjectElement AS _ProjectTask ON WBSElementInternalID = _ProjectTask.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_EntProjProcessingStatus AS _ProcessingStatus ON processingstatus = _ProcessingStatus.ProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_ActlHistSheetHierKeyFigSpec AS _AssetKeyFigureSpecification ON AssetAcctTransClassfctn = _AssetKeyFigureSpecification.AssetAcctAnlytlTransClassfctn AND SubLedgerAcctLineItemType = _AssetKeyFigureSpecification.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_AssetKeyFigure AS _AssetKeyFigure ON AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementHierarchy AS _Hierarchy ON GLAccountHierarchy = _Hierarchy.GLAccountHierarchy  -- association [0..*]
;