P_GLE_ADB_GR_03

Account Mapping and Partner Consolidation Unit | view: PGLEADBGR_03 | 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, 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
itgrp Breakdown Category FC_ITGRP
SubItemCategory Fixed value for a subitem category-like characteristic CHAR10
SubItem Functional Area FKBER
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
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
FinancialStatementItem Financial Statement Item FC_ITEM
ReferenceFiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • P_GLE_ADB_GR_03.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_GLE_ADB_GR_03.MANDT == T003.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_GLE_ADB_GR_03.MANDT == TCURC.MANDT
  • P_GLE_ADB_GR_03.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_GLE_ADB_GR_03.MANDT == T006.MANDT
  • P_GLE_ADB_GR_03.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • P_GLE_ADB_GR_03.BUSINESSAREA == TGSB.GSBER
  • P_GLE_ADB_GR_03.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • P_GLE_ADB_GR_03.COMPANYCODE == T001.BUKRS
  • P_GLE_ADB_GR_03.MANDT == T001.MANDT
Dimension
  • Dimension
  • Client
  • P_GLE_ADB_GR_03.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • P_GLE_ADB_GR_03.MANDT == TF150.MANDT
Cost Center
  • ?
  • Client
  • Cost Center
  • ?
  • P_GLE_ADB_GR_03.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_GLE_ADB_GR_03.MANDT == CSKS.MANDT
  • P_GLE_ADB_GR_03.COSTCENTER == CSKS.KOSTL
  • P_GLE_ADB_GR_03.[column in domain "DATBI"] == CSKS.DATBI
Transaction type
  • Client
  • Transaction type
  • P_GLE_ADB_GR_03.MANDT == T856.MANDT
  • P_GLE_ADB_GR_03.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Functional Area
  • Client
  • P_GLE_ADB_GR_03.FUNCTIONALAREA == TFKB.FKBER
  • P_GLE_ADB_GR_03.MANDT == TFKB.MANDT
Account Number
  • Company Code
  • Account Number
  • Client
  • P_GLE_ADB_GR_03.COMPANYCODE == SKB1.BUKRS
  • P_GLE_ADB_GR_03.GLACCOUNT == SKB1.SAKNR
  • P_GLE_ADB_GR_03.MANDT == SKB1.MANDT
Group Currency of Consolidation Version
  • Client
  • Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • P_GLE_ADB_GR_03.MANDT == TCURC.MANDT
  • P_GLE_ADB_GR_03.RGCURR == TCURC.WAERS
  • P_GLE_ADB_GR_03.GROUPCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
Profit Center
  • ?
  • Profit Center
  • Client
  • ?
  • P_GLE_ADB_GR_03.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_GLE_ADB_GR_03.PROFITCENTER == CEPC.PRCTR
  • P_GLE_ADB_GR_03.MANDT == CEPC.MANDT
  • P_GLE_ADB_GR_03.[column in domain "DATBI"] == CEPC.DATBI
Group Currency of Consolidation Version
  • Client
  • Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • P_GLE_ADB_GR_03.MANDT == TCURC.MANDT
  • P_GLE_ADB_GR_03.RGCURR == TCURC.WAERS
  • P_GLE_ADB_GR_03.GROUPCURRENCY == TCURC.WAERS
Local Currency
  • Client
  • Local Currency
  • P_GLE_ADB_GR_03.MANDT == TCURC.MANDT
  • P_GLE_ADB_GR_03.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