This problem occurs because the listing of SAP Type value options provided in the Exported Excel Template is not complete and is shown below : -
SR 7000834666
Refer link to add Tooltip - https://communities.bentley.com/products/assetwise/asset_performance_management/w/wiki/40327/missing-sap-type-tooltip-data-functions-for-data-loader