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

How can I output multiple IDOC messages in one dataflow in DS 3.2?

Hi, we are trying to load some business partner data into CRM through an IDOC. The specific IDOC we are attempting to use is CRMXIF_PARTNER_SAVE_M02. We successfully created a Data Services flow which takes input from a file and can write out an IDOC message which updates the record in CRM. The problem is that we can only manage to run this job for one record at a time - if the file we are using for input contains 2 or more records (2 or more business partners which we are trying to update), then the batch job fails with the error message:

IDoc Error: Message: Adding this segment exceeds maximum allowed number of repetition E101CRMXIF_PARTNER_KEYS

I'm guessing from this error message that it is trying to shove both business partner records into one IDOC which is not supported by this IDOC. Instead what we want it to do is send 2 IDOC messages to the server, one per business partner.

Does anyone have any suggestions on how we can make this work?

Thanks

-Trevor

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Feb 12, 2010 at 08:27 AM

    Imagine I have a simple source with a list of PARTNERS and want to load that as an IDOC. IDOC means nested, so I have to create the NRDM - the schemas. Big question is about the from clauses for each schema level.

    The schema shall be simplified a

    IDOC_ROOT
    +-- PARTNERS (schema)
          KEY_FIELD
          NAME_FIELD
    

    One option would be to set the FROM clause of the IDOC_ROOT to Row_Generation as input and the PARTNERS schema to the source file. In other words, you would get one IDOC with n PARTNER records.....and the error.

    If you swap these two, IDOC_ROOT has as FROM the source table, and PARTNERS the Row_Gen, it would mean n IDOCs with one row in the PARTNERS schema.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2013 at 12:04 AM

    Hi Werner,

    I am trying to load data into SAP for Functional Locations Domain using the 'FUNC_LOC_CHANGE' IDOC in Data Services and I am getting the following error.

    8236 7776 R3C-244005 2013/02/27 4:52:36 PM |Data flow DF_ChangeIDOC|Loader FUNC_LOC_CHANGE01 8236 7776 R3C-244005 2013/02/27 4:52:36 PM IDoc target tried to generate IDoc <FUNC_LOC_CHANGE01> from NRDM data: < 8236 7776 R3C-244005 2013/02/27 4:52:36 PM IDoc Error: Message: CIDocIterator::Field: No datarecord available for this segment type 8236 7776 R3C-244005 2013/02/27 4:52:36 PM IDoc Type: FUNC_LOC_CHANGE01 8236 7776 R3C-244005 2013/02/27 4:52:36 PM Release: 731 8236 7776 R3C-244005 2013/02/27 4:52:36 PM IDoc Number: Not Applicable 8236 7776 R3C-244005 2013/02/27 4:52:36 PM Segment Name: 8236 7776 R3C-244005 2013/02/27 4:52:36 PM Segment Type: 8236 7776 R3C-244005 2013/02/27 4:52:36 PM Field Name: FUNCTLOCATION 8236 7776 R3C-244005 2013/02/27 4:52:36 PM >. Check your input data. 6992 8284 R3C-244005 2013/02/27 4:52:46 PM |Data flow DF_ChangeIDOC|Loader FUNC_LOC_CHANGE01 6992 8284 R3C-244005 2013/02/27 4:52:46 PM IDoc target tried to generate IDoc <FUNC_LOC_CHANGE01> from NRDM data: < 6992 8284 R3C-244005 2013/02/27 4:52:46 PM IDoc Error: Message: CIDocIterator::Field: No datarecord available for this segment type 6992 8284 R3C-244005 2013/02/27 4:52:46 PM IDoc Type: FUNC_LOC_CHANGE01 6992 8284 R3C-244005 2013/02/27 4:52:46 PM Release: 731 6992 8284 R3C-244005 2013/02/27 4:52:46 PM IDoc Number: Not Applicable 6992 8284 R3C-244005 2013/02/27 4:52:46 PM Segment Name: 6992 8284 R3C-244005 2013/02/27 4:52:46 PM Segment Type: 6992 8284 R3C-244005 2013/02/27 4:52:46 PM Field Name: FUNCTLOCATION 6992 8284 R3C-244005 2013/02/27 4:52:46 PM >. Check your input data.

    I am trying to update the ABCIndicator from 2 to 3 and hence have set the Flag to X in the source table as well. I have updated the EDI_DC40 mandatory schema with the necessary values and mapped the values to the schemas in the IDOC

    E1FUNC_LOC_CHANGE - from the source table

    and sub schemas

    E1BP_ITOB - some from the source table and other values to NULL

    E1BP_ITOBX - FLAG X to the ABC Indicator from Source table and all others to NULL

    E1BP_ITOB_FL_ONLY - NULL for Everything

    E1BP_ITOB_FL_ONLYX - NUll for everything

    I have tried to play around the FROM cluase in the query as well as UNnesting...all of them failed to resolve the issue...Can you please suggest me where I am going Wrong..

    Thanks

    Chan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I get this error when I remove unnesting

      3056 7988 R3C-244005 2013/02/27 5:13:55 PM |Data flow DF_ChangeIDOC|Loader FUNC_LOC_CHANGE01 3056 7988 R3C-244005 2013/02/27 5:13:55 PM IDoc target tried to generate IDoc <FUNC_LOC_CHANGE01> from NRDM data: < 3056 7988 R3C-244005 2013/02/27 5:13:55 PM IDoc Error: Message: Adding this segment exceeds maximum allowed number of repetition E1BP_ITOB 3056 7988 R3C-244005 2013/02/27 5:13:55 PM IDoc Type: FUNC_LOC_CHANGE01 3056 7988 R3C-244005 2013/02/27 5:13:55 PM Release: 731 3056 7988 R3C-244005 2013/02/27 5:13:55 PM IDoc Number: 3056 7988 R3C-244005 2013/02/27 5:13:55 PM Segment Name: Not Applicable 3056 7988 R3C-244005 2013/02/27 5:13:55 PM Segment Type: E1BP_ITOB 3056 7988 R3C-244005 2013/02/27 5:13:55 PM Field Name: Not Applicable 3056 7988 R3C-244005 2013/02/27 5:13:55 PM >. Check your input data. 7180 144 R3C-244005 2013/02/27 5:14:05 PM |Data flow DF_ChangeIDOC|Loader FUNC_LOC_CHANGE01 7180 144 R3C-244005 2013/02/27 5:14:05 PM IDoc target tried to generate IDoc <FUNC_LOC_CHANGE01> from NRDM data: < 7180 144 R3C-244005 2013/02/27 5:14:05 PM IDoc Error: Message: Adding this segment exceeds maximum allowed number of repetition E1BP_ITOB 7180 144 R3C-244005 2013/02/27 5:14:05 PM IDoc Type: FUNC_LOC_CHANGE01 7180 144 R3C-244005 2013/02/27 5:14:05 PM Release: 731 7180 144 R3C-244005 2013/02/27 5:14:05 PM IDoc Number: 7180 144 R3C-244005 2013/02/27 5:14:05 PM Segment Name: Not Applicable 7180 144 R3C-244005 2013/02/27 5:14:05 PM Segment Type: E1BP_ITOB 7180 144 R3C-244005 2013/02/27 5:14:05 PM Field Name: Not Applicable 7180 144 R3C-244005 2013/02/27 5:14:05 PM >. Check your input data.

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.