whenever the idoc triggers its contains two lines of record,

[Former Member]

Hi Experts,

In my IDOC INFREC.INFRECMASS01 has two segments E1E1NAM and E1E1NEM.Both the Segments has some fields.In that E1E1NEM segment-WERKS contains two valuse, First its coming with 1010. Second its coming with 1014.So its Second line.So whenever the idoc triggers its contains two lines of record, Each i need to update in JDBC At same time.How? Even i tried SplitByValue with ValueChange its not working.... please help....

Advance Thanks

Arun

[former_member200962]

Map StatementName to WERKS.....each Statement will have one colnam under one access element.

Cannot club it into one Statement node.

Regards,

Abhishek.

[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 .

We are attaching the source xml and the target xml generated from RWB

*Source XML from SXMBMONI :*_

<?xml version="1.0" encoding="UTF-8" ?>

- <INFRECMASS01>

- <IDOC BEGIN="1">

+ <EDI_DC40 SEGMENT="1">

- <E1EINAM SEGMENT="1">

<MSGFN>005</MSGFN>

<INFNR>5300000074</INFNR>

<MATNR>000000000000103260</MATNR>

<LIFNR>0000009000</LIFNR>

<ERDAT>20091116</ERDAT>

<ERNAM>KAPIL</ERNAM>

<MEINS>PK</MEINS>

<UMREZ>10</UMREZ>

<UMREN>1</UMREN>

<TELF1>011-64612814</TELF1>

<MAHN1>0</MAHN1>

<MAHN2>0</MAHN2>

<MAHN3>0</MAHN3>

<URZDT>00000000</URZDT>

<URZLA>IN</URZLA>

<LMEIN>ST</LMEIN>

<REGIO>30</REGIO>

<VABME>1</VABME>

<LTSSF>00000</LTSSF>

<LIFAB>00000000</LIFAB>

<LIFBI>00000000</LIFBI>

<ANZPU>0.000</ANZPU>

<RELIF>X</RELIF>

- <E1EINEM SEGMENT="1">

<MSGFN>005</MSGFN>

<EKORG>1000</EKORG>

<ESOKZ>0</ESOKZ>

<WERKS>1010</WERKS>

<ERDAT>20091116</ERDAT>

<ERNAM>KAPIL</ERNAM>

<EKGRP>101</EKGRP>

<WAERS>INR</WAERS>

<MINBM>0.000</MINBM>

<NORBM>1.000</NORBM>

<APLFZ>0</APLFZ>

<UEBTO>0.0</UEBTO>

<UNTTO>0.0</UNTTO>

<ANGDT>00000000</ANGDT>

<NETPR>0.00</NETPR>

<PEINH>1</PEINH>

<BPRME>PK</BPRME>

<PRDAT>00000000</PRDAT>

<BPUMZ>1</BPUMZ>

<BPUMN>1</BPUMN>

<WEBRE>X</WEBRE>

<EFFPR>0.00</EFFPR>

<MHDRZ>2</MHDRZ>

<BSTMA>0.000</BSTMA>

<STAGING_TIME>0</STAGING_TIME>

</E1EINEM>

- <E1EINEM SEGMENT="1">

<MSGFN>005</MSGFN>

<EKORG>1000</EKORG>

<ESOKZ>0</ESOKZ>

<WERKS>1014</WERKS>

<ERDAT>20091116</ERDAT>

<ERNAM>KAPIL</ERNAM>

<EKGRP>101</EKGRP>

<WAERS>INR</WAERS>

<MINBM>0.000</MINBM>

<NORBM>1.000</NORBM>

<APLFZ>0</APLFZ>

<UEBTO>0.0</UEBTO>

<UNTTO>0.0</UNTTO>

<ANGDT>00000000</ANGDT>

<NETPR>0.00</NETPR>

<PEINH>1</PEINH>

<BPRME>PK</BPRME>

<PRDAT>00000000</PRDAT>

<BPUMZ>1</BPUMZ>

<BPUMN>1</BPUMN>

<WEBRE>X</WEBRE>

<EFFPR>0.00</EFFPR>

<MHDRZ>2</MHDRZ>

<BSTMA>0.000</BSTMA>

<STAGING_TIME>0</STAGING_TIME>

</E1EINEM>

</E1EINAM>

</IDOC>

</INFRECMASS01>

TARGET XML FROM RWB:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_IB_VENDORISL xmlns:ns0="http://VENDORITEMSITELINK_NS">

- <STATEMENTNAME>

- <si_sku_vendor_link ACTION="INSERT">

- <ACCESS>

<Sku_Code>000000000000103260</Sku_Code>

<Location_Code>1010</Location_Code>

<Vendor_Code>0000009000</Vendor_Code>

<Lead_Time>0</Lead_Time>

<Pref_Vendor_Flag>Y</Pref_Vendor_Flag>

<Active_Ind>Y</Active_Ind>

</ACCESS>

</si_sku_vendor_link>

</STATEMENTNAME>

</ns0:MT_IB_VENDORISL>

[former_member187339]

Hi Arun,

Map STATEMENTNAME to WERKS , so that two (or more, based on WERKS) statements are generated

Regards

Suraj

[former_member200962]

Check what is occurence of the StatementName node...maximum occurence should be more than 1.

Then a direct mapping of WERKS to StetementName should be enough.

You cannot directly go for creating multiple access/ column fields as it is not allowed....so you need to create multiple StatementName.

Regards,

Abhishek.

[Former Member]

I think multiple access Tag is still possible provided you Table is the same (Statement)

[former_member200962]

>

> I think multiple access Tag is still possible provided you Table is the same (Statement)

Multiple access tags are not allowed in case of an UPDATE statement!

Regards,

Abhishek.

[former_member187339]

Hi Arun,

It will be good if you show how the target structure (DB side) looks like..

Statement should be mapped to the WERKS field, so that two insert steps can be done.. Check whether your target structure is as shown in this link

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Suraj

[Former Member]

could you give more detail on the mapping