C_CAPaytRunSrchPaymentOrder

Payment Order | view: CCAPAYSRCHPAYORD | 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
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
PaidItemBusinessPartner null
PaidItemContractAccount null
CAContract null
CADocumentTypeName Document Type Description TEXT20
CAReturnReason Return Reason RLGRD_KK
CAReturnReasonName Name of Returns Reason TXT50
CAReversalDocumentNumber Reversal Document OPBEL_KK
CAPaymentOrderStatus Status of Payment Order
CAPaymentOrderStatusName Description (250 Characters)
CAPaymentDocument Number of Payment Document
CADocumentIsReversed null
PayeeBankName Name of Financial Institution TEXT60
PayeeBank Payee Bank Number BANKK
PayeeBankCountryName Country/Region Name TEXT50
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
BankNumber Bank Number BANKL
BankAccount Bank Account Number BANKN
HouseBankName Name of Financial Institution TEXT60
HouseBankAccountDescription Account Description TEXT60
BankCountryName Country/Region Name TEXT50
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
  • Country/Region Key of Bank
  • Client
  • C_CAPAYTRUNSRCHPAYMENTORDER.BANKCOUNTRY == T005.LAND1
  • C_CAPAYTRUNSRCHPAYMENTORDER.MANDT == T005.MANDT
Authorization Group
  • Client
  • ?
  • Authorization Group
  • C_CAPAYTRUNSRCHPAYMENTORDER.MANDT == TFK_BEGRU.CLIENT
  • C_CAPAYTRUNSRCHPAYMENTORDER.[column in domain "BGOBJ_KK"] == TFK_BEGRU.BGOBJ
  • C_CAPAYTRUNSRCHPAYMENTORDER.CAAUTHORIZATIONGROUP == TFK_BEGRU.BEGRU
Document Type
  • ?
  • Document Type
  • Client
  • C_CAPAYTRUNSRCHPAYMENTORDER.[column in domain "APPLK_KK"] == TFK003.APPLK
  • C_CAPAYTRUNSRCHPAYMENTORDER.CADOCUMENTTYPE == TFK003.BLART
  • C_CAPAYTRUNSRCHPAYMENTORDER.MANDT == TFK003.MANDT
Payment Method
  • ?
  • Payment Method
  • Client
  • C_CAPAYTRUNSRCHPAYMENTORDER.[column in domain "LAND1"] == TFK042Z.LAND1
  • C_CAPAYTRUNSRCHPAYMENTORDER.CAPAYMENTMETHOD == TFK042Z.ZLSCH
  • C_CAPAYTRUNSRCHPAYMENTORDER.MANDT == TFK042Z.MANDT
House Bank Key
  • House Bank Key
  • Client
  • ?
  • C_CAPAYTRUNSRCHPAYMENTORDER.HOUSEBANK == T012.HBKID
  • C_CAPAYTRUNSRCHPAYMENTORDER.MANDT == T012.MANDT
  • C_CAPAYTRUNSRCHPAYMENTORDER.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • House Bank Account
  • House Bank Key
  • Client
  • ?
  • C_CAPAYTRUNSRCHPAYMENTORDER.HOUSEBANKACCOUNT == T012K.HKTID
  • C_CAPAYTRUNSRCHPAYMENTORDER.HOUSEBANK == T012K.HBKID
  • C_CAPAYTRUNSRCHPAYMENTORDER.MANDT == T012K.MANDT
  • C_CAPAYTRUNSRCHPAYMENTORDER.[column in domain "BUKRS"] == T012K.BUKRS
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • C_CAPAYTRUNSRCHPAYMENTORDER.PAYEEBANKCOUNTRY == T005.LAND1
  • C_CAPAYTRUNSRCHPAYMENTORDER.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_CAPAYTRUNSRCHPAYMENTORDER.PAYEECOUNTRY == T005.LAND1
  • C_CAPAYTRUNSRCHPAYMENTORDER.MANDT == T005.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • C_CAPAYTRUNSRCHPAYMENTORDER.MANDT == TCURC.MANDT
  • C_CAPAYTRUNSRCHPAYMENTORDER.TRANSACTIONCURRENCY == TCURC.WAERS