P_GLE_ADB_GR_02

Consolidation Unit, Period and year | view: PGLEADBGR_02 | Extraction: Not supported | Component: Average Daily Balance
Tables used: ACDOCA, FINS_BAL_DUMMY2, FINCS_BUNIT_ATD, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, FINSC_LEDGER_REP, FINSC_PERIOD, GLE_TADB_MSUB, FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
tsl_m null
tsl_q null
tsl_y null
hsl_m null
hsl_q null
hsl_y null
ksl_m null
ksl_q null
ksl_y null
osl_m null
osl_q null
osl_y null
vsl_m null
vsl_q null
vsl_y null
bsl_m null
bsl_q null
bsl_y null
csl_m null
csl_q null
csl_y null
dsl_m null
dsl_q null
dsl_y null
esl_m null
esl_q null
esl_y null
fsl_m null
fsl_q null
fsl_y null
gsl_m null
gsl_q null
gsl_y null
Column Name Description
Column Name Description
Column Name Description
curr_local_send Source for Local Currency Key Figure Show values
CnsldtnUnitGroupCrcySource Source for Group Currency Key Figure Show values
DocumentEntryIsInGroupCurrency Group Currency is Leading Currency Show values
Column Name Description Domain name
FinancialStatementItem Financial Statement Item FC_ITEM
ConsolidationChartOfAccounts Consolidation Chart of Accounts FC_ITCLG
PartnerConsolidationUnit null
LedgerGLLineItem Six-Character Posting Item for Ledger DOCLN6
ConsolidationVersion Version FC_RVERS
ConsolidationUnit Consolidation Unit FINCS_MD_BUNIT
AccountingDocument Document Number of an Accounting Document BELNR
ConsolidationLedger Consolidation Ledger FC_RLDNR_CONS
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
fiscal_year_period Fiscal Year + Fiscal Period FINS_FYEARPERIOD
gjahr Fiscal Year GJAHR
ReferenceFiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Document Type
  • Client
  • Document Type
  • P_GLE_ADB_GR_02.MANDT == T003.MANDT
  • P_GLE_ADB_GR_02.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_GLE_ADB_GR_02.MANDT == TCURC.MANDT
  • P_GLE_ADB_GR_02.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_GLE_ADB_GR_02.MANDT == T006.MANDT
  • P_GLE_ADB_GR_02.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • P_GLE_ADB_GR_02.BUSINESSAREA == TGSB.GSBER
  • P_GLE_ADB_GR_02.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • P_GLE_ADB_GR_02.COMPANYCODE == T001.BUKRS
  • P_GLE_ADB_GR_02.MANDT == T001.MANDT
Dimension
  • Dimension
  • Client
  • P_GLE_ADB_GR_02.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • P_GLE_ADB_GR_02.MANDT == TF150.MANDT
Cost Center
  • ?
  • Cost Center
  • ?
  • Client
  • P_GLE_ADB_GR_02.[column in domain "DATBI"] == CSKS.DATBI
  • P_GLE_ADB_GR_02.COSTCENTER == CSKS.KOSTL
  • P_GLE_ADB_GR_02.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_GLE_ADB_GR_02.MANDT == CSKS.MANDT
Transaction type
  • Transaction type
  • Client
  • P_GLE_ADB_GR_02.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_GLE_ADB_GR_02.MANDT == T856.MANDT
Functional Area
  • Functional Area
  • Client
  • P_GLE_ADB_GR_02.FUNCTIONALAREA == TFKB.FKBER
  • P_GLE_ADB_GR_02.MANDT == TFKB.MANDT
Account Number
  • Account Number
  • Company Code
  • Client
  • P_GLE_ADB_GR_02.GLACCOUNT == SKB1.SAKNR
  • P_GLE_ADB_GR_02.COMPANYCODE == SKB1.BUKRS
  • P_GLE_ADB_GR_02.MANDT == SKB1.MANDT
Group Currency of Consolidation Version
  • Client
  • Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • P_GLE_ADB_GR_02.MANDT == TCURC.MANDT
  • P_GLE_ADB_GR_02.RGCURR == TCURC.WAERS
  • P_GLE_ADB_GR_02.GROUPCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
Trading partner's business area
  • Client
  • Trading partner's business area
  • P_GLE_ADB_GR_02.MANDT == TGSB.MANDT
  • P_GLE_ADB_GR_02.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_GLE_ADB_GR_02.PARTNERCOMPANY == T880.RCOMP
  • P_GLE_ADB_GR_02.MANDT == T880.MANDT
Profit Center
  • ?
  • Profit Center
  • ?
  • Client
  • P_GLE_ADB_GR_02.[column in domain "DATBI"] == CEPC.DATBI
  • P_GLE_ADB_GR_02.PROFITCENTER == CEPC.PRCTR
  • P_GLE_ADB_GR_02.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_GLE_ADB_GR_02.MANDT == CEPC.MANDT
Group Currency of Consolidation Version
  • Client
  • Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • P_GLE_ADB_GR_02.MANDT == TCURC.MANDT
  • P_GLE_ADB_GR_02.RGCURR == TCURC.WAERS
  • P_GLE_ADB_GR_02.GROUPCURRENCY == TCURC.WAERS
Local Currency
  • Client
  • Local Currency
  • P_GLE_ADB_GR_02.MANDT == TCURC.MANDT
  • P_GLE_ADB_GR_02.RLCURR == TCURC.WAERS
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting