File Xi IDoc scenario

[Former Member]

I am working on File XI Idoc Scenario(Customer master).

The Flat file got picked up by the sender File adapter(File Content Conversion)and I can see the message in the sxmb_moni.

I mapped the Idoc EDI_DC40 field with constants for SNDPRT,SNDPRN,RCVPRT and RCVPRN.

And I mapped the E1KNA1M segment (attribute) =005 (version No) as a constant,

the file structure to E1KNA1M name1,stras,ort01,land1 etc...

But in sxmb_moni when I see the XML payload it looks like this:

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

- <DEBMAS06>

- <IDOC BEGIN="1">

- <EDI_DC40>

<SNDPRT>LS</SNDPRT>

<SNDPRN>SAPSNX</SNDPRN>

<RCVPRT>LS</RCVPRT>

<RCVPRN>SAPSNX</RCVPRN>

</EDI_DC40>

<E1KNA1M SEGMENT="005" />

</IDOC>

</DEBMAS06>

The data from the File structure is not been sent to IDOC.

Experts any idea on this,please help me out.

Thank you,

Mili

[Former Member]

Hi Mili,

Can you tell the source structure and target structure in more detail.

Thanks,

Rajeev Gupta

[Former Member]

Hi,

My source structure is as follows:

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

- <ns:MT_CUSTIN >

- <Rootnode>

- <CustDetails>

<CUSTNAME>Test Company</CUSTNAME>

<CUSTADD>2500 Tobin Drive</CUSTADD>

<CITY>Detroit</CITY>

<STATE>MI</STATE>

<ZIPCODE>48236</ZIPCODE>

<TELEPHONE>313-555-5555</TELEPHONE>

<FAXNUMBER>313-555-5655</FAXNUMBER>

</CustDetails>

</Rootnode>

</ns:MT_CUSTIN>

The target structure is IDoc DEBMAS.

Thank you.

[bhavesh_kantilal]

Mili,

Did you map the Corresponding Target Node? Looks like the segment has not been mapped and so it has not been created. Map your target segment to some contant or to some source field

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

I mapped the target structure segment E1KNA1 Segment to a constant = 005, which is the version number of the segment.

Am I doing something wrong?Please let me know...

Thank you.

[Former Member]

Hi Mili -

I suspect your actual source structure sent from the file adapter doesn't match the Message Type of your source message in mapping. Your mapping appears to be working to a degree, but you're using a lot of constants for the required target fields, masking some potential problems.

Use the payload from MONI (right-click on payload and view source or just download) and test your mapping in the IR using the mapping test tool.

Regards,

Jin

[Former Member]

Hi Jin,

I used the payload from MONI (right-click on payload and view source or just download) and tested mapping in the IR using the mapping test tool.

I am getting Java Null pointer exception.

But when I removed "ns" prefix before the MT_CUSTIN then it is executed successfully without any errors.

My question is how to remove the "ns" prefix from the payload.

I appreciate your help.

Thankyou.

[Former Member]

Hi -

Either blank out your <b>XML Namespace</b> for your Message Type (MT_CUSTIN) or configure the corresponding namespace in your sender file adapter config.

Regards,

Jin

[Former Member]

Hi Jin,

I did add the Document Name and namspace in the File Content Conversion parameters of the Sender File adapter.

I blanked out the XML namespace and tried but have the same error.

But I am getting the same error.

I have changed the File type from Binary to Text (US-ASCII) but of no help.

Any more help is more appreciated.

Thank you.

[Former Member]

Hey Mili

is your sender file in CSV format or XML?if its XML you can simply delete the <ns..> tag

thanx

ahmad

[Former Member]

Mili,

If you blanked out XML Namespace from message type, then you shouldn't put the document name space in the file content conversion.

Either it should be you have both or you have none. I mean if you have XML Namespace in MT then only u need Document Namesapce in Content Conversion. Otherwise you can avoid both these values.

--Archana

[Former Member]

Hi Mili -

After blanking out the namespace in your MT, make sure this is reflected in your mapping. Use Generate Instance in the mapping tool test tab to see if your namespace and prefix still appears (this shouldn't be the case). If so, the removal of the namespace is not reflected in your mapping. Re-drag or populate your MT to the mapping (you may lose some of your existing mappings).

After you generate your instance in mapping test tool, paste the source here.

Regards,

Jin

[Former Member]

I solved the problem.

I apprciate and thank you all for the help.

Thank you.