Posting to SAP S/4 HANA – Financial Accounts Payable (FI-AP) delivered by SAP Profitability and Performance Management (PaPM) – Remote Function Adapter


Introduction :

SAP Profitability and Performance Management (PaPM) Remote Function Adapter offers you the capability to post your results directly to SAP S/4 HANA, eliminating the extra steps of

  1. Downloading results from SAP Profitability and Performance Management (PaPM) and uploading the same into SAP S/4 HANA. OR
  2. Writing the result to a SAP Business Warehouse ADSO and then using the BAPI (BAPI_ACC_DOCUMENT_POST) which requires customizing the BAPI and enhancing ABAP logic

The RFA Finance Accounts Payable function type (RFA FI-AP), allows you to post your SAP Profitability and Performance Management (PaPM) calculations to SAP S/4 HANA (in BSEG, BKPF and ACDOCA tables). It uses the standard SAP accounting interface BAPI_ACC_DOCUMENT_POST,

This helps you in, mass posting of SAP Accounting Documents as opposed to creating individual entries using the standard SAP transaction code (like FB60 – used for Vendor \ Account document posting).

Solution :

The Fields in the input function should  be mapped to the components of the RFA Function Type. The input function requires at least

  1. “GL Account”
  2. “Account key” (also known as Transaction Key)
  3. Amount in Document Currency (GL)
  4. Amount in Document Currency (Payable)

The above two Amount fields should have entries for each side (debit and credit)

Since the RFA FI-AP uses standard accounting interface (BAPI), the inputs are validated against standard SAP Financial Accounting (SAP FI) validation rules, the posting will happen once all the fields are successfully validated.

Example – In the Function type RFA FI-AP, you have defined a certain GL account that requires a transaction key then you need to supply a valid transaction key as part of your posting entry.

Input Function

Any input function type like Allocation, Calculation, Join, View etc can be used as an input function for the RFA FI-AP function type as long as it has the necessary fields that are required from posting perspective

A SAP Document number is generated for each line

In our example, we used the JOIN function type. The output of the join function type is shown below

Invoice%20Posting

Invoice Posting Preparation

RFA FI-AP Configuration

Select Finance Account Payable as Remote Function Adapter Type. The RFC Destination is populated automatically based on the RFC connection set up at the environment level.

In our example the RFC Destination: is shown as blank as the RFC connection is maintained at the Environment level.

Input Tab

The input tab should contain the main source of data to be posted to SAP, which is the JOIN  function type called as “Invoice Posting Preparation”

Input%20Tab

Input Tab

Signature Tab

The document number field (BELNR) is added in the Action section so that it can  be mapped to one of the output fields.  The Document number (per line item) generated in SAP after successfully posting is returned and stored in this field

Signature%20Tab

Signature Tab

Rules Tab

Like the Standard SAP Accounting  tables (BKPF – Header) and (BSEG – Item), the RFA FI-AP function type also has Header and Item fields in it. Some components are marked as mandatory as these are part of the standard SAP Financial Accounting (SAP-FI) validations that need to happen for a successful posting

Whenever you create an invoice in SAP using the transaction code for document entry (such as FB60 – Enter Vendor Invoice), the fields like GL-Account \ Supplier etc. are mandatory. therefore these fields need a valid value.

Hence, in the RFA FI-AP Rule configuration, these fields cannot be left blank and need a value that is part of your standard SAP Financial Accounting (SAP-FI) configuration.

There are some other fields which are also mandatory, such as

  • Header – username, posting date, document date, vendor number, GL Account and company code
  • Line Item – GL account, tax code, accounting key and amount.

These are mandatory as they also form a part of standard SAP Financial Accounting (SAP-FI) validations.

Other fields that are mandatory depending on the characteristics or attributes of the data entered into some of the fields, such as Profit and Loss GL accounts needs a Cost Center.

Looking at the rules below, you can identify by the description of the component whether it is header-related or line item-related.

In our example, all of the relevant header and line item components have been mapped to the appropriate fields in the input function.

Rules%20Tab

Rules Tab

You can activate the RFA FI-AP function- “Invoice Posting” by clicking on the Activate button:

Activation%20Result

Activation Result

Upon successful activation, you can Run the RFA FI-AP function- “Invoice Posting” by clicking on the Run button.

The results can be seen including the SAP document numbers automatically generated for the postings.

Results :

The output of the Invoice Posting generated after running the function is shown below

As the records in SAP Profitability and Performance Management (SAP PaPM) have successfully posted into SAP (BKPF and BSEG), the Accounting document numbers generated in SAP are now available in SAP Profitability and Performance Management (PaPM) as shown below

PaPM%20to%20SAP%20Posting%20Results

PaPM to SAP Posting Results

You can verify the results in SAP using transaction code FBL3N – GL Account Line Item Display

GL%20Account%20Line%20Item%20Display

GL Account Line Item Display

Or FB03 – Display Document. Click on the Header button to see header information

Document%20Details

Document Details

Conclusion :

We can use the RFA in SAP Profitability and Performance Management (PaPM) to post entries in to Accounts Payable. This can be further enhanced to post TAX related entries as well which I will cover in my next Blog

References :

I would like to give credit for following references that helped in writing this blog

https://blogs.sap.com/2020/05/12/powerful-posting-to-sap-erp-or-s-4-hana-features-delivered-by-papms-remote-function-adapter-part-1

Remote Function Adapter
Database Connection
RFC Destination

Summary :

To wrap up, I have shown how we can use ‘SAP Profitability and Performance Management (PaPM) – Remote Function Adapter’ function type to create mass posting in SAP S/4 HANA.

I thank you for reading through my first blog in SAP Profitability and Performance Management (PaPM).

Kindly requesting you to leave your feedback and comments.

I would encourage you to follow the topics in https://community.sap.com/topics/profitability-and-performance-management for more enlightenment on SAP Profitability and Performance Management (PaPM).

Thanks

Amogh Kulkarni

Other Credits – Accenture EPM Capability.