C_PaymentByBankQuery

Bank Payments - Query | view: CPAYBYBANKQRY | Extraction: Not supported | Component: Bank Account Management
Column Name Description
BankCountry FK Bank Country/Region Key
Bank FK Bank Key
TransactionDate Transaction Date
Column Name Description
💲 null (DisplayCurrency):
InAmountInDisplayCurrency null
OutAmountInDisplayCurrency null
AmountInDisplayCurrency null
Column Name Description
Column Name Description
TransactionDate Transaction Date
Column Name Description
Column Name Description Domain name
CompanyCode Company Code BUKRS
Master Data Relations Join Conditions
Bank Key
  • Bank Key
  • Client
  • Bank Country/Region Key
  • C_PAYMENTBYBANKQUERY.BANK == BNKA.BANKL
  • C_PAYMENTBYBANKQUERY.MANDT == BNKA.MANDT
  • C_PAYMENTBYBANKQUERY.BANKCOUNTRY == BNKA.BANKS
Bank Country/Region Key
  • Client
  • Bank Country/Region Key
  • C_PAYMENTBYBANKQUERY.MANDT == T005.MANDT
  • C_PAYMENTBYBANKQUERY.BANKCOUNTRY == T005.LAND1
Foreign key: Rating
  • Rating
  • Client
  • C_PAYMENTBYBANKQUERY.CREDITRATING == TP06.RATING
  • C_PAYMENTBYBANKQUERY.MANDT == TP06.MANDT