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

EH&S Data Editor Monomer and Exact Compositions data load problem

Hi,

I am trying to load data for Monomer Composition and Exact Composition.

In SAP, we have Header Sort Sequences 1,2 and 3 available.But my requirement is I need to change data for only Sort sequence 2.

So my question is can we prepare the Input file with only Sort Sequence 2 for the Specification and load it with Change mode using the data Edior Options.(OR) Do we need to give Sort Sequence 1,2 and 3 again in the Input file for Changes to Sort Sequence2.

for Data changes dataeditor option INSERT, DELETE,CHANGE,REPLACE which mode is best way to update the data .

Few cases--->

First case---> need to change the exisiting data

second case---> need to create new data

in both cases are there in same file so how we can load this?

Please help me to resolve.

Please help me to resolve this issues.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2009 at 07:47 AM

    Hi Bhanu,

    I hope you refereing here for Technidata's Data editor to upload/change data in specifications.

    In my point of view your second option should work, plaese make the file with all 1,2 & 3 short sequence and then change the data using data editor, this process will maintain your sort sequence as it was maintained before and your requirement to change in sort sequence 2 will also served.

    Thnaks & Regards,

    Nitin Pandey

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I have one question, can you pleas help me regaring Data Editor

      I am working on Legal Composition, I have total 3 Compositions for One SUBID consider 1 2 3 sort sequences I need to delete only 2nd sort sequence and i need to keep rest of two that menas i need ot delte the record 2 and keep as it is 1 and 3 by using DATA EDITOR how we can do that is there any special settings and file fomat we need to maintain

      help will be great

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2009 at 10:50 AM

    Hi Bhanu,

    Try from the following links useful for ur querry, i think better follow the link-1 and to create set of rules follow link-2.

    [http://help.sap.com/erp2005_ehp_04/helpdata/EN/b5/3bd1369f2d280ee10000009b38f889/frameset.htm]

    [http://help.sap.com/erp2005_ehp_04/helpdata/EN/b5/3bd1369f2d280ee10000009b38f889/frameset.htm]

    if u wish ot upload first monomer data, later updating with exact composotion, then setting od rules be done first and then go ahead as per the proceedure at link- 1.

    If u post more details, it will be convenient to add a thought to ur advices further.

    with regards,

    mahesh.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Thanks for *your fair response. Actually I am using DataEditor tool not Expert Rule Editor at my client* site .

      I have loaded data for Exact Composition for a Specification using the EH&S Data Editor tool.

      In the Input file I have data for Header *Sort sequences *1, 2 and 3.

      In SAP all the 3 Sort Sequences for the Composition data (Eg: 1,2,3) are loaded.

      Requirement for our project is to Change the Existing Data:

      1) Now Business wants to Update data for only Sort Sequence 2 and in the Load file for Change

      they would provide data only for Sort Sequence 2.

      I am trying to use the C- Change option with the data editor,but the existing data is getting deleted and only data with Sort Sequence 2 is now available in the SAP.

      But I need to retain the other sort sequences 1 and 3 and only update 2.

      Any help on this issue is appreciated.