cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in retrieving multiple records SAP xMII from SAP using BAPIS

Former Member
0 Kudos

Hi friends,

In SAP xMII i called BAPI_USER_GETLIST by passing import parameters 10 and y.In r/3 BAPI returned 10 rows but In xMII it was returned only one Record.

i want to display 10 records in sap xmii

1) I created to connection ECC5 in Dataservices-->SAPSERVERConfiguration

2)In BLS we placed JCO Interface inside Sequence

3)In BLS I used ECC5 connectrion(using JCO Interface) and called BAPI_USER_GELLIST

4)In Links-->Transaction created two input values for "maxnoofrows","withusername" and output value is "userid".

Input what i mapped

Transaction>"maxnoofrows" =====SAPJCOINTERFACE->Request>BAPI_USER_GETLIST>INPUT-->MAX_ROWS

Transaction>"withusername" =====SAPJCOINTERFACE->Request>BAPI_USER_GETLIST>INPUT-->WITH_USERNAME

Output what i mapped

SAPJCOINTERFACE->Response>BAPI_USER_GETLIST>TABELS>USERLITS >ITEM>USERNAME=====Transaction-->userid

5)Saved the Transaction.

6)In Query Template -->xactuateQuery selected

7)In Datasource Query mode was selected ,Inputrarams i passed 10 and y as parameters.

It was returned one user id from R/3 inSAP xMII

please help me to retrive all 10 rows from r/3

Regards

Srikanth

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Srikanth,

in your very detailed description about your Transaction I miss a Repeater to build a valid xMII-XML-Output Document.

What is the JCO output if you look at it in the Tracer or with the help of an XML-Saver in a XML File?

Maybe you have already a xMII-XML-Output Document document created.

I only want to be sure that you don't miss sth.

Ciao

Martin

Former Member
0 Kudos

hi,

What is the data type of Transaction output (userid)?

Make this as XML type.

The format which BAPI returns the result does not match with xMII XML format.

Create a xMII XML document and configure with column name as userid. and by using repeater and XML row add all tho values to the document. Then assign whole doument to transaction output.

Hope this will help to resolve the issue.

Regards,

Kishore

Former Member
0 Kudos

Hi Kishore,

I taken the out put variable "userids" as xml type.I will follow the steps what you explained.

Thnaks

Srikanth

Former Member
0 Kudos

hi

Have you got the output?

Regards,

Kishore

Former Member
0 Kudos

Hi All,

Problem was solved by using xMl document , repeater, xml row and Assignment tabs

Thanks All

Srikanth M

jcgood25
Active Contributor
0 Kudos

Why are you double posting the same question?

Former Member
0 Kudos

Hi,

Map the "USERLIST" node instead of "USERNAME" in the output SAP JCO Interface and try.

Regards

Guru

Former Member
0 Kudos

Hi guru,

I mapped USERID with USERLIST.Xactuate query is not display output.

Regards

Srikanth