on 08-23-2007 10:56 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why are you double posting the same question?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Map the "USERLIST" node instead of "USERNAME" in the output SAP JCO Interface and try.
Regards
Guru
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.