on 12-04-2012 9:54 AM
hi All,
I have a structure as shown below which needs to be converted into a flatfile. this is a case of XML to plain file in receiver AS2 channel.
Content to be converted :-
ANF 00 22 DANZAS-KR KRE STA 0002 03122012 152115 0000000 HEA 00000 0 AE U 871120080012 0008001
</Data>
</RecordSet>
</ns1:MaterialMasterDataToLVS>
As you can see above, inside Data there are three fields(SENDER_GLN,RECEIVER_GLN & MESSAGE_TYPE) and one text part which is the actual value of Data (ANF 00 22 DANZAS-KR KRE STA 0002 03122012 152115 0000000 HEA 00000 0 AE U 871120080012 0008001)
I need the output to be as below :-
ANF 00 22 DANZAS-KR KRE STA 0002 03122012 152115 0000000 HEA 00000 0 AE U 871120080012 0008001
That is i need to remove the other three fields. Is this possible? I tried using fieldlengthtooshorthandling - "Cut" as per Sravya's blog but it doesnt seem to work. http://scn.sap.com/people/sravya.talanki2/blog/2005/08/11/solution-to-the-problem-encountered-using-...
Also i cannot use a Java or XSLT to remove the 3 fields.
Regards,
Ninu
Hello Ninu,
I have never come across an xml file that contains child elements AND data in one element.
Is it a valid XML structure?
Would it be possible to change the source structure?
E.g. you could introduce a new child element <DATA> below the <Data> element after the <MESSAGE_TYPE>.
Or you could convert the three child elements into attributes of the <Data> element.
Regards,
Jürgen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi all,
I couldnt handle it as text . So had to use a node for the text field as well.
Regards,
Ninu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
You can try this:
1. Edit your message mapping
2. Right-click the field and then select disable field, do this for the three fields.
3. Save and activate
Hope this helps,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.