C_CAPaymentRunSearchPayment

Payments in Payment Run | view: CCAPAYTSRCHRUNPY | TRAN | Extraction: Not supported | Component: Convergent Contract Accounting
Column Name Description
CAMassRunDate Date ID
CAMassRunID Run ID
CAIntPaymentIdentification Sequential payment number
CAIntAddlPaymentIdentification Additional distinguishing criterion from payments
Column Name Description
💲 Transaction Currency (TransactionCurrency):
PaytAmountInCoCodeCurrency Amount in Local Currency
Column Name Description
Column Name Description
CAMassRunDate Date ID
ValueDate Value date
ValidityEndDate Payment Cards: Valid To
DocumentDate Document Date
CAPromisedPaymentDate Payment Date Promised
Column Name Description
CAPaymentDocumentType Payment document category Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerFullName null
ContractAccount Contract Account VKONT_KK
ContractAccountName Description of Contract Account TEXT35
CAPaymentDocumentReference Reference to Payment Document CHAR24
CAPaymentDocumentTypeName Character field, length 70 CHAR70
CADocumentNumber Document OPBEL_KK
CAPaymentOrder Payment Order PYORD
CASEPAPreNotificationNumber SEPA: Number of Direct Debit Pre-Notification PNNUM_KK
PayeeCountryName Country/Region Name TEXT50
AddressLine2 null
AddressLine1 null
CAPaymentMethodName Payment Method Name TEXT30
BankNumber Bank Number BANKL
BankAccount Bank Account Number BANKN
HouseBankName Name of Financial Institution TEXT60
HouseBankAccountDescription Account Description TEXT60
BankCountryName Country/Region Name TEXT50
PayeeBankName Name of Financial Institution TEXT60
PayeeBank Payee Bank Number BANKK
PayeeBankNumber Bank number of the payee's bank BANKL
PayeeBankAccount Bank Account Number BANKN
PayeeIBAN IBAN (International Bank Account Number) IBAN
CABankAccountHolderName Account Holder KOINH
SWIFTCode SWIFT/BIC for International Payments SWIFT
PayeeBankCountryName Country/Region Name TEXT50
CardHolder Payment cards: Name of cardholder TEXT40
CardTypeText Description TEXT30
CardNumber Masked Payment Card Number ( Digital Payment ) DP_MASK_NUMBER
PaidItemBusinessPartner null
PaidItemContractAccount null
CAContract null
CAReturnReason Return Reason RLGRD_KK
CAReturnReasonName Name of Returns Reason TXT50
CAReversalDocumentNumber Reversal Document OPBEL_KK
CADocumentIsReversed null
CADocumentReversalStatusName Char 20
CompanyCode Company Code for Automatic Payment Transactions BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
CAPaymentSpecification null
CAPaymentSpecificationRef Reference Number of Payment Specification PDREF_KK
CAPromiseToPay Identification of Promise to Pay PPKEY_KK
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • C_CAPAYMENTRUNSEARCHPAYMENT.MANDT == T005.MANDT
  • C_CAPAYMENTRUNSEARCHPAYMENT.BANKCOUNTRY == T005.LAND1
Authorization Group
  • ?
  • Authorization Group
  • Client
  • C_CAPAYMENTRUNSEARCHPAYMENT.[column in domain "BGOBJ_KK"] == TFK_BEGRU.BGOBJ
  • C_CAPAYMENTRUNSEARCHPAYMENT.CAAUTHORIZATIONGROUP == TFK_BEGRU.BEGRU
  • C_CAPAYMENTRUNSEARCHPAYMENT.MANDT == TFK_BEGRU.CLIENT
Payment Method
  • Payment Method
  • Client
  • ?
  • C_CAPAYMENTRUNSEARCHPAYMENT.CAPAYMENTMETHOD == TFK042Z.ZLSCH
  • C_CAPAYMENTRUNSEARCHPAYMENT.MANDT == TFK042Z.MANDT
  • C_CAPAYMENTRUNSEARCHPAYMENT.[column in domain "LAND1"] == TFK042Z.LAND1
House Bank Key
  • ?
  • House Bank Key
  • Client
  • C_CAPAYMENTRUNSEARCHPAYMENT.[column in domain "BUKRS"] == T012.BUKRS
  • C_CAPAYMENTRUNSEARCHPAYMENT.HOUSEBANK == T012.HBKID
  • C_CAPAYMENTRUNSEARCHPAYMENT.MANDT == T012.MANDT
House Bank Account
  • ?
  • House Bank Key
  • House Bank Account
  • Client
  • C_CAPAYMENTRUNSEARCHPAYMENT.[column in domain "BUKRS"] == T012K.BUKRS
  • C_CAPAYMENTRUNSEARCHPAYMENT.HOUSEBANK == T012K.HBKID
  • C_CAPAYMENTRUNSEARCHPAYMENT.HOUSEBANKACCOUNT == T012K.HKTID
  • C_CAPAYMENTRUNSEARCHPAYMENT.MANDT == T012K.MANDT
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • C_CAPAYMENTRUNSEARCHPAYMENT.MANDT == T005.MANDT
  • C_CAPAYMENTRUNSEARCHPAYMENT.PAYEEBANKCOUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • C_CAPAYMENTRUNSEARCHPAYMENT.MANDT == T005.MANDT
  • C_CAPAYMENTRUNSEARCHPAYMENT.PAYEECOUNTRY == T005.LAND1
Payment Card Type
  • Client
  • Payment Card Type
  • C_CAPAYMENTRUNSEARCHPAYMENT.MANDT == TB033.MANDT
  • C_CAPAYMENTRUNSEARCHPAYMENT.PAYMENTCARDTYPE == TB033.CCINS
Transaction Currency
  • Client
  • Transaction Currency
  • C_CAPAYMENTRUNSEARCHPAYMENT.MANDT == TCURC.MANDT
  • C_CAPAYMENTRUNSEARCHPAYMENT.TRANSACTIONCURRENCY == TCURC.WAERS