Repeating source field using useOneAsMany function, source field is Z field

[former_member185881]

Hi All

Scenario is IDOC to FILE

Structure is like this:-

E1WPT01 1....999999

FILIALE 0..1

ZTXCL01 0..999999

TAXM1 0..1

ZZTAKLV 0..1 (this is a z field we created)

I want to repeat FILIALE as many times as TAXM1 exist and I got success also.

now the problem is I dont want to use TAXM1 field to define replication, I wanted to use ZZTAKLV field to define replication. But I am not getting success in this.

For TAXM1 it is success but by field ZZTAKLV I am not getting success.

Please suggest me what could be the problem. Is it because of Z field for something else.

I am getting Error: "Too few values in second queue in function useOneAsMany. It must have over all contexts the same number of values as third queue] in class ".

Regards

Dheeraj Kumar

Edited by: Dheeraj Kumar on Nov 16, 2010 5:18 PM

[former_member241146]

Hi.

Follow a help link about it:

[HELP SAP useOneAsMany|http://help.sap.com/saphelp_nw70ehp1/helpdata/en/ef/df564b6aa24fc9ab0d685460747de5/frameset.htm|http://help.sap.com/saphelp_nw70ehp1/helpdata/en/ef/df564b6aa24fc9ab0d685460747de5/frameset.htm]

Best Regards.

Bruno

[prasannakrishna_mynam]

Hi Dheer,

Do check whether the ZZTAKLV is populating in the source structure. Since you are checking for replications using useOneAsMany.

Thanks&Regards,

Prasanna

[former_member185881]

Hi

Yes it is poplulating

Regards

Dheeraj Kumar

[Former Member]

Its nothing to do because of Z field.

I guess th issue is because this field is not repeating as required.

Check the 'Display Queue' for this field.

-Supriya.

[former_member185881]

Hi

When I am testing using test tab I am getting desired result, but when I am triggering an IDOC then I am getting this Runtime exception

"com.sap.aii.utilxi.misc.api.BaseRuntimeException: RuntimeException in Message-Mapping transformation: Runtime exception during processing target field mapping /WPDTAX01_MT/IDOC/TAXDTL/FILIALE. The message is: Exception:[com.sap.aii.mappingtool.tf3.IllegalInstanceException: Too few values in second queue in function useOneAsMany. It must have over all contexts the same number of values as third queue"

Regards

Dheeraj Kumar

[Former Member]

Check for this field if the few values are getting suppressed where they should not.

[prasannakrishna_mynam]

Hi Dheer,

You can able to test it successfully in test tab, because you have control on the occurrence of the Z field, its getting failed at run time because the Z field repetition is missing, check the inbound IDOC payload and see whether the Z filed is populated desired times.

FYI.. You can copy the inbound IDOC payload from moni and test in ESR/IR using test tab.

Thanks & Regards,

Prasanna

Edited by: PrasannaKrishna Mynam on Nov 16, 2010 2:41 PM

[former_member185881]

Hi

It is getting populated. Pasting the Inbound IDOC payload

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

<ZTAXEXT><IDOC BEGIN="1">

<EDI_DC40 SEGMENT="1"><TABNAM>EDI_DC40</TABNAM><MANDT>301</MANDT><DOCNUM>0000000001801242</DOCNUM>

<DOCREL>700</DOCREL><STATUS>30</STATUS><DIRECT>1</DIRECT><OUTMOD>2</OUTMOD>

<IDOCTYP>WPDTAX01</IDOCTYP><CIMTYP>ZTAXEXT</CIMTYP><MESTYP>WPDTAX</MESTYP>

<STDMES>WPDTAX</STDMES><SNDPOR>SAPRED</SNDPOR><SNDPRT>LS</SNDPRT><SNDPRN>REDCLNT301</SNDPRN>

<RCVPOR>XIDCLNT001</RCVPOR><RCVPRT>KU</RCVPRT><RCVPRN>0000000031</RCVPRN>

<CREDAT>20101116</CREDAT><CRETIM>190419</CRETIM><SERIAL>20101116115005</SERIAL>

</EDI_DC40><E1WPT01 SEGMENT="1"><FILIALE>0000000031</FILIALE><AENDKENNZ>MODI</AENDKENNZ><AKTIVDATUM>20101116</AKTIVDATUM>

<AENDDATUM>00000000</AENDDATUM><MWSKZ>AJ</MWSKZ><ZTXCL01 SEGMENT="1"><ZZTAKLV>4</ZZTAKLV></ZTXCL01><ZTXRG01 SEGMENT="1"><WKREG>UP</WKREG><REGIO>UP</REGIO></ZTXRG01><Z1WAD01 SEGMENT="1"><STEUERART1>A</STEUERART1><BEZEICH1>A/R, GST and PST applied</BEZEICH1><SATZ1>0.00</SATZ1></Z1WAD01><E1WPT02 SEGMENT="1"><STEUERART>A</STEUERART><BEZEICH>SALES TAX PAID SALE - OUTPUT</BEZEICH><SATZ>0.00</SATZ></E1WPT02></E1WPT01><E1WPT01 SEGMENT="1"><FILIALE>0000000031</FILIALE><AENDKENNZ>MODI</AENDKENNZ><AKTIVDATUM>20101116</AKTIVDATUM><AENDDATUM>00000000</AENDDATUM><MWSKZ>AY</MWSKZ><ZTXCL01 SEGMENT="1">_<ZZTAKLV>$</ZZTAKLV></_ZTXCL01><ZTXCL01 SEGMENT="1"><ZZTAKLV>%

regards

Dheeraj Kumar

Edited by: Dheeraj Kumar on Nov 16, 2010 7:28 PM

Edited by: Dheeraj Kumar on Nov 16, 2010 7:29 PM

Edited by: Dheeraj Kumar on Nov 16, 2010 7:31 PM

Edited by: Dheeraj Kumar on Nov 16, 2010 7:31 PM