BODS issue IDOC floating to double issue
I've created a real-time job that receives an standard IDOC(DeliveryProcessing_Execute) from ECC and processes the IDOC. Everything works with the connection, I have one small problem though. There are three fields in ECC which by default are right justified in it's field and the field is of floating type. When BODS processes this IDOC, it seems it reads it left to right and notices the spaces and assumes that it is empty because of the spaces and marks the values in this field to be 0.000.
My version is 18.104.22.1688 and ecc 6.0.
I save an XML copy of the file for validation before I make any changes to it. In that first xml, the values for these fields show as 0.000.
Anyone have a work around for this that doesn't consist of customizing the IDOC?
I haven't found anyone else having these challenges, which was hard for me to believe because I was using a standard IDOC.
Within the BODS, I can change the metadata of the IDOC but the change does not save or keep in place. It still shows it as a double when I try to use it as a source.