C_GLAccountYTDBalanceQ

Year-to-Date Balances | view: CFIGLACCTYTDBALQ | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
DebitAmountInGlobalCrcy Debit Amount in Global Currency
CreditAmountInGlobalCrcy Credit Amount in Global Currency
AmountInGlobalCurrency Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
AmountInFunctionalCurrency Amount in Functional Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
DebitAmountInBalanceTransCrcy Debit Amount in Balance Transaction Currency
CreditAmountInBalanceTransCrcy Credit Amount in Balance Transaction Currency
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
AmountInTransactionCurrency Amount in Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
DebitAmountInFreeDfndCrcy1 Debit Amount in Free Defined Currency 1
CreditAmountInFreeDfndCrcy1 Credit Amount in Free Defined Currency 1
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
DebitAmountInFreeDfndCrcy2 Debit Amount in Free Defined Currency 2
CreditAmountInFreeDfndCrcy2 Credit Amount in Free Defined Currency 2
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
DebitAmountInFreeDfndCrcy3 Debit Amount in Free Defined Currency 3
CreditAmountInFreeDfndCrcy3 Credit Amount in Free Defined Currency 3
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
DebitAmountInFreeDfndCrcy4 Debit Amount in Free Defined Currency 4
CreditAmountInFreeDfndCrcy4 Credit Amount in Free Defined Currency 4
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
DebitAmountInFreeDfndCrcy5 Debit Amount in Free Defined Currency 5
CreditAmountInFreeDfndCrcy5 Credit Amount in Free Defined Currency 5
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
DebitAmountInFreeDfndCrcy6 Debit Amount in Free Defined Currency 6
CreditAmountInFreeDfndCrcy6 Credit Amount in Free Defined Currency 6
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
DebitAmountInFreeDfndCrcy7 Debit Amount in Free Defined Currency 7
CreditAmountInFreeDfndCrcy7 Credit Amount in Free Defined Currency 7
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
DebitAmountInFreeDfndCrcy8 Debit Amount in Free Defined Currency 8
CreditAmountInFreeDfndCrcy8 Credit Amount in Free Defined Currency 8
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
OrderCategory Order category Show values
GLAccountType Type of a General Ledger Account Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalPeriod Fiscal Period POPER
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
AccountAssignmentNumber Account Assignment Number NUM02
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Business Area
  • Client
  • Business Area
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TGSB.MANDT
  • C_GLACCOUNTYTDBALANCEQ.BUSINESSAREA == TGSB.GSBER
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_GLACCOUNTYTDBALANCEQ.CHARTOFACCOUNTS == T004.KTOPL
  • C_GLACCOUNTYTDBALANCEQ.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_GLACCOUNTYTDBALANCEQ.COMPANYCODE == T001.BUKRS
  • C_GLACCOUNTYTDBALANCEQ.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • C_GLACCOUNTYTDBALANCEQ.CONTROLLINGAREA == TKA01.KOKRS
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • C_GLACCOUNTYTDBALANCEQ.[column in domain "DATBI"] == CSKS.DATBI
  • C_GLACCOUNTYTDBALANCEQ.CONTROLLINGAREA == CSKS.KOKRS
  • C_GLACCOUNTYTDBALANCEQ.MANDT == CSKS.MANDT
  • C_GLACCOUNTYTDBALANCEQ.COSTCENTER == CSKS.KOSTL
Activity Type
  • ?
  • Controlling Area
  • Client
  • Activity Type
  • C_GLACCOUNTYTDBALANCEQ.[column in domain "DATBI"] == CSLA.DATBI
  • C_GLACCOUNTYTDBALANCEQ.CONTROLLINGAREA == CSLA.KOKRS
  • C_GLACCOUNTYTDBALANCEQ.MANDT == CSLA.MANDT
  • C_GLACCOUNTYTDBALANCEQ.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Customer Number
  • Client
  • Customer Number
  • C_GLACCOUNTYTDBALANCEQ.MANDT == KNA1.MANDT
  • C_GLACCOUNTYTDBALANCEQ.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • C_GLACCOUNTYTDBALANCEQ.MANDT == T151.MANDT
  • C_GLACCOUNTYTDBALANCEQ.CUSTOMERGROUP == T151.KDGRP
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_GLACCOUNTYTDBALANCEQ.MANDT == T009.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FISCALYEARVARIANT == T009.PERIV
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TFKB.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FUNCTIONALAREA == TFKB.FKBER
Functional Currency
  • Client
  • Functional Currency
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.FUNCTIONALCURRENCY == TCURC.WAERS
G/L Account
  • Company Code
  • Client
  • G/L Account
  • C_GLACCOUNTYTDBALANCEQ.COMPANYCODE == SKB1.BUKRS
  • C_GLACCOUNTYTDBALANCEQ.MANDT == SKB1.MANDT
  • C_GLACCOUNTYTDBALANCEQ.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Order ID
  • Client
  • Order ID
  • C_GLACCOUNTYTDBALANCEQ.MANDT == AUFK.MANDT
  • C_GLACCOUNTYTDBALANCEQ.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TSPA.MANDT
  • C_GLACCOUNTYTDBALANCEQ.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • C_GLACCOUNTYTDBALANCEQ.MANDT == T001W.MANDT
  • C_GLACCOUNTYTDBALANCEQ.PLANT == T001W.WERKS
Posting Key
  • Client
  • Posting Key
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TBSL.MANDT
  • C_GLACCOUNTYTDBALANCEQ.POSTINGKEY == TBSL.BSCHL
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • C_GLACCOUNTYTDBALANCEQ.[column in domain "DATBI"] == CEPC.DATBI
  • C_GLACCOUNTYTDBALANCEQ.CONTROLLINGAREA == CEPC.KOKRS
  • C_GLACCOUNTYTDBALANCEQ.MANDT == CEPC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.PROFITCENTER == CEPC.PRCTR
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • C_GLACCOUNTYTDBALANCEQ.MANDT == AUFK.MANDT
  • C_GLACCOUNTYTDBALANCEQ.PROJECTNETWORK == AUFK.AUFNR
Sales Organization
  • Client
  • Sales Organization
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TVKO.MANDT
  • C_GLACCOUNTYTDBALANCEQ.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_GLACCOUNTYTDBALANCEQ.MANDT == FAGL_SEGM.MANDT
  • C_GLACCOUNTYTDBALANCEQ.SEGMENT == FAGL_SEGM.SEGMENT
Supplier
  • Client
  • Supplier
  • C_GLACCOUNTYTDBALANCEQ.MANDT == LFA1.MANDT
  • C_GLACCOUNTYTDBALANCEQ.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_GLACCOUNTYTDBALANCEQ.MANDT == TCURC.MANDT
  • C_GLACCOUNTYTDBALANCEQ.TRANSACTIONCURRENCY == TCURC.WAERS