P_RU_GLAcctBalance12

G/L Account Balance | view: PRUGLACCTBAL12 | Extraction: Not supported | Component: Financials Russia
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
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
PostingDate Posting Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
GLAccountExternal G/L Account Number CHAR10
OffsettingItem Offsetting Account GKONT
OffsettingChartOfAccounts Chart of Accounts KTOPL
OffsettingAccount G/L Account SAKNR
OffsettingAccountExternal G/L Account SAKNR
DocumentItemText Item Text TEXT50
LogicalSystem Logical system of source document LOGSYS
DocumentReferenceID Document Reference ID XBLNR1
AccountingDocumentHeaderText Document Header Text TEXT25
ControllingArea Controlling Area CACCD
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
FunctionalArea Functional Area FKBER
BusinessArea Business Area GSBER
Segment Application segment business partner A:Gen.:,F:FI or V:SD CHAR1
OrderID Order ID AUFNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementInternalID WBS Element PS_S4_PSPNR
ContractNumber Internal Contract Number ZUONR
Product Product Number MATNR
Plant Plant WERKS
Supplier Supplier LIFNR
Customer Customer Number KUNNR
AccountingDocumentType Journal Entry Type BLART
FiscalPeriod Fiscal Period POPER
PeriodFlag null
DisplayZeroTurnovers null
EmptyValue null
Master Data Relations Join Conditions
Alternative G/L Account Number In Company Code
  • Client
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • P_RU_GLACCTBALANCE12.MANDT == SKA1.MANDT
  • P_RU_GLACCTBALANCE12.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_RU_GLACCTBALANCE12.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_RU_GLACCTBALANCE12.MANDT == T006.MANDT
  • P_RU_GLACCTBALANCE12.BASEUNIT == T006.MSEHI
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_RU_GLACCTBALANCE12.CHARTOFACCOUNTS == T004.KTOPL
  • P_RU_GLACCTBALANCE12.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_RU_GLACCTBALANCE12.MANDT == T001.MANDT
  • P_RU_GLACCTBALANCE12.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_RU_GLACCTBALANCE12.MANDT == TCURC.MANDT
  • P_RU_GLACCTBALANCE12.COMPANYCODECURRENCY == TCURC.WAERS
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • P_RU_GLACCTBALANCE12.MANDT == T004.MANDT
  • P_RU_GLACCTBALANCE12.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_RU_GLACCTBALANCE12.GLACCOUNT == SKB1.SAKNR
  • P_RU_GLACCTBALANCE12.MANDT == SKB1.MANDT
  • P_RU_GLACCTBALANCE12.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Transaction Currency
  • Client
  • Transaction Currency
  • P_RU_GLACCTBALANCE12.MANDT == TCURC.MANDT
  • P_RU_GLACCTBALANCE12.TRANSACTIONCURRENCY == TCURC.WAERS