P_GLAcctBalWithComprnPeriod

GL Account Line Items in Report Period and Comparison Peirod | view: PGLACCTBALPERD | Extraction: Not supported | Component: Localization Financials Statements
Tables used: SCAL_TT_DATE, ACDOCA, FINSC_LD_CMP, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Functional Currency (Currency):
DebitPeriodBalAmtInDspCrcy Debit Amount in Functional Currency
CreditPeriodBalAmtInDspCrcy Credit Amount in Functional Currency
PeriodBalAmtInDspCrcy null
YearOpeningBalAmtInDspCrcy null
OpeningPeriodBalAmtInDspCrcy null
EndingPeriodBalAmtInDspCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
GLAccountType Type of a General Ledger Account Show values
Column Name Description Domain name
GLAccountInfo Hierarchy node
FinancialStatementLeafItem null
LedgerFiscalYear Ledger Fiscal Year GJAHR
GLAccountExternal G/L Account SAKNR
FiscalPeriod Fiscal Period POPER
WBSElement WBS Element FIS_WBS
ReportingPeriod null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_GLACCTBALWITHCOMPRNPERIOD.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == T003.MANDT
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_GLACCTBALWITHCOMPRNPERIOD.MANDT == SKA1.MANDT
  • P_GLACCTBALWITHCOMPRNPERIOD.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_GLACCTBALWITHCOMPRNPERIOD.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Business Area
  • Business Area
  • Client
  • P_GLACCTBALWITHCOMPRNPERIOD.BUSINESSAREA == TGSB.GSBER
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_GLACCTBALWITHCOMPRNPERIOD.CHARTOFACCOUNTS == T004.KTOPL
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == T001.MANDT
  • P_GLACCTBALWITHCOMPRNPERIOD.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • P_GLACCTBALWITHCOMPRNPERIOD.CONTROLLINGAREA == TKA01.KOKRS
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • Client
  • ?
  • P_GLACCTBALWITHCOMPRNPERIOD.CONTROLLINGAREA == CSKS.KOKRS
  • P_GLACCTBALWITHCOMPRNPERIOD.COSTCENTER == CSKS.KOSTL
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == CSKS.MANDT
  • P_GLACCTBALWITHCOMPRNPERIOD.[column in domain "DATBI"] == CSKS.DATBI
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == T004.MANDT
  • P_GLACCTBALWITHCOMPRNPERIOD.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Functional Area
  • Client
  • Functional Area
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == TFKB.MANDT
  • P_GLACCTBALWITHCOMPRNPERIOD.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == SKB1.MANDT
  • P_GLACCTBALWITHCOMPRNPERIOD.COMPANYCODE == SKB1.BUKRS
  • P_GLACCTBALWITHCOMPRNPERIOD.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == T880.MANDT
  • P_GLACCTBALWITHCOMPRNPERIOD.PARTNERCOMPANY == T880.RCOMP
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • P_GLACCTBALWITHCOMPRNPERIOD.CONTROLLINGAREA == CEPC.KOKRS
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == CEPC.MANDT
  • P_GLACCTBALWITHCOMPRNPERIOD.[column in domain "DATBI"] == CEPC.DATBI
  • P_GLACCTBALWITHCOMPRNPERIOD.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_GLACCTBALWITHCOMPRNPERIOD.MANDT == FAGL_SEGM.MANDT
  • P_GLACCTBALWITHCOMPRNPERIOD.SEGMENT == FAGL_SEGM.SEGMENT