C_BankPaymentBatch

Column Name Description
BatchUUID GUID to identify the batch
PaymentBatch Batch Identification Number
Column Name Description
💲 Batch Currency (BankPaymentBatchCurrency):
PaymentBatchAmountInCCCrcy Batch Amount in Batch Currency
MaxPaymentAmountInCCCrcy Maximum Payment Amount in Batch Currency
💲 Currency for Automatic Payment (PaymentCurrency):
PaidAmountInPaytCurrency Amount to be paid
💲 Rule Currency (PaymentBatchRuleCurrency):
TotalPaytBatchAmountInRuleCrcy Total Batch Amount in Rule Currency
MaxPaymentAmountInRuleCrcy Maximum Payment Amount in Rule Currency
Column Name Description
Column Name Description
PaymentRunDate Payment Run Date
PostingDate Posting Date of Payment Document
IncomingPaymentFileUploadDate Incoming Payment File Upload Date
CreationTime Creation Time
CreationDate Creation Date
LastChangeTime Change Time
LastChangeDate Last Change Date
PaidItemDueDate Due Date
Column Name Description
BankPaymentOrigin Payment System Show values
PaymentBatchHasAlert Payment Batch Alert Show values
PaymentBatchAdditionalInfo Additional Information for Payment Batch Show values
PaytBatchHasMoreReviewers More Approvers for Payment Batch Show values
PaymentBatchHasDraft Batch Has Draft Show values
PaymentBatchOrigin Identification of Batch Origin Show values
Column Name Description Domain name
NumberOfPaymentRunDates null
NumberOfPaymentRuns null
PaymentRunID Payment Run ID LAUFI
NumberOfPaymentDocuments null
PaymentDocument Document Number of the Payment Document BELNR
FiscalYear Fiscal Year GJAHR
NumberOfCompanyCodes null
PayingCompanyCode Paying Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
IncomingPaymentFile Incoming Payment File ID FARP_EFILEID
NumberOfPayments Number of Payments
PaymentBatchRuleDescription Description for Rule ID TEXT80
Status Object Status CRM_J_STATUS
PaymentBatchExternalStatus Payment Batch External Status
SystemStatusName Payment Batch Status Text TEXT30
NumberOfPaytIncomingStatuses null
BankPaytIncgStatusMessage Incoming Status Message
NumberOfHouseBanks null
HouseBank House Bank Key HBKID
BankName Name of Financial Institution TEXT60
BankInternalID Bank Control key at Our Bank BKONT
CurrentProcessor Current Processor USNAM
ProcessorUserName Full Name of Person TEXT80
CreatedByUser Created By User XUBNAME
CreatedByUserName Full Name of Person TEXT80
LastChangedByUser Changed By XUBNAME
LastChangedByUserName Full Name of Person TEXT80
PaymentBatchGrouping1 Grouping Field 1 CHAR30
PaymentBatchGrouping2 Grouping Field 2 CHAR30
NumberOfBankAccounts null
HouseBankAccount ID for Account Details HKTID
ApproverName Approver Name TEXT40
PaymentBatchUrgency null
NumberOfPaymentReferences null
PaymentMediumReference Reference Number TEXT16
NmbrOfSWIFTTransReference null
SWIFTTransactionReferenceUUID Unique Transaction Reference (UETR) SMUM_C36
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • C_BANKPAYMENTBATCH.MANDT == T005.MANDT
  • C_BANKPAYMENTBATCH.BANKCOUNTRY == T005.LAND1
Rule ID
  • Client
  • ?
  • Rule ID
  • C_BANKPAYMENTBATCH.MANDT == TBNK_RULE.MANDT
  • C_BANKPAYMENTBATCH.[column in domain "BNK_COM_RULE_PRIORITY"] == TBNK_RULE.PRIORITY
  • C_BANKPAYMENTBATCH.PAYMENTBATCHRULE == TBNK_RULE.RULE_ID
Rule Currency
  • Client
  • Rule Currency
  • C_BANKPAYMENTBATCH.MANDT == TCURC.MANDT
  • C_BANKPAYMENTBATCH.PAYMENTBATCHRULECURRENCY == TCURC.WAERS