XSD Validation for Map Format Data

There is new functionality available in Map Format Data in SAP S/4HANA Cloud, that allows you to define XSD (XML Schema Definition) validation for your outgoing format mappings.

Namely, the following integrations of Map Format Data receive this possibility:

  • Map Format Data for Payments
  • Map Format Data for Treasury Correspondence
  • Map Format Data for Advanced Payment Management

If you were provided with an XSD with a criterion for the output file from the requester (e.g., bank or other financial institution) you can now upload the XSD file and take advantage of the file being checked against the schema as soon as the file is created.

Depending on the integration, this feature can inform you about an invalid file before it is sent to your financial institution which shortens the feedback loop in which you get informed about the invalidity of your file.

Scope

Primarily, the validation can be used for XML files that are generated according to XSD schema files provided by Swiss Payment Standards from ISO (International Standards Organization) 20022 and includes the following:

  • 001
  • 002
  • 008
  • 052
  • 053
  • 054

And of course, it is possible to upload your XSD file and select it for validation.

How to Configure XSD Validation for Your Format Mappings

Open any format mapping that outputs an XML file and on the “Format Mapping Properties” node navigate to the newly introduced tab called “Validation.”

Validation%20tab%20and%20its%20content.

Validation tab and its content.

If you click on the value help found in the “XML Message Identifier” field, you can select one of the standardly delivered XSD validations.

Content%20of%20the%20value%20help

Content of the value help

Selected validation will be applied for all runs after you release the modified format mapping.

If you were provided with XSD from the requestor of the file (typically a bank or other financial institution) you can upload it using the “Create” button located at the top of the value help.

Create%20new%20XSD.

Create a new XSD.

In the subsequent popup provide at least a name and the XSD file and click on “Create”.

Dialog%20for%20upload%20of%20a%20new%20XSD

Dialog for upload of a new XSD.

Now, you can see the uploaded XSD file in the “Custom” section of the value help and you can assign it to the Format Mapping.

Custom%20section%20after%20upload%20of%20new%20XSD.

The custom section after uploading of new XSD.

On top of download functionality for standard XSDs, for custom XSDs you can also override the definition by uploading a new XSD and/or delete existing XSD.

All custom XSDs are available globally for all format mappings.

Validation

The validation of the generated file against XSD happens at the very end of file processing. Map Format Data Engine passes the result of the validation to the caller, for example, Manage Automatic Payments and it is then displayed in the process-specific log.

Manage%20Automatic%20Payments%3A%20XSD%20validation%20unsuccessful%20messages

Manage Automatic Payments: XSD validation unsuccessful messages

Delivery

XSD validation for Map Format Data is available as a part of SAP S/4HANA Cloud 2208 delivery.

Wrap-up

XSD validation in Map Format Data makes it easier for you to find potential problems with the format of the output file sooner than files are sent to the recipient.

If you have any questions about this new functionality, you can use the Q&A area. You are welcome to provide feedback in the comment section below.

To find out more about functionalities for payment formats, visit our Payment Formats blog.