Skip to Content

How to delete data for one value assignment for multiple specifications

Hi ,

I was uploaded data in 9200 specifications Value assignment SAP_EHS_1023_043 but in load file user given wrong Characteristic.

Data was uploaded wrongly,like below

Now i want to update Regulatory Basis and Regulatory list when i was trying to give only this 2 missing values in OCC file and upload it , its not getting updated but when i delete data entire value assignment data for SAP_EHS_1023_043 and update it freshly with missing data its getting updated.

Now i want to upload in bulk , i have to delete complete data first ?

if yes, How to delete only the VAT SAP_EHS_1023_043 fro 9200 specs

or is there anyway i update only Regulatory basis and Regulatory list ?

Thanks

Satya

1.png (11.5 kB)
2.png (55.9 kB)
3.png (30.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 29, 2017 at 07:46 PM

    Hello

    For such issues: many companies do write "own" ABAP" code. But before you start to look for ABAP code ask your self the following questions:

    1.) what has happened?

    2.) what was wrong?

    3.) can I avoid the same issue?

    I believe you can use "Standard" import to delete "all data" (only spec jheader will stay). But I am not sure for data in one "property"

    OVerall: In EHS you have nearly no suitable "good" option for data management (as in your case). That means:

    If you start mass updates using OCC or SAP standard import there are not really many options to get rid of "data" error (if the data is still part of database)

    Therefore: step 1: check standard import. I believe you can use it for mass "deletion"

    Step 2: if such error (or similar one) might happen often: check the standard options of SAP EHS. E.g. by using "hit list" and a "secondary data user exit" you can prepare whatever kind of solution to select specific data (using some clear criteria) to either update or delete them (and OCC is prepared like that (as an user exit for "insert")

    C.B.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 04, 2017 at 07:52 AM

    HI Satya,

    Since you are anyhow using the data editor functionality of OCC for loading the data you can use it to overwrite / or delete the data as needed.
    This works nicely if you have set different data sources for each property you loaded .

    To my knowledege you can't delete specfic characteristics.

    Best

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • This is perfect way.

      But we created a custom transaction using BUS_1077_delete which deleted the old one again i was created newly.

      And the process need customization changes and need to move to PRD right. So creating program help to solve this.

      Thanks mate.