Insert data from xml to file name in Mexico digital invoice

[Former Member]

Hello,

I implement digital invoice for Mexico market.

In this scenario I transfer data from ECC IDOC to XML file via XI.

I'm using already import mapping from SAP (note 1296042).

Now our company in Mexico asks me to add the official order number (its call in Spanish FOLIO number) to the XML file name.

This FOLIO number appears in xml data.

My questions are:

1. Is possible to do it without changing the sap Java mapping that imported from SAP.

2. I'll be happy to here if some of you add the Folio number to the xml file for Mexico digital invoice.

Thank you in advance.

Elad

[Former Member]

I am attempting to make some changes to the standard java mapping. My question is where do I access the java project? In Note 1296042, the class was in a download, but not the project itself. Therefore, I don't have anything to open in a java editor.

[prateek]

Towards the end of Java mapping, you may add another dummy mapping in the Interface Mapping. This mapping would be complete 1 to 1 mapping from same source to target. The only thing it would carry would be Dynamic Configuration to add the official order number in the filename. Then you can use Adapter Specific Message Attributed option in communication channel. The other option as said would be use of variable substitution.

Regards,

Prateek

[Former Member]

Hello,

Thank you for your answers.

I try to use with your advice about variable substitution.

My begging of payload xml is:

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

- <ZINVOIC02>

- <IDOC BEGIN="1">

- <EDI_DC40 SEGMENT="1">

<TABNAM>EDI_DC40</TABNAM>

<MANDT>400</MANDT>

<DOCNUM>0000000006599015</DOCNUM>

<DOCREL>700</DOCREL>

<STATUS>30</STATUS>

<DIRECT>1</DIRECT>

<OUTMOD>2</OUTMOD>

<IDOCTYP>INVOIC02</IDOCTYP>

<CIMTYP>ZINVOIC02</CIMTYP>

<MESTYP>INVOIC</MESTYP>

<STDMES>ZEDI</STDMES>

<SNDPOR>SAPDEV</SNDPOR>

<SNDPRT>LS</SNDPRT>

<SNDPRN>DEV400ECC</SNDPRN>

<RCVPOR>SAPDEV</RCVPOR>

<RCVPRT>LS</RCVPRT>

<RCVPFC>LS</RCVPFC>

<RCVPRN>MX_INV</RCVPRN>

<CREDAT>20100118</CREDAT>

<CRETIM>075931</CRETIM>

<SERIAL>20100118075931</SERIAL>

</EDI_DC40>

- <E1EDK01 SEGMENT="1">

<CURCY>USD</CURCY>

<HWAER>MXN</HWAER>

<WKURS>10.55530</WKURS>

<ZTERM>0090</ZTERM>

<KUNDEUINR>ACH971209KRA</KUNDEUINR>

<BSART>INVO</BSART>

<BELNR>0100017295</BELNR>

<BRGEW>0.045</BRGEW>

<GEWEI>KGM</GEWEI>

<FKART_RL>LR</FKART_RL>

<RECIPNT_NO>0000012977</RECIPNT_NO>

<FKTYP>L</FKTYP>

- <Z1EDK01 SEGMENT="1">

<XML_VERSION>2.0</XML_VERSION>

<ODN_PREFIX>A</ODN_PREFIX>

<ODN_NUMBER>1883</ODN_NUMBER>

<DATE_TIME>2009-11-01T17:05:10</DATE_TIME>

<DOC_SUB_TOTAL>4.22</DOC_SUB_TOTAL>

<DOC_DISCOUNT>3.00</DOC_DISCOUNT>

<DOC_TOTAL>1.40</DOC_TOTAL>

</Z1EDK01>

I try to write this variable without any result

payload:ZINVOIC02,1,IDOC BEGIN,1E1EDK01 SEGMENT,1,Z1EDK01 SEGMENT,1,ODN_NUMBER,1

What wrong in this variable?

Thank you again for your help

Elad

[former_member187339]

Hi Elad,

Try this:

var_filename = payload:ZINVOIC02,1,IDOC,1,E1EDK01,1,Z1EDK01,1,ODN_NUMBER,1

and update the Filename text box with %var_filename%

Regards

Suraj

[Former Member]

Hello,

when I try to change the receiver communication channel configuration

I received in TOC SXMB_MONI

The error: "Acknowledgment contains errors"

Maybe I need to add something to the module section in the communication channel?

Thank you again

Elad

[Former Member]

Do you still need help on this point? Maybe you already solve it.

The official document numbering is fully handled by SAP standar solutions without need to changing of the Java code provided by SAP for Digital Invoice Mexico, you only need to implement a few more notes.

Let me know if you need further details.

Regards,

RP

[Former Member]

Hello Rafael,

Thank you very much about your answer.

The scenario is already in our production system.

Our business team in Mexico asks me to add to the invoice file name convention the invoice number from the XML file content.

If I understand correctly this is not legal requirement and because that this is not include in SAP standard solution.

If I need to response to these needs I need to change manually the Java mapping program.

What to you think about this issue?

Thank you again

Elad

[RaghuVamseedhar]

Hi Elad,

I understand that file name (some part) is coming in target XML after mapping. Then you can use Variable Substitution http://help.sap.com/saphelp_nwpi711/helpdata/en/44/6a316af5a23672e10000000a114a6b/frameset.htm