urgent

[Former Member]

Hi,

iam working on excelsheet.user can fill the coloumns manually.it has 50 coloums.now i convert the excel file to certain Structure and performing mapping for the excel file fields and the Structure.The Structure realted to finanacial related one and excel fields are also same.now the doubt is how can we map Financial fields suppose GL-GL,GL-AP.GL-AR,AP-AR,AR-AR etc.

plz help me

helpful answers get rewarded.

thanks

[Former Member]

Hi,

iam working on excelsheet.user can fill the coloumns manually.it has 50 coloums.now i convert the excel file to certain Structure and performing mapping for the excel file fields and the Structure.The Structure realted to finanacial related one and excel fields are also same.now the doubt is how can we map Financial fields suppose GL-GL,GL-AP.GL-AR,AP-AR,AR-AR etc.

plz help me

helpful answers get rewarded.

thanks

[Former Member]

Hi,

Please explain the problem in detail.

Regards,

Mukul

[Former Member]

Hi,

here is the problem.convert the data in the internal table into the certain strcture and performing mapping of the data as GL-GL,GL-AR,GL-AP,AP-AP,AP-AR,AR-GL,etc.

how can we do this.

[Former Member]

Hi,

Use a Loop inside a Loop. Though this is not advised for performance purpose.

I feel your problem can be solved if you use a Loop inside a Loop.

If you want to map all the fields to itself, then, copy the contents to another internal table.

Eg: itab2[] = itab1[].

loop at itab1.

loop at itab2.

processing...stmts..

endloop.

endloop.

Is this lead useful?

Regards

Subramanian

[Former Member]

Hi,

You can use the Function Module - WS_UPLOAD for transfer of the contents from Excel Sheet to Internal tables.

From the Excel sheet , you can save the file as Coma seperated file.

Now convert the data from Coma seperated file to Internal table.

If you need further explanation please let me know so that i can send you an code snippet

Regards

Sunil

[Former Member]

Hi!

Thanks for the reply Sunil.

I have done the same but can u plz send me the formatting techniques that needs to be incooperated.Like the rules which i had specified earlier.

Thanks

srk

[Former Member]

Hi ,

Can you send your mail id so that I can send you the Code Snippet.

Regards

Sunil

[Former Member]

Hi

[email protected] send the code urgently..remeber we are writing this code for excelsheet.

thanks

[Former Member]

Hi ,

Sent it to the EMAIL mentioned by you .Please let me know if you have any other queries.

Regards

Sunil

[Former Member]

there is a fm for uploading excel sheet...

ALSM_EXCEL_INTO_INTERNALTABLE..

the structure tht u have to use for the internal table is ALSMEX_TABLINE..