P_GLE_ADB_GR_01

Aggregated select from ACDOCA | view: PGLEADBGR_01 | Extraction: Not supported | Component: Average Daily Balance
Tables used: ACDOCA, FINS_BAL_DUMMY2, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, 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
PostingDate Posting Date in the Document
Column Name Description
CnsldtnUnitGroupCrcySource Source for Group Currency Key Figure Show values
CnsldtnUnitLocalCrcySource Source for Local Currency Key Figure Show values
DocumentEntryIsInGroupCurrency Group Currency is Leading Currency Show values
Column Name Description Domain name
LedgerGLLineItem Six-Character Posting Item for Ledger DOCLN6
gjahr Fiscal Year GJAHR
AccountingDocument Document Number of an Accounting Document BELNR
ReferenceFiscalYear Fiscal Year GJAHR
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ConsolidationUnit Consolidation Unit FINCS_MD_BUNIT
ConsolidationVersion Version FC_RVERS
ConsolidationLedger Consolidation Ledger FC_RLDNR_CONS
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
fiscal_year_period Fiscal Year + Fiscal Period FINS_FYEARPERIOD
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • P_GLE_ADB_GR_01.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_GLE_ADB_GR_01.MANDT == T003.MANDT
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_GLE_ADB_GR_01.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_GLE_ADB_GR_01.MANDT == TCURC.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_GLE_ADB_GR_01.MANDT == T006.MANDT
  • P_GLE_ADB_GR_01.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • P_GLE_ADB_GR_01.BUSINESSAREA == TGSB.GSBER
  • P_GLE_ADB_GR_01.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_GLE_ADB_GR_01.CHARTOFACCOUNTS == T004.KTOPL
  • P_GLE_ADB_GR_01.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_GLE_ADB_GR_01.MANDT == T001.MANDT
  • P_GLE_ADB_GR_01.COMPANYCODE == T001.BUKRS
Dimension
  • Dimension
  • Client
  • P_GLE_ADB_GR_01.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • P_GLE_ADB_GR_01.MANDT == TF150.MANDT
Cost Center
  • ?
  • Cost Center
  • ?
  • Client
  • P_GLE_ADB_GR_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_GLE_ADB_GR_01.COSTCENTER == CSKS.KOSTL
  • P_GLE_ADB_GR_01.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_GLE_ADB_GR_01.MANDT == CSKS.MANDT
Transaction type
  • Client
  • Transaction type
  • P_GLE_ADB_GR_01.MANDT == T856.MANDT
  • P_GLE_ADB_GR_01.FINANCIALTRANSACTIONTYPE == T856.TRTYP
FS Item Mapping Version
  • FS Item Mapping Version
  • Client
  • P_GLE_ADB_GR_01.FSITEMMAPPINGVERSION == TF23A.IMPVS
  • P_GLE_ADB_GR_01.MANDT == TF23A.MANDT
Functional Area
  • Client
  • Functional Area
  • P_GLE_ADB_GR_01.MANDT == TFKB.MANDT
  • P_GLE_ADB_GR_01.FUNCTIONALAREA == TFKB.FKBER
Account Number
  • Account Number
  • Client
  • Company Code
  • P_GLE_ADB_GR_01.GLACCOUNT == SKB1.SAKNR
  • P_GLE_ADB_GR_01.MANDT == SKB1.MANDT
  • P_GLE_ADB_GR_01.COMPANYCODE == SKB1.BUKRS
Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • Client
  • P_GLE_ADB_GR_01.GROUPCURRENCY == TCURC.WAERS
  • P_GLE_ADB_GR_01.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
Trading partner's business area
  • Trading partner's business area
  • Client
  • P_GLE_ADB_GR_01.PARTNERBUSINESSAREA == TGSB.GSBER
  • P_GLE_ADB_GR_01.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_GLE_ADB_GR_01.PARTNERCOMPANY == T880.RCOMP
  • P_GLE_ADB_GR_01.MANDT == T880.MANDT
Profit Center
  • ?
  • Profit Center
  • ?
  • Client
  • P_GLE_ADB_GR_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_GLE_ADB_GR_01.PROFITCENTER == CEPC.PRCTR
  • P_GLE_ADB_GR_01.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_GLE_ADB_GR_01.MANDT == CEPC.MANDT
Reference procedure P_GLE_ADB_GR_01.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
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