File Content Conversion problem

[Former Member]

HI Gurus

we have the following message type :

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

- <ns1:MT_BaanSO850_1 xmlns:ns1="xxxxxxxxxxxxx.com:MCG:BAAN0232:SAP_PO_to_BAAN_SO">

- <BaanSO850_1>

<OurRefrence>"C1221205100001"</OurRefrence> <OurIdentification>"sap122"</OurIdentification> <PurchaseOrder>5100000043</PurchaseOrder> <NetworkAddress>"sap122"</NetworkAddress> <CodeInMessage>"SAP"</CodeInMessage> <CodeInMessage1>"850"</CodeInMessage1> <OrderType>"ZICP"</OrderType> <Constant>""</Constant> <Currentdate>120510</Currentdate> <currentTime>0729</currentTime> <Timestamp>120510 _07</Timestamp>

</BaanSO850_1>

</ns1:MT_BaanSO850_1>

in the content conversion parametres

I've used the following :

Recordset structure: BaanSO850_1

BaanSO850_1.addHeaderLine    0

BaanSO850_1.fieldSeparator    :

BaanSO850_1.fieldNames     OurRefrence,OurIdentification,PurchaseOrder,NetworkAddress,CodeInMessage,CodeInMessage1,OrderType,Constant,Currentdate,currentTime

BaanSO850_1.endSeparator    'nl'

BaanSO850_1.fixedLengthTooShortHandling    Ignore

Problem is : I  dont want Timestamp field in the target , which is present in the message type (as can be seen above ) but in the target I am getting the timestamp also which i dont want .

Please let me know which other parameters i need to use or remove in order to achieve the objective.

Regards

Rahman

[former_member184681 · Accepted solution]

Hi Rahman,

This can't be done with FCC. To reach your goal, delete the unwanted field from the target structure definition, or (if it has occurrence 0..1, so it's optional) make sure that it gets no value during mapping - it won't be put into the result file thanks to that.

Regards,

Greg

[Former Member · Accepted solution]

HI Greg/Fabio

The problem is I am using this filed " Timestamp" for variable substitution so i need the value of this field in mapping but at the same time i don't want it in the target file .

Please suggest

Regards

Rahman

[former_member184681 · Accepted solution]

Dear Rahman,

Do you use mapping in your scenario, or it's just a pass-through? If you have mapping, use ASMA & Dynamic Configuration to set the file name, and thanks to that - you can eliminate the Timestamp from target structure, as it's no longer required for Variable Substitution.

Regards,

Greg

[Former Member · Accepted solution]

Hi,

If in case u still want to go with variable substitution then chk below thread (madhu's reply)

http://scn.sap.com/thread/1708974

Thanks

Amit Srivastava

[Former Member · Accepted solution]

Hi,

use UDF to generate dynamic file name

Fabio

[Former Member · Accepted solution]

Hi,

Create another node, under that node(FileNode) create one filename element like Filename. Use content conversion like below

FileNode.fieldFixedLengths  0

FileNode.fixedLengthTooShortHandling  Cut

FileNode.endSeparator  '0'

the above content conversion will not generate new line.

thanks,

http://scn.sap.com/thread/1708974-- taken from this discussion

[Former Member]

Hi,

you can not map the field in message mapping.

Fabio