Material group updation by using function modules

[Former Member]

Hello All,

I would like to add , update and delete material group From database tables T023 and T023T according to the given Excel input file.Could you please suggest me any function modules are there apart form MATL_GROUP_UPDATE .

if i am using this function module i am getting the follwing error

'Class does not exist or is not valid on this date'.

Could you please send me any sample code.

Thanks in advance,

Arvind.

[Former Member]

Hi,

Probably you can use BDC in SM30 for the view V_T023 to update this table..

Thanks,

Naren

[Former Member]

Hello Narendran,

Thanks for your quick reply.

i need to do the following fucntions to the tables t023 and t023t.

1) adding material group

2) Updating the material group

3) Deleting the material group

according to the status field in the excel input file as shown below

Status ungültig Referenzen MGS Beschreibung deutsch Beschreibung englisch 中文 Beschreibung russisch

N H4*** Kohlen Carbon 炭 Уголь

N H4100 Kohlebürsten Carbon brushes 炭刷 Угольные щетки

N H4900 Sonstige Teile aus Kohle, techn. Kohle Other parts made from carbon, techn. carbon 由炭，工程用炭制成的其他零件 Прочие виды изделий из угля, технический уголь

U J2100 Polyphenylenether (PPESIB) Polyphenylene oxide (PPO) 聚苯氧化物(聚苯撑氧,聚苯撑氧化物)(PPO) Полифенилэфир (PPESIB)

D x J2400 Sonstige styrolhaltige Polymere Other Polymers Containing Styrene 其他含苯乙烯聚合物 Прочие виды полимеров, содержащие стирол

Note:Status :N means add the corresponding material group H4***

U means update the material group Description in t023t

D means delete the material group form the table t023t

in all languages

Could you please tell me any other fucntion modules are there.

As per your suggession we can add the material groups then what about Updation and deletion of material groups.

Also suggest me shall i go for normal modify , delete and update statements in my program to aceive the above functionality

2) The excel file format is also not constant they can change the columns

as per their wish i mean for exp in the above excel at col1 Status field is there and at col4 (MGS ) material group and remaining columns are description of the material group in different languages(sorry the excel alignment is not clear above) .

They can change this and they can place status at col5 and MGS at col6 .

Could you please advice me how to handle this situation in my program

Thanks in advance,

Arvind.

[Former Member]

Hi,

Ok..There is a business object BUS1072 for material group..

In that for create/change he is using the transaction WG21 / WG22..

For delete WG23..

Probably you can use BDC for those transaction..

Thanks,

Naren

[Former Member]

'updation' is not a word