Multi Mapping Problem?

[Former Member]

My scenario is File-To-RFC. I am sending One Header Multiple Line items. My source sturcture is as follows:

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

<ns0:MT_FIGL_JVUpload xmlns:ns0="urn:ccc:FIGL">

<VersionRecord>

<RecordType>VER</RecordType>

<VersionKey>PJ2006.00</VersionKey>

</VersionRecord>

<ControlRecord>

<RecordType>CTL</RecordType>

<UserID>aaa</UserID>

<SystemID>bbb</SystemID>

<TimeStamp>1530</TimeStamp>

<Description>FirstHeader</Description>

<Email>Abc@xyz.com</Email>

</ControlRecord>

<THeader>

<HeaderItems>

<RecordType>HDR</RecordType>

<DocumentDate>10/10/2006</DocumentDate>

<PostingDate>10/10/2006</PostingDate>

<PostingPeriod>hh</PostingPeriod>

<DocumentType>ee</DocumentType>

<CompanyCode>OFX</CompanyCode>

<ReferenceDocumentNumber>kkk</ReferenceDocumentNumber>

<Currency>USD</Currency>

<DocumentHeaderText>iii</DocumentHeaderText>

</HeaderItems>

</THeader>

<TLines>

<LineItems>

<RecordType>DTL</RecordType>

<PostingKey>40</PostingKey>

<GLAccount>5002</GLAccount>

<Amount>25000</Amount>

<FMFund>40</FMFund>

<BusinessArea>66</BusinessArea>

<CostCenter>777</CostCenter>

<InternalWorkOrder/>

<WBSElement>888</WBSElement>

<Description>Test One</Description>

</LineItems>

<LineItems>

<RecordType>DTL</RecordType>

<PostingKey>40</PostingKey>

<GLAccount>5002</GLAccount>

<Amount>25000</Amount>

<FMFund>40</FMFund>

<BusinessArea>66</BusinessArea>

<CostCenter>777</CostCenter>

<InternalWorkOrder/>

<WBSElement>888</WBSElement>

<Description>Test Two</Description>

</LineItems>

</TLines>

<SummaryRecord>

<RecordType>END</RecordType>

<TotalDebits>00200.2000</TotalDebits>

<TotalCredits>00200.2000</TotalCredits>

<Balance>0000000.0000</Balance>

<TotalLines>2</TotalLines>

</SummaryRecord>

</ns0:MT_FIGL_JVUpload>

On the Inbound side I am importing RFC. I have given the sender communicaiton channel parameters as:

DocumentName : MT_FIGL

Document Namespace : urn:xxx:FIGL

Recordset Structure : VersionRecord,1,ControlRecord,1,HeaderItems,1,LineItems,*,SummaryRecord,1

Recordset Sequence : Ascending

Key Field Name : RecordType

VersionRecord.fieldNames : RecordType,VersionKey

VersionRecord.fieldFixedLengths : 4,9

VersionRecord.keyFieldValu : VER

VersionRecord.endSeparator : 'nl'

ControlRecord.fieldNames : RecordType,UserID,SystemID,TimeStamp,Description,Email

ControlRecord.fieldFixedLengths : 4,20,3,19,30,150

ControlRecord.keyFieldValue : RecordType,DocumentDate,PostingDate,PostingPeriod,DocumentType,CompanyCode,ReferenceDocumentNumber,Currency,DocumentHeaderText

HeaderItems.fieldFixedLengths : 4,8,8,2,2,4,16,5,25

HeaderItems.keyFieldValue : HDR

LineItems.fieldNames : RecordType,PostingKey,GLAccount,Amount,FMFund,BusinessArea,CostCenter,InternalWorkOrder,WBSElement,Description

LineItems.fieldFixedLengths : 4,2,6,13,8,2,10,10,24,50

LineItems.endSeparator : 'nl'

LineItems.keyFieldValue : DTL

SummaryRecord.fieldNames : RecordType,TotalDebits,TotalCredits,Balance,TotalLines

SummaryRecord.fieldFixedLengths : 4,15,15,18,10

SummaryRecord.keyFieldValue : END

SummaryRecord.endSeparator : 'nl'

It does pick the file but says mapping exception. Let me know what are the changes I have to make.

[former_member8655]

Hi Satish

I feel the problem is with the structure which is generated after conversion.

check the format of structure that is produced after conversion

check the following link

http://help.sap.com/saphelp_nw2004s/helpdata/en/e3/94007075cae04f930cc4c034e411e1/frameset.htm

[moorthy]

Satish,

Try to get the xml input from the SXMB_MONI and test the same in the Design ->Mapping.

I think there is a prolem with XML input.

Check out this with only one line item first. Then check for mulltiple line items

Hope this helps to findout the error.

Regards,

Moorthy

[Former Member]

Krishna

The XML file works for multiple line items also. I think there is a problem with file content conversion. If I send XML instead of file it works fine. So help me out with content conversion.

[moorthy]

If you have a content conversion problem, then you will not get the message. That's reason, I told you to test the Message from the Inbound Message from the SXMB_MONI.

Is this works for you ? without changing anything in the xml file ?

This xml is output of Content COnversion right ?

Hope this helps,

regards,

Moorthy

[Former Member]

Hi,

Looks like you have specified the wong document name in the content conversion. The document name should be MT_FIGL_JVUpload right? and not MT_FIGL

Regards,

Smitha.

[former_member184154]

I got a solution for your issue!

The problem is keyFieldValue: I bet you specifed just 3 chars (e.g. "CTL") while you're structure declares keyFields with a length of 4!!! So the right specification is "CTL " (<b>with a space at the end</b>)

AND THAT'S THE SAME STORY FOR ALL RECORD TYPES!

Then you'll see that also with LineItems,* it's perfectly workin'

Take care,

Alex

[Former Member]

Alex

Its working now alex. First of all let me thank you for your immense support and patience which you have shown for resolving this issue. This is a lesson to all guys who are new to SDN how the experienced XI guys in SDN take their time to solve the issues. He has taken around 07hrs of his valuable time to resolve this issue. I am good to be in this part of the world.

---Satish