START ROUTINES for splitting data

[Former Member]

Hello SDN s,

How r u ?

I have a requirement, in MS SQL i have some fields with VARCHAR(200) and more than 200 even 2000. One SDN friend replied me to create InfoObjects and split the data but i need help on how to split and move the field value into multiple InfoObjects ?

Kindly guide me in this regard....

Best Regards....

Sankar Kumar

[Former Member]

Hi Maran,

Yes you can do this. Just split the data in transfer rules while reading the data from file.

For example you have a filed of lenth 200.

here create 4 infoobjects each of lengh 60chars.

In trnasfer rules write a routine/formula,

for 1st field

result = tran_structure-<field>+0(60). It will take from 1 to 60 chars.

For 2nd field

result = tran_structure-<field>+60(60). It will take from 61 to 120 chars.

For 3rd field

result = tran_structure-<field>+120(60). It will take from 121 to 160 chars.

For 4th field

result = tran_structure-<field>+180(60). It will take from 181 to 240 chars.

For more info see the SRTING commands in ABAP.

Hope this Helps

Srini

[edwin_harpino]

hi,

you can split them in ms-sql view, use substring

select substring(fieldname,1,60) as desc1, substring(fieldname,61,60) as desc2, substring(fieldname,121,60) as desc3, ... from tablename where condition..

then assign/map desc1 to infoobject1, desc2 to infoobject2 etc ....

later, to 'merge' them back in bw reporting, you can try following how to

https://websmp102.sap-ag.de/~sapdownload/011000358700009032612002E/HowToHideColumns.pdf

hope this helps.