P_CAPaymentSearch

Payment Search Run and Lot | view: PCAPAYMENTSEARCH | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKZKDFKKZPDPAYHTFK001GT001TKA02FKKVKP
Column Name Description
CAPaymentLot Payment Lot
CAPaymentLotItem Item number in a payment lot
CAMassRunDate null
CAMAssRunID null
CAIntPaymentIdentification Sequential payment number
CAIntAddlPaymentIdentification Additional distinguishing criterion from payments
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CAPaymentAmountInTransCurrency Amount in Transaction Currency with +/- Sign
Column Name Description
Column Name Description
ValueDate Value date
DocumentDate Document Date in Document
CreationDate Creation Date
PaymentDocumentPostingDate null
Column Name Description
CAPaymentTransIsToBeClarified Clarify Payment Transaction Show values
Column Name Description Domain name
CADocumentNumber Number of a FI-CA Document OPBEL_KK
CARepaymentRequest Repayment Request NRZAA_KK
CABankAccountHolderName Name of Holder of Bank Account/Check Issuer/Cardholder KOINH
CardNumber Payment cards: Card number CCNUM
BankNumber Bank Number of Other Bank Key BANKK
BankAccount Bank account number BANKN
SWIFTCode SWIFT/BIC for International Payments SWIFT
IBAN IBAN (International Bank Account Number) IBAN
CACheque Check number CHCKN
CANoteToPayeeInPayment Note to Payee in Payment CHAR80
CAAuthorizationGroup Authorization Group BEGRU
CAPaymentMethod null
PayeeBank null
PayeeCountry null
CityName null
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • P_CAPAYMENTSEARCH.MANDT == T005.MANDT
  • P_CAPAYMENTSEARCH.BANKCOUNTRY == T005.LAND1
Business Area
  • Client
  • Business Area
  • P_CAPAYMENTSEARCH.MANDT == TGSB.MANDT
  • P_CAPAYMENTSEARCH.BUSINESSAREA == TGSB.GSBER
Company Code
  • Company Code
  • Client
  • P_CAPAYMENTSEARCH.COMPANYCODE == T001.BUKRS
  • P_CAPAYMENTSEARCH.MANDT == T001.MANDT
Payment Card Type
  • Payment Card Type
  • Client
  • P_CAPAYMENTSEARCH.PAYMENTCARDTYPE == TB033.CCINS
  • P_CAPAYMENTSEARCH.MANDT == TB033.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_CAPAYMENTSEARCH.MANDT == TCURC.MANDT
  • P_CAPAYMENTSEARCH.TRANSACTIONCURRENCY == TCURC.WAERS