C_CAPaymentRunSearch

Search Payments in Payment Run | view: CCAPAYTSEARCHRUN | 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
💲 Company Code Currency (CompanyCodeCurrency):
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
CAPostingDate Posting Date in the Document
PaidItemDueDate Due date of the paid items
CAPaymentOrderExpirationDate Expiration Date of Payment Order
CAPromisedPaymentDate Payment Date Promised
Column Name Description
CASubApplication Subapplication in Contract Accounts Receivable and Payable Show values
CAPaymentDocumentType Payment document category Show values
PaymentAdvicePrintingReason Reason for Printing Payment Advice Show values
CAPaymentOrderStatus Status of Payment Order Show values
Column Name Description Domain name
CompanyCode Company Code for Automatic Payment Transactions BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
CAMassRunDateAndID null
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerFullName null
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
OrganizationBPName1 Name 1 of organization BU_NAME
OrganizationBPName2 Name 2 of organization BU_NAME
GroupBusinessPartnerName1 Name 1 (group) BU_NAME
GroupBusinessPartnerName2 Name 2 (group) BU_NAME
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
BankCountryName Country/Region Name TEXT50
BankNumber Bank Number BANKL
BankAccount Bank Account Number BANKN
PayeeBankCountryName Country/Region Name TEXT50
PayeeBank Payee Bank Number BANKK
PayeeBankName Name of Financial Institution TEXT60
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
PayeeCountryName Country/Region Name TEXT50
CityName City TEXT40
AddressPostalCode City postal code CHAR10
AddressLine2 null
AddressStreetName Street TEXT60
AddressHouseNumber House Number TEXT10
AddressLine1 null
SWIFTCode SWIFT/BIC for International Payments SWIFT
CurrencyName Description TEXT40
CAPaymentMethodName Payment Method Name TEXT30
BankName Name of Financial Institution TEXT60
HouseBankName Name of Financial Institution TEXT60
HouseBankAccountDescription Account Description TEXT60
CardHolder Payment cards: Name of cardholder TEXT40
PaymentCardData null
CardTypeText Description TEXT30
CardNumber Masked Payment Card Number ( Digital Payment ) DP_MASK_NUMBER
PaidItemBusinessPartner null
PaidItemContractAccount null
CAContract null
CAContractSemanticObject Semantic Object for Contract TEXT30
CADocumentTypeName Document Type Description TEXT20
CAReturnReason Return Reason RLGRD_KK
CAReturnReasonName Name of Returns Reason TXT50
CAReversalDocumentNumber Reversal Document OPBEL_KK
CAPaymentOrderStatusName Description (250 Characters)
CAPaymentDocument Number of Payment Document OPBEL_KK
CADocumentIsReversed null
CADocumentReversalStatusName Char 20 CHAR20
CAPaymentSpecification Number of Payment Specification PDKEY_KK
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_CAPAYMENTRUNSEARCH.MANDT == T005.MANDT
  • C_CAPAYMENTRUNSEARCH.BANKCOUNTRY == T005.LAND1
Document Type
  • ?
  • Client
  • Document Type
  • C_CAPAYMENTRUNSEARCH.[column in domain "APPLK_KK"] == TFK003.APPLK
  • C_CAPAYMENTRUNSEARCH.MANDT == TFK003.MANDT
  • C_CAPAYMENTRUNSEARCH.CADOCUMENTTYPE == TFK003.BLART
Payment Method
  • ?
  • Client
  • Payment Method
  • C_CAPAYMENTRUNSEARCH.[column in domain "LAND1"] == TFK042Z.LAND1
  • C_CAPAYMENTRUNSEARCH.MANDT == TFK042Z.MANDT
  • C_CAPAYMENTRUNSEARCH.CAPAYMENTMETHOD == TFK042Z.ZLSCH
Company Code Currency
  • Client
  • Company Code Currency
  • Transaction Currency
  • C_CAPAYMENTRUNSEARCH.MANDT == TCURC.MANDT
  • C_CAPAYMENTRUNSEARCH.COMPANYCODECURRENCY == TCURC.WAERS
  • C_CAPAYMENTRUNSEARCH.TRANSACTIONCURRENCY == TCURC.WAERS
House Bank Key
  • ?
  • House Bank Key
  • Client
  • C_CAPAYMENTRUNSEARCH.[column in domain "BUKRS"] == T012.BUKRS
  • C_CAPAYMENTRUNSEARCH.HOUSEBANK == T012.HBKID
  • C_CAPAYMENTRUNSEARCH.MANDT == T012.MANDT
House Bank Account
  • ?
  • House Bank Key
  • Client
  • House Bank Account
  • C_CAPAYMENTRUNSEARCH.[column in domain "BUKRS"] == T012K.BUKRS
  • C_CAPAYMENTRUNSEARCH.HOUSEBANK == T012K.HBKID
  • C_CAPAYMENTRUNSEARCH.MANDT == T012K.MANDT
  • C_CAPAYMENTRUNSEARCH.HOUSEBANKACCOUNT == T012K.HKTID
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • C_CAPAYMENTRUNSEARCH.MANDT == T005.MANDT
  • C_CAPAYMENTRUNSEARCH.PAYEEBANKCOUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • C_CAPAYMENTRUNSEARCH.MANDT == T005.MANDT
  • C_CAPAYMENTRUNSEARCH.PAYEECOUNTRY == T005.LAND1
Payment Card Type
  • Client
  • Payment Card Type
  • C_CAPAYMENTRUNSEARCH.MANDT == TB033.MANDT
  • C_CAPAYMENTRUNSEARCH.PAYMENTCARDTYPE == TB033.CCINS
Transaction Currency
  • Client
  • Company Code Currency
  • Transaction Currency
  • C_CAPAYMENTRUNSEARCH.MANDT == TCURC.MANDT
  • C_CAPAYMENTRUNSEARCH.COMPANYCODECURRENCY == TCURC.WAERS
  • C_CAPAYMENTRUNSEARCH.TRANSACTIONCURRENCY == TCURC.WAERS