Skip to Content

B1if : Sender systems List : Storage Location

Hello Experts,

Can anyone please help me to find, where the sender system List is stored and how to retrieve the list?

Thanks in advance,

Paul

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 06, 2018 at 06:34 AM

    Hello Paul,

    The information is from SLD.

    What do you mean retrieve?

    If you create an Http Inbound Step, then you may choose one(or more than one) of Http system as Sender system.

    Thanks

    Huan Yang

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Huan,

      Thanks for answering. I want to get the list of all Sender systems created. I have searched all tables in the SQL DB for SLD but could not find it.

      I just need the table name where this list is stored.

      Regards,

      Paul

    • Hello Paul,

      I'm sorry that you cannot get this list from database directly.

      May I know why you want this?

      Thanks

      Huan Yang

    • Hi Huan,

      We are integrating B1 with our Product.

      Let me explain my need. Suppose we have a URL generated from a scenario step like below

      http://<server>/B1iXcellerator/exec/ipo/vP.<0010000104 or any other sender system number>.in_HCSX/com.sap.b1i.vplatform.runtime/INB_HT_CALL_SYNC_XPT/INB_HT_CALL_SYNC_XPT.ipo/proc?action=GetVendors

      We are going to use the above URL in our API generator. Our API generator has the capability to convert parts of URL as variables. So we can use the same API in other systems using those variables without even generating a new API for a different system.

      We have noticed that the Sender system part of the URL generated from a scenario step varies depending on the sender system chosen. Thus we want to define this part as a variable in our API. To support the input of this variable we want to fetch all the sender systems defined in a B1 system.

      This is the reason we need to fetch the list of sender system.

      As per your answer I can understand that, it is not available in DB. Could you please point me where it is being stored and how to retrieve it?

      Thanks in advance.

      Regards,

      Paul

    • Hello Experts,

      Can anybody please put some light on this matter?

      Regards,

      Paul

    • Hello paul,

      You may build a scenario triggered by HTTP that returns the information about the systems.

      Sample code to get the Http system id list:

      XSL Code:
      	<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>
      

      Result:

      Best regards

      Huan Yang

      httplist.png (34.3 kB)