on 09-11-2007 8:17 PM
In text file to text file I have the following given input/output
Input structure is this:
<?xml version="1.0" encoding="UTF-8"?>
<ns:MT_SEND xmlns:ns="http://comp.com/sap">
<Recordset>
<Record>
<FIELD1>
<FIELD2>
<FIELD3>
</Record>
</Recordset>
</ns:MT_SEND>
Output structure is this:
<ns:MT_RECV xmlns:ns="http://comp.com/sap">
<Recordset>
<Header>
<field1>
<field2>
<field3>
</Header>
<Record>
<field4>
<field5>
<field6>
</Record>
</Recordset>
</ns:MT_RECV>
It is simple 1 to 1 mapping Record(SEND) to Record (RECV)
All Header fields are Constants: c1,c2,c3
All fields are strings.
The intput text file is fixed length:
Field4(5 char) Field3(char4) Field2(char3)
The desired output text file is fixed length:
field1( 8 char) field2(7 char) field3(6 char) field4(5 char) field3(char4) field2(char3)
Can someone please asap send me the right Content Conversions parameters for Receiver and Sender file adapters ?Please be specific when giving me Recordset, name, values,etc I will appreciate it...
p.s.Please do not send me sap help links docs, and sdn blogs I know all of them unfortunately the docs were not able to help me in my case. Please send me the exact parameter settings for the case described above.
Thanks!
Jon
Hi,
The FCC for the sender file adapter is,
Document Name : MT_SEND
Document Namespace : http://comp.com/sap
Recordset Name : Recordset
RecordSet Structure: Record,*
Record.endSeperator = 'nl'
Record.fieldName = field1,field2,field3.
Record.fixedFieldLength = 5,4,3.
This would convert the input flat file to the XML.
Map the constants to the target fields field1,field2,field3 and
the input XML foeld field1,field2&field3 to the target field field4,field5%field6.
Hope this helps....
Regards
San
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
RecordSet Structure: Header,Record
Parameter Value
Header.fieldFixedLengths 8,7,6
Record.fieldFixedLengths 5,4,3
Record.endSeparator 'nl'
Header.endSeparator 'nl'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The output structure must be:
<ns:MT_RECV xmlns:ns="http://comp.com/sap">
<Recordset>
<Record>
<field1>
<field2>
<field3>
<field4>
<field5>
<field6>
</Record>
</Recordset>
</ns:MT_RECV>
Now it should be easy to derive the channel config from the documents that you have already found
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.