I_MakeBkTransfWithFilter

Items of Track Bank Transfer | view: IMBKTWITHFILTER | Extraction: Not supported | Component: Fiori UI for Cash and Liquidity Management
Tables used: PAYRQ, PAYRQP, FIBL_RPCODE, T001, T042Z
Column Name Description
PaymentRequest Payment Request Key Number
Column Name Description
💲 Currency (PaymentRequestCurrency):
PaymentRequestAmountInPaytCrcy Payment Request Amount in Payment Currency
💲 Local Currency (CompanyCodeCurrency):
PaymentRequestAmountInCCCrcy Payment Request Amount in Local Currency
Column Name Description
Column Name Description
PayeeBankValueDate Value Date at Payee's Bank
ValueDate Value Date for the Sending Bank
PaymentRequestPostingDate Day on Which Payment Request Was Posted
AccountingDocumentCreationDate Accounting Document Entry Date
CreationTime Creation Time
ClearingDate Clearing Date
Column Name Description
IsSinglePayment Indicator: Individual Payment Show values
FinancialAccountType Account Type Show values
PaytReqIsReleasedForPosting Indicator: Released for Posting Show values
PaytReqIsCompleted Indicator: Complete Show values
PaytReqIsReleasedForPayment Indicator: Released for Payment Show values
IsReversed Indicator: Payment Request Is Reversed Show values
StatusCode Status of Payment Request Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
AccountingDocumentItem Journal Entry Posting View Item BUZEI
PayeeName Payee Name TEXT35
PayeeBankControlKey Bank Control Key of the Payee's Bank BKONT
PayeeBank Payee Bank Number BANKL
PayeeHouseBank House Bank Account HKTID
PayeeHouseBankAccount House Bank Account ID HKTID
PayeeCompanyCode null
BankDetailReference Reference Specifications for Bank Details CHAR20
BankAccountHolderName Account Holder Name BU_KOINH
ReferenceTypeText Reference Type Text TEXT50
PaymentMethod List of Respected Payment Methods ZWELS
PaymentReference Payment Reference CHAR30
TaxID1 Tax Number 1 STCD1
ClearingAccountingDocument Clearing Journal Entry BELNR
BPBankAccountInternalID Customer Bank Details ID BVTYP
PayeeTitle Title of the payee TEXT15
PayeePostalCode Postal Code of the Payee PSTLZ
PayeePOBox P.O. box of the payee PFACH
POBoxPostalCode P.O. Box Postal Code PSTLZ
PayeeAdditionalName2 Additional Name of the Payee 2 TEXT35
PayeeAdditionalName3 Additional Name of the Payee 3 TEXT35
PayeeAdditionalName4 Additional Name of the Payee 4 TEXT35
PayeeCityName Payee City Name TEXT35
PayeeStreet Payee's Street TEXT35
PayeeFaxNumber Fax Number of the Payee TEXT31
PayeeTelephoneNumber Telephone Number of the Payee TEXT16
PayeeIBAN IBAN of the Payee IBAN
RepetitiveCode Payment code RFTTRN_BF
LogHandle Application Log Handle
PaymentMethodName Name of Payment Method in Language of the Country/Region TEXT30
PayingCompanyCodeName Name of Company Code or Company TEXT25
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T005.MANDT
  • I_MAKEBKTRANSFWITHFILTER.BANKCOUNTRY == T005.LAND1
Bank Key of Our Bank
  • Client
  • Bank Key of Our Bank
  • Country/Region Key of Bank
  • I_MAKEBKTRANSFWITHFILTER.MANDT == BNKA.MANDT
  • I_MAKEBKTRANSFWITHFILTER.BANKINTERNALID == BNKA.BANKL
  • I_MAKEBKTRANSFWITHFILTER.BANKCOUNTRY == BNKA.BANKS
Business Area
  • Business Area
  • Client
  • I_MAKEBKTRANSFWITHFILTER.BUSINESSAREA == TGSB.GSBER
  • I_MAKEBKTRANSFWITHFILTER.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_MAKEBKTRANSFWITHFILTER.COMPANYCODE == T001.BUKRS
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T001.MANDT
Local Currency
  • Local Currency
  • Client
  • I_MAKEBKTRANSFWITHFILTER.COMPANYCODECURRENCY == TCURC.WAERS
  • I_MAKEBKTRANSFWITHFILTER.MANDT == TCURC.MANDT
Created By User
  • Created By User
  • Client
  • I_MAKEBKTRANSFWITHFILTER.CREATEDBYUSER == USR02.BNAME
  • I_MAKEBKTRANSFWITHFILTER.MANDT == USR02.MANDT
Numeric, 2-digit value
  • ?
  • ?
  • Numeric, 2-digit value
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "DTWSF"] == T015W1.DTWSF
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "DTWSC"] == T015W1.DTWSC
  • I_MAKEBKTRANSFWITHFILTER.DATAEXCHANGEINSTRUCTION1 == T015W1.DTWSX
Numeric, 2-digit value
  • ?
  • ?
  • Numeric, 2-digit value
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "DTWSF"] == T015W1.DTWSF
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "DTWSC"] == T015W1.DTWSC
  • I_MAKEBKTRANSFWITHFILTER.DATAEXCHANGEINSTRUCTION2 == T015W1.DTWSX
Numeric, 2-digit value
  • Numeric, 2-digit value
  • ?
  • ?
  • I_MAKEBKTRANSFWITHFILTER.DATAEXCHANGEINSTRUCTION3 == T015W1.DTWSX
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "DTWSF"] == T015W1.DTWSF
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "DTWSC"] == T015W1.DTWSC
Numeric, 2-digit value
  • ?
  • ?
  • Numeric, 2-digit value
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "DTWSF"] == T015W1.DTWSF
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "DTWSC"] == T015W1.DTWSC
  • I_MAKEBKTRANSFWITHFILTER.DATAEXCHANGEINSTRUCTION4 == T015W1.DTWSX
Instruction key for data medium exchange
  • ?
  • Client
  • Country/Region Key of Bank
  • Instruction key for data medium exchange
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "DZLSCH"] == T015W.ZLSCH
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T015W.MANDT
  • I_MAKEBKTRANSFWITHFILTER.BANKCOUNTRY == T015W.BANKS
  • I_MAKEBKTRANSFWITHFILTER.DATAEXCHANGEINSTRUCTIONKEY == T015W.DTAWS
General Ledger Account
  • ?
  • General Ledger Account
  • Client
  • I_MAKEBKTRANSFWITHFILTER.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_MAKEBKTRANSFWITHFILTER.GLACCOUNT == SKA1.SAKNR
  • I_MAKEBKTRANSFWITHFILTER.MANDT == SKA1.MANDT
House Bank Key
  • House Bank Key
  • Client
  • Paying Company Code
  • I_MAKEBKTRANSFWITHFILTER.HOUSEBANK == T012.HBKID
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T012.MANDT
  • I_MAKEBKTRANSFWITHFILTER.PAYINGCOMPANYCODE == T012.BUKRS
ID for Account Details
  • House Bank Key
  • Client
  • ID for Account Details
  • Paying Company Code
  • I_MAKEBKTRANSFWITHFILTER.HOUSEBANK == T012K.HBKID
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T012K.MANDT
  • I_MAKEBKTRANSFWITHFILTER.HOUSEBANKACCOUNT == T012K.HKTID
  • I_MAKEBKTRANSFWITHFILTER.PAYINGCOMPANYCODE == T012K.BUKRS
Payee Bank Country/Region
  • Payee Bank Country/Region
  • Client
  • I_MAKEBKTRANSFWITHFILTER.PAYEEBANKCOUNTRY == T005.LAND1
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T005.MANDT
Payee Bank Key
  • Payee Bank Country/Region
  • Payee Bank Key
  • Client
  • I_MAKEBKTRANSFWITHFILTER.PAYEEBANKCOUNTRY == BNKA.BANKS
  • I_MAKEBKTRANSFWITHFILTER.PAYEEBANKINTERNALID == BNKA.BANKL
  • I_MAKEBKTRANSFWITHFILTER.MANDT == BNKA.MANDT
Payee Country/Region Key
  • Client
  • Payee Country/Region Key
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T005.MANDT
  • I_MAKEBKTRANSFWITHFILTER.PAYEECOUNTRY == T005.LAND1
Payee Language Key I_MAKEBKTRANSFWITHFILTER.PAYEELANGUAGE == T002.SPRAS
Regional Code of the Payee
  • Regional Code of the Payee
  • Client
  • Payee Country/Region Key
  • I_MAKEBKTRANSFWITHFILTER.PAYEEREGION == T005S.BLAND
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T005S.MANDT
  • I_MAKEBKTRANSFWITHFILTER.PAYEECOUNTRY == T005S.LAND1
Paying Company Code
  • Client
  • Paying Company Code
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T001.MANDT
  • I_MAKEBKTRANSFWITHFILTER.PAYINGCOMPANYCODE == T001.BUKRS
Payment method supplement
  • Payment method supplement
  • Client
  • I_MAKEBKTRANSFWITHFILTER.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T042F.MANDT
Currency
  • Currency
  • Client
  • I_MAKEBKTRANSFWITHFILTER.PAYMENTREQUESTCURRENCY == TCURC.WAERS
  • I_MAKEBKTRANSFWITHFILTER.MANDT == TCURC.MANDT
Origin Indicator I_MAKEBKTRANSFWITHFILTER.PAYMENTREQUESTORIGIN == TFIBLORIGIN.ORIGIN
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T041C.MANDT
  • I_MAKEBKTRANSFWITHFILTER.REVERSALREASON == T041C.STGRD
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • I_MAKEBKTRANSFWITHFILTER.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T015L.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T005.MANDT
  • I_MAKEBKTRANSFWITHFILTER.SUPPLIERCOUNTRY == T005.LAND1
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • I_MAKEBKTRANSFWITHFILTER.MANDT == T005.MANDT
  • I_MAKEBKTRANSFWITHFILTER.SUPPLYINGCOUNTRY == T005.LAND1