idoc to jdbc :On the basis of field WERKS, the child segments should get re

[Former Member]

We are working on IDOC to JDBC scenario.

In my IDOC INFREC.INFRECMASS01 has one segment E1E1NAM( parent segment), inside this parent segment we have one child segment E1E1NEM containing two lines. On the basis of one field WERKS, the child segments should get repeated in the target but in the target side we are getting only one of the values of WERKS .

We have used SPLIT BY VALUE(each value) on WERKS but still only one of the values are coming on the target side .

pl help

rgds

arun

[former_member200962 · Accepted solution]

If possible can you post the mapping logic and the source structure (payload) either in this post or the earlier one

[Former Member · Accepted solution]

we tried to map WERKS with STATEMENTNAME whose occurance is 1 to unboounded , using SPLITBYVALUE , along with target field but its not working

WERKS->SPLITBYVALUE->STATEMENTNAME

WERKS->SPLITBYVALUE->LOCATION_CODE(target field)

pl some more inputs

[Former Member · Accepted solution]

u need to change the context of WERKS field

if ur struct is this

E1E1NAM>E1E1NEM>WERKS

change the context of WERKS to E1E1NAM when u map to Statement. remove the split by value for both mappings

can u paste ur Source/Target structures

[Former Member · Accepted solution]

Hi Arvind,

what do we need to set as context:

1) E1EINEM

2)E1EINAM

3)IDOC

4)INFRECMASS01

Pl suggest

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

ahi arvind ,

i sent the source /target every thing in ur rediffmail id , we tried to change the context of WERKS TO E1EINAM ,removed split by value , but got an error

Cannot produce target element /ns0:MT_IB_VENDORISL/STATEMENTNAME[2]/si_sku_vendor_link/ACCESS. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd

pl suggest ...

rgds

arun

[former_member200962 · Accepted solution]

You changed the context of WERKS....fine....accordingly the context needs to be handled for all the lower nodes of StatementName.

If you dont do it then the target node wont be produced....it will be produced only for the first instance....rest of the occurences wont be considered.

Regards,

Abhishek.

[abhijitbolakhe]

Hi

use Node function 'useOneAsMany' to repeat the header for each line item.

pls check the following link

http://help.sap.com/saphelp_nw04/helpdata/en/ef/df564b6aa24fc9ab0d685460747de5/content.htm

Regards

Abhijit

[Former Member]

it depends on your mapping. your access/statement tag has to be of multiple occurrence and oyu need to map the WERKS to this as well along with mapping to your tagrget field

You can close the previous post if you use this...

[Former Member]

HI Arvind,

Thanks. Problem solved with your suggestion. Here am mapped with Access to my changing segments.

Thanks

Arun