Skip to Content
avatar image
Former Member

Create mass specifications and update value assignments

Hello

I have a requirement to have multiple specifications created in my SAP EHS system and update specific value assignments for them.

If I have raw data provided to me in form of an excel spreadsheet, how can I create and update mass specifications. Please note that my client does not have a license for data editor/OCC.

The spcific tasks are:

- create multiple specifications

- assign inheritance relationships for each

- update specific properties (mainly physical and chemical properties) for each

- update composition values for each.

Appreciate any inputs.

Thanks.

Sachin

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 04, 2015 at 05:51 PM

    Dear Sachin

    please don't mix topics. Data Editor is not supported any more; it is only available as a service from SAP; But OCC is supported and use of OCC is part of your EHS license. So you can use OCC. And clearly you can use OCC do "load something".

    For OCC: please check this document: http://scn.sap.com/docs/DOC-59534

    You will find find references to many OCC threads. For OCC: there is one quite important new OSS note describing OCC changes. OCC was redesigned so that you will now find nearly the same options in OCC like in DataEditor.

    The story starts with your statement:

    If I have raw data provided to me in form of an excel spreadsheet, how can I create and update mass specifications.


    => whatever tool etc. you will use one can be pretty sure that you need to transform your EXCEL to something different (either EXCEL ready for OCC or ..)


    We should differentiate the "create" part from the "update" part.


    in principle: you can use EHS standard import (inheritance is not possible) and you can use OCC (not sure about inheritance, we are not using OCC for load purposes)


    Regarding:

    - create multiple specifications => you can do via standard import

    - assign inheritance relationships for each => not sure regarding OCC; to my knowlegde: not possiblel with "standard import"

    - update specific properties (mainly physical and chemical properties) for each => you can use either "import" or OCC

    - update composition values for each. => you can use either "import" or OCC



    A different option (nether used it) is:

    EXCEL data => XI/PI => SAP EHS

    or

    Use of LSMW via ALE

    EXCEL => LSMW => ALE to EHS


    For "creation" I am pretty sure that you can use that; for update: no idea: nether tried


    C.B.


    PS: you need to understand the "inheritance" option; tehn you will understand that it is not easy to "populate" this by "import".


    ALE is one suitable way to do it. So as long as you can prepare suitable IDOC you can do an import

    Add comment
    10|10000 characters needed characters exceeded

    • Hi sachin,

      there is no need for ABAP. Just create the dat-files for all properties you need to migrate. The actual load is then done in offline mode, so Citrix is no problem. The only thing you cannot do this way is the migration of inheritance relationships; they can only be loaded in online mode.

      Ralph