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

How to prevent syndication of records without remote key

Posted on May 02, 2011 at 12:49 PM 13 Views

Hi Experts,

We had an issue in ECC where the industry sector of existing materials were deleted by an IDOC comming from MDM.

It was found that the industry sector field was mapped in the industry sector remote key, but the remote key in the industries sub table was removed that's why both the XML and the IDOC does not have the industry sector value in it which leads to the deletion of the materials industry sector in ECC.

My question now is how to prevent this in MDM side.

Can we set-up an expression in the syndicator to filter if remote key is missing for the industry sector of a material then no XML file will be generated?

Please advise.

Thanks!

Please note that "Suppress Records Without Key" is already ticked but an XML file is still generated for a material but without the industry sector field.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 02, 2011 at 05:48 PM
    2

    Hey,

    So you just want to suppress syndication when "Industry_Sector" field is blank?

    If yes, then you can simply put a filter in syndication map, Industry_Sector != NULL.

    If that doesn't work, you can always write custom expressions in syndication map.

    Thanks

    Aamir

    Add a comment
    10|10000 characters needed characters exceeded

    • Sowseel P Former Member
      May 03, 2011 at 02:01 PM

      Hi Mike

      Are you using IDOC as data transfer between your MDM and SAP Systems ?

      we can not control the MDM records syndication based on the remote key value exists are not, but we can do control deleting the values in SAP by setting the Default Text property to " / " in your destination items.

      Which means when ever there is no entry in your remote key " / " will be syndicated other wise the remote key value will be syndicated.

      In IDOC Processing " / " will not change any existing value in SAP.

      Hope this will solve your problem.

      Regards

      Sowseel

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2011 at 07:00 AM
    0

    but sowseel :

    suppose there are values for that field - but no key mappings defined ...

    how will syndicator know - that if theres a value for the field but no key mapping defined then it should send a /

    i mean : have u tried this case before ?? works ? just curious to know

    thanks

    -Adrivit

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.