C_BankAcctAnalysisQuery

Bank Account Analysis - Query | view: CBKACCTANLYSQ | Extraction: Not supported | Component: Bank Account Management
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
BankGroup Bank Group ID BU_PARTNER
BankAccountInternalID Bank Account Technical ID NUM10
NumberOfBankAccounts Number of Bank Accounts FARP_NUMBER_OF_ITEMS
NrOfBanksRated Number of Banks
Master Data Relations Join Conditions
Bank Key
  • Bank Country/Region Key
  • Bank Key
  • Client
  • C_BANKACCTANALYSISQUERY.BANKCOUNTRY == BNKA.BANKS
  • C_BANKACCTANALYSISQUERY.BANK == BNKA.BANKL
  • C_BANKACCTANALYSISQUERY.MANDT == BNKA.MANDT
Bank Country/Region Key
  • Bank Country/Region Key
  • Client
  • C_BANKACCTANALYSISQUERY.BANKCOUNTRY == T005.LAND1
  • C_BANKACCTANALYSISQUERY.MANDT == T005.MANDT
Bank In Bank Group
  • Bank In Bank Group
  • Client
  • C_BANKACCTANALYSISQUERY.BANKINBANKGROUP == BUT000.PARTNER
  • C_BANKACCTANALYSISQUERY.MANDT == BUT000.CLIENT
Company Code
  • Company Code
  • Client
  • C_BANKACCTANALYSISQUERY.COMPANYCODE == T001.BUKRS
  • C_BANKACCTANALYSISQUERY.MANDT == T001.MANDT
Foreign key: Rating
  • Client
  • Rating
  • C_BANKACCTANALYSISQUERY.MANDT == TP06.MANDT
  • C_BANKACCTANALYSISQUERY.CREDITRATING == TP06.RATING