Function documentationConversion of Source Data

 

This function converts source field data to a particular format for the DME file. You can specify a conversion method for any of the mapping procedures available for elements, atoms, and action nodes.

The system supports conversion rules for the following field types:

  • Date

  • Time

  • Currency amount

  • Character string

If you require an additional conversion method, you must specify an exit module for the node.

Note Note

We recommend that you do not use any standard conversion function together with mapping procedure Exit module for the same node simultaneaously. Instead, implement your own conversion function within the selected exit function.

For more information, refer to SAP note 2262060.

End of the note.

Activities

First enter the source information, then choose Detail view: conversion (Detail view: conversion) on the Attributes tab; the system restricts the selection criteria and displays the conversion rules that apply to the particular field type. Alternatively, you can choose from all available formats via the input help. The following table shows available formats:

For field type

You can specify a combination of the following data:

Date

  • Day, month, and year sequence

  • Number of characters for year: two or four

  • With or without separator

  • Type of separator: slash or period

  • Year, month, or day only

  • Year and number of days since January 1

Time

  • Hour, minutes, and seconds sequence (with or without seconds)

  • With or without separator

  • Hour only

  • Conversion to time stamp

Currency amount

  • Number of decimal places

  • Decimal formatting: period, comma or none

  • With leading zeros

  • Left- or right-justified

  • Output decimal value as 0 (round down)

  • Arithmetic rounding to nearest decimal place allowed by the output format (0.5 rounds up)

Character string

  • Left- or right-justified

  • Left-justified with ending zeros

  • Right-justified with leading zeros

  • Unjustified

  • All characters in upper case (capital letters)

  • Replace national characters

  • Remove special characters

  • Replace leading zeros with space

  • Convert to numeric characters

  • Exclude/allow defined characters