How can I format timestamp values in the Managed Gateway for Spend&Network Mapping Tool?

	English	
Deutsch - Machine Translation Español - Machine Translation Français (France) - Machine Translation Italiano - Machine Translation 日本語 - Machine Translation 한국어 - Machine Translation Português (Brasil) - Machine Translation Русский - Machine Translation 简体中文 - Machine Translation

FAQ KB0403336

Symptom

I am having difficulties formatting timestamp values in the Managed Gateway for Spend&Network Mapping Tool.

Resolution

As of now, the only way to format timestamp values in the Managed Gateway for Spend&Network Mapping Tool is by using the Substring Function.

See Also

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

The following values can be achieved using Managed Gateway for Spend&Network Mapping Tool for this:

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

For more information regarding the Substring Function, please see the note How to use substring function in Managed Gateway for Spend&Network Mapping Tool - SAP Integration Suite, managed gateway for spend management and SAP Business Network.*

For any transformations outside of the formats presented above, the mapping should be performed via BAdi or Customer Exits on the ERP side. You can refer to Why should I use BAdI instead of Mapping Tool to implement logic customization?

*Please note that even though the SAP Integration Suite, managed gateway for spend management and SAP Business Network portal has been strategically renamed to Managed Gateway for Spend&Network, some older documentation is yet to reflect the name change.

Applies To

SAP Integration Suite Managed Gateway > Managed Gateway - Portal > Managed Gateway - Buy Side Mapping tool