Skip to Content
avatar image
Former Member

DG Data Distribution

Dear Experts,

I am trying to send DG data from one system to other but not able to complete the process.

Here are details,

DG data sent from source system to target system and got following message,

Idoc sent successfully to target system. Below is the view of idoc in source system.

Below is the view/status in target system. It's stuck in status 64 - Processing. It's remain in this status only. Not progressing at all. Below is the view from BD87,

now here if we process it Manually then it's getting processed as shown below,

but even after that, actually DG data is not getting updated in Target System. As shown below, in Source system, CPN is like shown on left where as in target system still old CPN shows. Revised CPN is not getting transferred to Target system.

Can you please provide an input to overcome this issue?

Thanking You,

Regards,

Amol Joshi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Dec 23, 2016 at 09:50 AM

    Dear Amol

    hope you are fine ?

    Assumptions:

    1.) both SAP systems of concern are on the same "status of release" (same SAP ERP release)?

    2.) both do have the same EHS customizing set up?

    Therefore: first you should look to "optimize" your inbond and outbound ALE process, You should optimize the "ALE" process so that you need not to "manipulate" manually in target system to get the IDOC data moved to data base.

    Normal set up is as:

    IF you have set up ALE scenario and you have distributed once the DG master data then any thing "on top" (changes in data) should be handled automatic. Here you need to set up several reports as jobs (ask ALE experts for guidance) in source and target system.

    Now coming back to your "inbound" topic: Proposal:

    1.) first check on source system that the data which should be distributed is distributed (check the important message in BD87 (topic of ALE filtering !). E.g. you have set up a new "phrase position" using language " IT" in source system. This should be dispatched to target system (and now customizing ! must be ! the same (same phrase langauges) automatically.

    So check first: is the IDOC generated correct in your source system (e.g. using BD87)

    2.) check the content of the IDOC in target system. Is the data present as expected?

    3.) If (by accident) the "phrase" is "blocked" (in this case() by a user or process ALE can not succeed.

    Hope this helps as starting points to look at

    C.B.

    PS: may be https://archive.sap.com/discussions/thread/3780222 is of interest

    same as: https://archive.sap.com/discussions/thread/3713792

    Other" related" threads are e.g:: https://archive.sap.com/discussions/thread/3637564 (may be for future use ? and https://archive.sap.com/discussions/thread/3637742

    PPS: may be reread: http://help.sap.com/saphelp_erp60_sp/helpdata/en/d0/26bf53d25ab64ce10000000a174cb4/content.htm?frameset=/en/29/20693701e08332e10000009b38f8cf/frameset.htm¤t_toc=/en/ef/27bf53d25ab64ce10000000a174cb4/plain.htm&node_id=88

    and http://help.sap.com/saphelp_erp60_sp/helpdata/en/9b/25bf53d25ab64ce10000000a174cb4/content.htm?frameset=/en/d0/26bf53d25ab64ce10000000a174cb4/frameset.htm¤t_toc=/en/ef/27bf53d25ab64ce10000000a174cb4/plain.htm&node_id=89&show_children=false

    PPS: the "job owner" of the job on target system side must have the "full EHS" write access (without that the "user" can not move the data to database

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 18, 2017 at 09:27 AM

    Dear All,

    Thanks a lot for your feedback on the same. This issue is not yet resolved. Since user was on leave till last week, i took a benefit of ignoring this topic till then. :-)

    Now since he is back, taking forward this requirement now. Will update you soon on the same.

    Hi Mark,

    I have noted your input that Phrase ALE is also required. Thanks for valuable hint.

    Regards,

    Amol Joshi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 26, 2017 at 04:27 PM

    Dear All,

    Mark was right. Phrase ALE is also required.

    I am testing in Development client. I sent idoc from one system to other. Following is the result

    Case 1) when it is new phrase ( Phrase is available only in Source System and not in Target System)

    ALE works well and in Target system, new phrase got created successfully.

    Case 2) phrase text of existing phrase is updated.

    here is problem.

    e.g. in my case, phrase id CUST-000000000010133 is available in both the systems ( source and target ).

    Now, the text of phrase is changed in source system and idoc sent to target but getting below error.

    system is not update the phrase text is target system.

    Getting follow error - Data record number exists twice. It seems, in this case also, system is considering it as new phrase creation AEL and not the updation ALE...

    any guidance to overcome this problem?

    Thanking You,

    Regards,

    Amol Joshi

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Amol

      according to the "log". The data is "deleted" and "created". This is "the wrong" approch (as we need onyl an update). This might be the problem. The "issue"could be in "number range" on target system (for phrase keys). If the "deleteion" of the key has happened, the data record does have "del" flag. Now if system set up as: any phrase get a new key, during set up the system "might" detect, that the phrase was still there... but not sure

      Honestly: use Debug. Try to identify what the "delete" is doing;

      I believe either the set up of phrases in "wrong" in target system or your "ALE" inbound process must be adapted

      C.B:

  • Feb 22, 2017 at 09:46 AM

    Just teo hinta from my side:

    First: Usually the number range in the target system is set to internal. As you want to Import a RECN with that number it won't work. You have to change the number range to external. (or you delete it in a user-Exit)

    Second: You also must delete any Change numbers which are parts of the IDOCs. They're not known in the target system hence booking fails.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2017 at 03:02 PM
    -1

    Hi Amol,

    Please check distribution model languages filter , what are the languages you maintained in distribution model, and the phrase languages configured in both system have to be same.

    if configuration is same the go fo

    r distribution model

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 27, 2017 at 07:18 AM
    -1

    Hi Amol,

    RECN number is the we tried by deleting the Phrase, it's working fine but it's not permanent solution. If you have anything can you please share us also.

    Thanks

    Satya

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04, 2017 at 03:23 PM

    Hi Amol,

    Is the phrase ALE set-up as well? I think you need to have both ( DG ALE and Phrase ALE) in place for this to work correctly! DG ALE only syncs the DG data part - but not the texts of the assigned phrases!

    Kind Regards

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Amol

      please check last hint of Mark. If I remember correct. in the "inbound process of phrases" you have as well aome exits. Depending on the set up of the target system (and set up of phrase) you might have the need to do some programming (e.g. topic of external or internal etc. number range).

      Iny any case. for phrase distribution: more or less any customizng must be the same (E.g. phrase group etc)

      E.g. you have two options for"language" part. Eitehr you filter on the outbound side the language (much simpler)or you filter on the "inbound side" (I believe only possible using one of the exits)

      C.B:

      PS: YOU SHOULD DOCUMENT ALE SET UP VERY WELL. You Should have a "cookbook" in place (e.g. if you later add more langauges etc.). In a project two years ago we have realized that we have "missed" to check one of the exists on inbound side and therefore no ALE booking was possible.

  • Jan 05, 2017 at 05:49 AM

    Dear Amol

    Mark is clearly correct (sorry missed this part of the topic). Clearly the ALE for phrases must be up and running as well to support the DG topic. A "huge" part of the DG master data is stored in database using phrases. During the DG Filling any new translations for identifiers etc. and other stuff should be detected in the phrase part as during the DG filling either a new phrase is generated or an update is happening for some phrase language (as in your case). The ALE will then push (normally) only the new phrase or the new prase language data to the target system and therefore Phrase ALE must be up and running as well (if set up is done properly for phrase ALE).

    C.B.

    PS: may be check: http://help.sap.com/saphelp_erp60_sp/helpdata/en/ba/75a54180505643b4160c20f5dd1220/content.htm

    PPS: I found some old threads of you in contetx of some DG topics. E.g. https://archive.sap.com/discussions/thread/3429385

    and

    https://archive.sap.com/discussions/thread/1611556

    A "different" thread of potential interest https://archive.sap.com/discussions/thread/3238565

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2017 at 01:07 PM

    Dear Amol

    any progress on your side regarding the feedbacks as shwon above?

    C.B

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 23, 2017 at 07:32 PM

    Dear Gernot

    quite helpful hints. For "Change numbers" if the change number exists in target I would assume that ALE should work (but never tried ALE scenario including change numbers)

    C.B.

    Add comment
    10|10000 characters needed characters exceeded