C_AvgDailyTrialBalance

ADB Trial Balance | view: CADBTRIALBAL | Extraction: Not supported | Component: Average Daily Balance
Tables used: FINS_BAL_DUMMY2, SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, CSKS, CSKT, TFKB, TFKBT, SKA1, CEPC, CEPCT, FAGL_SEGM, FAGL_SEGMT, SKAT, FINSC_LD_CMP, FINSC_LEDGER_REP, GLE_TADB_MSUB, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
PriorDayBalInBalTransCrcy Prior Day Balance In Balance Transaction Currency
CurDayActyAmtInBalTransCrcy Current Day Activity In Balance Transaction Currency
PriorMonthBalInBalTransCrcy Prior Month Balance In Balance Transaction Currency
CurMonthActyAmtInBalTransCrcy Current Month Activity In Balance Transaction Currency
YTDBalInBalTransCrcy Year-to-Date Balance In Balance Transaction Currency
MTDAvgDailyBalInBalTransCrcy Month-to-Date ADB In Balance Transaction Currency
QTDAvgDailyBalInBalTransCrcy Quarter-to-Date ADB In Balance Transaction Currency
YTDAvgDailyBalInBalTransCrcy Year-to-Date ADB In Balance Transaction Currency
MTDAvgActyAmtInBalTransCrcy Month-to-Date Avg Activity In Balance Transaction Currency
QTDActyAmtInBalTransCrcy Quarter-to-Date Acty In Balance Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
PriorDayBalInCCCrcy Prior Day Balance In Company Code Currency
CurDayActyAmtInCCCrcy Current Day Activity In Company Code Currency
PriorMonthBalInCCCrcy Prior Month Balance In Company Code Currency
CurMonthActyAmtInCCCrcy Current Month Activity In Company Code Currency
YTDBalInCCCrcy Year-to-Date Balance In Company Code Currency
MTDAvgDailyBalInCCCrcy Month-to-date ADB In Company Code Currency
QTDAvgDailyBalInCCCrcy Quarter-to-Date ADB In Company Code Currency
YTDAvgDailyBalInCCCrcy Year-to-Date ADB In Company Code Currency
MTDAvgActyAmtInCCCrcy Month-to-Date Average Activity In Company Code Currency
QTDActyAmtInCCCrcy Quarter-to-Date Activity In Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
PriorDayBalInGlobCrcy Prior Day Balance In Global Currency
CurDayActyAmtInGlobCrcy Current Day Activity In Global Currency
PriorMonthBalInGlobCrcy Prior Month Balance In Global Currency
CurMonthActyAmtInGlobCrcy Current Month Activity In Global Currency
YTDBalInGlobCrcy Year-to-Date Balance In Global Currency
MTDAvgDailyBalInGlobCrcy Month-to-Date Average Daily Balances In Global Currency
QTDAvgDailyBalInGlobCrcy Quarter-to-Date ADB In Global Currency
YTDAvgDailyBalInGlobCrcy Year-to-Date ADB In Global Currency
MTDAvgActyAmtInGlobCrcy Month-to-Date Average Activity In Balance Global Currency
QTDActyAmtInGlobCrcy Quarter-to-Date Activity In Balance GLobal Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
PriorDayBalInFDCrcy1 Prior Day Balance In Free-Defined Currency 1
CurDayActyAmtInFDCrcy1 Current Day Activity In Free-Defined Currency 1
PriorMonthBalInFDCrcy1 Prior Month Balance In Free-Defined Currency 1
CurMonthActyAmtInFDCrcy1 Current Month Activity In Free-Defined Currency 1
YTDBalInFDCrcy1 Year-to-Date Balance In Free-Defined Currency 1
MTDAvgDailyBalInFDCrcy1 Month-to-Date ADB In Free-Defined Currency 1
QTDAvgDailyBalInFDCrcy1 Quarter-to-Date ADB In Free-Defined Currency 1
YTDAvgDailyBalInFDCrcy1 Year-to-Date ADB In Free-Defined Currency 1
MTDAvgActyAmtInFDCrcy1 Month-to-Date Avg Activity In Free-Defined Currency 1
QTDActyAmtInFDCrcy1 Quarter-to-Date Activity In Free-Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
PriorDayBalInFDCrcy2 Prior Day Balance In Free-Defined Currency 2
CurDayActyAmtInFDCrcy2 Current Day Activity In Free-Defined Currency 2
PriorMonthBalInFDCrcy2 Prior Month Balance In Free-Defined Currency 2
CurMonthActyAmtInFDCrcy2 Current Month Activity In Free-Defined Currency 2
YTDBalInFDCrcy2 Year-to-Date Balance In Free-Defined Currency 2
MTDAvgDailyBalInFDCrcy2 Month-to-Date ADB In Free-Defined Currency 2
QTDAvgDailyBalInFDCrcy2 Quarter-to-Date ADB In Free-Defined Currency 2
YTDAvgDailyBalInFDCrcy2 Year-to-Date ADB In Free-Defined Currency 2
MTDAvgActyAmtInFDCrcy2 Month-to-Date Avg Activity In Free-Defined Currency 2
QTDActyAmtInFDCrcy2 Quarter-to-Date Avg Activity In Free-Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
PriorDayBalInFDCrcy3 Prior Day Balance In Free-Defined Currency 3
CurDayActyAmtInFDCrcy3 Current Day Activity In Free-Defined Currency 3
PriorMonthBalInFDCrcy3 Prior Month Balance In Free-Defined Currency 3
CurMonthActyAmtInFDCrcy3 Current Month Activity In Free-Defined Currency 3
YTDBalInFDCrcy3 Year-to-Date Balance In Free-Defined Currency 3
MTDAvgDailyBalInFDCrcy3 Month-to-Date ADB In Free-Defined Currency 3
QTDAvgDailyBalInFDCrcy3 Quarter-to-Date ADB In Free-Defined Currency 3
YTDAvgDailyBalInFDCrcy3 Year-to-Date ADB In Free-Defined Currency 3
MTDAvgActyAmtInFDCrcy3 Month-to-Date Avg Activity In Free-Defined Currency 3
QTDActyAmtInFDCrcy3 Quarter-to-Date Avg Activity In Free-Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
PriorDayBalInFDCrcy4 Prior Day Balance In Free-Defined Currency 4
CurDayActyAmtInFDCrcy4 Current Day Activity In Free-Defined Currency 4
PriorMonthBalInFDCrcy4 Prior Month Balance In Free-Defined Currency 4
CurMonthActyAmtInFDCrcy4 Current Month Activity In Free-Defined Currency 4
YTDBalInFDCrcy4 Year-to-Date Balance In Free-Defined Currency 4
MTDAvgDailyBalInFDCrcy4 Month-to-Date ADB In Free-Defined Currency 4
QTDAvgDailyBalInFDCrcy4 Quarter-to-Date ADB In Free-Defined Currency 4
YTDAvgDailyBalInFDCrcy4 Year-to-Date ADB In Free-Defined Currency 4
MTDAvgActyAmtInFDCrcy4 Month-to-Date Avg Activity In Free-Defined Currency 4
QTDActyAmtInFDCrcy4 Quarter-to-Date Activity In Free-Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
PriorDayBalInFDCrcy5 Prior Day Balance In Free-Defined Currency 5
CurDayActyAmtInFDCrcy5 Current Day Activity In Free-Defined Currency 5
PriorMonthBalInFDCrcy5 Prior Month Balance In Free-Defined Currency 5
CurMonthActyAmtInFDCrcy5 Current Month Activity In Free-Defined Currency 5
YTDBalInFDCrcy5 Year-to-Date Balance In Free-Defined Currency 5
MTDAvgDailyBalInFDCrcy5 Month-to-Date ADB In Free-Defined Currency 5
QTDAvgDailyBalInFDCrcy5 Quarter-to-Date ADB In Free-Defined Currency 5
YTDAvgDailyBalInFDCrcy5 Year-to-Date ADB In Free-Defined Currency 5
MTDAvgActyAmtInFDCrcy5 Month-to-Date Avg Activity In Free-Defined Currency 5
QTDActyAmtInFDCrcy5 Quarter-to-Date Activity In Free-Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
PriorDayBalInFDCrcy6 Prior Day Balance In Free-Defined Currency 6
CurDayActyAmtInFDCrcy6 Current Day Activity In Free-Defined Currency 6
PriorMonthBalInFDCrcy6 Prior Month Balance In Free-Defined Currency 6
CurMonthActyAmtInFDCrcy6 Current Month Activity In Free-Defined Currency 6
YTDBalInFDCrcy6 Year-to-Date Balance In Free-Defined Currency 6
MTDAvgDailyBalInFDCrcy6 Month-to-Date ADB In Free-Defined Currency 6
QTDAvgDailyBalInFDCrcy6 Quarter-to-Date ADB In Free-Defined Currency 6
YTDAvgDailyBalInFDCrcy6 Year-to-Date ADB In Free-Defined Currency 6
MTDAvgActyAmtInFDCrcy6 Month-to-Date Avg Activity In Free-Defined Currency 6
QTDActyAmtInFDCrcy6 Quarter-to-Date Activity In Free-Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
PriorDayBalInFDCrcy7 Prior Day Balance In Free-Defined Currency 7
CurDayActyAmtInFDCrcy7 Current Day Activity In Free-Defined Currency 7
PriorMonthBalInFDCrcy7 Prior Month Balance In Free-Defined Currency 7
CurMonthActyAmtInFDCrcy7 Current Month Activity In Free-Defined Currency 7
YTDBalInFDCrcy7 Year-to-Date Balance In Free-Defined Currency 7
MTDAvgDailyBalInFDCrcy7 Month-to-Date ADB In Free-Defined Currency 7
QTDAvgDailyBalInFDCrcy7 Quarter-to-Date ADB In Free-Defined Currency 7
YTDAvgDailyBalInFDCrcy7 Year-to-Date ADB In Free-Defined Currency 7
MTDAvgActyAmtInFDCrcy7 Month-to-Date Avg Activity In Free-Defined Currency 7
QTDActyAmtInFDCrcy7 Quarter-to-Date Activity In Free-Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
PriorDayBalInFDCrcy8 Prior Day Balance In Free-Defined Currency 8
CurDayActyAmtInFDCrcy8 Current Day Activity In Free-Defined Currency 8
PriorMonthBalInFDCrcy8 Prior Month Balance In Free-Defined Currency 8
CurMonthActyAmtInFDCrcy8 Current Month Activity In Free-Defined Currency 8
YTDBalInFDCrcy8 Year-to-Date Balance In Free-Defined Currency 8
MTDAvgDailyBalInFDCrcy8 Month-to-Date ADB In Free-Defined Currency 8
QTDAvgDailyBalInFDCrcy8 Quarter-to-Date ADB In Free-Defined Currency 8
YTDAvgDailyBalInFDCrcy8 Year-to-Date ADB In Free-Defined Currency 8
MTDAvgActyAmtInFDCrcy8 Month-to-Date Avg Activity In Free-Defined Currency 8
QTDActyAmtInFDCrcy8 Quarter-to-Date Activity In Free-Defined Currency 8
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
GLAccountName G/L Account Short Text TEXT20
FiscalYear Fiscal Year GJAHR
LedgerFiscalYear Ledger Fiscal Year GJAHR
FlowOfFundsLedgerFiscalYear Funds of Flow Ledger Fiscal Year
ProfitCenterName Description of Profit Center TEXT20
FunctionalAreaName Name of the Functional Area TEXT25
SegmentName Segment Name TEXT50
CostCenterName Cost Center Name TEXT20
PartnerProfitCenterName Description of Profit Center TEXT20
PartnerFunctionalAreaName Name of the Functional Area TEXT25
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
  • C_AVGDAILYTRIALBALANCE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_AVGDAILYTRIALBALANCE.MANDT == T004.MANDT
  • C_AVGDAILYTRIALBALANCE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_AVGDAILYTRIALBALANCE.MANDT == T001.MANDT
  • C_AVGDAILYTRIALBALANCE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
  • C_AVGDAILYTRIALBALANCE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_AVGDAILYTRIALBALANCE.MANDT == TKA01.MANDT
  • C_AVGDAILYTRIALBALANCE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • C_AVGDAILYTRIALBALANCE.MANDT == CSKS.MANDT
  • C_AVGDAILYTRIALBALANCE.[column in domain "DATBI"] == CSKS.DATBI
  • C_AVGDAILYTRIALBALANCE.CONTROLLINGAREA == CSKS.KOKRS
  • C_AVGDAILYTRIALBALANCE.COSTCENTER == CSKS.KOSTL
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_AVGDAILYTRIALBALANCE.MANDT == T009.MANDT
  • C_AVGDAILYTRIALBALANCE.FISCALYEARVARIANT == T009.PERIV
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
  • C_AVGDAILYTRIALBALANCE.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
  • C_AVGDAILYTRIALBALANCE.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • C_AVGDAILYTRIALBALANCE.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • C_AVGDAILYTRIALBALANCE.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
  • C_AVGDAILYTRIALBALANCE.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
  • C_AVGDAILYTRIALBALANCE.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
  • C_AVGDAILYTRIALBALANCE.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
  • C_AVGDAILYTRIALBALANCE.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • C_AVGDAILYTRIALBALANCE.MANDT == TFKB.MANDT
  • C_AVGDAILYTRIALBALANCE.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_AVGDAILYTRIALBALANCE.MANDT == SKB1.MANDT
  • C_AVGDAILYTRIALBALANCE.GLACCOUNT == SKB1.SAKNR
  • C_AVGDAILYTRIALBALANCE.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_AVGDAILYTRIALBALANCE.MANDT == TCURC.MANDT
  • C_AVGDAILYTRIALBALANCE.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_AVGDAILYTRIALBALANCE.MANDT == T880.MANDT
  • C_AVGDAILYTRIALBALANCE.PARTNERCOMPANY == T880.RCOMP
Partner Functional Area
  • Client
  • Partner Functional Area
  • C_AVGDAILYTRIALBALANCE.MANDT == TFKB.MANDT
  • C_AVGDAILYTRIALBALANCE.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • Partner Profit Center
  • C_AVGDAILYTRIALBALANCE.MANDT == CEPC.MANDT
  • C_AVGDAILYTRIALBALANCE.[column in domain "DATBI"] == CEPC.DATBI
  • C_AVGDAILYTRIALBALANCE.CONTROLLINGAREA == CEPC.KOKRS
  • C_AVGDAILYTRIALBALANCE.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • C_AVGDAILYTRIALBALANCE.MANDT == FAGL_SEGM.MANDT
  • C_AVGDAILYTRIALBALANCE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • C_AVGDAILYTRIALBALANCE.MANDT == CEPC.MANDT
  • C_AVGDAILYTRIALBALANCE.[column in domain "DATBI"] == CEPC.DATBI
  • C_AVGDAILYTRIALBALANCE.CONTROLLINGAREA == CEPC.KOKRS
  • C_AVGDAILYTRIALBALANCE.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_AVGDAILYTRIALBALANCE.MANDT == FAGL_SEGM.MANDT
  • C_AVGDAILYTRIALBALANCE.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger