2546156 - System Does Not Consider Blank Spaces in Bank Payment File Fields

SAP Knowledge Base Article - Public

2546156 - System Does Not Consider Blank Spaces in Bank Payment File Fields

Symptom

You want to add more than one space between characters in a payment file field. You add the spaces in the Constant Value, under Field Content Definition, but when you export the payment file, the spaces are gone and there is only one space between characters.

Reproducing the Issue

To configure the field you perform the following steps:

  1. Go to Business Configuration work center.
  2. Enter in Overview view.
  3. Search for activity Outgoing Bank Transfer.
  4. Select option Edit Payment File Structure, under Payment Medium Formats.
  5. Select the File Structure ID you want, then select Edit.
  6. Pass through steps 1 and 2. In step 3 select the Record.
  7. Add Row.
  8. Fill the data and in Data Source select option Constant.
  9. Under Field Content Definition tab, in Constant Value, you fill the value with the spaces within it.

When you open the output TXT file for the Bank Transfer the spaces do not appear, only the characters.

 

Cause

The system is not designed to accept spaces as characters, and that is why the system disconsiders the spaces when there is more than one filled.

Even if the Field Lenght considers the number of spaces between the charactes, the system will not consider them.
For example:

You filed the Constant Value and Field Lenght fields as below:
Constant Value: X     Y (with 5 spaces between characters X and Y).
Field Lenght: 7 (considering characters and spaces)

The Outbound Bank Transfer file shows the record as follows:
X Y (with only one blank space)

Resolution

Though the system does not consider spaces between characters within the Constant Value, you can follow the below steps if you need to have the spaces in the output file.

  1. Go to Business Configuration work center.
  2. Enter in Overview view.
  3. Search for activity Outgoing Bank Transfer.
  4. Select option Edit Payment File Structure, under Payment Medium Formats.
  5. Select the File Structure ID you want, then select Edit.
  6. Pass through steps 1 and 2. In step 3 select the Record.
  7. Add Row.
  8. First create the row for the firts character (you split the characters you want separated by spaces).
    1. Fill the Constant Value with the character.
    2. Fill the Field Lenght considering the character and the spaces you want between this and the next character.
  9. Create another row for the next character.

This way, in the output file the system will consider the Field Lenght between the characters.

Keywords

KBA , LOD-CRM-EMP , Employee , How To

Product

SAP Business ByDesign all versions