Master data Load for Substance Creation : Using BAPI in LSMW ?

[Former Member]

Hi ,

Had any one did a Master data load for creating a Substance in SAP RM. If so please let me know the best possible option. I am beeing trying to figure out the option to load Substances and its IDENTIFIER / MATERIAL ASSINGMNET from my legacy system. But I am not geeting a clue to use LSMW. ( Direct or BatchInput )

I am not seeing any BAPI for uploading it through the LSMW except the one BUS1077 ( method SAVEREPMUL ) and I guess this is used along with IDOC.

Appreciate your help and suggestion.

David

[john_hermans]

Hi David,

I'm afraid LSMW is not an option.

There is the transaction CG33 ( import specifications).

This works with plain text files, but the data formatting is rather special. You can find out what it looks like by exporting a substance from within CG02. This gives you a UNIX file that you can view with AL11, or download with CG3Y to your network environment.

Technidata offers a tool: DataEditor for offline data maintenance.

This has the possibility to read data in table format (Excel) and produce files with the right format for importing into EH&S.

Kind Regards,

John Hermans

[Former Member]

Thanks John.

I will try this option what you have suggested. Even I told by business team to look for CG33. But they were been telling me some format issue. Probably they would meant the same what you have said. But they were not aware of work around for this. your information is intresting.

The other option given to me was to create a recording for each and every Tab like Substance header / Identifier / Material assignment etc. seperately. Technically I don't feel good to create in that way. Do you think that is alernate approach.?

With Respect & Regards

David

[Former Member]

Try BAPI_BUS1077_CREATE