I_CAPaymentRunItem

Item Data of Payment Program | view: ICAPAYTRUNITEM | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DPAYP
Column Name Description
CAMassRunDate Date ID
CAMassRunID Run ID
CAIntPaymentIdentification Sequential payment number
CAIntAddlPaymentIdentification Additional distinguishing criterion from payments
CADocumentNumberWithItem null
CARepaymentRequest Repayment Request
CAPaymentOrder Payment Order
CASEPAPreNotificationNumber SEPA: Number of Direct Debit Pre-Notification
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CAAmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
CAClearingAmountInTransCrcy Clearing Amount in Transaction Currency (With +/- Sign)
CACashDiscountInTransCurrency Proportional Cash Discount in Transaction Currency
CATaxPortionInTransCurrency Tax Amount as Statistical Information in Document Currency
CAWhldgTaxAmountInTransCrcy Proportional Withholding Tax Amount In Transaction Currency
CAClearingAmountInLocalCrcy Clearing amount in local currency with +/- sign
CACashDiscountInLocalCurrency Proportional cash discount in local currency
CAWhldgTaxAmountInLocalCrcy Proportional Withholding Tax Amount In Local Currency
Column Name Description
Column Name Description
CAMassRunDate Date ID
DocumentDate Journal Entry Date
CAPostingDate Posting Date in the Document
PaidItemDueDate Due Date
Column Name Description
CASubApplication Subapplication in Contract Accounts Receivable and Payable Show values
CAStatisticalItemCode Type of statistical item Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
CABusinessPartnerReference Reference to Business Partner Giving Payment Instruction CHAR12
ContractAccount Contract Account VKONT_KK
ContractAccountReference Reference to Contract Account CHAR18
CAContract Reference Specifications from Contract VTREF_KK
CAProviderContractItemNumber Contract: Item Number VTPOS_KK
CAAdditionalContract Additional Reference Information VTREF_KK
CAMainTransaction Main Transaction for Line Item HVORG_KK
CASubTransaction Subtransaction for Document Item TVORG_KK
PayeeName Name 1 TEXT40
CityName City TEXT40
CAAcceptedCashDiscountRate Accepted cash discount rate PRZ23
CompanyCode Company Code BUKRS
BusinessArea Business Area GSBER
CAWorkflowCheckReason Check Reason for Workflows Acc. to Dual Control Principle C4EYE_KK
DocumentItemText Item Text TEXT50
CAReferenceDocument Reference document number XBLNR_KK
WithholdingTaxCode Withholding Tax Code QSSKZ
Master Data Relations Join Conditions
Address Number
  • Address Number
  • Client
  • ?
  • ?
  • I_CAPAYMENTRUNITEM.ADDRESSID == ADRC.ADDRNUMBER
  • I_CAPAYMENTRUNITEM.MANDT == ADRC.CLIENT
  • I_CAPAYMENTRUNITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • I_CAPAYMENTRUNITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Clearing Lock Reason
  • Client
  • Clearing Lock Reason
  • I_CAPAYMENTRUNITEM.MANDT == TFK000S.MANDT
  • I_CAPAYMENTRUNITEM.CACLEARINGLOCKREASON == TFK000S.SPPOS
Item indicator in payment program I_CAPAYMENTRUNITEM.CAPAYMENTEXCEPTIONREASON == TFKPK.POKEN
Lock Reason for Automatic Payment
  • Client
  • Lock Reason for Automatic Payment
  • I_CAPAYMENTRUNITEM.MANDT == TFK008.MANDT
  • I_CAPAYMENTRUNITEM.CAPAYMENTLOCKREASON == TFK008.ZAHLS
Country/Region Key
  • Country/Region Key
  • Client
  • I_CAPAYMENTRUNITEM.PAYEECOUNTRY == T005.LAND1
  • I_CAPAYMENTRUNITEM.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_CAPAYMENTRUNITEM.PAYEECOUNTRY == T005S.LAND1
  • I_CAPAYMENTRUNITEM.MANDT == T005S.MANDT
  • I_CAPAYMENTRUNITEM.REGION == T005S.BLAND
State Central Bank Indicator
  • Client
  • State Central Bank Indicator
  • I_CAPAYMENTRUNITEM.MANDT == T015L.MANDT
  • I_CAPAYMENTRUNITEM.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
Transaction Currency
  • Client
  • Transaction Currency
  • I_CAPAYMENTRUNITEM.MANDT == TCURC.MANDT
  • I_CAPAYMENTRUNITEM.TRANSACTIONCURRENCY == TCURC.WAERS