---
article_id: KB0403336
article_type: FAQ
component_ids:
  - BNS-ARI-CI-PRT-MAP
component_descriptions:
  - SAP Integration Suite, managed gateway > Managed Gateway - Portal > Managed Gateway - Buy Side Mapping tool
products:
  - SAP Ariba Procurement, cloud edition
  - SAP Business Network for Procurement and SAP Business Network for Supply Chain
personas:
  - Admin
  - Buyer
  - Supplier
language: en
created: 2026-05-01
updated: 2026-05-01
source: Knowledge Base
url: https://support.ariba.com/item/view/KB0403336
connect_url: https://support.ariba.com/item/view/KB0403336?min=1
sap_for_me_url: https://me.sap.com/notes/KB0403336
---

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

## 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*](https://help.sap.com/docs/sisgw/sap-ariba-cloud-integration-gateway-configuration-guide/how-to-add-substring-function).

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?](https://me.sap.com/notes/0003182124)

## Keywords

Mapping tool, cig, timestamp, date format, managed gateway for spend&network