I_CAPaymentRunHeader

Payment Run Header Data | view: ICAPAYTRUNHEADER | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DPAYH
Column Name Description
CAMassRunDate Date ID
CAMassRunID Run ID
CAIntPaymentIdentification Sequential payment number
CAIntAddlPaymentIdentification Additional distinguishing criterion from payments
Column Name Description
PaytAmountInCoCodeCurrency Amount in Local Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
CAWhldgTaxForCreditsInLoclCrcy Withholding Tax In Local Currency (Credit-Side)
CAWhldgTaxForDebitsInLoclCrcy Withholding Tax In Local Currency (Debit-Side)
💲 Transaction Currency (TransactionCurrency):
PaidAmountInPaytCurrency Amount Paid in Foreign Currency
CashDiscountAmtInTransacCrcy Cash Discount Amount
CADifferenceAmountInClrgProcg Difference Amount in Clearing Processing
CAWhldgTaxForCreditsInPaytCrcy Withholding Tax In Payment Currency (Credit-Side)
CAWhldgTaxForDebitsInPaytCrcy Withholding Tax In Payment Currency (Debit-Side)
Column Name Description
Column Name Description
CAMassRunDate Date ID
PaymentDocumentPostingDate Posting Date of Payment Document
PaidItemDueDate Due date of the paid items
ValueDate Value date
CAPromisedPaymentDate Payment Date Promised
Column Name Description
CAInternalPaymentGroup Grouping criterium for payments Show values
CAPaymentAdviceIsCreated Output payment advice Show values
CAPaymentDocumentType Payment document category Show values
DataMediumExchangeIndicator Report key for data medium exchange Show values
CAOriginOfBPBankData Payment Program: Origin of Business Partner Bank Data Show values
EncryptionType Type of Encryption Show values
SEPAPaymentType SEPA: Payment Type Show values
SEPASequenceType SEPA: Sequence Type Show values
SEPAMandateIsB2BMandate SEPA-Mandate: B2B Mandate Show values
DirectDebitType Local Instrument Code Show values
PaymentAdvicePrintingReason Reason for Printing Payment Advice Show values
Column Name Description Domain name
CAPaymentCompanyCode Company Code for Automatic Payment Transactions BUKRS
CACompanyCodeOfPaidItem Company Code BUKRS
BusinessPartner Business Partner Number BU_PARTNER
ContractAccount Contract Account VKONT_KK
CAPaymentDocumentReference Reference to Payment Document CHAR24
CADocumentNumber Document OPBEL_KK
CAPaymentOrder Payment Order PYORD
CASEPAPreNotificationNumber SEPA: Number of Direct Debit Pre-Notification PNNUM_KK
BankInternalID Bank Internal Identification BANKK
BankNumber House Bank Number BANKL
BankAccount Bank Account Number BANKN
BankControlKey Bank Control Key BKONT
PayeeBank Payee Bank Number BANKK
PayeeBankNumber Bank number of the payee's bank BANKL
PayeeBankAccount Payee's Bank Account Number BANKN
PayeeBankControlKey Bank Control Key of the Payee's Bank BKONT
PayeeIBAN IBAN (International Bank Account Number) IBAN
BankAccountReferenceText Reference Details for Bank Details CHAR20
CABankAccountHolderName Account Holder KOINH
LastName Last name TEXT40
FirstName First name TEXT40
CityName City TEXT40
District District TEXT40
POBoxDeviatingCityName PO Box city TEXT40
AddressPostalCode City postal code CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
PayeePOBox P.O. box of the payee PFACH
AddressStreetName Street TEXT60
AddressHouseNumber House Number TEXT10
ShipToPtyHouseNmbrSuplmntText House number supplement TEXT10
AddressPhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
AddressFaxNumber Fax number: dialling code+number CHAR30
FaxNumberExtension Fax no.: Extension CHAR10
SWIFTCode SWIFT/BIC for International Payments SWIFT
NumberOfPaidItems Item Included PACK3
NumberOfTextLines Number of Text Lines for Items Paid PACK3
CAGroupingForPayment Grouping field for automatic payments CHAR10
CAInternalGroupingForPayment Generated grouping field in payments CHAR50
CAHouseBankReference Own Bank Details EIGBV_KK
CardNumber Payment cards: Card number CCNUM
CAPaymentSpecification Number of Payment Specification PDKEY_KK
CAPaymentSpecificationRef Reference Number of Payment Specification PDREF_KK
CAPromiseToPay Identification of Promise to Pay PPKEY_KK
SEPAMandateUUID SEPA Mandate: GUID of Mandate
PaymentCardUUID GUID of a Payment Card SYSUUID
SEPAMandate Unique Reference to Mandate for each Payee ID035
Master Data Relations Join Conditions
Address Number
  • Client
  • Address Number
  • ?
  • ?
  • I_CAPAYMENTRUNHEADER.MANDT == ADRC.CLIENT
  • I_CAPAYMENTRUNHEADER.ADDRESSID == ADRC.ADDRNUMBER
  • I_CAPAYMENTRUNHEADER.[column in domain "AD_NATION"] == ADRC.NATION
  • I_CAPAYMENTRUNHEADER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • I_CAPAYMENTRUNHEADER.MANDT == T005.MANDT
  • I_CAPAYMENTRUNHEADER.BANKCOUNTRY == T005.LAND1
Business area in payment document
  • Client
  • Business area in payment document
  • I_CAPAYMENTRUNHEADER.MANDT == TGSB.MANDT
  • I_CAPAYMENTRUNHEADER.CABUSINESSAREAINPAYMENTDOC == TGSB.GSBER
Payment Method
  • Client
  • Payment Method
  • ?
  • I_CAPAYMENTRUNHEADER.MANDT == TFK042Z.MANDT
  • I_CAPAYMENTRUNHEADER.CAPAYMENTMETHOD == TFK042Z.ZLSCH
  • I_CAPAYMENTRUNHEADER.[column in domain "LAND1"] == TFK042Z.LAND1
Data Exchange Instruction
  • Client
  • Payment Method
  • Country/Region Key
  • Data Exchange Instruction
  • I_CAPAYMENTRUNHEADER.MANDT == TFK015W.MANDT
  • I_CAPAYMENTRUNHEADER.CAPAYMENTMETHOD == TFK015W.ZLSCH
  • I_CAPAYMENTRUNHEADER.PAYEECOUNTRY == TFK015W.LAND1
  • I_CAPAYMENTRUNHEADER.DATAEXCHANGEINSTRUCTIONKEY == TFK015W.DTAWS
G/L Account Number for Our Bank Account / Bank Subaccount
  • Client
  • ?
  • G/L Account Number for Our Bank Account / Bank Subaccount
  • I_CAPAYMENTRUNHEADER.MANDT == SKA1.MANDT
  • I_CAPAYMENTRUNHEADER.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_CAPAYMENTRUNHEADER.GLACCOUNTFORBANKACCOUNT == SKA1.SAKNR
House Bank Key
  • Client
  • ?
  • House Bank Key
  • I_CAPAYMENTRUNHEADER.MANDT == T012.MANDT
  • I_CAPAYMENTRUNHEADER.[column in domain "BUKRS"] == T012.BUKRS
  • I_CAPAYMENTRUNHEADER.HOUSEBANK == T012.HBKID
House Bank Account
  • Client
  • ?
  • House Bank Key
  • House Bank Account
  • I_CAPAYMENTRUNHEADER.MANDT == T012K.MANDT
  • I_CAPAYMENTRUNHEADER.[column in domain "BUKRS"] == T012K.BUKRS
  • I_CAPAYMENTRUNHEADER.HOUSEBANK == T012K.HBKID
  • I_CAPAYMENTRUNHEADER.HOUSEBANKACCOUNT == T012K.HKTID
Payee Bank Country/Region
  • Client
  • Payee Bank Country/Region
  • I_CAPAYMENTRUNHEADER.MANDT == T005.MANDT
  • I_CAPAYMENTRUNHEADER.PAYEEBANKCOUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • I_CAPAYMENTRUNHEADER.MANDT == T005.MANDT
  • I_CAPAYMENTRUNHEADER.PAYEECOUNTRY == T005.LAND1
Key of Payee's Language I_CAPAYMENTRUNHEADER.PAYEELANGUAGE == T002.SPRAS
Payment Card Type
  • Client
  • Payment Card Type
  • I_CAPAYMENTRUNHEADER.MANDT == TB033.MANDT
  • I_CAPAYMENTRUNHEADER.PAYMENTCARDTYPE == TB033.CCINS
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_CAPAYMENTRUNHEADER.MANDT == T005S.MANDT
  • I_CAPAYMENTRUNHEADER.PAYEECOUNTRY == T005S.LAND1
  • I_CAPAYMENTRUNHEADER.REGION == T005S.BLAND
Transaction Currency
  • Client
  • Transaction Currency
  • I_CAPAYMENTRUNHEADER.MANDT == TCURC.MANDT
  • I_CAPAYMENTRUNHEADER.TRANSACTIONCURRENCY == TCURC.WAERS