topic Re: Simple transformation need help in Application Development and Automation Discussions

Simple transformation need help

Former Member — Thu, 04 Oct 2012 13:10:54 GMT

Hi all,

my provider sends me an XML document, which I try to parse with simple transformation

My problem is the following part:

Sometimes i get the line with curvename, sometimes the line with group, or I got both.

If curvename is missing I got an exception CX_ST_MATCH_TEXT

How can I prevent this.

Best regards Marcus

Re: Simple transformation need help

jeroen_verbrugge2 — Thu, 04 Oct 2012 14:03:45 GMT

Hi,

You can use <tt:cond frq="?"> within <tt:group>.

More info: SAP Help on ST grouping

Have a look at attached examples, the ST will process them all filling a structure with two fields a and b.

Kind Regards,

Jeroen.

Re: Simple transformation need help

Former Member — Thu, 04 Oct 2012 14:24:03 GMT

Hi Jeroen,

thanks, but it does not work

<tt:group>

                <tt:cond frq="?">
                  <key name="curvename" tt:value-ref="CURVENAME"/>
                </tt:cond>
                <tt:cond frq="?">
                  <key name="group" tt:value-ref="GROUP"/>
                </tt:cond>
              </tt:group>
              </identifier>

I tink the problem is caused by same tag <key> and only different attribut values for attribut name.

Kind regards

Marcus

Re: Simple transformation need help

jeroen_verbrugge2 — Thu, 04 Oct 2012 14:59:44 GMT

Hi,

Sorry, I thought it was about optional elements.

For attributes of an element, it's similar.

Apply the grouping and the cond on the attributes.

Check example. Element a has two attributes, att1 and att2.

The simple transformation will process both without errors.

Kind Regards,

Jeroen

Re: Simple transformation need help

jeroen_verbrugge2 — Thu, 04 Oct 2012 15:12:01 GMT

Hi,

FYI: the tt:cond is also working without tt:group. It is often just in a tt:group scenario but it's not mandatory...

This will also work:

 <?sap.transform simple?>
 <tt:transform xmlns:tt="http://www.sap.com/transformation-templates">
 
   <tt:root name="ROOT"/>
 
   <tt:template>
     <identifier>
       <a>
           <tt:cond>
             <tt:attribute name="att1" value-ref="root.a"/>
           </tt:cond>
           <tt:cond>
             <tt:attribute name="att2" value-ref="root.b"/>
           </tt:cond>
       </a>
     </identifier>
   </tt:template>
 
 </tt:transform>

Kind Regards,

Jeroen.

Re: Simple transformation need help

Former Member — Thu, 04 Oct 2012 15:13:12 GMT

it is a combintion of both i think

example 1

</identifier>

example 2

</identifier>

example 3

</identifier>

Every case is possible

I tried:

<tt:group>

                  <tt:cond frq="1">
                    <key>
                      <tt:group>
                        <tt:cond frq="?">
                          <tt:attribute name="curvename" value-ref="CURVENAME"/>
                        </tt:cond>
                        <tt:cond frq="?">
                          <tt:attribute name="group" value-ref="GROUP"/>
                        </tt:cond>
                      </tt:group>
                    </key>
                  </tt:cond>
                  <tt:cond frq="?">
                    <key>
                      <tt:group>
                        <tt:cond frq="?">
                          <tt:attribute name="curvename" value-ref="CURVENAME"/>
                        </tt:cond>
                        <tt:cond frq="?">
                          <tt:attribute name="group" value-ref="GROUP"/>
                        </tt:cond>
                      </tt:group>
                    </key>
                  </tt:cond>
                </tt:group>
              </identifier>

but in this catch I got the exception CX_ST_MATCH_ELEMENT

Kind regards

Marcus

Re: Simple transformation need help

jeroen_verbrugge2 — Thu, 04 Oct 2012 15:31:11 GMT

Hi,

Are you saying that key is 1..n?

In that case, you'll need a <tt:loop>:

 <?sap.transform simple?>
 <tt:transform xmlns:tt="http://www.sap.com/transformation-templates">
 
   <tt:root name="ROOT"/>
 
   <tt:template>
     <identifier>
       <tt:loop ref="ROOT">
         <a>
           <tt:cond>
             <tt:attribute name="att1" value-ref="a"/>
           </tt:cond>
           <tt:cond>
             <tt:attribute name="att2" value-ref="b"/>
           </tt:cond>
           <tt:skip/>
         </a>
       </tt:loop>
     </identifier>
   </tt:template>
 
 </tt:transform>

If that's not the case, it's maybe easier if you attach a few example XML files to your message (use the advanced editor)

Kind Regards,

Jeroen

Re: Simple transformation need help

Former Member — Fri, 05 Oct 2012 06:31:43 GMT

  <?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates" xmlns:ddic="http://www.sap.com/abapxml/types/dictionary" xmlns:def="http://www.sap.com/abapxml/types/defined">
  <tt:root name="RESPONSE" type="ddic:ZMS_XML_PRICERESULT_SUBJECT"/>
  <tt:template>
    <response>
      <subject>
        <identifier>
          <key name="category" tt:value-ref=".RESPONSE.CATEGORY"/>
        </identifier>
        <identifier>
          <key>
            <tt:group>
              <tt:cond data="'curvename'=ref('.RESPONSE.CURVENAME_TXT')">

                <tt:attribute name="name">
                  <tt:value ref=".RESPONSE.CURVENAME_TXT"/>
                </tt:attribute>
                <tt:value ref=".RESPONSE.CURVENAME"/>
                <!--              &lt;/key&gt;-->
              </tt:cond>
              <tt:cond data="'hdbgroup'=ref('.RESPONSE.CURVENAME_TXT')">
                <!--              &lt;key&gt;-->
                <tt:attribute name="name">
                  <tt:value ref=".RESPONSE.CURVENAME_TXT"/>
                </tt:attribute>
                <tt:value ref=".RESPONSE.HDBGROUP"/>

              </tt:cond>
            </tt:group>
          </key>
        </identifier>
      </subject>
    </response>
  </tt:template>
</tt:transform>

The structure has only four elements type char 30

Re: Simple transformation need help

jeroen_verbrugge2 — Fri, 05 Oct 2012 08:53:32 GMT

Hi,

Im tot sure what you want to achieve but looking to your examples I think you mixup a few things or making it too difficult.

The structure of the XML is nested, multiple identifiers can exist and each can have multiple keys.

Each key element has only 1 attribute name. This is always the case. So there is no conditional processing needed. It's the values that are changing.

I think it's easier to first parse the XML content in a table having the same structure as the XML.
Then if needed you can transform this table to another structure in your program by looping over the result.

I think with the information you have your question is answered

Kind regards,
Jeroen