SAP data types

The Connector contains several support routines to perform data type conversions between the LC API and SAP. The following tables show the correspondences of SAP and LC API data types.

  • (p) - Indicates that if Allow Precision Loss is not enabled, error will be generated on the type match. Allowing precision loss is the default.
  • (o) - Indicates that overflow checking is performed when data is transferred. If an overflow occurs and Truncate Data When Necessary is enabled, the data is truncated. If it is nor enabled, an error is generated.

The Domino Connector for SAP Solutions does not perform precision checks.

Fetch

SAP HEI/DECS (LC API)
TYPINT, TYPINT2, TYPINT1, TYPFLOAT(o), TYPNUM(o), TYPP(o) lnt
TYPINT, TYPINT2, TYPINT1, TYPFLOAT, TYPNUM, TYPP Float
TYPINT, TYPINT2, TYPINT1, TYPFLOAT(o), TYPNUM(o), TYPP(o) Currency
TYPINT, TYPINT2, TYPINT1, TYPFLOAT(o), TYPNUM(o), TYPP(o) Numeric
TYPTIME(o), TYPDATE(o) Datetime
TYPC Text (o)

Insert/Update/Execute/Call

HEI/DECS (LC API)
lnt TYPINT, TYPINT2, TYPINT1, TYPFLOAT, TYPNUM, TYPP
Float TYPINT, TYPINT2, TYPINT1, TYPFLOAT, TYPNUM, TYPP
Currency TYPINT, TYPINT2, TYPINT1, TYPFLOAT, TYPNUM, TYPP
Numeric TYPINT, TYPINT2, TYPINT1, TYPFLOAT, TYPNUM, TYPP
Datetime TYPTIME, TYPDATE
Text (o) TYPC(o)