Skip to Content
author's profile photo Former Member
Former Member

Upload value assignments to substances

Hello all,

We need to do a mass upload of value assignments for substances included in a property tree for transaction CG02.

Can anyone point me out how to achieve this?

Can be done through abap coding or maybe with transaction CG33?

Thanks in advance.

Ruben

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Posted on May 14, 2015 at 07:26 PM

    Dear Ruben

    many people do have problems in using CG33 as the input file can not be generated "easily"(and many consultants "hate" therefore CG33). As long as the specification isstill existing the OCC might be a better tool as this has been enhanced (refer to answer of MR EHS EHSM) and yopu can use "EXCEL like structured data" for import.

    OCC can be used according to documentation now in two different scenarios: in an "online" modus and an "offline" modus.

    Please check:

    KEEP IN MIND THIS: based on standard EHS data model you should not load all data "direct" to REAL_SUB (e.g. DG data should be loaded different etc.).

    Keep in Mind, If you would like to populate properties of type "composition" / "Spec listing" the needed keys must still exists in data base and must be part of the import file.

    The use of CG33 is discussed rarelyin the last 3 years. I can not remember any thread in regards of this 2013 / 2014.

    2015. situation is different and lot of people have raised questions regarding the so called "DataEditor" and the "OCC".

    I propose you to do the load "property" by "property" if you do not have any experience with OCC or CG33.

    Please check: Rule Sets / Secondary Data Determination

    and: SAP EHS Management for Beginners

    First document will provide references to threads discussing use of "OCC" to load data; second docoment does provide references to threads discussing substance data import using CG33.

    C.B.

    PS: some threads only as an example:

    PPS: regarding:

    Can be done through abap coding or maybe with transaction CG33?

    IN most cases you do not use own ABAP code to do upload; Most of data import is done either by CG33 or OCC. Especially regulatory content is loaded (according to my knowledge) via OCC

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 14, 2015 at 12:18 PM

    Hi Ruben,

    Yes you can use CG33 to import substances.

    The below link will provide you additional details on the typical file format for import specfications using CG33.

    http://help.sap.com/erp2005_ehp_07/helpdata/EN/c3/a5ce5314894208e10000000a174cb4/content.htm?frameset=/EN/db/a5ce5314894208e10000000a174cb4/frameset.htm&current_toc=/en/86/5ebd534f22b44ce10000000a174cb4/plain.htm&node_id=369

    Alternatively, the SAP EHS Data editor tool can be used for Import of substances, however is a licensed tool needs to purchased from SAP.

    In our company we use CG33 to import specification data from our legacy.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on May 14, 2015 at 06:12 PM

    Hi Ruben,

    In your case its better to use the OCC, you can ask me why?

    1. You mentioned its a mass upload.

    2. CG33 is in some cases good enough, but time consumption.

    3. So better go with OCC (Data Editor, as mentioned by Kalyan Srinivas).

    4. Technically OCC is the new tool for the data load as there is no more support from SAP on the Data Editor. But functionality of both tools are same.

    --

    😊

    Add comment
    10|10000 characters needed characters exceeded