File to IDOC - multiple source fields to 1 field

[Former Member]

Hello,

I implement scenario from file to IDOC.

In source side I have 2 fields (in different levels) that I want to map to 1 field in the IDOC.

Is it possible to do it? And how?

Regards

Elad

[Former Member · Accepted solution]

Hi,

In message mapping you need to use concatenate from text functions.

Best regards,

Voytech

[Former Member · Accepted solution]

Hello,

The sorce file is xml:

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

<PLM_Out_MT>

<Quotation/>

<TransactionHeader>

<TransDateTime/>

<Sender/>

<Receiver/>

</TransactionHeader>

<QuotationHeader>

<DocTyp/>

<ContractNo/>

<PurcNo/>

<PurcDat/>

<ValToDate/>

<GenHeadText/>

<PlmUser/>

</QuotationHeader>

<QuotationLines>

<QuotationLine>

<ItemNum/>

<ItemCat/>

<Quantity/>

<ReqDelDate/>

<OrgReqDate/>

<Version/>

<QuotationTexts>

<QuotationText>

<TEXT_ID/>

<TEXT_LINE/>

</QuotationText>

</QuotationTexts>

</QuotationLine>

</QuotationLines>

</PLM_Out_MT>

The target is:

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

<ZCUSTQUOT_WITH_REF01><IDOC BEGIN="1"><Z1ZCUSTQUOT_WITH_REF SEGMENT="1"><E1BPSDHD1 SEGMENT="1"><DOC_TYPE></DOC_TYPE><PURCH_DATE></PURCH_DATE><PP_SEARCH></PP_SEARCH><REF_DOC></REF_DOC></E1BPSDHD1><E1BPSDITM SEGMENT="1"><ITM_NUMBER></ITM_NUMBER><MATERIAL></MATERIAL></E1BPSDITM><E1BPSCHDL SEGMENT="1"><ITM_NUMBER></ITM_NUMBER><REQ_QTY></REQ_QTY></E1BPSCHDL><E1BPSDTEXT SEGMENT="1"><ITM_NUMBER></ITM_NUMBER><TEXT_ID></TEXT_ID><TEXT_LINE></TEXT_LINE></E1BPSDTEXT></Z1ZCUSTQUOT_WITH_REF></IDOC></ZCUSTQUOT_WITH_REF01>

I need to map in the first time from <GenHeadText/> to <TEXT_LINE> and in the second time from <TEXT_LINE/> to <TEXT_LINE>

Is not possibole to use with concatenate because i need all the time to map diffrebt field.

Elad

[Former Member · Accepted solution]

in this case please select duplicate subtree on target field and map that.

/wg

[deepak_shah · Accepted solution]

HI

u can map 2 differnt source fields ie GenHeadText and TEXT_LINE to TEXT_LINE in the idoc..

one way of doing it as follows

since u r using a 'Z 'iodc ie ZCUSTQUOT_WITH_REF01

check what is the occurenc of the node E1BPSDTEXT .

if it can occur more than once the duplicate it.

then in first occurence u can map GenHeadText to TEXT_LINE of the idoc and in second occurence u can map TEXT_LINE to TEXT_LINE of the idoc.

hope this will solve ur problem

[Jitendra_Jeswan]

Yes you can defnately do this.

However I would like to know the Occurance of the fields in question and their Parent segment Occurance.

then I will be bale to tell you the Solution

Regards.

[Former Member]

Hi Elad,

You need to map two source IDOC fields to single target fields.

But that will be possible if incase you maintaine the same target field twice in the target structure at different levels.

OR based on conditions you could map any of the field.

Please give me some more details about the both end structures so I could narrow down the analysis and able to give precise answer

thanks

Swarup