Data format issue in RTCFU template

[Former Member]

Hi All,

I am working on RTC 1709, uploaded absolute data(with no decimals) using RTCFU Tcode successfully. Today When I tried to load data with decimals I see error saying "2000.20 at column KSL must be CURR type'. Where 2000.20 is my data in KSL Cloumn. Sample template is detailed.

ENTITY PENTITY RCONGR1 AUDIT_TRA RACCT RKCUR KSL KOKRS BPC_CATG RBUKRS

COM1 COM2 G_NONE INPUT 6593002 USD 1111.22 A001 PRELIM COM1

COM2 COM1 G_NONE INPUT 6594001 USD -1000.33 A001 PRELIM COM2

Regards,

Shanmukha Rao.

[chandradeloitte]

The decimal separator depends on the user default settings.
Path: System >> User Profile >> User Data >> Defaults >> Decimal Notation

Please check if the flat file has the same decimal separator as that of your user default decimal notation setting.

[chandradeloitte]

It worked. Thank you Very Much

[damovand]

Hello,

According to note 2478379 and note 2684906, adding KSL and HSL to FIN-RTC are done through additional configurations and some code changes. My recommendation is to verify if any of the steps are regarding defining a format for the KSL and HSL fields in RTC and if so if the format allows for decimal point.

Best Regards,

Leila