P_GLE_ADB_GR_04

Get Subitem (TF100, TF103A, TF110) | view: PGLEADBGR_04 | Extraction: Not supported | Component: Average Daily Balance
Tables used: ACDOCA, FINS_BAL_DUMMY2, FINCS_FSITEM, TF110, FINCS_BUNIT_ATD, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, FINSC_LEDGER_REP, FINSC_PERIOD, GLE_TADB_MSUB, TF103A, TF040, 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
CnsldtnSubitemSource SAP Consolidation Integration: Sender Field for Subitem Show values
CnsldtnUnitGroupCrcySource Source for Group Currency Key Figure Show values
DocumentEntryIsInGroupCurrency Group Currency is Leading Currency Show values
curr_local_send Source for Local Currency Key Figure Show values
Column Name Description Domain name
LedgerGLLineItem Six-Character Posting Item for Ledger DOCLN6
ConsolidationChartOfAccounts Consolidation Chart of Accounts FC_ITCLG
PartnerConsolidationUnit null
ConsolidationVersion Version FC_RVERS
ConsolidationUnit Consolidation Unit FINCS_MD_BUNIT
gjahr Fiscal Year GJAHR
AccountingDocument Document Number of an Accounting Document BELNR
ConsolidationLedger Consolidation Ledger FC_RLDNR_CONS
BaseUnit null
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
FinancialStatementItem Financial Statement Item FC_ITEM
itgrp Breakdown Category FC_ITGRP
SubItemCategory Fixed value for a subitem category-like characteristic CHAR10
SubItem null
ReferenceFiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_GLE_ADB_GR_04.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_GLE_ADB_GR_04.MANDT == TCURC.MANDT
Business Area
  • Business Area
  • Client
  • P_GLE_ADB_GR_04.BUSINESSAREA == TGSB.GSBER
  • P_GLE_ADB_GR_04.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • P_GLE_ADB_GR_04.COMPANYCODE == T001.BUKRS
  • P_GLE_ADB_GR_04.MANDT == T001.MANDT
Dimension
  • Client
  • Dimension
  • P_GLE_ADB_GR_04.MANDT == TF150.MANDT
  • P_GLE_ADB_GR_04.CONSOLIDATIONDIMENSION == TF150.DIMEN
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • P_GLE_ADB_GR_04.[column in domain "DATBI"] == CSKS.DATBI
  • P_GLE_ADB_GR_04.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_GLE_ADB_GR_04.COSTCENTER == CSKS.KOSTL
  • P_GLE_ADB_GR_04.MANDT == CSKS.MANDT
Transaction type
  • Transaction type
  • Client
  • P_GLE_ADB_GR_04.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_GLE_ADB_GR_04.MANDT == T856.MANDT
Functional Area
  • Functional Area
  • Client
  • P_GLE_ADB_GR_04.FUNCTIONALAREA == TFKB.FKBER
  • P_GLE_ADB_GR_04.MANDT == TFKB.MANDT
Account Number
  • Account Number
  • Company Code
  • Client
  • P_GLE_ADB_GR_04.GLACCOUNT == SKB1.SAKNR
  • P_GLE_ADB_GR_04.COMPANYCODE == SKB1.BUKRS
  • P_GLE_ADB_GR_04.MANDT == SKB1.MANDT
Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • Client
  • P_GLE_ADB_GR_04.GROUPCURRENCY == TCURC.WAERS
  • P_GLE_ADB_GR_04.RGCURR == TCURC.WAERS
  • P_GLE_ADB_GR_04.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • P_GLE_ADB_GR_04.[column in domain "DATBI"] == CEPC.DATBI
  • P_GLE_ADB_GR_04.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_GLE_ADB_GR_04.PROFITCENTER == CEPC.PRCTR
  • P_GLE_ADB_GR_04.MANDT == CEPC.MANDT
Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • Client
  • P_GLE_ADB_GR_04.GROUPCURRENCY == TCURC.WAERS
  • P_GLE_ADB_GR_04.RGCURR == TCURC.WAERS
  • P_GLE_ADB_GR_04.MANDT == TCURC.MANDT
Local Currency
  • Local Currency
  • Client
  • P_GLE_ADB_GR_04.RLCURR == TCURC.WAERS
  • P_GLE_ADB_GR_04.MANDT == TCURC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client