topic update infotypes from excel files in Application Development and Automation Discussions

update infotypes from excel files

Former Member — Sun, 08 Jan 2006 18:33:33 GMT

Hi All,

i've with me some excel files, each file contains data pertaining to a particular infotype ( <b>may not contain each & every field from infotype</b>). my requirement is to develop a <b>unique</b> program which can accept 1 particular file and insert all the data present in the file into that particular infotype. i'm using the FM ALSM_EXCEL_TO_INTERNAL_TABLE to upload data and the FM HR_INFOTYPE_OPERATION to insert data into infotype.

how can i use the concepts of field-symbols & dynamic internal tables w.r.t my requirement??

Re: update infotypes from excel files

Former Member — Mon, 09 Jan 2006 08:10:42 GMT

Will HR_INFOTYPE_OPERATION be part of the excel name ?

I mean how will you identify which file corresponds to which Infotype ?

Ankur Bhandari.

Re: update infotypes from excel files

Former Member — Mon, 09 Jan 2006 08:46:47 GMT

Hi Amit,

that is not a problem, i've another variable with stores the corresponding infotype of the file.

Re: update infotypes from excel files

Former Member — Mon, 09 Jan 2006 09:06:43 GMT

So u basically require a program which uses field symbols right to write data to infotypes ?