I_AvgDailyBalGroupReporting

Average Daily Balances in the group reporting format | view: IADBGRCUBE | TRAN | Extraction: Not supported | Component: Average Daily Balance
Tables used: ACDOCA, FINS_BAL_DUMMY2, ACDOCA, TF500, 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
💲 Currency Key (TransactionCurrency):
MTDAvgDailyBalInBalTransCrcy null
QTDAvgDailyBalInBalTransCrcy null
YTDAvgDailyBalInBalTransCrcy null
💲 Currency key of the local currency (LocalCurrency):
MTDAvgDailyBalInCCCrcy null
QTDAvgDailyBalInCCCrcy null
YTDAvgDailyBalInCCCrcy null
💲 Currency key of the ledger currency (GroupCurrency):
MTDAvgDailyBalInGlobCrcy null
QTDAvgDailyBalInGlobCrcy null
YTDAvgDailyBalInGlobCrcy null
Column Name Description
Column Name Description
Column Name Description
GLRecordType Record Type Show values
PostingLevel Posting Level Show values
ConsolidationApportionment Apportionment Show values
CurrencyConversionsDiffType Currency Translation Show values
Column Name Description Domain name
Ledger Ledger in General Ledger Accounting FINS_LEDGER
LedgerGLLineItem Six-Character Posting Item for Ledger DOCLN6
AccountingDocument Document Number of an Accounting Document BELNR
ConsolidationLedger Ledger RLDNR
ConsolidationVersion Version RVERS
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ConsolidationDimension Dimension FC_DIMEN
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
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
ReferenceDocumentNumber Character field, length 32 CHAR32
ConsolidationGroup Consolidation Group FC_CONGR
InvesteeConsolidationUnit Investee Unit FC_BUNIT
ConsolidationAcquisitionPeriod Period of Acquisition NUM03
ConsolidationAcquisitionYear Year of Acquisition GJAHR
ConsolidationDocumentType Document Type FC_DOCTY
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • I_AVGDAILYBALGROUPREPORTING.MANDT == TVFK.MANDT
  • I_AVGDAILYBALGROUPREPORTING.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Bill-to Party
  • Client
  • I_AVGDAILYBALGROUPREPORTING.BILLTOPARTY == KNA1.KUNNR
  • I_AVGDAILYBALGROUPREPORTING.MANDT == KNA1.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_AVGDAILYBALGROUPREPORTING.CHARTOFACCOUNTS == T004.KTOPL
  • I_AVGDAILYBALGROUPREPORTING.MANDT == T004.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_AVGDAILYBALGROUPREPORTING.CONTROLLINGAREA == TKA01.KOKRS
  • I_AVGDAILYBALGROUPREPORTING.MANDT == TKA01.MANDT
Customer Number
  • Client
  • Customer Number
  • I_AVGDAILYBALGROUPREPORTING.MANDT == KNA1.MANDT
  • I_AVGDAILYBALGROUPREPORTING.CUSTOMER == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • I_AVGDAILYBALGROUPREPORTING.CUSTOMERGROUP == T151.KDGRP
  • I_AVGDAILYBALGROUPREPORTING.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Client
  • Customer or Supplier Country/Region
  • I_AVGDAILYBALGROUPREPORTING.MANDT == T005.MANDT
  • I_AVGDAILYBALGROUPREPORTING.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • I_AVGDAILYBALGROUPREPORTING.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_AVGDAILYBALGROUPREPORTING.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_AVGDAILYBALGROUPREPORTING.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_AVGDAILYBALGROUPREPORTING.MANDT == TVTW.MANDT
Currency key of the local currency
  • Currency key of the local currency
  • Client
  • I_AVGDAILYBALGROUPREPORTING.LOCALCURRENCY == TCURC.WAERS
  • I_AVGDAILYBALGROUPREPORTING.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • I_AVGDAILYBALGROUPREPORTING.MATERIAL == MARA.MATNR
  • I_AVGDAILYBALGROUPREPORTING.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • I_AVGDAILYBALGROUPREPORTING.SOLDPRODUCTGROUP == T023.MATKL
  • I_AVGDAILYBALGROUPREPORTING.MATERIALGROUP == T023.MATKL
  • I_AVGDAILYBALGROUPREPORTING.MANDT == T023.MANDT
Order ID
  • Order ID
  • Client
  • I_AVGDAILYBALGROUPREPORTING.ORDERID == AUFK.AUFNR
  • I_AVGDAILYBALGROUPREPORTING.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • I_AVGDAILYBALGROUPREPORTING.ORGANIZATIONDIVISION == TSPA.SPART
  • I_AVGDAILYBALGROUPREPORTING.MANDT == TSPA.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • I_AVGDAILYBALGROUPREPORTING.PARTNERBUSINESSAREA == TGSB.GSBER
  • I_AVGDAILYBALGROUPREPORTING.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_AVGDAILYBALGROUPREPORTING.PARTNERCOMPANY == T880.RCOMP
  • I_AVGDAILYBALGROUPREPORTING.MANDT == T880.MANDT
Partner Cost Center
  • Controlling Area
  • Client
  • Partner Cost Center
  • ?
  • I_AVGDAILYBALGROUPREPORTING.CONTROLLINGAREA == CSKS.KOKRS
  • I_AVGDAILYBALGROUPREPORTING.MANDT == CSKS.MANDT
  • I_AVGDAILYBALGROUPREPORTING.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_AVGDAILYBALGROUPREPORTING.[column in domain "DATBI"] == CSKS.DATBI
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_AVGDAILYBALGROUPREPORTING.MANDT == TFKB.MANDT
  • I_AVGDAILYBALGROUPREPORTING.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Controlling Area
  • Client
  • ?
  • Partner Profit Center
  • I_AVGDAILYBALGROUPREPORTING.CONTROLLINGAREA == CEPC.KOKRS
  • I_AVGDAILYBALGROUPREPORTING.MANDT == CEPC.MANDT
  • I_AVGDAILYBALGROUPREPORTING.[column in domain "DATBI"] == CEPC.DATBI
  • I_AVGDAILYBALGROUPREPORTING.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • I_AVGDAILYBALGROUPREPORTING.MANDT == FAGL_SEGM.MANDT
  • I_AVGDAILYBALGROUPREPORTING.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • I_AVGDAILYBALGROUPREPORTING.MANDT == T001W.MANDT
  • I_AVGDAILYBALGROUPREPORTING.PLANT == T001W.WERKS
Sales District
  • Sales District
  • Client
  • I_AVGDAILYBALGROUPREPORTING.SALESDISTRICT == T171.BZIRK
  • I_AVGDAILYBALGROUPREPORTING.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_AVGDAILYBALGROUPREPORTING.SALESORGANIZATION == TVKO.VKORG
  • I_AVGDAILYBALGROUPREPORTING.MANDT == TVKO.MANDT
Ship-to Party
  • Client
  • Ship-to Party
  • I_AVGDAILYBALGROUPREPORTING.MANDT == KNA1.MANDT
  • I_AVGDAILYBALGROUPREPORTING.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Product Sold
  • Client
  • I_AVGDAILYBALGROUPREPORTING.SOLDPRODUCT == MARA.MATNR
  • I_AVGDAILYBALGROUPREPORTING.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • I_AVGDAILYBALGROUPREPORTING.SOLDPRODUCTGROUP == T023.MATKL
  • I_AVGDAILYBALGROUPREPORTING.MATERIALGROUP == T023.MATKL
  • I_AVGDAILYBALGROUPREPORTING.MANDT == T023.MANDT
Supplier
  • Supplier
  • Client
  • I_AVGDAILYBALGROUPREPORTING.SUPPLIER == LFA1.LIFNR
  • I_AVGDAILYBALGROUPREPORTING.MANDT == LFA1.MANDT