I_PaymentReleaseListItem

Payment Release List Item | view: IFPRLITEMS | TRAN | Extraction: Not supported | Component: Payment Progam / Payment transfer (DE, JP, US)
Tables used: FPRL_ITEM, LFA1
Column Name Description
PaymentReleaseListItemUUID UUID in X form (binary)
Column Name Description
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency Amount in document currency
CashDiscountBaseAmount Amount Eligible for Cash Discount in Document Currency
CashDiscountAmtInTransacCrcy Cash Discount Amount in Document Currency
WhldgTaxAmtInTransacCrcy Withholding Tax Amount (in Document Currency)
PaymentRequestAmountInPaytCrcy Payment Request Amount in Payment Currency
💲 Update Currency for General Ledger Transaction Figures (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount for Updating in General Ledger
CashDiscountAmount Cash Discount Deduction for the Item
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Document Date in Document
DueCalculationBaseDate Baseline Date for Due Date Calculation
PaymentRunDate Date on Which the Program Is to Be Run
ProposalRunDate Date of Proposal Run
PaymentDocumentPostingDate Posting Date of Payment Document
ValueDate Value date
PaidItemDueDate Due date of the paid items
BillOfExchangeDueDate Bill of Exchange Due Date
BillOfExchangeIssueDate Bill of Exchange Issue Date
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
FinancialAccountType Account type Show values
AddressAndBankIsSetManually Indicator: Address and Bank Data Set Individually Show values
PaymentStatus Item Status Show values
Column Name Description Domain name
CreatedByUser Created By USNAM
LastChangedByUser Last Changed By USNAM
AccountingDocument Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
BranchAccount Account Number of the Branch MAXKK
PayerPayee Payee/Payer MAXKK
TaxCode Tax on sales/purchases code MWSKZ
WithholdingTaxCode Withholding Tax Code QSSKZ
DocumentItemText Item Text TEXT50
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
VATRegistration VAT Registration Number STCEG
DocumentReferenceID Reference Document Number XBLNR1
ProjectNetwork Network Number for Account Assignment AUFNR
OrderInternalBillOfOperations Routing number of operations in the order AUFPL
AssignmentReference Assignment number ZUONR
AssetContract Contract Number RANL
FollowOnDocumentType Follow-On Document Type REBZT
CostCenter Cost Center KOSTL
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
ProfitCenter Profit Center PRCTR
Reference1IDByBusinessPartner Business Partner Reference Key CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key CHAR12
Reference3IDByBusinessPartner Reference key for line item CHAR20
DataExchangeInstruction1 Instruction Key 1 DTWSX
DataExchangeInstruction2 Instruction Key 2 DTWSX
DataExchangeInstruction3 Instruction key 3 DTWSX
DataExchangeInstruction4 Instruction key 4 DTWSX
BusinessPlace Business Place J_1BBRANCH
PartnerProfitCenter Partner Profit Center PRCTR
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
Fund Fund BP_GEBER
PaymentRequest Key Number for Payment Request PRQ_KEYNO
PaymentRequestOrigin Origin Indicator FIBL_ORIGIN
CurrentProcessor Processor XUBNAME
ReferencePurchasingDocument Purchasing Document Number EBELN
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
TaxID2 Tax Number 2 STCD2
PaymentRunItemMessageNumber Item Indicator CHAR3
PaymentRunID Additional Identification LAUFI
PaymentDocument Document Number of the Payment Document BELNR
PaymentOrder Payment Order PYORD
ProposalRunNumber Payment Proposal LAUFI
SendingCompanyCode Sending company code BUKRS
PayeeAdditionalName Name of the payee TEXT35
PayeePostalCode Postal Code of the Payee PSTLZ
PayeeCityName City of the payee TEXT35
PayeeCountry Country/Region Key LAND1
PayeeRegion Regional code of the payee REGIO
PayeeLanguage Language key of the payee SPRAS
Name Name 1 NAME
PayeeBankCountry Country/Region Key LAND1
PayeeBank Bank key of the payee's bank BANKK
PayeeBankNumber Bank number of the payee's bank BANKL
PayeeBankAccount Bank account number of the payee BANKN
PayeeBankControlKey Bank Control Key of the Payee's Bank BKONT
BankDetailReference Reference Details for Bank Details CHAR20
PayeeBankIdentifierCode SWIFT/BIC for International Payments SWIFT
PayeeIBAN IBAN (International Bank Account Number) IBAN
BankAccountHolderName Account Holder Name KOINH
HouseBankAccount ID for Account Details HKTID
BankCountry Country/Region Key of Bank LAND1
Bank Bank Key of Our Bank BANKK
BankNumber Bank number of our bank BANKL
BankAccount Our account number at the bank BANKN
BankControlKey Bank control key at our bank BKONT
GLAccountForBankAccount G/L Account Number for Our Bank Account / Bank Subaccount SAKNR
DataExchangeInstructionKey Instruction Key for Data Medium Exchange DTAWS
AccountingClerk Accounting Clerk Abbreviation BUSAB
AccountByShipper Shipper's (Our) Account Number at the Customer or Vendor CHAR12
PaymentReference Payment Reference CHAR30
SEPAMandateUUID SEPA Mandate: GUID of Mandate
SEPAMandate Unique Reference to Mandate for each Payee ID035
InvoiceReference Document Number or Invoice Reference Number BELNR
InvoiceReferenceFiscalYear Fiscal Year of DocNo/Inf.ref. GJAHR
InvoiceItemReference Line Item within Accounting Document or Relevant Invoice BUZEI
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • I_PAYMENTRELEASELISTITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_PAYMENTRELEASELISTITEM.MANDT == T003.MANDT
Business Area
  • Business Area
  • Client
  • I_PAYMENTRELEASELISTITEM.BUSINESSAREA == TGSB.GSBER
  • I_PAYMENTRELEASELISTITEM.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_PAYMENTRELEASELISTITEM.COMPANYCODE == T001.BUKRS
  • I_PAYMENTRELEASELISTITEM.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • I_PAYMENTRELEASELISTITEM.CUSTOMER == KNA1.KUNNR
  • I_PAYMENTRELEASELISTITEM.MANDT == KNA1.MANDT
General Ledger Account
  • General Ledger Account
  • Company Code
  • Client
  • I_PAYMENTRELEASELISTITEM.GLACCOUNT == SKB1.SAKNR
  • I_PAYMENTRELEASELISTITEM.COMPANYCODE == SKB1.BUKRS
  • I_PAYMENTRELEASELISTITEM.MANDT == SKB1.MANDT
Short Key for a House Bank
  • Paying company code
  • Short Key for a House Bank
  • Client
  • I_PAYMENTRELEASELISTITEM.PAYINGCOMPANYCODE == T012.BUKRS
  • I_PAYMENTRELEASELISTITEM.HOUSEBANK == T012.HBKID
  • I_PAYMENTRELEASELISTITEM.MANDT == T012.MANDT
G/L Account Number
  • G/L Account Number
  • Company Code
  • Client
  • I_PAYMENTRELEASELISTITEM.OPERATIONALGLACCOUNT == SKB1.SAKNR
  • I_PAYMENTRELEASELISTITEM.COMPANYCODE == SKB1.BUKRS
  • I_PAYMENTRELEASELISTITEM.MANDT == SKB1.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_PAYMENTRELEASELISTITEM.MANDT == T880.MANDT
  • I_PAYMENTRELEASELISTITEM.PARTNERCOMPANY == T880.RCOMP
Paying company code
  • Paying company code
  • Client
  • I_PAYMENTRELEASELISTITEM.PAYINGCOMPANYCODE == T001.BUKRS
  • I_PAYMENTRELEASELISTITEM.MANDT == T001.MANDT
Payment Block Key
  • Client
  • Payment Block Key
  • I_PAYMENTRELEASELISTITEM.MANDT == T008.MANDT
  • I_PAYMENTRELEASELISTITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Payment method supplement
  • Client
  • Payment method supplement
  • I_PAYMENTRELEASELISTITEM.MANDT == T042F.MANDT
  • I_PAYMENTRELEASELISTITEM.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Payment Release List Application ID I_PAYMENTRELEASELISTITEM.PAYMENTRELEASELISTAPPLICATION == FPRL_APPLIC.APPLICATION
Item Status ID I_PAYMENTRELEASELISTITEM.PAYMENTRELEASELISTITEMSTATUS == FPRL_ITEM_STAT.STATUS
Approval Level
  • Payment Release List Application ID
  • Approval Level
  • Client
  • I_PAYMENTRELEASELISTITEM.PAYMENTRELEASELISTAPPLICATION == FPRL_LEVELS.APPLICATION
  • I_PAYMENTRELEASELISTITEM.PAYTRELLISTITEMAPPROVALLEVEL == FPRL_LEVELS.ALEVEL
  • I_PAYMENTRELEASELISTITEM.MANDT == FPRL_LEVELS.MANDT
Posting Key
  • Client
  • Posting Key
  • I_PAYMENTRELEASELISTITEM.MANDT == TBSL.MANDT
  • I_PAYMENTRELEASELISTITEM.POSTINGKEY == TBSL.BSCHL
Special G/L Indicator
  • Account type
  • Special G/L Indicator
  • Client
  • I_PAYMENTRELEASELISTITEM.FINANCIALACCOUNTTYPE == T074U.KOART
  • I_PAYMENTRELEASELISTITEM.SPECIALGLCODE == T074U.UMSKZ
  • I_PAYMENTRELEASELISTITEM.MANDT == T074U.MANDT
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • I_PAYMENTRELEASELISTITEM.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • I_PAYMENTRELEASELISTITEM.MANDT == T015L.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_PAYMENTRELEASELISTITEM.SUPPLIER == LFA1.LIFNR
  • I_PAYMENTRELEASELISTITEM.MANDT == LFA1.MANDT
Payment Method
  • Payment Method
  • Client
  • Country/Region Key of Bank
  • I_PAYMENTRELEASELISTITEM.SUPPLIERPAYMENTMETHOD == T042Z.ZLSCH
  • I_PAYMENTRELEASELISTITEM.MANDT == T042Z.MANDT
  • I_PAYMENTRELEASELISTITEM.BANKCOUNTRY == T042Z.LAND1
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • I_PAYMENTRELEASELISTITEM.SUPPLYINGCOUNTRY == T005.LAND1
  • I_PAYMENTRELEASELISTITEM.MANDT == T005.MANDT
Currency Key
  • Client
  • Currency Key
  • I_PAYMENTRELEASELISTITEM.MANDT == TCURC.MANDT
  • I_PAYMENTRELEASELISTITEM.TRANSACTIONCURRENCY == TCURC.WAERS