C_CAPaymentLotSearch

Search Payment in Lots | view: CCAPAYTSEARCHLOT | TRAN | Extraction: Not supported | Component: Convergent Contract Accounting
Column Name Description
CAPaymentLot Payment Lot
CAPaymentLotItem Item number in a payment lot
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CAPaymentAmountInTransCurrency Payment Amount in Transaction Currency
Column Name Description
Column Name Description
ValueDate Value date
DocumentDate Document Date in Document
CreationDate Creation Date
Column Name Description
CAPaymentTransIsToBeClarified Clarify Payment Transaction Show values
Column Name Description Domain name
CADocumentOriginCodeName Description of Document Origin TEXT40
CADocumentOriginCode Document Origin Key HERKF_KK
CABankAccountHolderName Name of Holder of Bank Account/Check Issuer/Cardholder
IBAN IBAN (International Bank Account Number) IBAN
CardNumber Masked Payment Card Number ( Digital Payment )
CANoteToPayeeInPayment Note to Payee in Payment
CADocumentNumber Number of a FI-CA Document
CompanyCodeName Name of Company Code or Company TEXT25
PaymentCriticality null
CAClarificationDocument Number of Clarification Document
CAClarificationAccountName G/L Account Name TEXT20
CABankClearingAccountName G/L Account Name TEXT20
CADocumentTypeName Document Type Description TEXT20
CAClearingReasonName Name TEXT50
CACheque Check number
PayeeCountryName Country/Region Name TEXT50
BankNumber Bank Number of Other Bank Key
BankAccount Bank Account Number BANKN
SWIFTCode SWIFT/BIC for International Payments SWIFT
CAReversalDocumentNumber Reversal Document OPBEL_KK
CardHolder Payment cards: Name of cardholder
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • C_CAPAYMENTLOTSEARCH.MANDT == T005.MANDT
  • C_CAPAYMENTLOTSEARCH.BANKCOUNTRY == T005.LAND1
Business Area
  • Business Area
  • Client
  • C_CAPAYMENTLOTSEARCH.BUSINESSAREA == TGSB.GSBER
  • C_CAPAYMENTLOTSEARCH.MANDT == TGSB.MANDT
Bank clearing account
  • Bank clearing account
  • Client
  • Company Code
  • C_CAPAYMENTLOTSEARCH.CABANKCLEARINGACCOUNT == SKB1.SAKNR
  • C_CAPAYMENTLOTSEARCH.MANDT == SKB1.MANDT
  • C_CAPAYMENTLOTSEARCH.COMPANYCODE == SKB1.BUKRS
Clarification Account
  • Clarification Account
  • Client
  • Company Code
  • C_CAPAYMENTLOTSEARCH.CACLARIFICATIONACCOUNT == SKB1.SAKNR
  • C_CAPAYMENTLOTSEARCH.MANDT == SKB1.MANDT
  • C_CAPAYMENTLOTSEARCH.COMPANYCODE == SKB1.BUKRS
Clearing Reason C_CAPAYMENTLOTSEARCH.CACLEARINGREASON == TFK001A.AUGRD
Document Type
  • Document Type
  • Client
  • ?
  • C_CAPAYMENTLOTSEARCH.CADOCUMENTTYPE == TFK003.BLART
  • C_CAPAYMENTLOTSEARCH.MANDT == TFK003.MANDT
  • C_CAPAYMENTLOTSEARCH.[column in domain "APPLK_KK"] == TFK003.APPLK
Company Code
  • Client
  • Company Code
  • C_CAPAYMENTLOTSEARCH.MANDT == T001.MANDT
  • C_CAPAYMENTLOTSEARCH.COMPANYCODE == T001.BUKRS
Payment Card Type
  • Payment Card Type
  • Payment Card Type
  • Client
  • C_CAPAYMENTLOTSEARCH.PAYMENTCARDDATA == TB033.CCINS
  • C_CAPAYMENTLOTSEARCH.PAYMENTCARDTYPE == TB033.CCINS
  • C_CAPAYMENTLOTSEARCH.MANDT == TB033.MANDT
Payment Card Type
  • Payment Card Type
  • Payment Card Type
  • Client
  • C_CAPAYMENTLOTSEARCH.PAYMENTCARDDATA == TB033.CCINS
  • C_CAPAYMENTLOTSEARCH.PAYMENTCARDTYPE == TB033.CCINS
  • C_CAPAYMENTLOTSEARCH.MANDT == TB033.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • C_CAPAYMENTLOTSEARCH.MANDT == TCURC.MANDT
  • C_CAPAYMENTLOTSEARCH.TRANSACTIONCURRENCY == TCURC.WAERS