topic Re: Simple Transformation Problem in Application Development and Automation Discussions

Simple Transformation Problem

dmi — Fri, 08 Dec 2017 06:15:07 GMT

hello

I got the requirement to export data from a sap table to a xml file. The xml file must be in the followed form:

<StoreMaterial>
  <Material Name="ArticleNb" Value="value from SAP"/>
  <Material Name="MatDesc" Value="value from SAP"/>
</StoreMaterial>

What is the correct syntax to create this node in one line:
<Material Name="ArticleNb" Value="value from SAP" />

value from SAP is e.g. a material number

many thanks Daniel

Re: Simple Transformation Problem

Sandra_Rossi — Fri, 08 Dec 2017 08:17:06 GMT

Did you try anything? What is the structure of your internal table?

Something like that:

<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates" xmlns:ddic="http://www.sap.com/abapxml/types/dictionary">
  <tt:root name="ROOT"/>
  <tt:template>
    <XMLROOT>
      <tt:loop ref=".ROOT">
        <StoreMaterial>
         <Material Name="ArticleNb">
          <tt:attribute name="Value" value-ref="$ref.ARTICLENB"/>
          </Material>
         <Material Name="MatDesc">
          <tt:attribute name="Value" value-ref="$ref.MATDESC"/>
          </Material>
        </StoreMaterial>
      </tt:loop>
    </XMLROOT>
  </tt:template>
</tt:transform>

EDIT 15 hours later: sorry, it was value-ref, not ref.

Re: Simple Transformation Problem

dmi — Fri, 08 Dec 2017 10:12:17 GMT

Hello Sandra
I tryed with text, it looks like what I need, but there is no cr between the nodes ArticleNb and MatDesc
It's possible to make a line feed?
Thank you in advance, Daniel

        <StoreMaterial>
          <tt:loop name="data" ref="$line.data">

            <tt:text>Material Name = "ArticleNb" Value="</tt:text>
            <tt:value ref="articlenb"/>
            <tt:text>"</tt:text>
            
            <tt:text>Material Name = "MatDesc" Value="</tt:text>
            <tt:value ref="matdesc"/>
            <tt:text>"</tt:text>

          </tt:loop>
        </StoreMaterial>

Re: Simple Transformation Problem

dmi — Fri, 08 Dec 2017 12:14:45 GMT

Now I found the solution - but???
The first Node "ArticleNb" is not correct, the next nodes are correct
If I delete the first Node "ArticleNb", the next nodes are not correct
I can't find out the reason, thanks for any help
Daniel

<StoreMaterial>
  <tt:loop name="data" ref="$line.data">
    <Material Value="ArticleNb">        " display wrong
      <tt:attribute name="Name">
        <tt:value ref="articlenb"/>
      </tt:attribute>
    </Material>
    <Material Name="ArticleNb">         " display correct
      <tt:attribute name="Value">
        <tt:value ref="articlenb"/>
      </tt:attribute>
    </Material>
    <Material Name="MatDesc">          " display correct
      <tt:attribute name="Value">
        <tt:value ref="matdesc"/>
      </tt:attribute>
    </Material>
  </tt:loop>
</StoreMaterial>

Re: Simple Transformation Problem

former_member443654 — Fri, 08 Dec 2017 14:44:38 GMT

Hi Daniel,

Ideally Creating a node is important for correct output.please check with the node and the structure how your are refering in the coding part.Check with the screen shot may be this would helpful.You can also have test transformation T-Code : XSLT_TOOL give transformation name as SP12_TESTVECTOR2.

capture.png

Re: Simple Transformation Problem

Sandra_Rossi — Fri, 08 Dec 2017 22:30:29 GMT

I tried your example and have no issue if I remove the first <Material ... </Material>

Re: Simple Transformation Problem

Former Member — Sat, 09 Dec 2017 07:42:48 GMT

Hi Daniel in ST you can create a corresponding DDIC structure and the base ST code is generated when u use it in STRANS.

Then you can improve it further. both for deserelization and serilization.

Re: Simple Transformation Problem

dmi — Sat, 09 Dec 2017 14:52:54 GMT

Hi Prasenjit
Thanks for help, but all what I need is a solution to create a xml in this form:

Normal XML:
 <ArticleNb>123456789</ArticleNb>
  <MatDesc>somthing</Matdesc>

My requirement:
  <Material Name="ArticleNb" Value="123456789"/>
  <Material Name="MatDesc" Value="something"/>

Re: Simple Transformation Problem

dmi — Sun, 10 Dec 2017 13:02:06 GMT

Hello Sandra
Your propose helps me, but there is still a problem:

The first Node "ArticleNb" is not correct, the next nodes are correct
If I delete the first Node "ArticleNb", the next nodes are not correct
The result you can see in the printscreen. Do you have any idea for this problem?
Many thanks, Daniel

<StoreMaterial>
  <tt:loop name="data" ref="$line.data">
    <Material Value="ArticleNb">        " display wrong
      <tt:attribute name="Name">
        <tt:value ref="articlenb"/>
      </tt:attribute>
    </Material>
    <Material Name="ArticleNb">         " display correct
      <tt:attribute name="Value">
        <tt:value ref="articlenb"/>
      </tt:attribute>
    </Material>
    <Material Name="MatDesc">          " display correct
      <tt:attribute name="Value">
        <tt:value ref="matdesc"/>
      </tt:attribute>
    </Material>
  </tt:loop>
</StoreMaterial>

Re: Simple Transformation Problem

Sandra_Rossi — Sun, 10 Dec 2017 16:23:50 GMT

I already answered on your same post 2 days ago. Why do you need to keep the first node? What is the expected result? (please, not in words, but in XML)

It's normal that with :

<Material Value="ArticleNb">
  <tt:attribute name="Name">
    <tt:value ref="articlenb"/>
  </tt:attribute>
</Material>

you get

<Material Name="8.28.005.210" Value="ArticleNb"/>

Look carefully your code.

Re: Simple Transformation Problem

dmi — Mon, 11 Dec 2017 09:01:07 GMT

Hi Sandra
Sorry, I'm anyoing, but what is wrong with my code?
The expected result can you see in the print screen, I have only a specification, I can't show you in xml, only in word.
Sorry again and many thanks, Daniel
My ST:

sap-st.txt

My requirement

<?xml version="1.0" encoding="iso-8859-1" ?>
<StoreInventoryDataList>
<StoreMaterial>
<Material Name="ArticleNb" Value="DD11"/>
<Material Name="MatDesc" Value="mild steel"/>

My result: