I_PaymentRequestTP

Payment Request Draft | view: IPAYMENTREQTP | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
Tables used: PAYRQ, PAYRQC, BSEG, T001, TKA02, T015W, T001, T014, FINSC_FISC_DATE
Column Name Description
PaymentRequest Payment Request Key Number
Column Name Description
💲 Payment Request Currency Key (PaymentRequestCurrency):
PaymentRequestAmountInPaytCrcy Payment Request Amount in Payment Currency
💲 Local Currency (CompanyCodeCurrency):
PaymentRequestAmountInCCCrcy Payment Request Amount in Local Currency
💲 Currency Key of Second Local Currency (AdditionalCurrency1):
AmountInAdditionalCurrency1 Amount in Second Local Currency or Global Currency
💲 Currency Key of Third Local Currency (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Third Local Currency or First Freely-Def. Currency
Column Name Description
Column Name Description
AccountingDocumentCreationDate Accounting Document Entry Date
ClearingDate Clearing Date
ValueDate Value Date for the Sending Bank
ReleaseDate Release Date for Payment
PaymentRequestPostingDate Day on Which Payment Request Was Posted
LastChangeTime Change Time
LastChangeDate Last Change Date
CreationTime Creation Time
Column Name Description
FinancialAccountType Financial Account Type (Free Form Payments) Show values
IsSinglePayment Indicator: Individual Payment Show values
IsUrgentPayment Urgent Payment 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
PayeeName Payee Name TEXT80
BankDetailReference Reference Specifications for Bank Details CHAR20
PayeeBankControlKey Bank Control Key of the Payee's Bank BKONT
PayeeBank Payee Bank Number BANKL
PayeeBankAccount Bank Account Number of The Payee BANKN
BankAccountHolderName Account Holder Name BU_KOINH
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
ReferenceTypeText Reference Type Text TEXT50
PaymentReference Payment Reference CHAR30
CustomerSupplierAccount Account Number CHAR35
Customer Customer ID KUNNR
Supplier Account Number of Supplier LIFNR
DocumentItemText Item Text TEXT50
FinancialAccountTypeName Financial Account Type Name DDTEXT
AccountingDocument Journal Entry BELNR
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingFiscalYear Fiscal Year GJAHR
PaymentMethod List of Respected Payment Methods ZWELS
TaxID1 Tax Number 1 STCD1
BankChain ID for Bank Chain CHAINID
CustomerBankType Customer Bank Details ID BVTYP
SupplierBankType Supplier Bank Details ID BVTYP
LastChangedByUser Changed By XUBNAME
CreationDateTime Creation Date and Time TZNTSTMPL
LastChangeDateTime Change Date and Time TZNTSTMPL
PaymentRequestVariant Variant Name CHAR14
PaymentRepetitiveCode Repetitive Code RFTTRN_BF
FiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Currency Key of Second Local Currency
  • Currency Key of Second Local Currency
  • Client
  • I_PAYMENTREQUESTTP.ADDITIONALCURRENCY1 == TCURC.WAERS
  • I_PAYMENTREQUESTTP.MANDT == TCURC.MANDT
Currency Key of Third Local Currency
  • Currency Key of Third Local Currency
  • Client
  • I_PAYMENTREQUESTTP.ADDITIONALCURRENCY2 == TCURC.WAERS
  • I_PAYMENTREQUESTTP.MANDT == TCURC.MANDT
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • I_PAYMENTREQUESTTP.MANDT == T005.MANDT
  • I_PAYMENTREQUESTTP.BANKCOUNTRY == T005.LAND1
Bank Key of Our Bank
  • Client
  • Country/Region Key of Bank
  • Bank Key of Our Bank
  • I_PAYMENTREQUESTTP.MANDT == BNKA.MANDT
  • I_PAYMENTREQUESTTP.BANKCOUNTRY == BNKA.BANKS
  • I_PAYMENTREQUESTTP.BANKINTERNALID == BNKA.BANKL
Business Area
  • Business Area
  • Client
  • I_PAYMENTREQUESTTP.BUSINESSAREA == TGSB.GSBER
  • I_PAYMENTREQUESTTP.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_PAYMENTREQUESTTP.COMPANYCODE == T001.BUKRS
  • I_PAYMENTREQUESTTP.MANDT == T001.MANDT
Local Currency
  • Local Currency
  • Client
  • I_PAYMENTREQUESTTP.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYMENTREQUESTTP.MANDT == TCURC.MANDT
Created By User
  • Created By User
  • Client
  • I_PAYMENTREQUESTTP.CREATEDBYUSER == USR02.BNAME
  • I_PAYMENTREQUESTTP.MANDT == USR02.MANDT
Instruction Key 1
  • Instruction Key 1
  • ?
  • ?
  • I_PAYMENTREQUESTTP.DATAEXCHANGEINSTRUCTION1 == T015W1.DTWSX
  • I_PAYMENTREQUESTTP.[column in domain "DTWSF"] == T015W1.DTWSF
  • I_PAYMENTREQUESTTP.[column in domain "DTWSC"] == T015W1.DTWSC
Instruction Key 2
  • Instruction Key 2
  • ?
  • ?
  • I_PAYMENTREQUESTTP.DATAEXCHANGEINSTRUCTION2 == T015W1.DTWSX
  • I_PAYMENTREQUESTTP.[column in domain "DTWSF"] == T015W1.DTWSF
  • I_PAYMENTREQUESTTP.[column in domain "DTWSC"] == T015W1.DTWSC
Instruction Key 3
  • ?
  • ?
  • Instruction Key 3
  • I_PAYMENTREQUESTTP.[column in domain "DTWSF"] == T015W1.DTWSF
  • I_PAYMENTREQUESTTP.[column in domain "DTWSC"] == T015W1.DTWSC
  • I_PAYMENTREQUESTTP.DATAEXCHANGEINSTRUCTION3 == T015W1.DTWSX
Instruction Key 4
  • Instruction Key 4
  • ?
  • ?
  • I_PAYMENTREQUESTTP.DATAEXCHANGEINSTRUCTION4 == T015W1.DTWSX
  • I_PAYMENTREQUESTTP.[column in domain "DTWSF"] == T015W1.DTWSF
  • I_PAYMENTREQUESTTP.[column in domain "DTWSC"] == T015W1.DTWSC
Instruction key for data medium exchange
  • Instruction key for data medium exchange
  • ?
  • Client
  • Country/Region Key of Bank
  • I_PAYMENTREQUESTTP.DATAEXCHANGEINSTRUCTIONKEY == T015W.DTAWS
  • I_PAYMENTREQUESTTP.[column in domain "DZLSCH"] == T015W.ZLSCH
  • I_PAYMENTREQUESTTP.MANDT == T015W.MANDT
  • I_PAYMENTREQUESTTP.BANKCOUNTRY == T015W.BANKS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_PAYMENTREQUESTTP.FISCALYEARVARIANT == T009.PERIV
  • I_PAYMENTREQUESTTP.MANDT == T009.MANDT
General Ledger Account
  • General Ledger Account
  • ?
  • Client
  • I_PAYMENTREQUESTTP.GLACCOUNT == SKA1.SAKNR
  • I_PAYMENTREQUESTTP.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_PAYMENTREQUESTTP.MANDT == SKA1.MANDT
House Bank Key
  • House Bank Key
  • Paying Company Code
  • Client
  • I_PAYMENTREQUESTTP.HOUSEBANK == T012.HBKID
  • I_PAYMENTREQUESTTP.PAYINGCOMPANYCODE == T012.BUKRS
  • I_PAYMENTREQUESTTP.MANDT == T012.MANDT
ID for Account Details
  • House Bank Key
  • Paying Company Code
  • ID for Account Details
  • Client
  • I_PAYMENTREQUESTTP.HOUSEBANK == T012K.HBKID
  • I_PAYMENTREQUESTTP.PAYINGCOMPANYCODE == T012K.BUKRS
  • I_PAYMENTREQUESTTP.HOUSEBANKACCOUNT == T012K.HKTID
  • I_PAYMENTREQUESTTP.MANDT == T012K.MANDT
Payee Bank Country/Region
  • Client
  • Payee Bank Country/Region
  • I_PAYMENTREQUESTTP.MANDT == T005.MANDT
  • I_PAYMENTREQUESTTP.PAYEEBANKCOUNTRY == T005.LAND1
Payee Bank Key
  • Payee Bank Key
  • Client
  • Payee Bank Country/Region
  • I_PAYMENTREQUESTTP.PAYEEBANKINTERNALID == BNKA.BANKL
  • I_PAYMENTREQUESTTP.MANDT == BNKA.MANDT
  • I_PAYMENTREQUESTTP.PAYEEBANKCOUNTRY == BNKA.BANKS
Payee Country/Region Key
  • Payee Country/Region Key
  • Client
  • I_PAYMENTREQUESTTP.PAYEECOUNTRY == T005.LAND1
  • I_PAYMENTREQUESTTP.MANDT == T005.MANDT
Payee Language Key I_PAYMENTREQUESTTP.PAYEELANGUAGE == T002.SPRAS
Regional Code of the Payee
  • Payee Country/Region Key
  • Regional Code of the Payee
  • Client
  • I_PAYMENTREQUESTTP.PAYEECOUNTRY == T005S.LAND1
  • I_PAYMENTREQUESTTP.PAYEEREGION == T005S.BLAND
  • I_PAYMENTREQUESTTP.MANDT == T005S.MANDT
Paying Company Code
  • Paying Company Code
  • Client
  • I_PAYMENTREQUESTTP.PAYINGCOMPANYCODE == T001.BUKRS
  • I_PAYMENTREQUESTTP.MANDT == T001.MANDT
Payment Method Supplement
  • Payment Method Supplement
  • Client
  • I_PAYMENTREQUESTTP.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
  • I_PAYMENTREQUESTTP.MANDT == T042F.MANDT
Payment Request Currency Key
  • Client
  • Payment Request Currency Key
  • I_PAYMENTREQUESTTP.MANDT == TCURC.MANDT
  • I_PAYMENTREQUESTTP.PAYMENTREQUESTCURRENCY == TCURC.WAERS
Origin Indicator
  • Origin Indicator
  • Payment Request Type
  • I_PAYMENTREQUESTTP.PAYMENTREQUESTORIGIN == TFIBLORIGIN.ORIGIN
  • I_PAYMENTREQUESTTP.PAYMENTREQUESTTYPE == TFIBLORIGIN.ORIGIN
Payment Request Type
  • Origin Indicator
  • Payment Request Type
  • I_PAYMENTREQUESTTP.PAYMENTREQUESTORIGIN == TFIBLORIGIN.ORIGIN
  • I_PAYMENTREQUESTTP.PAYMENTREQUESTTYPE == TFIBLORIGIN.ORIGIN
User Who Carried Out the Posting
  • User Who Carried Out the Posting
  • Client
  • I_PAYMENTREQUESTTP.POSTINGCREATEDBYUSER == USR02.BNAME
  • I_PAYMENTREQUESTTP.MANDT == USR02.MANDT
User Who Carried Out the Release
  • User Who Carried Out the Release
  • Client
  • I_PAYMENTREQUESTTP.RELEASEDBYUSER == USR02.BNAME
  • I_PAYMENTREQUESTTP.MANDT == USR02.MANDT
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • I_PAYMENTREQUESTTP.MANDT == T041C.MANDT
  • I_PAYMENTREQUESTTP.REVERSALREASON == T041C.STGRD
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • I_PAYMENTREQUESTTP.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • I_PAYMENTREQUESTTP.MANDT == T015L.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • I_PAYMENTREQUESTTP.SUPPLYINGCOUNTRY == T005.LAND1
  • I_PAYMENTREQUESTTP.MANDT == T005.MANDT