I_GLAccountBalance

G/L Account Balance with Flow-Measure | view: IFIGLACCTBAL | TRAN | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, SKA1, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
FlowAmountInBalanceTransCrcy Flow Amount in Balance Transaction Currency
DebitAmountInBalanceTransCrcy Debit Amount in Balance Transaction Currency
CreditAmountInBalanceTransCrcy Credit Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
FlowAmountInTransCrcy Flow Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
FlowAmountInCoCodeCrcy Flow Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FlowAmountInGlobalCrcy Flow Amount in Global Currency
DebitAmountInGlobalCrcy Debit Amount in Global Currency
CreditAmountInGlobalCrcy Credit Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FlowAmountInFreeDfndCrcy1 Flow Amount in Free Defined Currency 1
DebitAmountInFreeDfndCrcy1 Debit Amount in Free Defined Currency 1
CreditAmountInFreeDfndCrcy1 Credit Amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FlowAmountInFreeDfndCrcy2 Flow Amount in Free Defined Currency 2
DebitAmountInFreeDfndCrcy2 Debit Amount in Free Defined Currency 2
CreditAmountInFreeDfndCrcy2 Credit Amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FlowAmountInFreeDfndCrcy3 Flow Amount in Free Defined Currency 3
DebitAmountInFreeDfndCrcy3 Debit Amount in Free Defined Currency 3
CreditAmountInFreeDfndCrcy3 Credit Amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FlowAmountInFreeDfndCrcy4 Flow Amount in Free Defined Currency 4
DebitAmountInFreeDfndCrcy4 Debit Amount in Free Defined Currency 4
CreditAmountInFreeDfndCrcy4 Credit Amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FlowAmountInFreeDfndCrcy5 Flow Amount in Free Defined Currency 5
DebitAmountInFreeDfndCrcy5 Debit Amount in Free Defined Currency 5
CreditAmountInFreeDfndCrcy5 Credit Amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FlowAmountInFreeDfndCrcy6 Flow Amount in Free Defined Currency 6
DebitAmountInFreeDfndCrcy6 Debit Amount in Free Defined Currency 6
CreditAmountInFreeDfndCrcy6 Credit Amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FlowAmountInFreeDfndCrcy7 Flow Amount in Free Defined Currency 7
DebitAmountInFreeDfndCrcy7 Debit Amount in Free Defined Currency 7
CreditAmountInFreeDfndCrcy7 Credit Amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
FlowAmountInFreeDfndCrcy8 Flow Amount in Free Defined Currency 8
DebitAmountInFreeDfndCrcy8 Debit Amount in Free Defined Currency 8
CreditAmountInFreeDfndCrcy8 Credit Amount in Free Defined Currency 8
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
CreationDate Creation Date
ServicesRenderedDate Date on which services are rendered
ClearingDate Clearing Date
AssetValueDate Asset Value Date
SettlementReferenceDate Settlement Reference Date
PubSecBudgetCnsmpnDate Budget Consumption Date
Column Name Description
GLRecordType Record Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsSettlement Indicator: Item is Settling or Transferring Another Item Show values
IsSettled Indicator: Line Item is Settled or Transferred Show values
IsCommitment Indicator: Is Commitment Show values
JrnlEntryItemObsoleteReason Journal Entry Item Obsolete Reason Show values
GLAccountFlowType G/L Account Flow Type Show values
GLAccountTypeFlowType G/L Account Flow Type For G/L Account Type Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
OriginObjectType Type of Origin Object Show values
GLAccountType Type of a General Ledger Account Show values
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
FinancialAccountType Account Type Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
QuantityIsIncomplete Indicator: Quantity Is Incomplete Show values
OffsettingAccountType Offsetting Account Type Show values
LineItemIsCompleted Indicator: Line Item is Completed Show values
ControllingObjectClass Object Class Show values
PartnerControllingObjectClass Partner object class Show values
OrderCategory Order category Show values
PartnerOrderCategory Partner Order Category Show values
MaintenanceOrderPlanningCode Maintenance order planning indicator Show values
MaintenanceOrderIsPlanned Planned Parts/Work Show values
IsStatisticalOrder Indicator: Internal Order is Statistical Account Assignment Show values
IsStatisticalCostCenter Indicator: Cost Center is Statistical Account Assignment Show values
IsStatisticalSalesDocument Sales Document is statistical Show values
WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment Show values
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
PubSecBudgetCnsmpnAmtType Budget Consumption Amount Type Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocumentItemGroup Reference Document Item Group NUMC6
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
ReversalReferenceDocument Reversal Reference Document AWREF
PredecessorReferenceDocCntxt Predecessor Reference Document Context AWORG
PredecessorReferenceDocument Predecessor Reference Document AWREF
PredecessorReferenceDocItem Predecessor Reference Document Item NUMC6
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountingDocumentItem Journal Entry Posting View Item BUZEI
AssignmentReference Assignment Reference ZUONR
TransactionTypeDetermination Transaction Key CHAR3
LastChangeDateTime Time Stamp of Last Change TZNTSTMPS
CreationDateTime Time Stamp of Creation TZNTSTMPS
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceItemReference Invoice Item Reference BUZEI
AccountAssignmentNumber Account Assignment Number NUM02
DocumentItemText Item Text TEXT50
SalesDocumentItem Sales Document Item POSNR
ConditionContract Condition Contract WCB_COCO_NUM
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
CostEstimate Cost Estimate CK_KALNR
InventorySpecialStockType Inventory Special Stock Type SOBKZ
InventorySpclStkSalesDocument Inventory Special Stock Sales Document VBELN
InventorySpclStkSalesDocItm Inventory Special Stock Sales Document Item POSNR
InvtrySpclStockWBSElmntIntID Inventory Special Stock WBS Element Internal ID FIS_WBSINT_NO_CONV
InventorySpecialStockSupplier Supplier of Inventory Special Stock LIFNR
SenderGLAccount Sender G/L Account CHAR10
SenderAccountAssignment Sender Account Assignment ACCAS
OffsettingAccount Offsetting Account GKONT
OffsettingChartOfAccounts Offsetting Chart of Accounts KTOPL
PersonnelNumber Personnel Number PERNR
AccountAssignment Account Assignment ACCAS
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
RelatedNetworkActivity Network activity VORNR
PartnerAccountAssignment Partner Account Assignment ACCAS
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerProjectNetworkActivity Partner Project Network Activity VORNR
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
OrderOperation Operation/Activity Number VORNR
OrderItem Order item number CO_POSNR
OrderSuboperation Suboperation VORNR
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarYearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
CalendarYearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
CalendarYearWeek Year Week NUM6
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
AccrualObject Identifier of the Accrual Object ACR_OBJ_ID
AccrualSubobject Identifier of the Accrual Subobject ACR_SUBOBJ_ID
AccrualItemType Type of the Item of the Accrual Subobject ACR_ITEM_TYPE
GrantID Grant GM_GRANT_NBR
PartnerGrant Partner Grant GM_GRANT_NBR
PubSecBudgetCnsmpnFsclPeriod CC Fiscal Period for Budget Consumption Date POPER
PubSecBudgetCnsmpnFsclYear CC Fiscal Year for Budget Consumption Date GJAHR
SalesOrderItem Sales Order Item POSNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_GLACCOUNTBALANCE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_GLACCOUNTBALANCE.MANDT == T003.MANDT
Type of the Accrual Object
  • Client
  • Type of the Accrual Object
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Client
  • Alternative Chart of Accounts for Country/Region
  • I_GLACCOUNTBALANCE.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • I_GLACCOUNTBALANCE.MANDT == SKA1.MANDT
  • I_GLACCOUNTBALANCE.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
Assembly
  • Assembly
  • Client
  • I_GLACCOUNTBALANCE.ASSEMBLY == MARA.MATNR
  • I_GLACCOUNTBALANCE.MANDT == MARA.MANDT
Transaction Type Category I_GLACCOUNTBALANCE.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Class
  • Asset Class
  • Client
  • I_GLACCOUNTBALANCE.ASSETCLASS == ANKA.ANLKL
  • I_GLACCOUNTBALANCE.MANDT == ANKA.MANDT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • I_GLACCOUNTBALANCE.MANDT == TABW.MANDT
  • I_GLACCOUNTBALANCE.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Billable Control
  • Client
  • Billable Control
  • I_GLACCOUNTBALANCE.MANDT == TBMOT.MANDT
  • I_GLACCOUNTBALANCE.BILLABLECONTROL == TBMOT.BEMOT
Billing Type
  • Client
  • Billing Type
  • I_GLACCOUNTBALANCE.MANDT == TVFK.MANDT
  • I_GLACCOUNTBALANCE.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Bill-to Party
  • Client
  • I_GLACCOUNTBALANCE.BILLTOPARTY == KNA1.KUNNR
  • I_GLACCOUNTBALANCE.MANDT == KNA1.MANDT
Budget Period
  • Financial Management Area
  • Client
  • Fund
  • Budget Period
  • I_GLACCOUNTBALANCE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_GLACCOUNTBALANCE.MANDT == FMFUNDBPD.MANDT
  • I_GLACCOUNTBALANCE.FUND == FMFUNDBPD.FINCODE
  • I_GLACCOUNTBALANCE.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
Business Area
  • Business Area
  • Client
  • I_GLACCOUNTBALANCE.BUSINESSAREA == TGSB.GSBER
  • I_GLACCOUNTBALANCE.MANDT == TGSB.MANDT
Business Process
  • Client
  • ?
  • Controlling Area
  • Business Process
  • I_GLACCOUNTBALANCE.MANDT == CBPR.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CBPR.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CBPR.KOKRS
  • I_GLACCOUNTBALANCE.BUSINESSPROCESS == CBPR.PRZNR
Business Transaction Type
  • Business Transaction Type
  • Client
Cash Origin Account
  • Chart of Accounts
  • Client
  • Cash Origin Account
  • I_GLACCOUNTBALANCE.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_GLACCOUNTBALANCE.MANDT == SKA1.MANDT
  • I_GLACCOUNTBALANCE.CASHLEDGERACCOUNT == SKA1.SAKNR
Cash Origin Company Code
  • Cash Origin Company Code
  • Client
  • I_GLACCOUNTBALANCE.CASHLEDGERCOMPANYCODE == T001.BUKRS
  • I_GLACCOUNTBALANCE.MANDT == T001.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_GLACCOUNTBALANCE.CHARTOFACCOUNTS == T004.KTOPL
  • I_GLACCOUNTBALANCE.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_GLACCOUNTBALANCE.MANDT == T001.MANDT
  • I_GLACCOUNTBALANCE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • I_GLACCOUNTBALANCE.MANDT == TKA01.MANDT
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == TKA01.KOKRS
Cost Analysis Resource
  • Client
  • Cost Analysis Resource
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.MANDT == CSKR.MANDT
  • I_GLACCOUNTBALANCE.COSTANALYSISRESOURCE == CSKR.RESRC
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CSKR.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CSKR.KOKRS
Cost Center
  • Cost Center
  • Client
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.COSTCENTER == CSKS.KOSTL
  • I_GLACCOUNTBALANCE.MANDT == CSKS.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CSKS.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CSKS.KOKRS
Activity Type
  • Client
  • ?
  • Controlling Area
  • Activity Type
  • I_GLACCOUNTBALANCE.MANDT == CSLA.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CSLA.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CSLA.KOKRS
  • I_GLACCOUNTBALANCE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Cost Object
  • Client
  • ?
  • Cost Object
  • I_GLACCOUNTBALANCE.MANDT == CKPH.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CKPH.DATBI
  • I_GLACCOUNTBALANCE.COSTOBJECT == CKPH.KSTRG
Origin Group as Subdivision of Cost Element
  • Origin Group as Subdivision of Cost Element
  • Client
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.COSTORIGINGROUP == TKKH1.HRKFT
  • I_GLACCOUNTBALANCE.MANDT == TKKH1.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "HRKTYP"] == TKKH1.KOATY
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == TKKH1.KOKRS
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • I_GLACCOUNTBALANCE.MANDT == T004.MANDT
  • I_GLACCOUNTBALANCE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Customer Number
  • Customer Number
  • Client
  • I_GLACCOUNTBALANCE.CUSTOMER == KNA1.KUNNR
  • I_GLACCOUNTBALANCE.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • I_GLACCOUNTBALANCE.MANDT == T151.MANDT
  • I_GLACCOUNTBALANCE.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Client
  • Customer or Supplier Country/Region
  • I_GLACCOUNTBALANCE.MANDT == T005.MANDT
  • I_GLACCOUNTBALANCE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • I_GLACCOUNTBALANCE.MANDT == T016.MANDT
  • I_GLACCOUNTBALANCE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • I_GLACCOUNTBALANCE.MANDT == TVTW.MANDT
  • I_GLACCOUNTBALANCE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Elimination Profit Center
  • Client
  • ?
  • Elimination Profit Center
  • Controlling Area
  • I_GLACCOUNTBALANCE.MANDT == CEPC.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CEPC.DATBI
  • I_GLACCOUNTBALANCE.ELIMINATIONPROFITCENTER == CEPC.PRCTR
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CEPC.KOKRS
Equipment Number
  • Client
  • Equipment Number
  • I_GLACCOUNTBALANCE.MANDT == EQUI.MANDT
  • I_GLACCOUNTBALANCE.EQUIPMENT == EQUI.EQUNR
Financial Management Area
  • Financial Management Area
  • Client
  • I_GLACCOUNTBALANCE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_GLACCOUNTBALANCE.MANDT == FM01.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_GLACCOUNTBALANCE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_GLACCOUNTBALANCE.MANDT == T856.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_GLACCOUNTBALANCE.FISCALYEARVARIANT == T009.PERIV
  • I_GLACCOUNTBALANCE.MANDT == T009.MANDT
Asset Subnumber
  • Client
  • Asset Subnumber
  • ?
  • Fixed Asset
  • I_GLACCOUNTBALANCE.MANDT == ANLA.MANDT
  • I_GLACCOUNTBALANCE.FIXEDASSET == ANLA.ANLN2
  • I_GLACCOUNTBALANCE.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_GLACCOUNTBALANCE.MASTERFIXEDASSET == ANLA.ANLN1
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • I_GLACCOUNTBALANCE.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_GLACCOUNTBALANCE.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • I_GLACCOUNTBALANCE.MANDT == TFKB.MANDT
  • I_GLACCOUNTBALANCE.FUNCTIONALAREA == TFKB.FKBER
Functional Location
  • Client
  • Functional Location
  • I_GLACCOUNTBALANCE.MANDT == IFLOT.MANDT
  • I_GLACCOUNTBALANCE.FUNCTIONALLOCATION == IFLOT.TPLNR
Fund
  • Financial Management Area
  • Client
  • Fund
  • I_GLACCOUNTBALANCE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_GLACCOUNTBALANCE.MANDT == FMFINCODE.MANDT
  • I_GLACCOUNTBALANCE.FUND == FMFINCODE.FINCODE
Funded Program
  • Financial Management Area
  • Funded Program
  • Client
  • I_GLACCOUNTBALANCE.FINANCIALMANAGEMENTAREA == FMMEASURE.FMAREA
  • I_GLACCOUNTBALANCE.FUNDEDPROGRAM == FMMEASURE.MEASURE
  • I_GLACCOUNTBALANCE.MANDT == FMMEASURE.CLIENT
Funds Management Center
  • Financial Management Area
  • Client
  • Funds Management Center
  • ?
  • I_GLACCOUNTBALANCE.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • I_GLACCOUNTBALANCE.MANDT == FMFCTR.MANDT
  • I_GLACCOUNTBALANCE.FUNDSCENTER == FMFCTR.FICTR
  • I_GLACCOUNTBALANCE.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • I_GLACCOUNTBALANCE.GLACCOUNT == SKB1.SAKNR
  • I_GLACCOUNTBALANCE.MANDT == SKB1.MANDT
  • I_GLACCOUNTBALANCE.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.GLOBALCURRENCY == TCURC.WAERS
Group Asset Subnumber
  • Group Asset Subnumber
  • Client
  • Group Asset
  • ?
  • I_GLACCOUNTBALANCE.GROUPFIXEDASSET == ANLA.ANLN2
  • I_GLACCOUNTBALANCE.MANDT == ANLA.MANDT
  • I_GLACCOUNTBALANCE.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • I_GLACCOUNTBALANCE.[column in domain "BUKRS"] == ANLA.BUKRS
House Bank Key
  • House Bank Key
  • Client
  • ?
  • I_GLACCOUNTBALANCE.HOUSEBANK == T012.HBKID
  • I_GLACCOUNTBALANCE.MANDT == T012.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • House Bank Key
  • Client
  • ?
  • House Bank Account
  • I_GLACCOUNTBALANCE.HOUSEBANK == T012K.HBKID
  • I_GLACCOUNTBALANCE.MANDT == T012K.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "BUKRS"] == T012K.BUKRS
  • I_GLACCOUNTBALANCE.HOUSEBANKACCOUNT == T012K.HKTID
Inventory Valuation Type
  • Client
  • Inventory Valuation Type
  • I_GLACCOUNTBALANCE.MANDT == T149D.MANDT
  • I_GLACCOUNTBALANCE.INVENTORYVALUATIONTYPE == T149D.BWTAR
Joint venture
  • Client
  • Joint venture
  • ?
  • I_GLACCOUNTBALANCE.MANDT == T8JV.MANDT
  • I_GLACCOUNTBALANCE.JOINTVENTURE == T8JV.VNAME
  • I_GLACCOUNTBALANCE.[column in domain "BUKRS"] == T8JV.BUKRS
Joint Venture Cost Recovery Code
  • Client
  • ?
  • Joint Venture Cost Recovery Code
  • I_GLACCOUNTBALANCE.MANDT == T8JJ.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "BUKRS"] == T8JJ.BUKRS
  • I_GLACCOUNTBALANCE.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Joint Venture Equity Group
  • Client
  • Joint venture
  • ?
  • Joint Venture Equity Group
  • I_GLACCOUNTBALANCE.MANDT == T8JF.MANDT
  • I_GLACCOUNTBALANCE.JOINTVENTURE == T8JF.VNAME
  • I_GLACCOUNTBALANCE.[column in domain "BUKRS"] == T8JF.BUKRS
  • I_GLACCOUNTBALANCE.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
Joint Venture Equity Type
  • Client
  • ?
  • Joint Venture Equity Type
  • I_GLACCOUNTBALANCE.MANDT == T8JE.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "BUKRS"] == T8JE.BUKRS
  • I_GLACCOUNTBALANCE.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Logical System I_GLACCOUNTBALANCE.LOGICALSYSTEM == TBDLS.LOGSYS
Maintenance activity type
  • Client
  • Maintenance activity type
  • I_GLACCOUNTBALANCE.MANDT == T353I.MANDT
  • I_GLACCOUNTBALANCE.MAINTENANCEACTIVITYTYPE == T353I.ILART
Priority
  • Client
  • Priority Type
  • Priority
  • I_GLACCOUNTBALANCE.MANDT == T356.MANDT
  • I_GLACCOUNTBALANCE.MAINTPRIORITYTYPE == T356.ARTPR
  • I_GLACCOUNTBALANCE.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Client
  • Priority Type
  • I_GLACCOUNTBALANCE.MANDT == T356A.MANDT
  • I_GLACCOUNTBALANCE.MAINTPRIORITYTYPE == T356A.ARTPR
Operating concern
  • Operating concern
  • Client
  • I_GLACCOUNTBALANCE.OPERATINGCONCERN == TKEB.ERKRS
  • I_GLACCOUNTBALANCE.MANDT == TKEB.MANDT
Order ID
  • Client
  • Order ID
  • I_GLACCOUNTBALANCE.MANDT == AUFK.MANDT
  • I_GLACCOUNTBALANCE.ORDERID == AUFK.AUFNR
Division
  • Division
  • Client
  • I_GLACCOUNTBALANCE.ORGANIZATIONDIVISION == TSPA.SPART
  • I_GLACCOUNTBALANCE.MANDT == TSPA.MANDT
Origin Cost Center
  • Client
  • Origin Cost Center
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.MANDT == CSKS.MANDT
  • I_GLACCOUNTBALANCE.ORIGINCOSTCENTER == CSKS.KOSTL
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CSKS.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CSKS.KOKRS
Origin Cost Center Activity Type
  • Client
  • Origin Cost Center Activity Type
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.MANDT == CSLA.MANDT
  • I_GLACCOUNTBALANCE.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CSLA.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CSLA.KOKRS
Origin Profit Center
  • Client
  • Origin Profit Center
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.MANDT == CEPC.MANDT
  • I_GLACCOUNTBALANCE.ORIGINPROFITCENTER == CEPC.PRCTR
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CEPC.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CEPC.KOKRS
FM: Partner Budget Period
  • Partner Fund
  • Financial Management Area
  • Client
  • FM: Partner Budget Period
  • I_GLACCOUNTBALANCE.PARTNERFUND == FMFUNDBPD.FINCODE
  • I_GLACCOUNTBALANCE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_GLACCOUNTBALANCE.MANDT == FMFUNDBPD.MANDT
  • I_GLACCOUNTBALANCE.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
Partner Business Area
  • Partner Business Area
  • Client
  • I_GLACCOUNTBALANCE.PARTNERBUSINESSAREA == TGSB.GSBER
  • I_GLACCOUNTBALANCE.MANDT == TGSB.MANDT
Partner Business Process
  • Client
  • ?
  • Controlling Area
  • Partner Business Process
  • I_GLACCOUNTBALANCE.MANDT == CBPR.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CBPR.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CBPR.KOKRS
  • I_GLACCOUNTBALANCE.PARTNERBUSINESSPROCESS == CBPR.PRZNR
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_GLACCOUNTBALANCE.PARTNERCOMPANY == T880.RCOMP
  • I_GLACCOUNTBALANCE.MANDT == T880.MANDT
Partner Company Code
  • Client
  • Partner Company Code
  • I_GLACCOUNTBALANCE.MANDT == T001.MANDT
  • I_GLACCOUNTBALANCE.PARTNERCOMPANYCODE == T001.BUKRS
Partner Cost Center
  • Client
  • Partner Cost Center
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.MANDT == CSKS.MANDT
  • I_GLACCOUNTBALANCE.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CSKS.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CSKS.KOKRS
Partner Cost Center Activity Type
  • Partner Cost Center Activity Type
  • Client
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_GLACCOUNTBALANCE.MANDT == CSLA.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CSLA.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CSLA.KOKRS
Partner Cost Object
  • Partner Cost Object
  • Client
  • ?
  • I_GLACCOUNTBALANCE.PARTNERCOSTOBJECT == CKPH.KSTRG
  • I_GLACCOUNTBALANCE.MANDT == CKPH.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CKPH.DATBI
Partner Functional Area
  • Partner Functional Area
  • Client
  • I_GLACCOUNTBALANCE.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • I_GLACCOUNTBALANCE.MANDT == TFKB.MANDT
Partner Fund
  • Partner Fund
  • Financial Management Area
  • Client
  • I_GLACCOUNTBALANCE.PARTNERFUND == FMFINCODE.FINCODE
  • I_GLACCOUNTBALANCE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_GLACCOUNTBALANCE.MANDT == FMFINCODE.MANDT
Partner Order
  • Partner Order
  • Client
  • I_GLACCOUNTBALANCE.PARTNERORDER == AUFK.AUFNR
  • I_GLACCOUNTBALANCE.MANDT == AUFK.MANDT
Partner Profit Center
  • Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_GLACCOUNTBALANCE.MANDT == CEPC.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CEPC.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CEPC.KOKRS
Partner Project Internal ID
  • Partner Project Internal ID
  • Client
  • I_GLACCOUNTBALANCE.PARTNERPROJECTINTERNALID == PROJ.PSPNR
  • I_GLACCOUNTBALANCE.MANDT == PROJ.MANDT
Partner Project Network
  • Partner Project Network
  • Client
  • I_GLACCOUNTBALANCE.PARTNERPROJECTNETWORK == AUFK.AUFNR
  • I_GLACCOUNTBALANCE.MANDT == AUFK.MANDT
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • I_GLACCOUNTBALANCE.MANDT == FAGL_SEGM.MANDT
  • I_GLACCOUNTBALANCE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • I_GLACCOUNTBALANCE.MANDT == T001W.MANDT
  • I_GLACCOUNTBALANCE.PLANT == T001W.WERKS
Posting Key
  • Posting Key
  • Client
  • I_GLACCOUNTBALANCE.POSTINGKEY == TBSL.BSCHL
  • I_GLACCOUNTBALANCE.MANDT == TBSL.MANDT
Predecessor Reference Document Type I_GLACCOUNTBALANCE.PREDECESSORREFERENCEDOCTYPE == TTYP.AWTYP
Product Number
  • Product Number
  • Client
  • I_GLACCOUNTBALANCE.PRODUCT == MARA.MATNR
  • I_GLACCOUNTBALANCE.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • I_GLACCOUNTBALANCE.PRODUCTGROUP == T023.MATKL
  • I_GLACCOUNTBALANCE.MANDT == T023.MANDT
Profit Center
  • Client
  • Profit Center
  • ?
  • Controlling Area
  • I_GLACCOUNTBALANCE.MANDT == CEPC.MANDT
  • I_GLACCOUNTBALANCE.PROFITCENTER == CEPC.PRCTR
  • I_GLACCOUNTBALANCE.[column in domain "DATBI"] == CEPC.DATBI
  • I_GLACCOUNTBALANCE.CONTROLLINGAREA == CEPC.KOKRS
Project Internal ID
  • Project Internal ID
  • Client
  • I_GLACCOUNTBALANCE.PROJECTINTERNALID == PROJ.PSPNR
  • I_GLACCOUNTBALANCE.MANDT == PROJ.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • I_GLACCOUNTBALANCE.PROJECTNETWORK == AUFK.AUFNR
  • I_GLACCOUNTBALANCE.MANDT == AUFK.MANDT
Budget Account
  • Chart of Accounts
  • Budget Account
  • Client
  • I_GLACCOUNTBALANCE.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_GLACCOUNTBALANCE.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • I_GLACCOUNTBALANCE.MANDT == SKA1.MANDT
Budget Account Company Code
  • Budget Account Company Code
  • Client
  • I_GLACCOUNTBALANCE.PUBSECBUDGETACCOUNTCOCODE == T001.BUKRS
  • I_GLACCOUNTBALANCE.MANDT == T001.MANDT
Budget Consumption Type
  • Budget Consumption Type
  • Client
Reference Document Type I_GLACCOUNTBALANCE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales District
  • Client
  • Sales District
  • I_GLACCOUNTBALANCE.MANDT == T171.MANDT
  • I_GLACCOUNTBALANCE.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Sales Organization
  • Client
  • I_GLACCOUNTBALANCE.SALESORGANIZATION == TVKO.VKORG
  • I_GLACCOUNTBALANCE.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_GLACCOUNTBALANCE.MANDT == FAGL_SEGM.MANDT
  • I_GLACCOUNTBALANCE.SEGMENT == FAGL_SEGM.SEGMENT
Service Contract ID
  • Client
  • Service Contract Item ID
  • Service Contract ID
  • Service Contract Type
  • I_GLACCOUNTBALANCE.MANDT == FCO_SRVDOC.MANDT
  • I_GLACCOUNTBALANCE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_GLACCOUNTBALANCE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_GLACCOUNTBALANCE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Contract Item ID
  • Client
  • Service Contract Item ID
  • Service Contract ID
  • Service Contract Type
  • I_GLACCOUNTBALANCE.MANDT == FCO_SRVDOC.MANDT
  • I_GLACCOUNTBALANCE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_GLACCOUNTBALANCE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_GLACCOUNTBALANCE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Contract Type
  • Client
  • Service Contract Type
Service Document ID
  • Service Document Item ID
  • Client
  • Service Document Type
  • Service Document ID
  • I_GLACCOUNTBALANCE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_GLACCOUNTBALANCE.MANDT == FCO_SRVDOC.MANDT
  • I_GLACCOUNTBALANCE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_GLACCOUNTBALANCE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Item ID
  • Service Document Item ID
  • Client
  • Service Document Type
  • Service Document ID
  • I_GLACCOUNTBALANCE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_GLACCOUNTBALANCE.MANDT == FCO_SRVDOC.MANDT
  • I_GLACCOUNTBALANCE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_GLACCOUNTBALANCE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Type
  • Client
  • Service Document Type
Ship-to Party
  • Ship-to Party
  • Client
  • I_GLACCOUNTBALANCE.SHIPTOPARTY == KNA1.KUNNR
  • I_GLACCOUNTBALANCE.MANDT == KNA1.MANDT
Product Sold
  • Client
  • Product Sold
  • I_GLACCOUNTBALANCE.MANDT == MARA.MANDT
  • I_GLACCOUNTBALANCE.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Client
  • I_GLACCOUNTBALANCE.SOLDPRODUCTGROUP == T023.MATKL
  • I_GLACCOUNTBALANCE.MANDT == T023.MANDT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Source Logical System I_GLACCOUNTBALANCE.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_GLACCOUNTBALANCE.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Special G/L Indicator
  • Special G/L Indicator
  • Account Type
  • Client
  • I_GLACCOUNTBALANCE.SPECIALGLCODE == T074U.UMSKZ
  • I_GLACCOUNTBALANCE.FINANCIALACCOUNTTYPE == T074U.KOART
  • I_GLACCOUNTBALANCE.MANDT == T074U.MANDT
Subledger-Specific Line Item Type I_GLACCOUNTBALANCE.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Number of Superior Order
  • Number of Superior Order
  • Client
  • I_GLACCOUNTBALANCE.SUPERIORORDER == AUFK.AUFNR
  • I_GLACCOUNTBALANCE.MANDT == AUFK.MANDT
Supplier
  • Supplier
  • Client
  • I_GLACCOUNTBALANCE.SUPPLIER == LFA1.LIFNR
  • I_GLACCOUNTBALANCE.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • Client
  • Tax on Sales/Purchases Code
  • ?
  • I_GLACCOUNTBALANCE.MANDT == T007A.MANDT
  • I_GLACCOUNTBALANCE.TAXCODE == T007A.MWSKZ
  • I_GLACCOUNTBALANCE.[column in domain "KALSM_D"] == T007A.KALSM
Transaction Currency
  • Client
  • Transaction Currency
  • I_GLACCOUNTBALANCE.MANDT == TCURC.MANDT
  • I_GLACCOUNTBALANCE.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Client
  • Valuation area
  • I_GLACCOUNTBALANCE.MANDT == T001K.MANDT
  • I_GLACCOUNTBALANCE.VALUATIONAREA == T001K.BWKEY
Object ID of the resource
  • Object ID of the resource
  • Client
  • ?
  • I_GLACCOUNTBALANCE.WORKCENTERINTERNALID == CRID.OBJID
  • I_GLACCOUNTBALANCE.MANDT == CRID.MANDT
  • I_GLACCOUNTBALANCE.[column in domain "CR_OBJTY"] == CRID.OBJTY