cancel
Showing results for 
Search instead for 
Did you mean: 

B1if : Sender systems List : Storage Location

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

HuanYang
Employee
Employee
0 Kudos

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

0 Kudos

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

HuanYang
Employee
Employee
0 Kudos

Hello Paul,

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

May I know why you want this?

Thanks

Huan Yang

0 Kudos

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

0 Kudos

Hello Experts,

Can anybody please put some light on this matter?

Regards,

Paul

HuanYang
Employee
Employee
0 Kudos

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