C_HouseBankAcctAnlysQry

House Bank Account Analysis - Query | view: CHSBKACCTANLYSQ | 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
Bank Bank Keys BANKK
CompanyCode Company Code BUKRS
HouseBankAccount House Bank Account HKTID
NumberOfCompanyCodes Number of Company Codes
Master Data Relations Join Conditions
Bank Account Technical ID
  • Client
  • ?
  • Bank Account Technical ID
  • C_HOUSEBANKACCTANLYSQRY.MANDT == FCLM_BAM_AMD.MANDT
  • C_HOUSEBANKACCTANLYSQRY.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • C_HOUSEBANKACCTANLYSQRY.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • C_HOUSEBANKACCTANLYSQRY.BANKCOUNTRY == T005.LAND1
  • C_HOUSEBANKACCTANLYSQRY.MANDT == T005.MANDT
Bank In Bank Group
  • Client
  • Bank In Bank Group
  • C_HOUSEBANKACCTANLYSQRY.MANDT == BUT000.CLIENT
  • C_HOUSEBANKACCTANLYSQRY.BANKINBANKGROUP == BUT000.PARTNER
Foreign key: Rating
  • Client
  • Rating
  • C_HOUSEBANKACCTANLYSQRY.MANDT == TP06.MANDT
  • C_HOUSEBANKACCTANLYSQRY.CREDITRATING == TP06.RATING
Short Key for a House Bank
  • Client
  • Short Key for a House Bank
  • Company Code
  • C_HOUSEBANKACCTANLYSQRY.MANDT == T012.MANDT
  • C_HOUSEBANKACCTANLYSQRY.HOUSEBANK == T012.HBKID
  • C_HOUSEBANKACCTANLYSQRY.COMPANYCODE == T012.BUKRS