Skip to Content

Using the SLD-variables in Integration Framework

I'm designing a Scenario in Integration Framework and want to present the Company name in the respons.

According to the documentation i shall use a variable called $*xxxxxxxx.B1DI.Company* for this, where xxxxxxx is the sysid. I have the sysid in a variable called $sysid.

How is it possible to show the Company name? I have tried in a million different ways to get it, but i can't seem to make the xsl correct.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 27 at 10:34 AM

    Hi,

    Work around is to use "Call SQL" atom where the SQL statement as

    #SELECT CompnyName FROM OADM

    and make sure to have the SysId of the SQL atom to the xPath of your variable :)

    Hope it works

    Regards,

    Bala

    Add comment
    10|10000 characters needed characters exceeded

  • May 06 at 09:03 AM

    Hello Leif,

    Hope the following one do help

    https://answers.sap.com/questions/561889/b1if-sender-systems-list-storage-location.html?childToView=562696#comment-562696

    xsl code example:

    	<xsl:template name="transform">
    		<xsl:variable name="cdoc" select="document('/com.sap.b1i.system.sld.directory/RoutingTree.xml/RoutingTree')"/>
    		<HttpSysIdList>
    			<xsl:for-each select="$cdoc/sim:RoutingTree/sim:ParticipantNode/sim:ParticipantNode">
    				<xsl:variable name="sysIDdoc" select="document(concat('/com.sap.b1i.system.sld.directory/SysId.xml/',@SysId,'(Id)'))"/>
    				<xsl:if test="$sysIDdoc/sim:SysId/@SysTypeId='H.AnySystem'">
    					<row>
    						<SysId>
    							<xsl:value-of select="@SysId"/>
    						</SysId>
    						<Description>
    							<xsl:value-of select="@Description"/>
    						</Description>
    					</row>
    				</xsl:if>
    			</xsl:for-each>
    		</HttpSysIdList>
    	</xsl:template>

    Thanks

    Huan Yang

    Add comment
    10|10000 characters needed characters exceeded