C_AprvBkPaytExcludedPayment

ABP - Excluded Payments | view: CABPEXCLDPAYT | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
Column Name Description
PaymentBatch Batch Identification Number
PaymentBatchItem Batch Item Number
Column Name Description
💲 Rule Currency (PaymentBatchRuleCurrency):
PaymentAmountInRuleCrcy Payment Amount in Rule Currency
💲 Currency for Automatic Payment (PaymentCurrency):
PaidAmountInPaytCurrency Amount Paid in Foreign Currency
💲 Local Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Local Currency
Column Name Description
Column Name Description
PaidItemDueDate Due Date
PaymentRunDate Payment Run Date
PaymentBatchMergeDate Payment Batch Merge Date
BillOfExchangeDueDate Bill of Exchange Due Date
BillOfExchangeIssueDate Bill of Exchange Issue Date
PaymentDeferDate Defer Date
DueDate Due Date
Column Name Description
IsUrgentPayment Urgent Payment Show values
PaymentRunIsProposal Auto Payment Is Proposal Show values
PaymentOrigin Grouping Criterion for Payments Show values
BankPaymentOrigin Payment System Show values
Column Name Description Domain name
DataExchangeInstructionKey Instruction Key DTAWS
PaymentDocument Document Number of the Payment Document
NumberOfPaidItems Item Included PACK3
PaymentIsUrgentText 128 character
PayeeName Payee Name TEXT35
PayeeBankName Name of Payee Bank TEXT60
PayeeBank Payee Bank Number BANKL
SWIFTCode Swift Code SWIFT
PayeeBankAccount Bank Account Number of The Payee BANKN
PayeeBankAccountLongID Payee's Bank Account Number BANKN35
PayeeIBAN IBAN of the Payee IBAN
PaymentMethodName Payment Method Name TEXT30
PayingCompanyCode Paying Company Code BUKRS
PaymentRunID Payment Run ID LAUFI
PaymentBatchMerge Batch Merge LAUFI
PaymentRecipient Payment Recipient EMPFG
Status Object Status CRM_J_STATUS
SystemStatusShortName Status ID TEXT5
StatusName 128 character CHAR128
StatusProfile Status Profile J_STSMA
BankAccountLongID Bank Account Number BANKN35
HouseBankIBAN House Bank IBAN IBAN
BankName Name of Financial Institution TEXT60
SystemStatusName Object status TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
BankPaymentGroupingOrigin Origin of Grouping FIBL_ORIGIN
PayeeBankInternalID Payee Bank Key BANKK
Bank House Bank Number BANKL
PaymentRequestPaymentGroup Grouping Field for Automatic Payments CHAR20
PaymentAction Action for Processing Payment CHAR03
DataExchangeInstruction1 Instruction Key for Data Medium Exchange DTAWS
FiscalYear null
AuthorizationGroup Authorization Group BRGRU
CustomerAuthznGrp Authorization Group BRGRU
PaymentBatchItemExtEndToEnd End to End Identification (External) BNK_COM_END_TO_END_ID_EXT
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == T005.MANDT
  • C_APRVBKPAYTEXCLUDEDPAYMENT.BANKCOUNTRY == T005.LAND1
Local Currency
  • Client
  • Currency for Automatic Payment
  • Local Currency
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == TCURC.MANDT
  • C_APRVBKPAYTEXCLUDEDPAYMENT.PAYMENTCURRENCY == TCURC.WAERS
  • C_APRVBKPAYTEXCLUDEDPAYMENT.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == KNA1.MANDT
  • C_APRVBKPAYTEXCLUDEDPAYMENT.CUSTOMER == KNA1.KUNNR
Customer Account Group
  • Customer Account Group
  • Client
  • C_APRVBKPAYTEXCLUDEDPAYMENT.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == T077D.MANDT
House Bank Key
  • Paying Company Code
  • House Bank Key
  • Client
  • C_APRVBKPAYTEXCLUDEDPAYMENT.PAYINGCOMPANYCODE == T012.BUKRS
  • C_APRVBKPAYTEXCLUDEDPAYMENT.HOUSEBANK == T012.HBKID
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == T012.MANDT
ID for Account Details
  • Paying Company Code
  • House Bank Key
  • ID for Account Details
  • Client
  • C_APRVBKPAYTEXCLUDEDPAYMENT.PAYINGCOMPANYCODE == T012K.BUKRS
  • C_APRVBKPAYTEXCLUDEDPAYMENT.HOUSEBANK == T012K.HBKID
  • C_APRVBKPAYTEXCLUDEDPAYMENT.HOUSEBANKACCOUNT == T012K.HKTID
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == T012K.MANDT
Payee
  • Payee
  • Client
  • C_APRVBKPAYTEXCLUDEDPAYMENT.PAYEE == LFA1.LIFNR
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == LFA1.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == T005.MANDT
  • C_APRVBKPAYTEXCLUDEDPAYMENT.PAYEEBANKCOUNTRY == T005.LAND1
Rule Currency
  • Client
  • Rule Currency
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == TCURC.MANDT
  • C_APRVBKPAYTEXCLUDEDPAYMENT.PAYMENTBATCHRULECURRENCY == TCURC.WAERS
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • Local Currency
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == TCURC.MANDT
  • C_APRVBKPAYTEXCLUDEDPAYMENT.PAYMENTCURRENCY == TCURC.WAERS
  • C_APRVBKPAYTEXCLUDEDPAYMENT.COMPANYCODECURRENCY == TCURC.WAERS
Payment Method for This Payment
  • ?
  • Client
  • Payment Method for This Payment
  • C_APRVBKPAYTEXCLUDEDPAYMENT.[column in domain "LAND1"] == T042Z.LAND1
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == T042Z.MANDT
  • C_APRVBKPAYTEXCLUDEDPAYMENT.PAYMENTMETHOD == T042Z.ZLSCH
Vendor account group
  • Client
  • Vendor account group
  • C_APRVBKPAYTEXCLUDEDPAYMENT.MANDT == T077K.MANDT
  • C_APRVBKPAYTEXCLUDEDPAYMENT.SUPPLIERACCOUNTGROUP == T077K.KTOKK