How to format timestamp values in Cloud Integration Gateway (CIG) mapping tool?

As of now, the only way to format timestamp values on CIG mapping tool is using Substring Function.

Timestamp values have format YYYY-MM-DDThh:mm:ss.

The following values can be achieved using CIG mapping tool for this type of value:

• YYYY-MM-DD
• YYYY-MM
• YYYY
• MM-DD
• MM
• DD
• hh:mm:ss
• hh:mm
• hh
• mm:ss
• mm
• ss

For more information about Substring Function,please see the note How to use sub string function in CIG Mapping Tool - Cloud Integration Gateway.

For any transformation instead of the above, the mapping should be performed via BAdi on ERP side. You can refer to Why should I use BAdI instead of Mapping Tool to implement logic customization?

SAP Ariba Buying and Invoicing
SAP Ariba Buying
SAP Business Network