Question Re: Strans XSLT-Programm Conversion error in Technology Q&A

Strans XSLT-Programm Conversion error

mt13065 — Mon, 11 Mar 2019 06:22:53 GMT

I often use strans for XML->ABAP TABLE conversion, but I have encountered the following problem. The correct result should be that there is only one row of data in the ''GT_ORDER-PART'' of each row, but now he has two rows, he has read all the The data in "part", how can I make him correspond to ORDER?

Re: Strans XSLT-Programm Conversion error

Sandra_Rossi — Mon, 11 Mar 2019 06:47:13 GMT

Please post the code as text instead of image, so that we can easily answer by modifying portions of your code.

Re: Strans XSLT-Programm Conversion error

mt13065 — Mon, 11 Mar 2019 07:19:59 GMT

it's my strans code, I think it should be something wrong,hope someone can help me, best regards, T^T

Re: Strans XSLT-Programm Conversion error

Sandra_Rossi — Mon, 11 Mar 2019 07:27:58 GMT

Thank you.

Note: you'd better correcting your original question rather than adding text.

If you want to reply to someone to add complements, please use the COMMENT button. ANSWER is only to propose a solution. If it's too late, you still have an option to convert your answer into a comment.

Re: Strans XSLT-Programm Conversion error

mt13065 — Mon, 11 Mar 2019 07:33:40 GMT

<xsl:transform version="1.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:sap="http://www.sap.com/sapxsl"
>


<xsl:strip-space elements="*"/>


<xsl:template match="/">
<asx:abap xmlns:asx="http://www.sap.com/abapxml" version="1.0">
    <asx:values>
        <ORDERS>
            <xsl:for-each select="/Orders/Order">
            <xsl:variable name="var1" select="/Orders/Order"/>
            <HEAD>
                <NAME>
                    <xsl:value-of select="Name"/>
                </NAME>
                <STRATEGY>
                    <xsl:value-of select="Strategy"/>
                </STRATEGY>
                <STARTDATE>
                    <xsl:value-of select="StartDate"/>
                </STARTDATE>
                <PART>
                    <xsl:for-each select="$var1/Parts/Part">
                       <ITEM>
                            <NAME>
                                <xsl:value-of select="Name"/>
                            </NAME>
                            <MEASURE>
                                <xsl:value-of select="Measure"/>
                            </MEASURE>
                        </ITEM>
                    </xsl:for-each>
                </PART>
            </HEAD>
            </xsl:for-each>
        </ORDERS>
    </asx:values>
</asx:abap>
</xsl:template>


</xsl:transform>

-------------------------------------my strans code↑

<Orders>
        <Order>
          <Name>Bend_001_10</Name>
          <Strategy>MaterialAdministrationOrder</Strategy>
          <StartDate>2018-07-13T08:00:00</StartDate>
          <TargetDate>2018-08-02T16:00:00</TargetDate>
          <Parts>
            <Part>
              <Name>B010_110_011V3</Name>
              <Measure>Metric</Measure>
            </Part>
          </Parts>
        </Order>
        <Order>
          <Age>2</Age>
          <Name>Zusammenbau Teil</Name>
          <Strategy>MaterialAdministrationOrder</Strategy>
          <StartDate>2018-07-13T08:00:00</StartDate>
          <Parts>
            <Part>
              <Name>Imported1</Name>
              <Measure>Metric</Measure>
            </Part>
          </Parts>
        </Order>
      </Orders>
-----------------------------------------my xml code↑
best regards.

Re: Strans XSLT-Programm Conversion error

Sandra_Rossi — Mon, 11 Mar 2019 07:47:35 GMT

XSLT refers to nodes by using the XPATH language, which use absolute (start with / like in your example /OrdersOrder) or paths relative to the "context node" (not starting with /, like Parts/Part as I show below). The context node is changed by XSLT at runtime, for example for-each sets the context node to the currently-iterated node.

I think that should work:

            <xsl:for-each select="/Orders/Order">
                ...
                    <xsl:for-each select="Parts/Part">

Note: $var1/Parts/Part is equivalent to /Orders/Order/Parts/Part which starts from the root and parses all nodes matching that path.

Re: Strans XSLT-Programm Conversion error

mt13065 — Mon, 11 Mar 2019 07:53:49 GMT

oh my god,i'm so stupid,I tried /Parts/Part, but I didn't try what you said,thank you so much.

Re: Strans XSLT-Programm Conversion error

Sandra_Rossi — Mon, 11 Mar 2019 08:08:17 GMT

By the way, you should better switch to the Simple Transformation language (provided that the transformations remain simple), because it's something like 10 times faster.

Re: Strans XSLT-Programm Conversion error

mt13065 — Mon, 11 Mar 2019 08:33:29 GMT

i will, but simple need create all fields in se11 ,If I am not mistaken.
but I am worried that the customer will add the fields that need to be read later. I am preparing to create a simple strans,thank you again.^_^

Re: Strans XSLT-Programm Conversion error

Sandra_Rossi — Mon, 11 Mar 2019 09:58:52 GMT

A Simple Transformation may work without any reference to the DDIC i.e. the type of the data root is optional, in that case it's considered of type "any" and it will check the ABAP names when the transformation runs.