C_BankPaymentBatchItem

Column Name Description
BatchUUID GUID to identify the batch
PaymentBatchItem Batch Item Number
Column Name Description
💲 Rule Currency (PaymentBatchRuleCurrency):
PaymentAmountInRuleCrcy Payment Amount in Rule Currency
💲 Payment Currency (PaymentCurrency):
PaidAmountInPaytCurrency Amount Paid in Foreign Currency
💲 Currency Key (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
PaymentRunDate Payment Run Date
PostingDate Posting Date of Payment Document
PaidItemDueDate Due Date
BillOfExchangeIssueDate Bill of Exchange Issue Date
BillOfExchangeDueDate Bill of Exchange Due Date
PaymentBatchMergeDate Payment Batch Merge Date
Column Name Description
PaytBatItmHasMoreIncgStatuses More Bank Payment Incoming Statuses for Payment Batch Item Show values
IsUrgentPayment Urgent Payment Show values
BankPaymentOrigin Payment System Show values
Column Name Description Domain name
PaymentBatch Batch Identification Number FARP_BNK_COM_BATCH_NO
PaymentDocument Document Number of the Payment Document BELNR
FiscalYear Fiscal Year GJAHR
Status Object Status CRM_J_STATUS
SystemStatusName Payment Batch Status Text TEXT30
BankPaytIncgStatusMessage Incoming Status Message
PaymentRunID Payment Run ID LAUFI
PayingCompanyCode Paying Company Code BUKRS
CompanyCodeName Paying Company Code Name TEXT25
PaymentMethodName Payment Method Name TEXT30
DataExchangeCostAllocation Cost Allocation Key NUMC02
Supplier Supplier LIFNR
SupplierName Supplier Name TEXT80
PayeeName Name of the payee TEXT35
PaymentRecipient Payment Recipient EMPFG
BankAccountLongID Bank Account Number BANKN35
BankName Name of Financial Institution TEXT60
BankInternalID Bank Key of Our Bank BANKK
HouseBankIBAN IBAN at Our House Bank IBAN
BankControlKey Bank Control key at Our Bank BKONT
SWIFTCode SWIFT/BIC for International Payments SWIFT
PaymentBatchItemExtEndToEnd End to End Identification (External) BNK_COM_END_TO_END_ID_EXT
PaymentBatchItemExternalStatus Payment Batch Item External Status
PayeeBank Payee Bank Number BANKL
PayeeBankAccountLongID Bank Account Number of The Payee BANKN
PayeeBankName Name of Payee Bank TEXT60
PayeeSWIFTCode Payee's SWIFT/BIC for International Payments SWIFT
PayeeIBAN IBAN of the Payee IBAN
PayeeBankControlKey Bank Control Key of the Payee's Bank BKONT
PayeeBankInternalID Payee Bank Key BANKK
DataExchangeInstructionKey Instruction Key for Data Medium Exchange DTAWS
DataExchangeInstrnAddlInfo Instruction Key Additional Information TEXT25
Customer Customer Number KUNNR
CustomerName Customer Name NAME
PaymentBatchMerge Batch Merge LAUFI
BankPaymentGroupingOrigin Payment Media Origin FIBL_ORIGIN
PaymentRequestPaymentGroup Grouping Field for Automatic Payments CHAR20
SWIFTTransactionReferenceUUID Unique Transaction Reference (UETR) SMUM_C36
PaymentStatusReasonByBank Payment Status Reason By Bank BNK_COM_RSN
PaymentStatusReasonByBankName Additional Payment Status Information by Bank
PaymentStatusReason Payment Status Reason BNK_COM_RSN
PaymentStatusReasonName Payment Status Reason Name BNK_COM_RSN_DESC
SupplierFinsAuthorizationGrp Authorization Group BRGRU
CustomerFinsAuthorizationGrp Authorization Group BRGRU
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • C_BANKPAYMENTBATCHITEM.MANDT == T005.MANDT
  • C_BANKPAYMENTBATCHITEM.BANKCOUNTRY == T005.LAND1
Currency Key
  • Client
  • Currency Key
  • Payment Currency
  • C_BANKPAYMENTBATCHITEM.MANDT == TCURC.MANDT
  • C_BANKPAYMENTBATCHITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_BANKPAYMENTBATCHITEM.PAYMENTCURRENCY == TCURC.WAERS
Customer Account Group
  • Customer Account Group
  • Client
  • C_BANKPAYMENTBATCHITEM.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_BANKPAYMENTBATCHITEM.MANDT == T077D.MANDT
House Bank Key
  • House Bank Key
  • Client
  • Paying Company Code
  • C_BANKPAYMENTBATCHITEM.HOUSEBANK == T012.HBKID
  • C_BANKPAYMENTBATCHITEM.MANDT == T012.MANDT
  • C_BANKPAYMENTBATCHITEM.PAYINGCOMPANYCODE == T012.BUKRS
ID for Account Details
  • House Bank Key
  • ID for Account Details
  • Client
  • Paying Company Code
  • C_BANKPAYMENTBATCHITEM.HOUSEBANK == T012K.HBKID
  • C_BANKPAYMENTBATCHITEM.HOUSEBANKACCOUNT == T012K.HKTID
  • C_BANKPAYMENTBATCHITEM.MANDT == T012K.MANDT
  • C_BANKPAYMENTBATCHITEM.PAYINGCOMPANYCODE == T012K.BUKRS
Payee Bank Country/Region
  • Payee Bank Country/Region
  • Client
  • C_BANKPAYMENTBATCHITEM.PAYEEBANKCOUNTRY == T005.LAND1
  • C_BANKPAYMENTBATCHITEM.MANDT == T005.MANDT
Rule Currency
  • Client
  • Rule Currency
  • C_BANKPAYMENTBATCHITEM.MANDT == TCURC.MANDT
  • C_BANKPAYMENTBATCHITEM.PAYMENTBATCHRULECURRENCY == TCURC.WAERS
Payment Currency
  • Client
  • Currency Key
  • Payment Currency
  • C_BANKPAYMENTBATCHITEM.MANDT == TCURC.MANDT
  • C_BANKPAYMENTBATCHITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_BANKPAYMENTBATCHITEM.PAYMENTCURRENCY == TCURC.WAERS
Payment Method for This Payment
  • Payment Method for This Payment
  • Client
  • ?
  • C_BANKPAYMENTBATCHITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • C_BANKPAYMENTBATCHITEM.MANDT == T042Z.MANDT
  • C_BANKPAYMENTBATCHITEM.[column in domain "LAND1"] == T042Z.LAND1
Vendor account group
  • Vendor account group
  • Client
  • C_BANKPAYMENTBATCHITEM.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • C_BANKPAYMENTBATCHITEM.MANDT == T077K.MANDT