I_CAPaymentLotItem

Payment Lot: Data for Payment | view: ICAPAYTLOTITEM | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKZK, DFKKZP, T001, TKA02
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
AssignedAmountInTransCrcy Assigned Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
CAAmountInLocalCurrency Amount In Local Currency With +/- Signs
ClarifiedAmountInLocalCurrency Clarified Amount In Local Currency
Column Name Description
Column Name Description
CAPostingDateOfClrfctnDoc Posting date of clarif. doc
CAPostingDate Posting Date in the Document
DocumentDate Document Date in Document
ValueDate Value date
LastChangeDate Last Change Date
LastChangeTime Time of Change
Column Name Description
CAPartialClrfctnIsExisting Partial Clarifications Exist For Payment Show values
CAPaymentTransIsToBeClarified Clarify Payment Transaction Show values
CAPaymentIsPostedOnAccount Post Payment on Account Show values
CAIsSeparateLineItemInGL Create Line Item in General Ledger Show values
CAPaytLotItemMchnLrngStatus Machine Learning: Status of Payment Lot Item Show values
ItemIsClarifiedWithMchnLrng Machine Learning: Clearing Based on Proposal Show values
CAApplicationArea Application Area Show values
Column Name Description Domain name
CAFirstSelectionValue First Field Value to be Selected CHAR35
CASecondSelectionValue Second Field Value to be Selected CHAR35
CAThirdSelectionValue Third Field Value to be Selected CHAR35
ProfitCenter Profit Center PRCTR
CAClarificationDocument Number of Clarification Document OPBEL_KK
ExchangeRate Exchange rate KURSF
LastChangedByUser Name of Person Who Changed Object USNAM
CADocumentNumber Number of a FI-CA Document OPBEL_KK
CANoteToPayeeInPayment Note to Payee in Payment CHAR80
CACheque Check number CHCKN
BankNumber Bank Number of Other Bank Key BANKK
BankAccount Bank account number BANKN
BankControlKey Bank Control Key BKONT
CABankAccountHolderName Name of Holder of Bank Account/Check Issuer/Cardholder KOINH
CARepaymentRequest Repayment Request NRZAA_KK
CardNumber Payment cards: Card number CCNUM
PaymentCardUUID GUID of a Payment Card SYSUUID
CAAuthorizationGroup Authorization Group BEGRU
IBAN IBAN (International Bank Account Number) IBAN
SWIFTCode SWIFT/BIC for International Payments SWIFT
BankStatementItem Memo Record Number (Line Item Number in Bank Statement) NUM5
CAPaymentLotItemRefMemoLine Allocation key for payment item NUM06
CAPaymentLotItemRefFurtherSel Allocation key for payment item NUM06
CASubAreaForParallelization Subarea for Parallelization in Mass Processing NUMC3
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • I_CAPAYMENTLOTITEM.BANKCOUNTRY == T005.LAND1
  • I_CAPAYMENTLOTITEM.MANDT == T005.MANDT
Business Area
  • Business Area
  • Client
  • I_CAPAYMENTLOTITEM.BUSINESSAREA == TGSB.GSBER
  • I_CAPAYMENTLOTITEM.MANDT == TGSB.MANDT
Bank clearing account
  • Company Code
  • Bank clearing account
  • Client
  • I_CAPAYMENTLOTITEM.COMPANYCODE == SKB1.BUKRS
  • I_CAPAYMENTLOTITEM.CABANKCLEARINGACCOUNT == SKB1.SAKNR
  • I_CAPAYMENTLOTITEM.MANDT == SKB1.MANDT
Clarification Account
  • Company Code
  • Client
  • Clarification Account
  • I_CAPAYMENTLOTITEM.COMPANYCODE == SKB1.BUKRS
  • I_CAPAYMENTLOTITEM.MANDT == SKB1.MANDT
  • I_CAPAYMENTLOTITEM.CACLARIFICATIONACCOUNT == SKB1.SAKNR
Clearing Reason I_CAPAYMENTLOTITEM.CACLEARINGREASON == TFK001A.AUGRD
Document Type
  • Document Type
  • Client
  • Application Area
  • I_CAPAYMENTLOTITEM.CADOCUMENTTYPE == TFK003.BLART
  • I_CAPAYMENTLOTITEM.MANDT == TFK003.MANDT
  • I_CAPAYMENTLOTITEM.CAAPPLICATIONAREA == TFK003.APPLK
1. Selection Category
  • 1. Selection Category
  • Client
  • Application Area
  • I_CAPAYMENTLOTITEM.CAFIRSTSELECTIONCATEGORY == TFK004.SELTX
  • I_CAPAYMENTLOTITEM.MANDT == TFK004.MANDT
  • I_CAPAYMENTLOTITEM.CAAPPLICATIONAREA == TFK004.APPLK
Reconciliation Key for General Ledger
  • Reconciliation Key for General Ledger
  • Client
  • I_CAPAYMENTLOTITEM.CARECONCILIATIONKEY == DFKKSUMC.FIKEY
  • I_CAPAYMENTLOTITEM.MANDT == DFKKSUMC.MANDT
2. Selection Category
  • 2. Selection Category
  • Client
  • Application Area
  • I_CAPAYMENTLOTITEM.CASECONDSELECTIONCATEGORY == TFK004.SELTX
  • I_CAPAYMENTLOTITEM.MANDT == TFK004.MANDT
  • I_CAPAYMENTLOTITEM.CAAPPLICATIONAREA == TFK004.APPLK
3. Selection Category
  • Client
  • 3. Selection Category
  • Application Area
  • I_CAPAYMENTLOTITEM.MANDT == TFK004.MANDT
  • I_CAPAYMENTLOTITEM.CATHIRDSELECTIONCATEGORY == TFK004.SELTX
  • I_CAPAYMENTLOTITEM.CAAPPLICATIONAREA == TFK004.APPLK
Company Code
  • Company Code
  • Client
  • I_CAPAYMENTLOTITEM.COMPANYCODE == T001.BUKRS
  • I_CAPAYMENTLOTITEM.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • Transaction Currency
  • I_CAPAYMENTLOTITEM.MANDT == TCURC.MANDT
  • I_CAPAYMENTLOTITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CAPAYMENTLOTITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • I_CAPAYMENTLOTITEM.MANDT == TKA01.MANDT
  • I_CAPAYMENTLOTITEM.CONTROLLINGAREA == TKA01.KOKRS
Payment cards: Merchant ID at the clearing house
  • Payment cards: Merchant ID at the clearing house
  • Client
  • I_CAPAYMENTLOTITEM.MERCHANTBYCLEARINGHOUSE == TCCM.MERCH
  • I_CAPAYMENTLOTITEM.MANDT == TCCM.MANDT
Payment Card Type
  • Payment Card Type
  • Client
  • I_CAPAYMENTLOTITEM.PAYMENTCARDTYPE == TB033.CCINS
  • I_CAPAYMENTLOTITEM.MANDT == TB033.MANDT
Transaction Currency
  • Client
  • Company Code Currency
  • Transaction Currency
  • I_CAPAYMENTLOTITEM.MANDT == TCURC.MANDT
  • I_CAPAYMENTLOTITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CAPAYMENTLOTITEM.TRANSACTIONCURRENCY == TCURC.WAERS