Accompanying Sheet for Payment Output in Contract Accounting

[cheng-hua_huang]

This blog post introduces how to create an accompanying sheet when generating a payment file in Contract Accounting.

An accompanying sheet is created containing a total amount of one or more fields in a file, or hash total. You can use the hash total in the sheet to compare it with the hash total that is generated when you upload the file to your bank portal.

This blog post takes the solution for Netherlands as an example to display how to generate accompanying sheets and import the files.

Business Procedure

Before we learn about how to set up the accompanying sheet functions, we have to know in which stage the accompanying sheets are generated. The following paragraph is the end-to-end business procedure.

1. You have an open item, either for direct debit payment or credit transfer, in Contract Accounting.
2. You execute a payment run for this open item.
3. You select the payment run and download the payment file. You can get the accompanying sheet depends on your configuration in the output management, for example, through an email.

Setting up Accompany Sheet

To generate accompanying sheet, you have to complete the configuration activities as follows:

1. Map Format Data for Payments: enabling accompanying sheet for the output setting in Map Format Data for Payments.
2. Define Payment Medium Formats: selecting the checkbox of extra payment medium with documents.
3. Assign Form Templates: Define FIN_FO_PAYM_HASH_NL_ACCSHT as the output form template.
4. Assign Email templates.

Enabling Accompanying Sheet in Map Format Data for Payments

You can modify the standard mapping structure that is delivered by SAP in the activity Map Format Data for Payments.

1. In your configuration environment, open Map Format Data for Payments (ID: 100558).
2. Create your own mapping format or copy the existing one.
3. Select Edit.
4. In the Format Mapping Attributes, select either Simplified Accompanying Sheet or Accompanying Sheet with Subtotals as your accompany sheet type.
5. Select Release, when you finish editing.

Define Payment Medium Formats

In this activity, select the checkbox “Accompanying Sheet for Payment Medium” that allows you to generate an accompanying sheet with this payment medium.

1. In your configuration environment open Define Payment Medium Formats (ID: 106730).
2. Create your payment medium format by copying the existing one. For more information check Enhancement of Payment Formats in Contract Accounting.
3. When you set up your payment medium format, select the checkbox “Accompanying Sheet for Payment Medium” and selected the format tree that you defined in the previous configuration activity (Map Format Data for Payments).
4. Save your entry.

You then complete the following configuration activities Define Variants for Payment Medium Program and Define Variant Determination for Payment Medium Program. To learn about more details, see Enhancement of Payment Formats in Contract Accounting.

Setting up Output Management

Assign an Output Form Template

In this activity you can define the output form or use the template delivered by SAP. In this activity, we take the Form Template ID for Netherland as an example.

1. In your configuration environment open Assign Form Templates (ID: 102313).
2. Search for the form template based on the following values:

   Field	Value
   Appl.Object Type	FFO_PAYM_MEDIUM
   Output Type	FFO_ACCOM_SHT
   Email Template ID	FFO_PAYM_ACCOMPANY_SHEET_EMAIL

3. Save your entry.

Assign Email templates

In this activity you can define an email template or use the template delivered by SAP for customizing outputs or specific application objects.

1. In your configuration environment open Assign Email Templates (ID:101945).
2. Create your entries or use the following sample values.

   Field	Value
   Appl.Object Type	FFO_PAYM_MEDIUM
   Output Type	FFO_ACCOM_SHT
   Email Template ID	FFO_PAYM_ACCOMPANY_SHEET_EMAIL

Creating Accompanying Sheets for Payment Output

In this activity you can configure the output of payment accompanying sheets for your payment medium formats.

To access the Output Parameter Determination app, you need to have the authorization delivered with the business role template SAP_BR_CONF_EXPERT_BUS_NET_INT (Configuration Expert - Business Network Integration).

1. Open the Output Parameter Determination app.
2. Show Rules for Payment Medium.
3. In the determination step select the following options successively and create entries as the sample values for Netherlands. Alternatively, you can create entries based on your business requirements.
   
4. Activate the settings.

After you finished the settings, you can run the standard business procedure that is mentioned above and get the accompanying sheet through the email or you can use app  "Manage Output Items" to view your accompanying sheets output.

Is the blog post useful to you? Leave your comments to let us know your thoughts!