I_GLAccountBalance

DDL: I_GLACCOUNTBALANCE Type: view_entity COMPOSITE Package: FINS_FIS_FICO
520 Fields 1 Data Sources 2 Associations

G/L Account Balance with Flow-Measure

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

Data Sources (1)

SourceAliasJoin Type
P_GLAccountBalance P_GLAccountBalance from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Grant _Grant $projection.GrantID = _Grant.GrantID
[0..1] I_Grant _PartnerGrant $projection.PartnerGrant = _PartnerGrant.GrantID

Annotations (16)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label G/L Account Balance with Flow-Measure view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataCategory #CUBE view
Analytics.technicalName IFIGLACCTBAL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey LedgerGLLineItem view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view
Environment.sql.passValueForClient true view
Analytics.readClassName CL_FIS_GL_ACCOUNT_BALANCE_CDS view
Metadata.allowExtensions true view

Fields (520)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger P_GLAccountBalance SourceLedger Source Ledger
KEY CompanyCode P_GLAccountBalance CompanyCode Receiver Company Code
KEY FiscalYear P_GLAccountBalance FiscalYear G/L Fiscal Year
KEY AccountingDocument P_GLAccountBalance AccountingDocument Journal Entry
KEY LedgerGLLineItem P_GLAccountBalance LedgerGLLineItem Journal Entry Item
KEY Ledger P_GLAccountBalance Ledger Ledger
LedgerFiscalYear P_GLAccountBalance LedgerFiscalYear
GLRecordType P_GLAccountBalance GLRecordType Record Type
ChartOfAccounts P_GLAccountBalance ChartOfAccounts Node Class
ControllingArea P_GLAccountBalance ControllingArea Controlling Area
FinancialTransactionType P_GLAccountBalance FinancialTransactionType Transact. Type
BusinessTransactionType P_GLAccountBalance BusinessTransactionType Bus.transaction
ReferenceDocumentType P_GLAccountBalance ReferenceDocumentType Reference Document Type
LogicalSystem P_GLAccountBalance LogicalSystem Logical System
ReferenceDocumentContext P_GLAccountBalance ReferenceDocumentContext Reference Document Context
ReferenceDocument P_GLAccountBalance ReferenceDocument Reference Document
ReferenceDocumentItem P_GLAccountBalance ReferenceDocumentItem Reference item
ReferenceDocumentItemGroup P_GLAccountBalance ReferenceDocumentItemGroup Reference Document Item Group
IsReversal P_GLAccountBalance IsReversal Reversal doc.
IsReversed P_GLAccountBalance IsReversed Reversed?
ReversalReferenceDocumentCntxt P_GLAccountBalance ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument P_GLAccountBalance ReversalReferenceDocument Reversal Reference Document
IsSettlement P_GLAccountBalance IsSettlement Is Settling
IsSettled P_GLAccountBalance IsSettled Is Settled
PredecessorReferenceDocType P_GLAccountBalance PredecessorReferenceDocType Predecessor Reference Document Type
PredecessorReferenceDocCntxt P_GLAccountBalance PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocument P_GLAccountBalance PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem P_GLAccountBalance PredecessorReferenceDocItem Prec. Ref. Doc. Item
SourceReferenceDocumentType P_GLAccountBalance SourceReferenceDocumentType Ref. procedure
SourceLogicalSystem P_GLAccountBalance SourceLogicalSystem
SourceReferenceDocumentCntxt P_GLAccountBalance SourceReferenceDocumentCntxt
SourceReferenceDocument P_GLAccountBalance SourceReferenceDocument Reference Doc.
SourceReferenceDocumentItem P_GLAccountBalance SourceReferenceDocumentItem Ref. Doc. Item
SourceReferenceDocSubitem P_GLAccountBalance SourceReferenceDocSubitem
IsCommitment P_GLAccountBalance IsCommitment
JrnlEntryItemObsoleteReason P_GLAccountBalance JrnlEntryItemObsoleteReason
GLAccount P_GLAccountBalance GLAccount General Ledger
CostCenter P_GLAccountBalance CostCenter Cost Center
ProfitCenter P_GLAccountBalance ProfitCenter Profit Center
FunctionalArea P_GLAccountBalance FunctionalArea Sendr Fctl Area
BusinessArea P_GLAccountBalance BusinessArea Business Area
Segment P_GLAccountBalance Segment Segment number
PartnerCostCenter P_GLAccountBalance PartnerCostCenter Sender Cost Ctr
PartnerProfitCenter P_GLAccountBalance PartnerProfitCenter Profit Center
PartnerFunctionalArea P_GLAccountBalance PartnerFunctionalArea Rec. Fntcl Area
PartnerBusinessArea P_GLAccountBalance PartnerBusinessArea Trdg Part.BA
PartnerCompany P_GLAccountBalance PartnerCompany Trading Partner
PartnerSegment P_GLAccountBalance PartnerSegment Partner Segment
BalanceTransactionCurrency P_GLAccountBalance BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy P_GLAccountBalance AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
FlowAmountInBalanceTransCrcy P_GLAccountBalance FlowAmountInBalanceTransCrcy
DebitAmountInBalanceTransCrcy P_GLAccountBalance DebitAmountInBalanceTransCrcy Debit Amount in Balance Trans. Currency
CreditAmountInBalanceTransCrcy P_GLAccountBalance CreditAmountInBalanceTransCrcy Credit Amount in Balance Trans. Currency
TransactionCurrency P_GLAccountBalance TransactionCurrency Transaction Currency
AmountInTransactionCurrency P_GLAccountBalance AmountInTransactionCurrency Pt Crcy Amt
FlowAmountInTransCrcy P_GLAccountBalance FlowAmountInTransCrcy
DebitAmountInTransCrcy P_GLAccountBalance DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy P_GLAccountBalance CreditAmountInTransCrcy Credit Amt in DC
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_GLAccountBalance AmountInCompanyCodeCurrency Local Crcy Amt
FlowAmountInCoCodeCrcy P_GLAccountBalance FlowAmountInCoCodeCrcy
DebitAmountInCoCodeCrcy P_GLAccountBalance DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy P_GLAccountBalance CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
GlobalCurrency P_GLAccountBalance GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency P_GLAccountBalance AmountInGlobalCurrency Amount in Global Currency
FlowAmountInGlobalCrcy P_GLAccountBalance FlowAmountInGlobalCrcy
DebitAmountInGlobalCrcy P_GLAccountBalance DebitAmountInGlobalCrcy
CreditAmountInGlobalCrcy P_GLAccountBalance CreditAmountInGlobalCrcy
FreeDefinedCurrency1 P_GLAccountBalance FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 P_GLAccountBalance AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FlowAmountInFreeDfndCrcy1 P_GLAccountBalance FlowAmountInFreeDfndCrcy1
DebitAmountInFreeDfndCrcy1 P_GLAccountBalance DebitAmountInFreeDfndCrcy1
CreditAmountInFreeDfndCrcy1 P_GLAccountBalance CreditAmountInFreeDfndCrcy1
FreeDefinedCurrency2 P_GLAccountBalance FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 P_GLAccountBalance AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FlowAmountInFreeDfndCrcy2 P_GLAccountBalance FlowAmountInFreeDfndCrcy2
DebitAmountInFreeDfndCrcy2 P_GLAccountBalance DebitAmountInFreeDfndCrcy2
CreditAmountInFreeDfndCrcy2 P_GLAccountBalance CreditAmountInFreeDfndCrcy2
FreeDefinedCurrency3 P_GLAccountBalance FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 P_GLAccountBalance AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FlowAmountInFreeDfndCrcy3 P_GLAccountBalance FlowAmountInFreeDfndCrcy3
DebitAmountInFreeDfndCrcy3 P_GLAccountBalance DebitAmountInFreeDfndCrcy3
CreditAmountInFreeDfndCrcy3 P_GLAccountBalance CreditAmountInFreeDfndCrcy3
FreeDefinedCurrency4 P_GLAccountBalance FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 P_GLAccountBalance AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FlowAmountInFreeDfndCrcy4 P_GLAccountBalance FlowAmountInFreeDfndCrcy4
DebitAmountInFreeDfndCrcy4 P_GLAccountBalance DebitAmountInFreeDfndCrcy4
CreditAmountInFreeDfndCrcy4 P_GLAccountBalance CreditAmountInFreeDfndCrcy4
FreeDefinedCurrency5 P_GLAccountBalance FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FlowAmountInFreeDfndCrcy5 P_GLAccountBalance FlowAmountInFreeDfndCrcy5
DebitAmountInFreeDfndCrcy5 P_GLAccountBalance DebitAmountInFreeDfndCrcy5
CreditAmountInFreeDfndCrcy5 P_GLAccountBalance CreditAmountInFreeDfndCrcy5
FreeDefinedCurrency6 P_GLAccountBalance FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 P_GLAccountBalance AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FlowAmountInFreeDfndCrcy6 P_GLAccountBalance FlowAmountInFreeDfndCrcy6
DebitAmountInFreeDfndCrcy6 P_GLAccountBalance DebitAmountInFreeDfndCrcy6
CreditAmountInFreeDfndCrcy6 P_GLAccountBalance CreditAmountInFreeDfndCrcy6
FreeDefinedCurrency7 P_GLAccountBalance FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 P_GLAccountBalance AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FlowAmountInFreeDfndCrcy7 P_GLAccountBalance FlowAmountInFreeDfndCrcy7
DebitAmountInFreeDfndCrcy7 P_GLAccountBalance DebitAmountInFreeDfndCrcy7
CreditAmountInFreeDfndCrcy7 P_GLAccountBalance CreditAmountInFreeDfndCrcy7
FreeDefinedCurrency8 P_GLAccountBalance FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 P_GLAccountBalance AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
FlowAmountInFreeDfndCrcy8 P_GLAccountBalance FlowAmountInFreeDfndCrcy8
DebitAmountInFreeDfndCrcy8 P_GLAccountBalance DebitAmountInFreeDfndCrcy8
CreditAmountInFreeDfndCrcy8 P_GLAccountBalance CreditAmountInFreeDfndCrcy8
GLAccountFlowType P_GLAccountBalance GLAccountFlowType
GLAccountTypeFlowType P_GLAccountBalance GLAccountTypeFlowType
IsBalanceSheetAccount P_GLAccountBalance IsBalanceSheetAccount Is Balance Sheet Account
DebitCreditCode P_GLAccountBalance DebitCreditCode Single-Character Flag
FiscalPeriod P_GLAccountBalance FiscalPeriod Tax period
FiscalYearVariant P_GLAccountBalance FiscalYearVariant FY Variant
FiscalYearPeriod P_GLAccountBalance FiscalYearPeriod Period/Year
PostingDate P_GLAccountBalance PostingDate Posting Date for GR
DocumentDate P_GLAccountBalance DocumentDate Journal Entry Date
AccountingDocumentType P_GLAccountBalance AccountingDocumentType Journal Entry Type
AccountingDocumentItem P_GLAccountBalance AccountingDocumentItem Posting View Item
AssignmentReference P_GLAccountBalance AssignmentReference Assignment Reference
AccountingDocumentCategory P_GLAccountBalance AccountingDocumentCategory Journal Entry Category
PostingKey P_GLAccountBalance PostingKey Posting Key
TransactionTypeDetermination P_GLAccountBalance TransactionTypeDetermination Transaction Key
SubLedgerAcctLineItemType P_GLAccountBalance SubLedgerAcctLineItemType SLALineItemType
AccountingDocCreatedByUser P_GLAccountBalance AccountingDocCreatedByUser User which created overhead document
LastChangeDateTime P_GLAccountBalance LastChangeDateTime Timestamp
CreationDateTime P_GLAccountBalance CreationDateTime Timestamp
CreationDate P_GLAccountBalance CreationDate Time Stamp
EliminationProfitCenter P_GLAccountBalance EliminationProfitCenter
OriginObjectType P_GLAccountBalance OriginObjectType Origin
GLAccountType P_GLAccountBalance GLAccountType G/L Account Type
AlternativeGLAccount P_GLAccountBalance AlternativeGLAccount Group Account
CountryChartOfAccounts P_GLAccountBalance CountryChartOfAccounts Chart of Accts
InvoiceReference P_GLAccountBalance InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear P_GLAccountBalance InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
FollowOnDocumentType P_GLAccountBalance FollowOnDocumentType Follow-On Document Type
InvoiceItemReference P_GLAccountBalance InvoiceItemReference Item
ReferencePurchaseOrderCategory P_GLAccountBalance ReferencePurchaseOrderCategory
PurchasingDocument P_GLAccountBalance PurchasingDocument Purchasing Document
PurchasingDocumentItem P_GLAccountBalance PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber P_GLAccountBalance AccountAssignmentNumber Account Assgmt No.
DocumentItemText P_GLAccountBalance DocumentItemText Text
SalesDocument P_GLAccountBalance SalesDocument SD Document
SalesDocumentItem P_GLAccountBalance SalesDocumentItem Sales Document Item
Product P_GLAccountBalance Product Product Sold
Plant P_GLAccountBalance Plant Valuation Area
Supplier P_GLAccountBalance Supplier Supplier
Customer P_GLAccountBalance Customer Sold-to Party
ServicesRenderedDate P_GLAccountBalance ServicesRenderedDate Services Rendered Date
ConditionContract P_GLAccountBalance ConditionContract Condition Contract
FinancialAccountType P_GLAccountBalance FinancialAccountType Fin. Account Type
SpecialGLCode P_GLAccountBalance SpecialGLCode Special G/L Ind
TaxCode P_GLAccountBalance TaxCode Tax Code
HouseBank P_GLAccountBalance HouseBank House Bank
HouseBankAccount P_GLAccountBalance HouseBankAccount House Bank Account
IsOpenItemManaged P_GLAccountBalance IsOpenItemManaged Open Item Management
ClearingDate P_GLAccountBalance ClearingDate Clearing Date
ClearingAccountingDocument P_GLAccountBalance ClearingAccountingDocument Clearing Journal Entry
ClearingDocFiscalYear P_GLAccountBalance ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
ClearingJournalEntry P_GLAccountBalance ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear P_GLAccountBalance ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
AssetDepreciationArea P_GLAccountBalance AssetDepreciationArea Deprec. Area
MasterFixedAsset P_GLAccountBalance MasterFixedAsset Fixed Asset
FixedAsset P_GLAccountBalance FixedAsset Sub-number
AssetValueDate P_GLAccountBalance AssetValueDate Reference date
AssetTransactionType P_GLAccountBalance AssetTransactionType Trans.Type
AssetAcctTransClassfctn P_GLAccountBalance AssetAcctTransClassfctn Trans.Type Cat.
DepreciationFiscalPeriod P_GLAccountBalance DepreciationFiscalPeriod Deprec. Period
GroupMasterFixedAsset P_GLAccountBalance GroupMasterFixedAsset
GroupFixedAsset P_GLAccountBalance GroupFixedAsset
CostEstimate P_GLAccountBalance CostEstimate Cost EstimateNo
InventorySpecialStockValnType P_GLAccountBalance InventorySpecialStockValnType Valuation
InvtrySpecialStockValnType_2 P_GLAccountBalance InvtrySpecialStockValnType_2
InventorySpecialStockType P_GLAccountBalance InventorySpecialStockType Special Stock Type
InventorySpclStkSalesDocument P_GLAccountBalance InventorySpclStkSalesDocument
InventorySpclStkSalesDocItm P_GLAccountBalance InventorySpclStkSalesDocItm
InvtrySpclStockWBSElmntIntID P_GLAccountBalance InvtrySpclStockWBSElmntIntID
InvtrySpclStockWBSElmntExtID P_GLAccountBalance InvtrySpclStockWBSElmntExtID
InventorySpecialStockSupplier P_GLAccountBalance InventorySpecialStockSupplier
InventoryValuationType P_GLAccountBalance InventoryValuationType Valuation Type
ValuationArea P_GLAccountBalance ValuationArea Valuation Area
SenderGLAccount P_GLAccountBalance SenderGLAccount
SenderAccountAssignment P_GLAccountBalance SenderAccountAssignment
SenderAccountAssignmentType P_GLAccountBalance SenderAccountAssignmentType
CostOriginGroup P_GLAccountBalance CostOriginGroup Origin Group
OriginSenderObject P_GLAccountBalance OriginSenderObject
ControllingDebitCreditCode P_GLAccountBalance ControllingDebitCreditCode Dr/Cr ind. CO
ControllingObjectDebitType P_GLAccountBalance ControllingObjectDebitType
QuantityIsIncomplete P_GLAccountBalance QuantityIsIncomplete
OffsettingAccount P_GLAccountBalance OffsettingAccount Offsetting Acct
OffsettingAccountType P_GLAccountBalance OffsettingAccountType Offset Acct Type
OffsettingChartOfAccounts P_GLAccountBalance OffsettingChartOfAccounts Offsetting Chart of Accounts
LineItemIsCompleted P_GLAccountBalance LineItemIsCompleted Item Completed
PersonnelNumber P_GLAccountBalance PersonnelNumber Personnel No.
ControllingObjectClass P_GLAccountBalance ControllingObjectClass Object Class
PartnerCompanyCode P_GLAccountBalance PartnerCompanyCode Partner Company Code
PartnerControllingObjectClass P_GLAccountBalance PartnerControllingObjectClass
OriginCostCenter P_GLAccountBalance OriginCostCenter
OriginProfitCenter P_GLAccountBalance OriginProfitCenter
OriginCostCtrActivityType P_GLAccountBalance OriginCostCtrActivityType
AccountAssignment P_GLAccountBalance AccountAssignment Sender Acct Assgmt
AccountAssignmentType P_GLAccountBalance AccountAssignmentType Sndr AcctAssgmt Type
CostCtrActivityType P_GLAccountBalance CostCtrActivityType Activity Type
OrderID P_GLAccountBalance OrderID Order ID
OrderCategory P_GLAccountBalance OrderCategory Order Category
ServiceDocumentType P_GLAccountBalance ServiceDocumentType Transaction Type
ServiceDocument P_GLAccountBalance ServiceDocument Transaction ID
ServiceDocumentItem P_GLAccountBalance ServiceDocumentItem Service Document
ServiceContractType P_GLAccountBalance ServiceContractType
ServiceContract P_GLAccountBalance ServiceContract Transaction ID
ServiceContractItem P_GLAccountBalance ServiceContractItem Item Number in Doc.
TimeSheetOvertimeCategory P_GLAccountBalance TimeSheetOvertimeCategory
WBSElementInternalID P_GLAccountBalance WBSElementInternalID WBS Internal ID
WBSElementExternalID P_GLAccountBalance WBSElementExternalID WBS Element External ID
WBSElement P_GLAccountBalance WBSElement WBS Internal ID
ProjectInternalID P_GLAccountBalance ProjectInternalID Project Def.
ProjectExternalID P_GLAccountBalance ProjectExternalID Project def.
Project P_GLAccountBalance Project WBS Element
OperatingConcern P_GLAccountBalance OperatingConcern Operating concern
ProjectNetwork P_GLAccountBalance ProjectNetwork Order
RelatedNetworkActivity P_GLAccountBalance RelatedNetworkActivity Netwk activity
BusinessProcess P_GLAccountBalance BusinessProcess Business Process
CostObject P_GLAccountBalance CostObject Cost Object
BillableControl P_GLAccountBalance BillableControl Billable Control
CostAnalysisResource P_GLAccountBalance CostAnalysisResource
CustomerServiceNotification P_GLAccountBalance CustomerServiceNotification
PartnerAccountAssignment P_GLAccountBalance PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType P_GLAccountBalance PartnerAccountAssignmentType Partner Account Assignment Type
WorkPackage P_GLAccountBalance WorkPackage Plan Item
WorkItem P_GLAccountBalance WorkItem Work Item ID
PartnerCostCtrActivityType P_GLAccountBalance PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerOrder P_GLAccountBalance PartnerOrder Partner Order
PartnerOrder_2 P_GLAccountBalance PartnerOrder_2
PartnerOrderCategory P_GLAccountBalance PartnerOrderCategory
PartnerWBSElementInternalID P_GLAccountBalance PartnerWBSElementInternalID Partner WBS Element Internal ID
PartnerWBSElementExternalID P_GLAccountBalance PartnerWBSElementExternalID Partner WBSElmnt ext
PartnerWBSElement P_GLAccountBalance PartnerWBSElement WBS Element
PartnerProjectInternalID P_GLAccountBalance PartnerProjectInternalID
PartnerProjectExternalID P_GLAccountBalance PartnerProjectExternalID Partner Project External ID
PartnerProject P_GLAccountBalance PartnerProject
PartnerSalesDocument P_GLAccountBalance PartnerSalesDocument Partner Sales Doc.
PartnerSalesDocumentItem P_GLAccountBalance PartnerSalesDocumentItem Partner Sales Document Item
PartnerProjectNetwork P_GLAccountBalance PartnerProjectNetwork Part. Proj. Network
PartnerProjectNetworkActivity P_GLAccountBalance PartnerProjectNetworkActivity Partner Project Network Activity
PartnerBusinessProcess P_GLAccountBalance PartnerBusinessProcess Part. Bus. Process
PartnerCostObject P_GLAccountBalance PartnerCostObject Partner Cost Object
BillingDocumentType P_GLAccountBalance BillingDocumentType Billing Type
SalesOrganization P_GLAccountBalance SalesOrganization Sales Organization
DistributionChannel P_GLAccountBalance DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_GLAccountBalance OrganizationDivision Org. Division
SoldProduct P_GLAccountBalance SoldProduct Product Sold
SoldProductGroup P_GLAccountBalance SoldProductGroup Product Sold Group
CustomerGroup P_GLAccountBalance CustomerGroup Customer Group
CustomerSupplierCountry P_GLAccountBalance CustomerSupplierCountry Customer or Supplier Country/Region
CustomerSupplierIndustry P_GLAccountBalance CustomerSupplierIndustry Industry
SalesDistrict P_GLAccountBalance SalesDistrict Sales District
BillToParty P_GLAccountBalance BillToParty Inv. Recipient
ShipToParty P_GLAccountBalance ShipToParty Ship-To Party (obsolete)
CustomerSupplierCorporateGroup P_GLAccountBalance CustomerSupplierCorporateGroup Group
JointVenture P_GLAccountBalance JointVenture Joint venture
JointVentureEquityGroup P_GLAccountBalance JointVentureEquityGroup Joint Venture Equity Group
JointVentureCostRecoveryCode P_GLAccountBalance JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityType P_GLAccountBalance JointVentureEquityType Joint Venture Equity Type
SettlementReferenceDate P_GLAccountBalance SettlementReferenceDate Reference date
WorkCenterInternalID P_GLAccountBalance WorkCenterInternalID Work Center
OrderOperation P_GLAccountBalance OrderOperation Operation or Phase
OrderItem P_GLAccountBalance OrderItem
OrderSuboperation P_GLAccountBalance OrderSuboperation
Equipment P_GLAccountBalance Equipment Equipment check
FunctionalLocation P_GLAccountBalance FunctionalLocation Object ID
Assembly P_GLAccountBalance Assembly Pegged Reqmt
MaintenanceActivityType P_GLAccountBalance MaintenanceActivityType MaintActivType
MaintenanceOrderPlanningCode P_GLAccountBalance MaintenanceOrderPlanningCode OrderPlanInd.
MaintPriorityType P_GLAccountBalance MaintPriorityType PriorityType
MaintPriority P_GLAccountBalance MaintPriority Priority
SuperiorOrder P_GLAccountBalance SuperiorOrder
ProductGroup P_GLAccountBalance ProductGroup Product Sold Group
MaintenanceOrderIsPlanned P_GLAccountBalance MaintenanceOrderIsPlanned
IsStatisticalOrder P_GLAccountBalance IsStatisticalOrder Statistical Order
IsStatisticalCostCenter P_GLAccountBalance IsStatisticalCostCenter Cost Center Is Stat.
IsStatisticalSalesDocument P_GLAccountBalance IsStatisticalSalesDocument
WBSIsStatisticalWBSElement P_GLAccountBalance WBSIsStatisticalWBSElement Statistical
CalendarYear P_GLAccountBalance CalendarYear Year
CalendarQuarter P_GLAccountBalance CalendarQuarter Calendar Quarter
CalendarYearQuarter P_GLAccountBalance CalendarYearQuarter
CalendarMonth P_GLAccountBalance CalendarMonth Calendar Month
CalendarYearMonth P_GLAccountBalance CalendarYearMonth
CalendarWeek P_GLAccountBalance CalendarWeek Calendar Week
CalendarYearWeek P_GLAccountBalance CalendarYearWeek
FiscalQuarter
FiscalWeek
FiscalYearQuarter
FiscalYearWeek
AccrualObjectLogicalSystem P_GLAccountBalance AccrualObjectLogicalSystem Logical System
AccrualObjectType P_GLAccountBalance AccrualObjectType Accrual Object Type
AccrualObject P_GLAccountBalance AccrualObject External Reference of Accrual Object
AccrualSubobject P_GLAccountBalance AccrualSubobject External Reference of Accrual Subobject
AccrualItemType P_GLAccountBalance AccrualItemType Accrual Item Type
CashLedgerCompanyCode P_GLAccountBalance CashLedgerCompanyCode Cash Origin CoCode
CashLedgerAccount P_GLAccountBalance CashLedgerAccount Cash Origin Account
FinancialManagementArea P_GLAccountBalance FinancialManagementArea FM Area
FundsCenter P_GLAccountBalance FundsCenter Funds Center
FundedProgram P_GLAccountBalance FundedProgram Funded Program
Fund P_GLAccountBalance Fund Sender Fund
GrantID P_GLAccountBalance GrantID Sender Grant
BudgetPeriod P_GLAccountBalance BudgetPeriod Budget Period
PartnerFund P_GLAccountBalance PartnerFund Receiver Fund
PartnerGrant P_GLAccountBalance PartnerGrant Receiver Grant
PartnerBudgetPeriod P_GLAccountBalance PartnerBudgetPeriod Partner Budget Period
PubSecBudgetAccount P_GLAccountBalance PubSecBudgetAccount Budget Account
PubSecBudgetAccountCoCode P_GLAccountBalance PubSecBudgetAccountCoCode Company Code for Budget Account
PubSecBudgetCnsmpnDate P_GLAccountBalance PubSecBudgetCnsmpnDate
PubSecBudgetCnsmpnFsclPeriod P_GLAccountBalance PubSecBudgetCnsmpnFsclPeriod
PubSecBudgetCnsmpnFsclYear P_GLAccountBalance PubSecBudgetCnsmpnFsclYear
PubSecBudgetIsRelevant P_GLAccountBalance PubSecBudgetIsRelevant
PubSecBudgetCnsmpnType P_GLAccountBalance PubSecBudgetCnsmpnType Budget Consumption Type
PubSecBudgetCnsmpnAmtType P_GLAccountBalance PubSecBudgetCnsmpnAmtType
AssetClass P_GLAccountBalance AssetClass Asset Class
SalesOrder P_GLAccountBalance SalesOrder SD Document
SalesOrderItem P_GLAccountBalance SalesOrderItem Sales Order Item
_AccrualObjectType P_GLAccountBalance _AccrualObjectType
_AccrualObject P_GLAccountBalance _AccrualObject
_AccrualSubobject P_GLAccountBalance _AccrualSubobject
_AccrualItemType P_GLAccountBalance _AccrualItemType
_AccountingDocumentCategory P_GLAccountBalance _AccountingDocumentCategory
_AccountingDocumentType P_GLAccountBalance _AccountingDocumentType
_AccountingDocumentTypeText P_GLAccountBalance _AccountingDocumentTypeText
_AlternativeGLAccount P_GLAccountBalance _AlternativeGLAccount
_Assembly P_GLAccountBalance _Assembly
_AssetTransactionType P_GLAccountBalance _AssetTransactionType
_BalanceTransactionCurrency P_GLAccountBalance _BalanceTransactionCurrency
_BillableControl P_GLAccountBalance _BillableControl
_BillingDocumentType P_GLAccountBalance _BillingDocumentType
_BillToParty P_GLAccountBalance _BillToParty
_BusinessArea P_GLAccountBalance _BusinessArea
_BusinessAreaText P_GLAccountBalance _BusinessAreaText
_BusinessProcess P_GLAccountBalance _BusinessProcess
_BusinessTransactionType P_GLAccountBalance _BusinessTransactionType
_ChartOfAccounts P_GLAccountBalance _ChartOfAccounts
_ClearingJrnlEntryFiscalYear P_GLAccountBalance _ClearingJrnlEntryFiscalYear
_ClearingJournalEntry P_GLAccountBalance _ClearingJournalEntry
_ClearingAccountingDocument P_GLAccountBalance _ClearingAccountingDocument
_CompanyCode P_GLAccountBalance _CompanyCode
_CompanyCodeText P_GLAccountBalance _CompanyCodeText
_CompanyCodeCurrency P_GLAccountBalance _CompanyCodeCurrency
_ConditionContract P_GLAccountBalance _ConditionContract
_ControllingArea P_GLAccountBalance _ControllingArea
_ControllingAreaText P_GLAccountBalance _ControllingAreaText
_ControllingDebitCreditCode P_GLAccountBalance _ControllingDebitCreditCode
_ControllingObjectClass P_GLAccountBalance _ControllingObjectClass
_CostAnalysisResource P_GLAccountBalance _CostAnalysisResource
_CostCenter P_GLAccountBalance _CostCenter
_CostCtrActivityType P_GLAccountBalance _CostCtrActivityType
_CostOriginGroup P_GLAccountBalance _CostOriginGroup
_CountryChartOfAccounts P_GLAccountBalance _CountryChartOfAccounts
_CurrentCostCenter P_GLAccountBalance _CurrentCostCenter
_CurrentProfitCenter P_GLAccountBalance _CurrentProfitCenter
_Customer P_GLAccountBalance _Customer
_CustomerText P_GLAccountBalance _CustomerText
_CustomerGroup P_GLAccountBalance _CustomerGroup
_CustomerSupplierCountry P_GLAccountBalance _CustomerSupplierCountry
_DebitCreditCode P_GLAccountBalance _DebitCreditCode
_DistributionChannel P_GLAccountBalance _DistributionChannel
_EliminationProfitCenter P_GLAccountBalance _EliminationProfitCenter
_Employment P_GLAccountBalance _Employment
_PersonWorkAgreement_1 P_GLAccountBalance _PersonWorkAgreement_1
_Equipment P_GLAccountBalance _Equipment
_FinancialAccountType P_GLAccountBalance _FinancialAccountType
_FinancialTransactionType P_GLAccountBalance _FinancialTransactionType
_FiscalCalendarDate P_GLAccountBalance _FiscalCalendarDate
_FiscalPeriod P_GLAccountBalance _FiscalPeriod
_FiscalPeriodForVariant P_GLAccountBalance _FiscalPeriodForVariant
_FiscalYear P_GLAccountBalance _FiscalYear
_FiscalYearPeriod P_GLAccountBalance _FiscalYearPeriod
_FiscalYearPeriodForVariant P_GLAccountBalance _FiscalYearPeriodForVariant
_FiscalYearVariant P_GLAccountBalance _FiscalYearVariant
_FixedAsset P_GLAccountBalance _FixedAsset
_FixedAssetText P_GLAccountBalance _FixedAssetText
_FreeDefinedCurrency1 P_GLAccountBalance _FreeDefinedCurrency1
_FreeDefinedCurrency2 P_GLAccountBalance _FreeDefinedCurrency2
_FreeDefinedCurrency3 P_GLAccountBalance _FreeDefinedCurrency3
_FreeDefinedCurrency4 P_GLAccountBalance _FreeDefinedCurrency4
_FreeDefinedCurrency5 P_GLAccountBalance _FreeDefinedCurrency5
_FreeDefinedCurrency6 P_GLAccountBalance _FreeDefinedCurrency6
_FreeDefinedCurrency7 P_GLAccountBalance _FreeDefinedCurrency7
_FreeDefinedCurrency8 P_GLAccountBalance _FreeDefinedCurrency8
_FunctionalArea P_GLAccountBalance _FunctionalArea
_FunctionalLocation P_GLAccountBalance _FunctionalLocation
_GLAccountInChartOfAccounts P_GLAccountBalance _GLAccountInChartOfAccounts
_GLAccountInCompanyCode P_GLAccountBalance _GLAccountInCompanyCode
_GLAccountType P_GLAccountBalance _GLAccountType
_GlobalCurrency P_GLAccountBalance _GlobalCurrency
_GroupFixedAsset P_GLAccountBalance _GroupFixedAsset
_GroupFixedAssetText P_GLAccountBalance _GroupFixedAssetText
_GroupMasterFixedAsset P_GLAccountBalance _GroupMasterFixedAsset
_GroupMasterFixedAssetText P_GLAccountBalance _GroupMasterFixedAssetText
_HouseBank P_GLAccountBalance _HouseBank
_HouseBankAccount P_GLAccountBalance _HouseBankAccount
_InternalOrder P_GLAccountBalance _InternalOrder
_InventorySpclStkSalesDocItm P_GLAccountBalance _InventorySpclStkSalesDocItm
_InventorySpclStkSalesDocument P_GLAccountBalance _InventorySpclStkSalesDocument
_InvtrySpclStkWBSElmntBscData P_GLAccountBalance _InvtrySpclStkWBSElmntBscData
_InventorySpecialStockSupplier P_GLAccountBalance _InventorySpecialStockSupplier
_InvtrySpclStockSupplierText P_GLAccountBalance _InvtrySpclStockSupplierText
_InventorySpecialStockType P_GLAccountBalance _InventorySpecialStockType
_InventorySpecialStockValnType P_GLAccountBalance _InventorySpecialStockValnType
_InventorySpclStockValnType P_GLAccountBalance _InventorySpclStockValnType
_InventoryValuationType P_GLAccountBalance _InventoryValuationType
_JournalEntry P_GLAccountBalance _JournalEntry
_Ledger P_GLAccountBalance _Ledger
_LedgerFiscalYear P_GLAccountBalance _LedgerFiscalYear
_LedgerFiscalYearForVariant P_GLAccountBalance _LedgerFiscalYearForVariant
_LogicalSystem P_GLAccountBalance _LogicalSystem
_MaintenanceActivityType P_GLAccountBalance _MaintenanceActivityType
_MaintenanceOrderSubOperation P_GLAccountBalance _MaintenanceOrderSubOperation
_MaintOrdPlngDegreeCode P_GLAccountBalance _MaintOrdPlngDegreeCode
_MasterFixedAsset P_GLAccountBalance _MasterFixedAsset
_MasterFixedAssetText P_GLAccountBalance _MasterFixedAssetText
_MovementCategory P_GLAccountBalance _MovementCategory
_OffsettingAccount P_GLAccountBalance _OffsettingAccount
_OffsettingAccountText P_GLAccountBalance _OffsettingAccountText
_OffsettingAccountType P_GLAccountBalance _OffsettingAccountType
_OffsettingAccountWithBP P_GLAccountBalance _OffsettingAccountWithBP
_OffsettingChartOfAccounts P_GLAccountBalance _OffsettingChartOfAccounts
_OperatingConcern P_GLAccountBalance _OperatingConcern
_Order P_GLAccountBalance _Order
_OrderCategory P_GLAccountBalance _OrderCategory
_OriginCostCenter P_GLAccountBalance _OriginCostCenter
_OriginCostCtrActivityType P_GLAccountBalance _OriginCostCtrActivityType
_OriginProfitCenter P_GLAccountBalance _OriginProfitCenter
_OriginSenderObject P_GLAccountBalance _OriginSenderObject
_PartnerBusinessArea P_GLAccountBalance _PartnerBusinessArea
_PartnerBusinessAreaText P_GLAccountBalance _PartnerBusinessAreaText
_PartnerBusinessProcess P_GLAccountBalance _PartnerBusinessProcess
_PartnerCompany P_GLAccountBalance _PartnerCompany
_PartnerCompanyCode P_GLAccountBalance _PartnerCompanyCode
_PartnerCompanyCodeText P_GLAccountBalance _PartnerCompanyCodeText
_PartnerControllingObjectClass P_GLAccountBalance _PartnerControllingObjectClass
_PartnerCostCenter P_GLAccountBalance _PartnerCostCenter
_PartnerCostCtrActivityType P_GLAccountBalance _PartnerCostCtrActivityType
_PartnerFunctionalArea P_GLAccountBalance _PartnerFunctionalArea
_PartnerOrder P_GLAccountBalance _PartnerOrder
_PartnerOrder_2 P_GLAccountBalance _PartnerOrder_2
_PartnerOrderText P_GLAccountBalance _PartnerOrderText
_PartnerOrderText_2 P_GLAccountBalance _PartnerOrderText_2
_PartnerOrderCategory P_GLAccountBalance _PartnerOrderCategory
_PartnerProfitCenter P_GLAccountBalance _PartnerProfitCenter
_PartnerProjectBasicData P_GLAccountBalance _PartnerProjectBasicData
_PartnerSalesDocument P_GLAccountBalance _PartnerSalesDocument
_PartnerSalesDocumentItem P_GLAccountBalance _PartnerSalesDocumentItem
_PartnerSegment P_GLAccountBalance _PartnerSegment
_PartnerWBSElementBasicData P_GLAccountBalance _PartnerWBSElementBasicData
_Plant P_GLAccountBalance _Plant
_PMNotificationPriority P_GLAccountBalance _PMNotificationPriority
_PMNotificationPriorityType P_GLAccountBalance _PMNotificationPriorityType
_PostingKey P_GLAccountBalance _PostingKey
_PredecessorReferenceDocType P_GLAccountBalance _PredecessorReferenceDocType
_Product P_GLAccountBalance _Product
_ProductGroup P_GLAccountBalance _ProductGroup
_ProductGroup_2 P_GLAccountBalance _ProductGroup_2
_ProfitCenter P_GLAccountBalance _ProfitCenter
_ProjectBasicData P_GLAccountBalance _ProjectBasicData
_ProjectNetwork P_GLAccountBalance _ProjectNetwork
_PurchasingDocument P_GLAccountBalance _PurchasingDocument
_PurchasingDocumentItem P_GLAccountBalance _PurchasingDocumentItem
_PurReqValuationArea P_GLAccountBalance _PurReqValuationArea
_ReferenceDocumentType P_GLAccountBalance _ReferenceDocumentType
_SalesDistrict P_GLAccountBalance _SalesDistrict
_SalesDocument P_GLAccountBalance _SalesDocument
_SalesDocumentItem P_GLAccountBalance _SalesDocumentItem
_SalesOrder P_GLAccountBalance _SalesOrder
_SalesOrderItem P_GLAccountBalance _SalesOrderItem
_SalesOrganization P_GLAccountBalance _SalesOrganization
_Segment P_GLAccountBalance _Segment
_ServiceDocument P_GLAccountBalance _ServiceDocument
_ServiceDocumentType P_GLAccountBalance _ServiceDocumentType
_ServiceDocumentItem P_GLAccountBalance _ServiceDocumentItem
_ServiceContract P_GLAccountBalance _ServiceContract
_ServiceContractType P_GLAccountBalance _ServiceContractType
_ServiceContractItem P_GLAccountBalance _ServiceContractItem
_TimeSheetOvertimeCat P_GLAccountBalance _TimeSheetOvertimeCat
_ShipToParty P_GLAccountBalance _ShipToParty
_SoldProduct P_GLAccountBalance _SoldProduct
_SoldProductGroup P_GLAccountBalance _SoldProductGroup
_SoldProductGroup_2 P_GLAccountBalance _SoldProductGroup_2
_SourceLedger P_GLAccountBalance _SourceLedger
_SpecialGLCode P_GLAccountBalance _SpecialGLCode
_SubLedgerAccLineItemType P_GLAccountBalance _SubLedgerAccLineItemType
_SuperiorOrder P_GLAccountBalance _SuperiorOrder
_Supplier P_GLAccountBalance _Supplier
_SupplierText P_GLAccountBalance _SupplierText
_TaxCode P_GLAccountBalance _TaxCode
_TransactionCurrency P_GLAccountBalance _TransactionCurrency
_User P_GLAccountBalance _User
_WBSElementBasicData P_GLAccountBalance _WBSElementBasicData
_WorkCenter P_GLAccountBalance _WorkCenter
_WorkPackageText P_GLAccountBalance _WorkPackageText
_GLAccountFlowType P_GLAccountBalance _GLAccountFlowType
_GLAccountTypeFlowType P_GLAccountBalance _GLAccountTypeFlowType
_CashLedgerCompanyCode P_GLAccountBalance _CashLedgerCompanyCode
_CashLedgerAccount P_GLAccountBalance _CashLedgerAccount
_FinancialManagementArea P_GLAccountBalance _FinancialManagementArea
_FundsCenter P_GLAccountBalance _FundsCenter
_FundedProgram P_GLAccountBalance _FundedProgram
_Fund P_GLAccountBalance _Fund
_Grant _Grant
_BudgetPeriod P_GLAccountBalance _BudgetPeriod
_BudgetPeriodText P_GLAccountBalance _BudgetPeriodText
_PartnerFund P_GLAccountBalance _PartnerFund
_PartnerGrant _PartnerGrant
_PartnerBudgetPeriod P_GLAccountBalance _PartnerBudgetPeriod
_PubSecBudgetAccountCoCode P_GLAccountBalance _PubSecBudgetAccountCoCode
_PubSecBudgetAccount P_GLAccountBalance _PubSecBudgetAccount
_PubSecBudgetCnsmpnDate P_GLAccountBalance _PubSecBudgetCnsmpnDate
_PubSecBudgetCnsmpnFsclPeriod P_GLAccountBalance _PubSecBudgetCnsmpnFsclPeriod
_PubSecBudgetCnsmpnFsclYear P_GLAccountBalance _PubSecBudgetCnsmpnFsclYear
_PubSecBudgetCnsmpnType P_GLAccountBalance _PubSecBudgetCnsmpnType
_PubSecBudgetCnsmpnAmtType P_GLAccountBalance _PubSecBudgetCnsmpnAmtType
_CustomerCompany P_GLAccountBalance _CustomerCompany
_SupplierCompany P_GLAccountBalance _SupplierCompany

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_GLAccountBalance.
-- 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_GLAccountBalance AS
SELECT
  P_GLAccountBalance.SourceLedger AS SourceLedger,
  P_GLAccountBalance.CompanyCode AS CompanyCode,
  P_GLAccountBalance.FiscalYear AS FiscalYear,
  P_GLAccountBalance.AccountingDocument AS AccountingDocument,
  P_GLAccountBalance.LedgerGLLineItem AS LedgerGLLineItem,
  P_GLAccountBalance.Ledger AS Ledger,
  P_GLAccountBalance.LedgerFiscalYear AS LedgerFiscalYear,
  P_GLAccountBalance.GLRecordType AS GLRecordType,
  P_GLAccountBalance.ChartOfAccounts AS ChartOfAccounts,
  P_GLAccountBalance.ControllingArea AS ControllingArea,
  P_GLAccountBalance.FinancialTransactionType AS FinancialTransactionType,
  P_GLAccountBalance.BusinessTransactionType AS BusinessTransactionType,
  P_GLAccountBalance.ReferenceDocumentType AS ReferenceDocumentType,
  P_GLAccountBalance.LogicalSystem AS LogicalSystem,
  P_GLAccountBalance.ReferenceDocumentContext AS ReferenceDocumentContext,
  P_GLAccountBalance.ReferenceDocument AS ReferenceDocument,
  P_GLAccountBalance.ReferenceDocumentItem AS ReferenceDocumentItem,
  P_GLAccountBalance.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  P_GLAccountBalance.IsReversal AS IsReversal,
  P_GLAccountBalance.IsReversed AS IsReversed,
  P_GLAccountBalance.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  P_GLAccountBalance.ReversalReferenceDocument AS ReversalReferenceDocument,
  P_GLAccountBalance.IsSettlement AS IsSettlement,
  P_GLAccountBalance.IsSettled AS IsSettled,
  P_GLAccountBalance.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  P_GLAccountBalance.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  P_GLAccountBalance.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  P_GLAccountBalance.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  P_GLAccountBalance.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  P_GLAccountBalance.SourceLogicalSystem AS SourceLogicalSystem,
  P_GLAccountBalance.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  P_GLAccountBalance.SourceReferenceDocument AS SourceReferenceDocument,
  P_GLAccountBalance.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  P_GLAccountBalance.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  P_GLAccountBalance.IsCommitment AS IsCommitment,
  P_GLAccountBalance.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  P_GLAccountBalance.GLAccount AS GLAccount,
  P_GLAccountBalance.CostCenter AS CostCenter,
  P_GLAccountBalance.ProfitCenter AS ProfitCenter,
  P_GLAccountBalance.FunctionalArea AS FunctionalArea,
  P_GLAccountBalance.BusinessArea AS BusinessArea,
  P_GLAccountBalance.Segment AS Segment,
  P_GLAccountBalance.PartnerCostCenter AS PartnerCostCenter,
  P_GLAccountBalance.PartnerProfitCenter AS PartnerProfitCenter,
  P_GLAccountBalance.PartnerFunctionalArea AS PartnerFunctionalArea,
  P_GLAccountBalance.PartnerBusinessArea AS PartnerBusinessArea,
  P_GLAccountBalance.PartnerCompany AS PartnerCompany,
  P_GLAccountBalance.PartnerSegment AS PartnerSegment,
  P_GLAccountBalance.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  P_GLAccountBalance.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  P_GLAccountBalance.FlowAmountInBalanceTransCrcy AS FlowAmountInBalanceTransCrcy,
  P_GLAccountBalance.DebitAmountInBalanceTransCrcy AS DebitAmountInBalanceTransCrcy,
  P_GLAccountBalance.CreditAmountInBalanceTransCrcy AS CreditAmountInBalanceTransCrcy,
  P_GLAccountBalance.TransactionCurrency AS TransactionCurrency,
  P_GLAccountBalance.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_GLAccountBalance.FlowAmountInTransCrcy AS FlowAmountInTransCrcy,
  P_GLAccountBalance.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  P_GLAccountBalance.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  CompanyCodeCurrency,
  P_GLAccountBalance.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_GLAccountBalance.FlowAmountInCoCodeCrcy AS FlowAmountInCoCodeCrcy,
  P_GLAccountBalance.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  P_GLAccountBalance.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  P_GLAccountBalance.GlobalCurrency AS GlobalCurrency,
  P_GLAccountBalance.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  P_GLAccountBalance.FlowAmountInGlobalCrcy AS FlowAmountInGlobalCrcy,
  P_GLAccountBalance.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  P_GLAccountBalance.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  P_GLAccountBalance.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  P_GLAccountBalance.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  P_GLAccountBalance.FlowAmountInFreeDfndCrcy1 AS FlowAmountInFreeDfndCrcy1,
  P_GLAccountBalance.DebitAmountInFreeDfndCrcy1 AS DebitAmountInFreeDfndCrcy1,
  P_GLAccountBalance.CreditAmountInFreeDfndCrcy1 AS CreditAmountInFreeDfndCrcy1,
  P_GLAccountBalance.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  P_GLAccountBalance.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  P_GLAccountBalance.FlowAmountInFreeDfndCrcy2 AS FlowAmountInFreeDfndCrcy2,
  P_GLAccountBalance.DebitAmountInFreeDfndCrcy2 AS DebitAmountInFreeDfndCrcy2,
  P_GLAccountBalance.CreditAmountInFreeDfndCrcy2 AS CreditAmountInFreeDfndCrcy2,
  P_GLAccountBalance.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  P_GLAccountBalance.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  P_GLAccountBalance.FlowAmountInFreeDfndCrcy3 AS FlowAmountInFreeDfndCrcy3,
  P_GLAccountBalance.DebitAmountInFreeDfndCrcy3 AS DebitAmountInFreeDfndCrcy3,
  P_GLAccountBalance.CreditAmountInFreeDfndCrcy3 AS CreditAmountInFreeDfndCrcy3,
  P_GLAccountBalance.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  P_GLAccountBalance.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  P_GLAccountBalance.FlowAmountInFreeDfndCrcy4 AS FlowAmountInFreeDfndCrcy4,
  P_GLAccountBalance.DebitAmountInFreeDfndCrcy4 AS DebitAmountInFreeDfndCrcy4,
  P_GLAccountBalance.CreditAmountInFreeDfndCrcy4 AS CreditAmountInFreeDfndCrcy4,
  P_GLAccountBalance.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  P_GLAccountBalance.FlowAmountInFreeDfndCrcy5 AS FlowAmountInFreeDfndCrcy5,
  P_GLAccountBalance.DebitAmountInFreeDfndCrcy5 AS DebitAmountInFreeDfndCrcy5,
  P_GLAccountBalance.CreditAmountInFreeDfndCrcy5 AS CreditAmountInFreeDfndCrcy5,
  P_GLAccountBalance.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  P_GLAccountBalance.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  P_GLAccountBalance.FlowAmountInFreeDfndCrcy6 AS FlowAmountInFreeDfndCrcy6,
  P_GLAccountBalance.DebitAmountInFreeDfndCrcy6 AS DebitAmountInFreeDfndCrcy6,
  P_GLAccountBalance.CreditAmountInFreeDfndCrcy6 AS CreditAmountInFreeDfndCrcy6,
  P_GLAccountBalance.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  P_GLAccountBalance.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  P_GLAccountBalance.FlowAmountInFreeDfndCrcy7 AS FlowAmountInFreeDfndCrcy7,
  P_GLAccountBalance.DebitAmountInFreeDfndCrcy7 AS DebitAmountInFreeDfndCrcy7,
  P_GLAccountBalance.CreditAmountInFreeDfndCrcy7 AS CreditAmountInFreeDfndCrcy7,
  P_GLAccountBalance.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  P_GLAccountBalance.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  P_GLAccountBalance.FlowAmountInFreeDfndCrcy8 AS FlowAmountInFreeDfndCrcy8,
  P_GLAccountBalance.DebitAmountInFreeDfndCrcy8 AS DebitAmountInFreeDfndCrcy8,
  P_GLAccountBalance.CreditAmountInFreeDfndCrcy8 AS CreditAmountInFreeDfndCrcy8,
  P_GLAccountBalance.GLAccountFlowType AS GLAccountFlowType,
  P_GLAccountBalance.GLAccountTypeFlowType AS GLAccountTypeFlowType,
  P_GLAccountBalance.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  P_GLAccountBalance.DebitCreditCode AS DebitCreditCode,
  P_GLAccountBalance.FiscalPeriod AS FiscalPeriod,
  P_GLAccountBalance.FiscalYearVariant AS FiscalYearVariant,
  P_GLAccountBalance.FiscalYearPeriod AS FiscalYearPeriod,
  P_GLAccountBalance.PostingDate AS PostingDate,
  P_GLAccountBalance.DocumentDate AS DocumentDate,
  P_GLAccountBalance.AccountingDocumentType AS AccountingDocumentType,
  P_GLAccountBalance.AccountingDocumentItem AS AccountingDocumentItem,
  P_GLAccountBalance.AssignmentReference AS AssignmentReference,
  P_GLAccountBalance.AccountingDocumentCategory AS AccountingDocumentCategory,
  P_GLAccountBalance.PostingKey AS PostingKey,
  P_GLAccountBalance.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_GLAccountBalance.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  P_GLAccountBalance.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  P_GLAccountBalance.LastChangeDateTime AS LastChangeDateTime,
  P_GLAccountBalance.CreationDateTime AS CreationDateTime,
  P_GLAccountBalance.CreationDate AS CreationDate,
  P_GLAccountBalance.EliminationProfitCenter AS EliminationProfitCenter,
  P_GLAccountBalance.OriginObjectType AS OriginObjectType,
  P_GLAccountBalance.GLAccountType AS GLAccountType,
  P_GLAccountBalance.AlternativeGLAccount AS AlternativeGLAccount,
  P_GLAccountBalance.CountryChartOfAccounts AS CountryChartOfAccounts,
  P_GLAccountBalance.InvoiceReference AS InvoiceReference,
  P_GLAccountBalance.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  P_GLAccountBalance.FollowOnDocumentType AS FollowOnDocumentType,
  P_GLAccountBalance.InvoiceItemReference AS InvoiceItemReference,
  P_GLAccountBalance.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  P_GLAccountBalance.PurchasingDocument AS PurchasingDocument,
  P_GLAccountBalance.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_GLAccountBalance.AccountAssignmentNumber AS AccountAssignmentNumber,
  P_GLAccountBalance.DocumentItemText AS DocumentItemText,
  P_GLAccountBalance.SalesDocument AS SalesDocument,
  P_GLAccountBalance.SalesDocumentItem AS SalesDocumentItem,
  P_GLAccountBalance.Product AS Product,
  P_GLAccountBalance.Plant AS Plant,
  P_GLAccountBalance.Supplier AS Supplier,
  P_GLAccountBalance.Customer AS Customer,
  P_GLAccountBalance.ServicesRenderedDate AS ServicesRenderedDate,
  P_GLAccountBalance.ConditionContract AS ConditionContract,
  P_GLAccountBalance.FinancialAccountType AS FinancialAccountType,
  P_GLAccountBalance.SpecialGLCode AS SpecialGLCode,
  P_GLAccountBalance.TaxCode AS TaxCode,
  P_GLAccountBalance.HouseBank AS HouseBank,
  P_GLAccountBalance.HouseBankAccount AS HouseBankAccount,
  P_GLAccountBalance.IsOpenItemManaged AS IsOpenItemManaged,
  P_GLAccountBalance.ClearingDate AS ClearingDate,
  P_GLAccountBalance.ClearingAccountingDocument AS ClearingAccountingDocument,
  P_GLAccountBalance.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  P_GLAccountBalance.ClearingJournalEntry AS ClearingJournalEntry,
  P_GLAccountBalance.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_GLAccountBalance.AssetDepreciationArea AS AssetDepreciationArea,
  P_GLAccountBalance.MasterFixedAsset AS MasterFixedAsset,
  P_GLAccountBalance.FixedAsset AS FixedAsset,
  P_GLAccountBalance.AssetValueDate AS AssetValueDate,
  P_GLAccountBalance.AssetTransactionType AS AssetTransactionType,
  P_GLAccountBalance.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  P_GLAccountBalance.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  P_GLAccountBalance.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  P_GLAccountBalance.GroupFixedAsset AS GroupFixedAsset,
  P_GLAccountBalance.CostEstimate AS CostEstimate,
  P_GLAccountBalance.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  P_GLAccountBalance.InvtrySpecialStockValnType_2 AS InvtrySpecialStockValnType_2,
  P_GLAccountBalance.InventorySpecialStockType AS InventorySpecialStockType,
  P_GLAccountBalance.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  P_GLAccountBalance.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  P_GLAccountBalance.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  P_GLAccountBalance.InvtrySpclStockWBSElmntExtID AS InvtrySpclStockWBSElmntExtID,
  P_GLAccountBalance.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  P_GLAccountBalance.InventoryValuationType AS InventoryValuationType,
  P_GLAccountBalance.ValuationArea AS ValuationArea,
  P_GLAccountBalance.SenderGLAccount AS SenderGLAccount,
  P_GLAccountBalance.SenderAccountAssignment AS SenderAccountAssignment,
  P_GLAccountBalance.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  P_GLAccountBalance.CostOriginGroup AS CostOriginGroup,
  P_GLAccountBalance.OriginSenderObject AS OriginSenderObject,
  P_GLAccountBalance.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  P_GLAccountBalance.ControllingObjectDebitType AS ControllingObjectDebitType,
  P_GLAccountBalance.QuantityIsIncomplete AS QuantityIsIncomplete,
  P_GLAccountBalance.OffsettingAccount AS OffsettingAccount,
  P_GLAccountBalance.OffsettingAccountType AS OffsettingAccountType,
  P_GLAccountBalance.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  P_GLAccountBalance.LineItemIsCompleted AS LineItemIsCompleted,
  P_GLAccountBalance.PersonnelNumber AS PersonnelNumber,
  P_GLAccountBalance.ControllingObjectClass AS ControllingObjectClass,
  P_GLAccountBalance.PartnerCompanyCode AS PartnerCompanyCode,
  P_GLAccountBalance.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  P_GLAccountBalance.OriginCostCenter AS OriginCostCenter,
  P_GLAccountBalance.OriginProfitCenter AS OriginProfitCenter,
  P_GLAccountBalance.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  P_GLAccountBalance.AccountAssignment AS AccountAssignment,
  P_GLAccountBalance.AccountAssignmentType AS AccountAssignmentType,
  P_GLAccountBalance.CostCtrActivityType AS CostCtrActivityType,
  P_GLAccountBalance.OrderID AS OrderID,
  P_GLAccountBalance.OrderCategory AS OrderCategory,
  P_GLAccountBalance.ServiceDocumentType AS ServiceDocumentType,
  P_GLAccountBalance.ServiceDocument AS ServiceDocument,
  P_GLAccountBalance.ServiceDocumentItem AS ServiceDocumentItem,
  P_GLAccountBalance.ServiceContractType AS ServiceContractType,
  P_GLAccountBalance.ServiceContract AS ServiceContract,
  P_GLAccountBalance.ServiceContractItem AS ServiceContractItem,
  P_GLAccountBalance.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  P_GLAccountBalance.WBSElementInternalID AS WBSElementInternalID,
  P_GLAccountBalance.WBSElementExternalID AS WBSElementExternalID,
  P_GLAccountBalance.WBSElement AS WBSElement,
  P_GLAccountBalance.ProjectInternalID AS ProjectInternalID,
  P_GLAccountBalance.ProjectExternalID AS ProjectExternalID,
  P_GLAccountBalance.Project AS Project,
  P_GLAccountBalance.OperatingConcern AS OperatingConcern,
  P_GLAccountBalance.ProjectNetwork AS ProjectNetwork,
  P_GLAccountBalance.RelatedNetworkActivity AS RelatedNetworkActivity,
  P_GLAccountBalance.BusinessProcess AS BusinessProcess,
  P_GLAccountBalance.CostObject AS CostObject,
  P_GLAccountBalance.BillableControl AS BillableControl,
  P_GLAccountBalance.CostAnalysisResource AS CostAnalysisResource,
  P_GLAccountBalance.CustomerServiceNotification AS CustomerServiceNotification,
  P_GLAccountBalance.PartnerAccountAssignment AS PartnerAccountAssignment,
  P_GLAccountBalance.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  P_GLAccountBalance.WorkPackage AS WorkPackage,
  P_GLAccountBalance.WorkItem AS WorkItem,
  P_GLAccountBalance.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  P_GLAccountBalance.PartnerOrder AS PartnerOrder,
  P_GLAccountBalance.PartnerOrder_2 AS PartnerOrder_2,
  P_GLAccountBalance.PartnerOrderCategory AS PartnerOrderCategory,
  P_GLAccountBalance.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  P_GLAccountBalance.PartnerWBSElementExternalID AS PartnerWBSElementExternalID,
  P_GLAccountBalance.PartnerWBSElement AS PartnerWBSElement,
  P_GLAccountBalance.PartnerProjectInternalID AS PartnerProjectInternalID,
  P_GLAccountBalance.PartnerProjectExternalID AS PartnerProjectExternalID,
  P_GLAccountBalance.PartnerProject AS PartnerProject,
  P_GLAccountBalance.PartnerSalesDocument AS PartnerSalesDocument,
  P_GLAccountBalance.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  P_GLAccountBalance.PartnerProjectNetwork AS PartnerProjectNetwork,
  P_GLAccountBalance.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  P_GLAccountBalance.PartnerBusinessProcess AS PartnerBusinessProcess,
  P_GLAccountBalance.PartnerCostObject AS PartnerCostObject,
  P_GLAccountBalance.BillingDocumentType AS BillingDocumentType,
  P_GLAccountBalance.SalesOrganization AS SalesOrganization,
  P_GLAccountBalance.DistributionChannel AS DistributionChannel,
  P_GLAccountBalance.OrganizationDivision AS OrganizationDivision,
  P_GLAccountBalance.SoldProduct AS SoldProduct,
  P_GLAccountBalance.SoldProductGroup AS SoldProductGroup,
  P_GLAccountBalance.CustomerGroup AS CustomerGroup,
  P_GLAccountBalance.CustomerSupplierCountry AS CustomerSupplierCountry,
  P_GLAccountBalance.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  P_GLAccountBalance.SalesDistrict AS SalesDistrict,
  P_GLAccountBalance.BillToParty AS BillToParty,
  P_GLAccountBalance.ShipToParty AS ShipToParty,
  P_GLAccountBalance.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  P_GLAccountBalance.JointVenture AS JointVenture,
  P_GLAccountBalance.JointVentureEquityGroup AS JointVentureEquityGroup,
  P_GLAccountBalance.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  P_GLAccountBalance.JointVentureEquityType AS JointVentureEquityType,
  P_GLAccountBalance.SettlementReferenceDate AS SettlementReferenceDate,
  P_GLAccountBalance.WorkCenterInternalID AS WorkCenterInternalID,
  P_GLAccountBalance.OrderOperation AS OrderOperation,
  P_GLAccountBalance.OrderItem AS OrderItem,
  P_GLAccountBalance.OrderSuboperation AS OrderSuboperation,
  P_GLAccountBalance.Equipment AS Equipment,
  P_GLAccountBalance.FunctionalLocation AS FunctionalLocation,
  P_GLAccountBalance.Assembly AS Assembly,
  P_GLAccountBalance.MaintenanceActivityType AS MaintenanceActivityType,
  P_GLAccountBalance.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
  P_GLAccountBalance.MaintPriorityType AS MaintPriorityType,
  P_GLAccountBalance.MaintPriority AS MaintPriority,
  P_GLAccountBalance.SuperiorOrder AS SuperiorOrder,
  P_GLAccountBalance.ProductGroup AS ProductGroup,
  P_GLAccountBalance.MaintenanceOrderIsPlanned AS MaintenanceOrderIsPlanned,
  P_GLAccountBalance.IsStatisticalOrder AS IsStatisticalOrder,
  P_GLAccountBalance.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  P_GLAccountBalance.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  P_GLAccountBalance.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  P_GLAccountBalance.CalendarYear AS CalendarYear,
  P_GLAccountBalance.CalendarQuarter AS CalendarQuarter,
  P_GLAccountBalance.CalendarYearQuarter AS CalendarYearQuarter,
  P_GLAccountBalance.CalendarMonth AS CalendarMonth,
  P_GLAccountBalance.CalendarYearMonth AS CalendarYearMonth,
  P_GLAccountBalance.CalendarWeek AS CalendarWeek,
  P_GLAccountBalance.CalendarYearWeek AS CalendarYearWeek,
  P_GLAccountBalance._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  P_GLAccountBalance._FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  P_GLAccountBalance._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  P_GLAccountBalance._FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  P_GLAccountBalance.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  P_GLAccountBalance.AccrualObjectType AS AccrualObjectType,
  P_GLAccountBalance.AccrualObject AS AccrualObject,
  P_GLAccountBalance.AccrualSubobject AS AccrualSubobject,
  P_GLAccountBalance.AccrualItemType AS AccrualItemType,
  P_GLAccountBalance.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  P_GLAccountBalance.CashLedgerAccount AS CashLedgerAccount,
  P_GLAccountBalance.FinancialManagementArea AS FinancialManagementArea,
  P_GLAccountBalance.FundsCenter AS FundsCenter,
  P_GLAccountBalance.FundedProgram AS FundedProgram,
  P_GLAccountBalance.Fund AS Fund,
  P_GLAccountBalance.GrantID AS GrantID,
  P_GLAccountBalance.BudgetPeriod AS BudgetPeriod,
  P_GLAccountBalance.PartnerFund AS PartnerFund,
  P_GLAccountBalance.PartnerGrant AS PartnerGrant,
  P_GLAccountBalance.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  P_GLAccountBalance.PubSecBudgetAccount AS PubSecBudgetAccount,
  P_GLAccountBalance.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  P_GLAccountBalance.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  P_GLAccountBalance.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  P_GLAccountBalance.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  P_GLAccountBalance.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  P_GLAccountBalance.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  P_GLAccountBalance.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  P_GLAccountBalance.AssetClass AS AssetClass,
  P_GLAccountBalance.SalesOrder AS SalesOrder,
  P_GLAccountBalance.SalesOrderItem AS SalesOrderItem,
  P_GLAccountBalance._AccrualObjectType AS _AccrualObjectType,
  P_GLAccountBalance._AccrualObject AS _AccrualObject,
  P_GLAccountBalance._AccrualSubobject AS _AccrualSubobject,
  P_GLAccountBalance._AccrualItemType AS _AccrualItemType,
  P_GLAccountBalance._AccountingDocumentCategory AS _AccountingDocumentCategory,
  P_GLAccountBalance._AccountingDocumentType AS _AccountingDocumentType,
  P_GLAccountBalance._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
  P_GLAccountBalance._AlternativeGLAccount AS _AlternativeGLAccount,
  P_GLAccountBalance._Assembly AS _Assembly,
  P_GLAccountBalance._AssetTransactionType AS _AssetTransactionType,
  P_GLAccountBalance._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  P_GLAccountBalance._BillableControl AS _BillableControl,
  P_GLAccountBalance._BillingDocumentType AS _BillingDocumentType,
  P_GLAccountBalance._BillToParty AS _BillToParty,
  P_GLAccountBalance._BusinessArea AS _BusinessArea,
  P_GLAccountBalance._BusinessAreaText AS _BusinessAreaText,
  P_GLAccountBalance._BusinessProcess AS _BusinessProcess,
  P_GLAccountBalance._BusinessTransactionType AS _BusinessTransactionType,
  P_GLAccountBalance._ChartOfAccounts AS _ChartOfAccounts,
  P_GLAccountBalance._ClearingJrnlEntryFiscalYear AS _ClearingJrnlEntryFiscalYear,
  P_GLAccountBalance._ClearingJournalEntry AS _ClearingJournalEntry,
  P_GLAccountBalance._ClearingAccountingDocument AS _ClearingAccountingDocument,
  P_GLAccountBalance._CompanyCode AS _CompanyCode,
  P_GLAccountBalance._CompanyCodeText AS _CompanyCodeText,
  P_GLAccountBalance._CompanyCodeCurrency AS _CompanyCodeCurrency,
  P_GLAccountBalance._ConditionContract AS _ConditionContract,
  P_GLAccountBalance._ControllingArea AS _ControllingArea,
  P_GLAccountBalance._ControllingAreaText AS _ControllingAreaText,
  P_GLAccountBalance._ControllingDebitCreditCode AS _ControllingDebitCreditCode,
  P_GLAccountBalance._ControllingObjectClass AS _ControllingObjectClass,
  P_GLAccountBalance._CostAnalysisResource AS _CostAnalysisResource,
  P_GLAccountBalance._CostCenter AS _CostCenter,
  P_GLAccountBalance._CostCtrActivityType AS _CostCtrActivityType,
  P_GLAccountBalance._CostOriginGroup AS _CostOriginGroup,
  P_GLAccountBalance._CountryChartOfAccounts AS _CountryChartOfAccounts,
  P_GLAccountBalance._CurrentCostCenter AS _CurrentCostCenter,
  P_GLAccountBalance._CurrentProfitCenter AS _CurrentProfitCenter,
  P_GLAccountBalance._Customer AS _Customer,
  P_GLAccountBalance._CustomerText AS _CustomerText,
  P_GLAccountBalance._CustomerGroup AS _CustomerGroup,
  P_GLAccountBalance._CustomerSupplierCountry AS _CustomerSupplierCountry,
  P_GLAccountBalance._DebitCreditCode AS _DebitCreditCode,
  P_GLAccountBalance._DistributionChannel AS _DistributionChannel,
  P_GLAccountBalance._EliminationProfitCenter AS _EliminationProfitCenter,
  P_GLAccountBalance._Employment AS _Employment,
  P_GLAccountBalance._PersonWorkAgreement_1 AS _PersonWorkAgreement_1,
  P_GLAccountBalance._Equipment AS _Equipment,
  P_GLAccountBalance._FinancialAccountType AS _FinancialAccountType,
  P_GLAccountBalance._FinancialTransactionType AS _FinancialTransactionType,
  P_GLAccountBalance._FiscalCalendarDate AS _FiscalCalendarDate,
  P_GLAccountBalance._FiscalPeriod AS _FiscalPeriod,
  P_GLAccountBalance._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  P_GLAccountBalance._FiscalYear AS _FiscalYear,
  P_GLAccountBalance._FiscalYearPeriod AS _FiscalYearPeriod,
  P_GLAccountBalance._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  P_GLAccountBalance._FiscalYearVariant AS _FiscalYearVariant,
  P_GLAccountBalance._FixedAsset AS _FixedAsset,
  P_GLAccountBalance._FixedAssetText AS _FixedAssetText,
  P_GLAccountBalance._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  P_GLAccountBalance._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  P_GLAccountBalance._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  P_GLAccountBalance._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  P_GLAccountBalance._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  P_GLAccountBalance._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  P_GLAccountBalance._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  P_GLAccountBalance._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  P_GLAccountBalance._FunctionalArea AS _FunctionalArea,
  P_GLAccountBalance._FunctionalLocation AS _FunctionalLocation,
  P_GLAccountBalance._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  P_GLAccountBalance._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  P_GLAccountBalance._GLAccountType AS _GLAccountType,
  P_GLAccountBalance._GlobalCurrency AS _GlobalCurrency,
  P_GLAccountBalance._GroupFixedAsset AS _GroupFixedAsset,
  P_GLAccountBalance._GroupFixedAssetText AS _GroupFixedAssetText,
  P_GLAccountBalance._GroupMasterFixedAsset AS _GroupMasterFixedAsset,
  P_GLAccountBalance._GroupMasterFixedAssetText AS _GroupMasterFixedAssetText,
  P_GLAccountBalance._HouseBank AS _HouseBank,
  P_GLAccountBalance._HouseBankAccount AS _HouseBankAccount,
  P_GLAccountBalance._InternalOrder AS _InternalOrder,
  P_GLAccountBalance._InventorySpclStkSalesDocItm AS _InventorySpclStkSalesDocItm,
  P_GLAccountBalance._InventorySpclStkSalesDocument AS _InventorySpclStkSalesDocument,
  P_GLAccountBalance._InvtrySpclStkWBSElmntBscData AS _InvtrySpclStkWBSElmntBscData,
  P_GLAccountBalance._InventorySpecialStockSupplier AS _InventorySpecialStockSupplier,
  P_GLAccountBalance._InvtrySpclStockSupplierText AS _InvtrySpclStockSupplierText,
  P_GLAccountBalance._InventorySpecialStockType AS _InventorySpecialStockType,
  P_GLAccountBalance._InventorySpecialStockValnType AS _InventorySpecialStockValnType,
  P_GLAccountBalance._InventorySpclStockValnType AS _InventorySpclStockValnType,
  P_GLAccountBalance._InventoryValuationType AS _InventoryValuationType,
  P_GLAccountBalance._JournalEntry AS _JournalEntry,
  P_GLAccountBalance._Ledger AS _Ledger,
  P_GLAccountBalance._LedgerFiscalYear AS _LedgerFiscalYear,
  P_GLAccountBalance._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  P_GLAccountBalance._LogicalSystem AS _LogicalSystem,
  P_GLAccountBalance._MaintenanceActivityType AS _MaintenanceActivityType,
  P_GLAccountBalance._MaintenanceOrderSubOperation AS _MaintenanceOrderSubOperation,
  P_GLAccountBalance._MaintOrdPlngDegreeCode AS _MaintOrdPlngDegreeCode,
  P_GLAccountBalance._MasterFixedAsset AS _MasterFixedAsset,
  P_GLAccountBalance._MasterFixedAssetText AS _MasterFixedAssetText,
  P_GLAccountBalance._MovementCategory AS _MovementCategory,
  P_GLAccountBalance._OffsettingAccount AS _OffsettingAccount,
  P_GLAccountBalance._OffsettingAccountText AS _OffsettingAccountText,
  P_GLAccountBalance._OffsettingAccountType AS _OffsettingAccountType,
  P_GLAccountBalance._OffsettingAccountWithBP AS _OffsettingAccountWithBP,
  P_GLAccountBalance._OffsettingChartOfAccounts AS _OffsettingChartOfAccounts,
  P_GLAccountBalance._OperatingConcern AS _OperatingConcern,
  P_GLAccountBalance._Order AS _Order,
  P_GLAccountBalance._OrderCategory AS _OrderCategory,
  P_GLAccountBalance._OriginCostCenter AS _OriginCostCenter,
  P_GLAccountBalance._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  P_GLAccountBalance._OriginProfitCenter AS _OriginProfitCenter,
  P_GLAccountBalance._OriginSenderObject AS _OriginSenderObject,
  P_GLAccountBalance._PartnerBusinessArea AS _PartnerBusinessArea,
  P_GLAccountBalance._PartnerBusinessAreaText AS _PartnerBusinessAreaText,
  P_GLAccountBalance._PartnerBusinessProcess AS _PartnerBusinessProcess,
  P_GLAccountBalance._PartnerCompany AS _PartnerCompany,
  P_GLAccountBalance._PartnerCompanyCode AS _PartnerCompanyCode,
  P_GLAccountBalance._PartnerCompanyCodeText AS _PartnerCompanyCodeText,
  P_GLAccountBalance._PartnerControllingObjectClass AS _PartnerControllingObjectClass,
  P_GLAccountBalance._PartnerCostCenter AS _PartnerCostCenter,
  P_GLAccountBalance._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  P_GLAccountBalance._PartnerFunctionalArea AS _PartnerFunctionalArea,
  P_GLAccountBalance._PartnerOrder AS _PartnerOrder,
  P_GLAccountBalance._PartnerOrder_2 AS _PartnerOrder_2,
  P_GLAccountBalance._PartnerOrderText AS _PartnerOrderText,
  P_GLAccountBalance._PartnerOrderText_2 AS _PartnerOrderText_2,
  P_GLAccountBalance._PartnerOrderCategory AS _PartnerOrderCategory,
  P_GLAccountBalance._PartnerProfitCenter AS _PartnerProfitCenter,
  P_GLAccountBalance._PartnerProjectBasicData AS _PartnerProjectBasicData,
  P_GLAccountBalance._PartnerSalesDocument AS _PartnerSalesDocument,
  P_GLAccountBalance._PartnerSalesDocumentItem AS _PartnerSalesDocumentItem,
  P_GLAccountBalance._PartnerSegment AS _PartnerSegment,
  P_GLAccountBalance._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData,
  P_GLAccountBalance._Plant AS _Plant,
  P_GLAccountBalance._PMNotificationPriority AS _PMNotificationPriority,
  P_GLAccountBalance._PMNotificationPriorityType AS _PMNotificationPriorityType,
  P_GLAccountBalance._PostingKey AS _PostingKey,
  P_GLAccountBalance._PredecessorReferenceDocType AS _PredecessorReferenceDocType,
  P_GLAccountBalance._Product AS _Product,
  P_GLAccountBalance._ProductGroup AS _ProductGroup,
  P_GLAccountBalance._ProductGroup_2 AS _ProductGroup_2,
  P_GLAccountBalance._ProfitCenter AS _ProfitCenter,
  P_GLAccountBalance._ProjectBasicData AS _ProjectBasicData,
  P_GLAccountBalance._ProjectNetwork AS _ProjectNetwork,
  P_GLAccountBalance._PurchasingDocument AS _PurchasingDocument,
  P_GLAccountBalance._PurchasingDocumentItem AS _PurchasingDocumentItem,
  P_GLAccountBalance._PurReqValuationArea AS _PurReqValuationArea,
  P_GLAccountBalance._ReferenceDocumentType AS _ReferenceDocumentType,
  P_GLAccountBalance._SalesDistrict AS _SalesDistrict,
  P_GLAccountBalance._SalesDocument AS _SalesDocument,
  P_GLAccountBalance._SalesDocumentItem AS _SalesDocumentItem,
  P_GLAccountBalance._SalesOrder AS _SalesOrder,
  P_GLAccountBalance._SalesOrderItem AS _SalesOrderItem,
  P_GLAccountBalance._SalesOrganization AS _SalesOrganization,
  P_GLAccountBalance._Segment AS _Segment,
  P_GLAccountBalance._ServiceDocument AS _ServiceDocument,
  P_GLAccountBalance._ServiceDocumentType AS _ServiceDocumentType,
  P_GLAccountBalance._ServiceDocumentItem AS _ServiceDocumentItem,
  P_GLAccountBalance._ServiceContract AS _ServiceContract,
  P_GLAccountBalance._ServiceContractType AS _ServiceContractType,
  P_GLAccountBalance._ServiceContractItem AS _ServiceContractItem,
  P_GLAccountBalance._TimeSheetOvertimeCat AS _TimeSheetOvertimeCat,
  P_GLAccountBalance._ShipToParty AS _ShipToParty,
  P_GLAccountBalance._SoldProduct AS _SoldProduct,
  P_GLAccountBalance._SoldProductGroup AS _SoldProductGroup,
  P_GLAccountBalance._SoldProductGroup_2 AS _SoldProductGroup_2,
  P_GLAccountBalance._SourceLedger AS _SourceLedger,
  P_GLAccountBalance._SpecialGLCode AS _SpecialGLCode,
  P_GLAccountBalance._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
  P_GLAccountBalance._SuperiorOrder AS _SuperiorOrder,
  P_GLAccountBalance._Supplier AS _Supplier,
  P_GLAccountBalance._SupplierText AS _SupplierText,
  P_GLAccountBalance._TaxCode AS _TaxCode,
  P_GLAccountBalance._TransactionCurrency AS _TransactionCurrency,
  P_GLAccountBalance._User AS _User,
  P_GLAccountBalance._WBSElementBasicData AS _WBSElementBasicData,
  P_GLAccountBalance._WorkCenter AS _WorkCenter,
  P_GLAccountBalance._WorkPackageText AS _WorkPackageText,
  P_GLAccountBalance._GLAccountFlowType AS _GLAccountFlowType,
  P_GLAccountBalance._GLAccountTypeFlowType AS _GLAccountTypeFlowType,
  P_GLAccountBalance._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  P_GLAccountBalance._CashLedgerAccount AS _CashLedgerAccount,
  P_GLAccountBalance._FinancialManagementArea AS _FinancialManagementArea,
  P_GLAccountBalance._FundsCenter AS _FundsCenter,
  P_GLAccountBalance._FundedProgram AS _FundedProgram,
  P_GLAccountBalance._Fund AS _Fund,
  P_GLAccountBalance._BudgetPeriod AS _BudgetPeriod,
  P_GLAccountBalance._BudgetPeriodText AS _BudgetPeriodText,
  P_GLAccountBalance._PartnerFund AS _PartnerFund,
  P_GLAccountBalance._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  P_GLAccountBalance._PubSecBudgetAccountCoCode AS _PubSecBudgetAccountCoCode,
  P_GLAccountBalance._PubSecBudgetAccount AS _PubSecBudgetAccount,
  P_GLAccountBalance._PubSecBudgetCnsmpnDate AS _PubSecBudgetCnsmpnDate,
  P_GLAccountBalance._PubSecBudgetCnsmpnFsclPeriod AS _PubSecBudgetCnsmpnFsclPeriod,
  P_GLAccountBalance._PubSecBudgetCnsmpnFsclYear AS _PubSecBudgetCnsmpnFsclYear,
  P_GLAccountBalance._PubSecBudgetCnsmpnType AS _PubSecBudgetCnsmpnType,
  P_GLAccountBalance._PubSecBudgetCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType,
  P_GLAccountBalance._CustomerCompany AS _CustomerCompany,
  P_GLAccountBalance._SupplierCompany AS _SupplierCompany
FROM P_GLAccountBalance
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _PartnerGrant ON PartnerGrant = _PartnerGrant.GrantID  -- association [0..1]
;

Learn More