Data type query

[Former Member]

Hi All,

I have some queries regarding the data type to be used in XI.

We have a target structure for a third party where they have mentioned some data type to be used for the fields. I am unsure which data type to be used from XI corresponding to those:

CHAR(2)................. This should be STRING in XI with max length as 2.

INT1........................ Doubtful on this Whether (INTEGER or INT) as both these options are there in XI.

DATS(8)................. This should be DATE (just wondering if we could specify the length somewhere).

CURR(15,2)............ Should it be DECIMAL or FLOAT,I guess ??

QUAN(12,3)........... Again not sure ??

DEC(5,2)................ Should be DECIMAL (But then what should be the length. Is this 5 including decimal digits also or the part before decimal). Eg. is this something like 12.23 where total length is 5 or something like 12345.65.

What is the difference between INT and INTEGER.

Is someone could please answer this.

Thanks,

Vikas

[Former Member]

Hi Vikas,

If I were you I will take all as string and in mapping according to their requirments I will map along with file content conversion paramters. Dont worry to much. If it is 15,2 then 15 numeric part and two decimal part without the separator counted. Its my guess and you can ask them this question too, because they only know their representation. So if you have amount with 252.24 then I will pad with 12 zeros and make 000000000000252.24. So you can do this, else you can define separately while definining the datatypes also. Please see sap help for any specific ones.

Regards,

---Satish

[Former Member]

Hi Vikas,

If you take all fields are string then no problem

Check this link for the differencess of int and integer data types

http://www.futureware.biz/mantis/view.php?id=386

Other links

http://books.xmlschemata.org/relaxng/ch19-77183.html

http://books.xmlschemata.org/relaxng/ch19-77175.html

Regards

Ramesh