How to format timestamp values in the SAP Integration Suite, managed gateway for spend management & Business 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

How to format timestamp values in the SAP Integration Suite, managed gateway for spend management & Business Network Mapping Tool.

Resolution

As of now, the only way to format timestamp values in the SAP Integration Suite, the managed gateway for spend management & Business Network Mapping Tool, is 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 guide SAP Help Portal > SAP Integration Suite, Managed Gateway for Spend Management and SAP Business Network > SAP Integration Suite, Managed Gateway for Spend Management and SAP Business Network Configuration Guide > Adding Substring Function | SAP Help Portal.

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 ERP customization options instead of Mapping Tool to implement logic customization?

Applies To

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