SAP Knowledge Base Article - Public

3512237 - Field Formats Used With Respect To Data Import And Export In SAP Sales And Service Cloud V2

Symptom

This KBA gives a list of field formats/types that are used in Data Import and Export.

Environment

SAP Sales and Service Cloud V2

Resolution

  • CODE_FORMAT -> Represents the code value for a field which is of the type list. You can find the code values by downloading the template in Data Import and Export view and opening the wanted the file starting with Code
  • STRING_FORMAT -> Text data.
  • URI_FORMAT -> URL format e.g. https://www.test.com
  • FLOAT_FORMAT -> Decimal number e.g 1.56
  • INT64_FORMAT -> Integer number, e.g. 2
  • DATETIME_FORMAT -> yyyy-mm-ddThh:mm:ssZ e.g. 2024-03-18T23:00:51Z
  • INT32_FORMAT -> Integer number, e.g. 5
  • DOUBLE_FORMAT > Decimal number.
  • TIME_FORMAT -> HH-MM-SS e.g. 18:00:00

See Also

Extension Field Data Types | SAP Help Portal

Keywords

Data formats,  Data import and export, V2 , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , Problem

Product

SAP Sales Cloud and SAP Service Cloud Version 2 1.0