Powerful Posting to SAP ERP or S/4 HANA Features Delivered by PaPM’s Remote Function Adapter – Part 1
SAP Profitability and Performance Management (PaPM) Remote Function Adapter (see link below) offers you the capability to post your results directly to SAP ERP / SAP S4 HANA, eliminating the extra steps to download results from PaPM and upload the same into SAP. With the RFA Finance General Ledger function type (RFA FI-GL), you can now post the results of your calculations in PaPM to SAP. Because it uses the standard SAP accounting interface BAPI_ACC_DOCUMENT_POST, you can post your entries via RFA FI-GL in the same way as using any standard SAP transaction code for GL Account document posting.
Let me show you how you can configure your RFA FI-GL with just a few simple steps:
Database Connection and RFC Destination
The first thing you normally do is set up the database connection and RFC destination at the environment level. If no RFC destination is defined at the environment level, then the local client and system will be used by default, if you do not specify the RFC destination in the RFA FI-GL rules. (See links below for more information on DB connection and RFC destination.)
The data in your input function should contain the fields that need to be mapped to the components of the RFA FI-GL. The input function requires at least one GL account and amount for each side of the entry (debit and credit). Since the RFA FI-GL uses standard accounting interface (BAPI), your inputs are validated against standard SAP FI validation rules, and only inputs that pass the validation will be posted. What this means, for example, is that if on your RFA FI-GL debit side, you used a certain GL account that requires assignment to a cost object (such as a cost center) then you need to supply a valid cost center also on the debit side.
The input function for the RFA FI-GL can be a model table/view or result of other PaPM functions such as allocation, calculation, join, derivation, etc. as long as it contains the necessary fields. Each line in the input function will create one document in SAP.
In our example, we used as input function the below model table with six lines of data.
RFA FI-GL Configuration
Select Finance General Ledger as Remote Function Adapter Type. The RFC Destination is filled automatically based on the RFC connection set up at the environment level, but you can also specify this within the rules tab via component RFC destination. This powerful feature gives you the capability to post to different systems by letting you define more than one RFC destination within the same input function. In our example, we will use the RFC destination defaulted from the environment and leave the RFC destination component in the Rules tab blank.
The input tab should contain the main source of data to be posted to SAP, which is the input function.
In the Action section of the Signature tab, add the document number field so that it can later be mapped to one of the output fields. This will allow for the automatically generated document numbers to be returned by SAP to PaPM in the RFA FI-GL function run results.
The RFA FI-GL function has header components and item components. Some components are marked as mandatory in the function’s configuration, but this is intended only as a guide because as I have mentioned previously, the real validation is done on the FI side.
The basic rule to remember is if a field is mandatory when posting via any of the SAP transaction codes for document entry (such as FB50 – Enter GL Account Document or F-02 – General Posting), then a valid value for that field should be supplied in the RFA FI-GL configuration. Some fields are in themselves mandatory, such as posting date and company code in the header, and GL account and amount in the line items. However, there are also some fields that may be mandatory depending on the characteristics or attributes of the data entered into some of the fields, such as Profit and Loss GL accounts that require assignment to a cost center.
Looking at the rules, you can easily ascertain by the description of the component whether it is header-related or line item-related. There are two sets of line item related components (component name contains either ‘1’ or ‘2’), one for each side of the accounting entry. The amounts for each side should be offsetting (add up to zero). A positive amount should be entered on the debit side and a negative amount on the credit side.
In our example, all of the relevant header and line item components have been mapped to the appropriate fields in the input function, except for two header components that were intentionally hard-coded with values, to illustrate that the components can be either hard-coded or mapped to the fields from the input function.
Once you are satisfied with the rules, you can ignore the lines highlighted in orange and activate the RFA FI-GL function by clicking on the Activate button:
Run the RFA FI-GL function by clicking on the Run button. The results can be seen including the SAP document numbers automatically generated for the postings.
You can verify the results in SAP using transaction code FBL3N – GL Account Line Item Display;
Or FB03 – Display Document. Click on the Header button to see header information.
Alternatively, the postings can be verified by accessing table ACDOCA via SAP transaction code SE16:
There are two other RFA function types that may be used to automatically load data into SAP ERP / S4 HANA: The RFA Finance General Ledger Items (RFA FI-GL Items) which can post multiple lines of data into one SAP document, and the RFA Sales and Distribution (RFA SD) for mass upload of SD documents. These two will be the topic of separate blog entries in the coming weeks.
Thanks for taking the time to read my first blog entry and I hope you found it useful.
Please like, share and let me know what you think in the comments.
Until next time!
Note: Some of the features mentioned here are available only from SP08 (in addition, please install note 2902513).