topic Re: Help required in Transformations (XML Conversion) in Application Development and Automation Discussions

Help required in Transformations (XML Conversion)

Former Member — Wed, 26 May 2010 15:17:04 GMT

Hi All,

Iam using transformations for reading the data from XML to Internal tables. Everything is working fine.

Here my question is, If some tags are missing in the XML file, program is giving error 'TAG XXX is missing'.

I dont want to get this error, if any tag is missing program should take the blank value instead of raising the error.

Please help. thanks.

Regards,

Sreedhar

Re: Help required in Transformations (XML Conversion)

brad_bohn — Wed, 26 May 2010 15:32:41 GMT

You need to set the tag as conditional in your transformation template.

Re: Help required in Transformations (XML Conversion)

Former Member — Wed, 26 May 2010 17:42:31 GMT

Hi,

How you reading data from XML to internal table.

If you are reading it throught DATASET then try and to increse number of lines and you will able to read all tabs.

Ex- READ DATASET FNAME INTO TEXT2 LENGTH 500.

Ashutosh

Re: Help required in Transformations (XML Conversion)

Former Member — Thu, 27 May 2010 05:42:17 GMT

Please let me know how to make tags as conditional in transformations...

Re: Help required in Transformations (XML Conversion)

brad_bohn — Thu, 27 May 2010 13:16:27 GMT

You can find the syntax for all of the conditional operators in the help files for transformations, but here's an example:


        <tt:cond frq="?">
          <NODE>
            <tt:value ref="NODE"/>
          </NODE>
        </tt:cond>

Re: Help required in Transformations (XML Conversion)

Former Member — Thu, 27 May 2010 13:33:04 GMT

Hi,

I have done the changes using the condition..but its working if we have the condition for only one Node..if we put the condition for more Nodes its giving error. I have put the below condition.

<tt:s-cond check="not-initial($ref.copy)">

<tt:value ref="$ref.copy"/>

</COPYINDICATOR>

</tt:s-cond>

if i use the condition only for any of one node its working..if i write the code like below

<tt:s-cond check="not-initial($ref.copy)">

<tt:value ref="$ref.copy"/>

</COPYINDICATOR>

</tt:s-cond>

<tt:s-cond check="not-initial($ref.lcn)">

<LCN>

<tt:value ref="$ref.lcn"/>

</LCN>

</tt:s-cond>

its giving me error saying that some Element is missing..but actually that element is present in XML. Please advice

Re: Help required in Transformations (XML Conversion)

brad_bohn — Thu, 27 May 2010 13:48:57 GMT

Unfortunately, I don't have any idea how your XML is formed. Keep in mind that 's-' is for serialization while you are deserializing, and if you need to initiate a loop process, you need to use 'tt:group'.

Re: Help required in Transformations (XML Conversion)

Former Member — Thu, 27 May 2010 13:52:56 GMT

Hi,

My transformation is as below... Please let me know you mail ID so that i will send XML format

<?sap.transform simple?>

<tt:transform xmlns:tt="http://www.sap.com/transformation-templates" template="temp">

<tt:root name="ROOT"/>

<tt:template name="temp">

<tt:loop ref="ROOT">

<tt:value ref="$ref.profile"/>

</PROFILEID>

<tt:s-cond check="not-initial($ref.bol)">

<BOLID>

<tt:value ref="$ref.bol"/>

</BOLID>

</tt:s-cond>

<tt:s-cond check="not-initial($ref.copy)">

<tt:value ref="$ref.copy"/>

</COPYINDICATOR>

</tt:s-cond>

<tt:s-cond check="not-initial($ref.lcn)">

<LCN>

<tt:value ref="$ref.lcn"/>

</LCN>

</tt:s-cond>

<tt:s-cond check="not-initial($ref.gwm)">

<GWM>

<tt:value ref="$ref.gwm"/>

</GWM>

</tt:s-cond>

<tt:s-cond check="not-initial($ref.pro)">

<PROID>

<tt:value ref="$ref.pro"/>

</PROID>

</tt:s-cond>

<tt:s-cond check="not-initial($ref.dac)">

<DAC>

<tt:value ref="$ref.dac"/>

</DAC>

</tt:s-cond>

<DOCUMENT_CONF>

<tt:s-cond check="not-initial($ref.trailer)">

<tt:value ref="$ref.trailer"/>

</TRAILERID>

</tt:s-cond>

<tt:s-cond check="not-initial($ref.scac)">

<tt:value ref="$ref.scac"/>

</SCACCODE>

</tt:s-cond>

</DOCUMENT_CONF>

<tt:loop name="details" ref="$ref.details">

<DESPATCH_CONF>

<tt:s-cond check="not-initial($details.po)">

<PO_CONF>

<tt:value ref="$details.po"/>

</PO_CONF>

</tt:s-cond>

<tt:s-cond check="not-initial($details.item)">

<ITEMID_CONF>

<tt:value ref="$details.item"/>

</ITEMID_CONF>

</tt:s-cond>

<SHIPMENT_CONF>

<tt:s-cond check="not-initial($details.matnr)">

<tt:value ref="$details.matnr"/>

</MATERAIL>

</tt:s-cond>

<tt:s-cond check="not-initial($details.tiq)">

<TIQ>

<tt:value ref="$details.tiq"/>

</TIQ>

</tt:s-cond>

<tt:s-cond check="not-initial($details.packing)">

<tt:value ref="$details.packing"/>

</PACKINGSLIP>

</tt:s-cond>

<tt:loop name="serial" ref="$ref.serial">

<THU_CONF>

<tt:s-cond check="not-initial($serial.sernr)">

<SERNR>

<tt:value ref="$serial.sernr"/>

</SERNR>

</tt:s-cond>

</THU_CONF>

</tt:loop>

</SHIPMENT_CONF>

</DESPATCH_CONF>

</tt:loop>

</DESPATCHADVICE>

</tt:loop>

</tt:template>

</tt:transform>

We are reading the data from XML..Please suggest.. Please let me know how to use <tt:group>

Edited by: Sreedhar841 on May 27, 2010 4:09 PM