Payment Request in SAP: Payment Requests Tables, BAPIs and BADI

Published by John on

Mime Type in SAP

“You use this function (transaction F111) to start the Payment Program for Payment Requests .

This is an additional option for automatic payment in the SAP system.

Unlike the standard payment program, the payments are not based on open items (customer items) but on payment requests.
Integration

What is Payment Request in SAP ?

You use the Payment Program for Payment Requests in the Money Market , Foreign Exchange , Derivatives , and Securities areas of Treasury and Risk Management and in Loans Management in the Bank Applications area .

There is a link to the payment details. The system can, therefore, use the house bank specified in the payment details to update the payment data in SAP Cash Management .” (source)

SAP Payment Requests Tables

The main table for Payment Request in SAP is the table PAYRQ :Payment Requests/

The Key for any SAP Payment Request is the KEYNO (Key Number for Payment Request).
You will find also, some other information such as:

  • ZBUKR: Paying Company Code for this Payment Request
  • ABSBU: Sending Company Code for PR
  • BUKRS: Company Code
  • BELNR: Accounting Document Number
  • BUZEI: Number of Line Item Within Accounting Document
  • GJAHR Fiscal Year
  • WAERS: Currency Key of the Invoice
  • SHKZG: Debit/Credit Indicator
  • KOART: Account Type

Related SAP Payment Request Tables

The list of related tables in SAP for Payment Request are:

TableSAP Payment Req Table
COPC_PAYRQPayment Request for Cash Operation Center
COPC_PAYRQ_DTLCOPC: PAYRQ Detail
COPC_PAYRQ_TCOPC: Payment request text
COPC_RPR_VAR_VLCOPC: RPR variant value
EPIC_EBR_FEBAdditional Data on Bank Statement Line Item for Bank Receipt
FDZACash Management line items in payment reques ts
FPRL_ITEMItem Data
IHC_DB_PNSource Document for Incoming Payment Orders
OTC_CONV_FHAPOBackup Table for Financial Transaction Flows
PAYBUHeader Supplement for Payment Requests Without Vendor
PAYCTAdditional Criteria per Line Item
PAYKOAdditional FM Data for Payment Request
PAYOIItem from a Payment Order
PRQKYKey Number for Payment Request
PAYRCAdditional Header Data for Recovery Order
PAYRQPayment Requests
PAYRQPPAYRQ Enhancement (Cross-Country Bank Acc ount Transfers)
PAYRQTReference Texts for Payment Request
REGUPProcessed items from payment program
RESCTAdditional Criteria per Line Item
TRPRT_PAYMENTSPersistent Data for Payment Requests
VDBEPIPosted line items for document header
VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)
VDBEPPFlow Data – Planned Item
VDBOBEPPBusiness Operation: Entered and Activated Flow Data
VTBFHAPOTransaction Flow
VTBFHAPO_MIGRMigrated Financial Flows
VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows
VWBEPITreasury Securities: Actual Flows – Item
VZFZE_VDBEPPCentral Entry Table for Release Procedure

SAP BAPIs for Payment Request

The list of Payment Request BAPIs in SAP are:

BAPIDescription
BAPI_PAYMENTREQUEST_CREATECreation of a Payment Request
BAPI_PAYMENTREQUEST_GETLISTList of Payment Requests with Selections
BAPI_PAYMENTREQUEST_GETSTATUSDetermination of Payment Request Status
BAPI_PAYMENTREQUEST_CANCELCancel Payment Request
BAPI_PAYMENTREQUEST_POSTPosting a Parked Payment Request
BAPI_PAYMENTREQUEST_RELEASEPayment Request Released for Payment
BAPI_PAYMENTREQ_STARTPAYMENTStart Payment of Payment Request

BAPI_PAYMENTREQUEST_CREATE

This BAPI BAPI_PAYMENTREQUEST_CREATE will create a new Payment Request Object in SAP.
Here the signature of BAPI_PAYMENTREQUEST_CREATE.

BAPI_PAYMENTREQUEST_GETLIST

The function BAPI_PAYMENTREQUEST_GETLIST will retrieve a list of Payment Request.

Here the signature of this BAPI :

BAPI_PAYMENTREQUEST_GETSTATUS

The BAPI BAPI_PAYMENTREQUEST_GETSTATUS will retrieve the status for a Request Payment in SAP.
As input, it takes the REQUESTID

BAPI_PAYMENTREQUEST_CANCEL

The BAPI BAPI_PAYMENTREQUEST_CANCEL will cancel an existing Request Payment in SAP.

Here the signature of BAPI_PAYMENTREQUEST_CANCEL

BAPI_PAYMENTREQUEST_POST

This function BAPI_PAYMENTREQUEST_POST will Post a Parked Payment Request.
The input is the REQUESTID and flag Run Test.

Here the signature of BAPI_PAYMENTREQUEST_POST:

BAPI_PAYMENTREQUEST_RELEASE

This is the BAPI for Payment Request Released for Payment.

The signature of BAPI_PAYMENTREQUEST_RELEASE is:

BAPI_PAYMENTREQ_STARTPAYMENT

Finally, in order to start the payment of a SAP Payment Request call the BAPI BAPI_PAYMENTREQ_STARTPAYMENT.

Here the signature of BAPI_PAYMENTREQ_STARTPAYMENT:

SAP BADI for Payment Request

You can also use a BAdI (technical name TPM_EXT_PAYMENT_TRPR) to make payments for payment requests using another payment program (such as In-House Cash).

The BAdI is available in Customizing for the Transaction Manager under  General Settings  Payment Management  Payment Requests Customer Payment Programs. (source)

BADI TPM_EXT_PAYMENT_TRPR

The BAID TPM_EXT_PAYMENT_TRPR is for Payments via External Programs.

Here the list of methods available for TPM_EXT_PAYMENT_TRPR:

MethodDescription
CANCEL_PAYMENTReverses a Payment
DISPLAY_PAYMENTDisplays Payment
BLOCK_PAYMENTBlocks a Payment
RELEASE_PAYMENTReleases a Payment
IS_RELEVANTPayment Should Be Made via External Payment Program
CREATE_PAYMENTGenerates a Payment
GET_PAYMENT_STATUSGets the Status of a Payment
You may also like: