I_PaymentRequest

Payment Requests | view: IPAYMENTREQUEST | Extraction: Not supported | Component: Direct Bank Communication

Tables used: PAYRQ

🔑 Keys (1)
💰 Amounts (4)
∑ Quantities
📅 Dates (7)
☰ Categorical (7)
Other (28)
🔗 Relations (31)

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
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
ReleaseDate	Release Date for Payment

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	TEXT80
PayeeBankControlKey	Bank Control Key of the Payee's Bank	BKONT
PayeeBank	Payee Bank Number	BANKL
PayeeBankAccount	Bank Account Number of The Payee	BANKN
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
PaymentRepetitiveCode	Repetitive Code	RFTTRN_BF

Master Data Relations	Join Conditions
Currency Key of Second Local Currency Currency Key of Second Local Currency Client	`I_PAYMENTREQUEST.ADDITIONALCURRENCY1 == TCURC.WAERS` `I_PAYMENTREQUEST.MANDT == TCURC.MANDT`
Currency Key of Third Local Currency Client Currency Key of Third Local Currency	`I_PAYMENTREQUEST.MANDT == TCURC.MANDT` `I_PAYMENTREQUEST.ADDITIONALCURRENCY2 == TCURC.WAERS`
Country/Region Key of Bank Client Country/Region Key of Bank	`I_PAYMENTREQUEST.MANDT == T005.MANDT` `I_PAYMENTREQUEST.BANKCOUNTRY == T005.LAND1`
Bank Key of Our Bank Client Country/Region Key of Bank Bank Key of Our Bank	`I_PAYMENTREQUEST.MANDT == BNKA.MANDT` `I_PAYMENTREQUEST.BANKCOUNTRY == BNKA.BANKS` `I_PAYMENTREQUEST.BANKINTERNALID == BNKA.BANKL`
Business Area Client Business Area	`I_PAYMENTREQUEST.MANDT == TGSB.MANDT` `I_PAYMENTREQUEST.BUSINESSAREA == TGSB.GSBER`
Company Code Company Code Client	`I_PAYMENTREQUEST.COMPANYCODE == T001.BUKRS` `I_PAYMENTREQUEST.MANDT == T001.MANDT`
Local Currency Client Local Currency	`I_PAYMENTREQUEST.MANDT == TCURC.MANDT` `I_PAYMENTREQUEST.COMPANYCODECURRENCY == TCURC.WAERS`
Created By User Client Created By User	`I_PAYMENTREQUEST.MANDT == USR02.MANDT` `I_PAYMENTREQUEST.CREATEDBYUSER == USR02.BNAME`
Instruction Key 1 ? ? Instruction Key 1	`I_PAYMENTREQUEST.[column in domain "DTWSF"] == T015W1.DTWSF` `I_PAYMENTREQUEST.[column in domain "DTWSC"] == T015W1.DTWSC` `I_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTION1 == T015W1.DTWSX`
Instruction Key 2 ? ? Instruction Key 2	`I_PAYMENTREQUEST.[column in domain "DTWSF"] == T015W1.DTWSF` `I_PAYMENTREQUEST.[column in domain "DTWSC"] == T015W1.DTWSC` `I_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTION2 == T015W1.DTWSX`
Instruction Key 3 ? ? Instruction Key 3	`I_PAYMENTREQUEST.[column in domain "DTWSF"] == T015W1.DTWSF` `I_PAYMENTREQUEST.[column in domain "DTWSC"] == T015W1.DTWSC` `I_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTION3 == T015W1.DTWSX`
Instruction Key 4 ? ? Instruction Key 4	`I_PAYMENTREQUEST.[column in domain "DTWSF"] == T015W1.DTWSF` `I_PAYMENTREQUEST.[column in domain "DTWSC"] == T015W1.DTWSC` `I_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTION4 == T015W1.DTWSX`
Instruction key for data medium exchange ? Client Country/Region Key of Bank Instruction key for data medium exchange	`I_PAYMENTREQUEST.[column in domain "DZLSCH"] == T015W.ZLSCH` `I_PAYMENTREQUEST.MANDT == T015W.MANDT` `I_PAYMENTREQUEST.BANKCOUNTRY == T015W.BANKS` `I_PAYMENTREQUEST.DATAEXCHANGEINSTRUCTIONKEY == T015W.DTAWS`
General Ledger Account ? Client General Ledger Account	`I_PAYMENTREQUEST.[column in domain "KTOPL"] == SKA1.KTOPL` `I_PAYMENTREQUEST.MANDT == SKA1.MANDT` `I_PAYMENTREQUEST.GLACCOUNT == SKA1.SAKNR`
House Bank Key Client House Bank Key Paying Company Code	`I_PAYMENTREQUEST.MANDT == T012.MANDT` `I_PAYMENTREQUEST.HOUSEBANK == T012.HBKID` `I_PAYMENTREQUEST.PAYINGCOMPANYCODE == T012.BUKRS`
ID for Account Details Client House Bank Key Paying Company Code ID for Account Details	`I_PAYMENTREQUEST.MANDT == T012K.MANDT` `I_PAYMENTREQUEST.HOUSEBANK == T012K.HBKID` `I_PAYMENTREQUEST.PAYINGCOMPANYCODE == T012K.BUKRS` `I_PAYMENTREQUEST.HOUSEBANKACCOUNT == T012K.HKTID`
Payee Bank Country/Region Client Payee Bank Country/Region	`I_PAYMENTREQUEST.MANDT == T005.MANDT` `I_PAYMENTREQUEST.PAYEEBANKCOUNTRY == T005.LAND1`
Payee Bank Key Client Payee Bank Country/Region Payee Bank Key	`I_PAYMENTREQUEST.MANDT == BNKA.MANDT` `I_PAYMENTREQUEST.PAYEEBANKCOUNTRY == BNKA.BANKS` `I_PAYMENTREQUEST.PAYEEBANKINTERNALID == BNKA.BANKL`
Payee Country/Region Key Client Payee Country/Region Key	`I_PAYMENTREQUEST.MANDT == T005.MANDT` `I_PAYMENTREQUEST.PAYEECOUNTRY == T005.LAND1`
Payee Language Key	`I_PAYMENTREQUEST.PAYEELANGUAGE == T002.SPRAS`
Regional Code of the Payee Client Payee Country/Region Key Regional Code of the Payee	`I_PAYMENTREQUEST.MANDT == T005S.MANDT` `I_PAYMENTREQUEST.PAYEECOUNTRY == T005S.LAND1` `I_PAYMENTREQUEST.PAYEEREGION == T005S.BLAND`
Paying Company Code Client Paying Company Code	`I_PAYMENTREQUEST.MANDT == T001.MANDT` `I_PAYMENTREQUEST.PAYINGCOMPANYCODE == T001.BUKRS`
Payment Method Supplement Client Payment Method Supplement	`I_PAYMENTREQUEST.MANDT == T042F.MANDT` `I_PAYMENTREQUEST.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE`
Payment Request Currency Key Client Payment Request Currency Key	`I_PAYMENTREQUEST.MANDT == TCURC.MANDT` `I_PAYMENTREQUEST.PAYMENTREQUESTCURRENCY == TCURC.WAERS`
Origin Indicator	`I_PAYMENTREQUEST.PAYMENTREQUESTORIGIN == TFIBLORIGIN.ORIGIN`
User Who Carried Out the Posting Client User Who Carried Out the Posting	`I_PAYMENTREQUEST.MANDT == USR02.MANDT` `I_PAYMENTREQUEST.POSTINGCREATEDBYUSER == USR02.BNAME`
User Who Carried Out the Release Client User Who Carried Out the Release	`I_PAYMENTREQUEST.MANDT == USR02.MANDT` `I_PAYMENTREQUEST.RELEASEDBYUSER == USR02.BNAME`
Reason for Reversal or Inverse Posting Client Reason for Reversal or Inverse Posting	`I_PAYMENTREQUEST.MANDT == T041C.MANDT` `I_PAYMENTREQUEST.REVERSALREASON == T041C.STGRD`
State Central Bank Indicator Client State Central Bank Indicator	`I_PAYMENTREQUEST.MANDT == T015L.MANDT` `I_PAYMENTREQUEST.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ`
Country/Region Key Client Country/Region Key	`I_PAYMENTREQUEST.MANDT == T005.MANDT` `I_PAYMENTREQUEST.SUPPLIERCOUNTRY == T005.LAND1`
Supplying Country/Region Client Supplying Country/Region	`I_PAYMENTREQUEST.MANDT == T005.MANDT` `I_PAYMENTREQUEST.SUPPLYINGCOUNTRY == T005.LAND1`