P_GLE_ADB_GR_07

Evaluate breakdown by RTCUR and provide fields from ACDOCA | view: PGLEADBGR_07 | Extraction: Not supported | Component: Average Daily Balance
Tables used: ACDOCA, FINS_BAL_DUMMY2, ACDOCA, 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_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
ConsolidationRecordNumber Record number of the line item record
Column Name Description
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
Column Name Description
Column Name Description
Column Name Description
PostingLevel Posting Level Show values
Column Name Description Domain name
ConsolidationGroup Consolidation Group FC_CONGR
ConsolidationLedger Ledger RLDNR
ConsolidationVersion Version RVERS
AccountingDocument Document Number of an Accounting Document BELNR
Ledger Ledger in General Ledger Accounting FINS_LEDGER
LedgerGLLineItem Six-Character Posting Item for Ledger DOCLN6
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ConsolidationUnit Consolidation Unit FC_BUNIT
ConsolidationChartOfAccounts Consolidation Chart of Accounts FC_ITCLG
FinancialStatementItem Financial Statement Item FC_ITEM
PartnerConsolidationUnit Partner Unit FC_BUNIT
CompanyCode Original company code BUKRS
SubItemCategory Subitem Category FC_SITYP
SubItem Subitem FC_SITEM
GLAccount Account Number SAKNR
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
FunctionalArea Functional Area FKBER
BusinessArea Business Area GSBER
Segment Segment for Segmental Reporting FB_SEGMENT
FinancialTransactionType Transaction type RMVCT
ReferenceDocumentNumber Reference Document Number XBLNR1
AssignmentReference Assignment Reference ZUONR
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
Project Project FIS_PROJECT_NO_CONV
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
CreationDateTime Time Stamp of Creation TZNTSTMPS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • P_GLE_ADB_GR_07.MANDT == TVFK.MANDT
  • P_GLE_ADB_GR_07.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Client
  • Bill-to Party
  • P_GLE_ADB_GR_07.MANDT == KNA1.MANDT
  • P_GLE_ADB_GR_07.BILLTOPARTY == KNA1.KUNNR
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_GLE_ADB_GR_07.CHARTOFACCOUNTS == T004.KTOPL
  • P_GLE_ADB_GR_07.MANDT == T004.MANDT
Dimension
  • Dimension
  • Client
  • P_GLE_ADB_GR_07.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • P_GLE_ADB_GR_07.MANDT == TF150.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_GLE_ADB_GR_07.MANDT == TKA01.MANDT
  • P_GLE_ADB_GR_07.CONTROLLINGAREA == TKA01.KOKRS
Customer Number
  • Client
  • Customer Number
  • P_GLE_ADB_GR_07.MANDT == KNA1.MANDT
  • P_GLE_ADB_GR_07.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • P_GLE_ADB_GR_07.MANDT == T151.MANDT
  • P_GLE_ADB_GR_07.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • P_GLE_ADB_GR_07.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_GLE_ADB_GR_07.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • P_GLE_ADB_GR_07.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • P_GLE_ADB_GR_07.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • P_GLE_ADB_GR_07.MANDT == TVTW.MANDT
  • P_GLE_ADB_GR_07.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Currency key of the ledger currency
  • Currency key of the ledger currency
  • Client
  • P_GLE_ADB_GR_07.GROUPCURRENCY == TCURC.WAERS
  • P_GLE_ADB_GR_07.MANDT == TCURC.MANDT
Currency key of the local currency
  • Currency key of the local currency
  • Client
  • P_GLE_ADB_GR_07.LOCALCURRENCY == TCURC.WAERS
  • P_GLE_ADB_GR_07.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • P_GLE_ADB_GR_07.MANDT == MARA.MANDT
  • P_GLE_ADB_GR_07.MATERIAL == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_GLE_ADB_GR_07.MATERIALGROUP == T023.MATKL
  • P_GLE_ADB_GR_07.SOLDPRODUCTGROUP == T023.MATKL
  • P_GLE_ADB_GR_07.MANDT == T023.MANDT
Order ID
  • Client
  • Order ID
  • P_GLE_ADB_GR_07.MANDT == AUFK.MANDT
  • P_GLE_ADB_GR_07.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • P_GLE_ADB_GR_07.MANDT == TSPA.MANDT
  • P_GLE_ADB_GR_07.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Client
  • Partner Business Area
  • P_GLE_ADB_GR_07.MANDT == TGSB.MANDT
  • P_GLE_ADB_GR_07.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_GLE_ADB_GR_07.MANDT == T880.MANDT
  • P_GLE_ADB_GR_07.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Client
  • ?
  • Controlling Area
  • Partner Cost Center
  • P_GLE_ADB_GR_07.MANDT == CSKS.MANDT
  • P_GLE_ADB_GR_07.[column in domain "DATBI"] == CSKS.DATBI
  • P_GLE_ADB_GR_07.CONTROLLINGAREA == CSKS.KOKRS
  • P_GLE_ADB_GR_07.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_GLE_ADB_GR_07.MANDT == TFKB.MANDT
  • P_GLE_ADB_GR_07.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • Partner Profit Center
  • P_GLE_ADB_GR_07.MANDT == CEPC.MANDT
  • P_GLE_ADB_GR_07.[column in domain "DATBI"] == CEPC.DATBI
  • P_GLE_ADB_GR_07.CONTROLLINGAREA == CEPC.KOKRS
  • P_GLE_ADB_GR_07.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_GLE_ADB_GR_07.MANDT == FAGL_SEGM.MANDT
  • P_GLE_ADB_GR_07.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • P_GLE_ADB_GR_07.MANDT == T001W.MANDT
  • P_GLE_ADB_GR_07.PLANT == T001W.WERKS
Sales District
  • Client
  • Sales District
  • P_GLE_ADB_GR_07.MANDT == T171.MANDT
  • P_GLE_ADB_GR_07.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • P_GLE_ADB_GR_07.MANDT == TVKO.MANDT
  • P_GLE_ADB_GR_07.SALESORGANIZATION == TVKO.VKORG
Ship-to Party
  • Ship-to Party
  • Client
  • P_GLE_ADB_GR_07.SHIPTOPARTY == KNA1.KUNNR
  • P_GLE_ADB_GR_07.MANDT == KNA1.MANDT
Product Sold
  • Client
  • Product Sold
  • P_GLE_ADB_GR_07.MANDT == MARA.MANDT
  • P_GLE_ADB_GR_07.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_GLE_ADB_GR_07.MATERIALGROUP == T023.MATKL
  • P_GLE_ADB_GR_07.SOLDPRODUCTGROUP == T023.MATKL
  • P_GLE_ADB_GR_07.MANDT == T023.MANDT
Supplier
  • Client
  • Supplier
  • P_GLE_ADB_GR_07.MANDT == LFA1.MANDT
  • P_GLE_ADB_GR_07.SUPPLIER == LFA1.LIFNR