update infotypes from excel files

[Former Member]

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??

[Former Member]

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??

[Former Member]

Will HR_INFOTYPE_OPERATION be part of the excel name ?

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

Ankur Bhandari.

[Former Member]

Hi Amit,

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

[Former Member]

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