Confused xMII or me???

[Former Member]

Hi All,

We are fetching data from some custom table in SAP. Data is frequently updated in that table. We have written a BAPI to get the data in xMII too.

But the problem is that whenever we try to get the data from SAP using logic editor..... we don't get all the columns....it shows only first three columns.... all the columns are string in SAP as well as in xMII.....

moreover it gives some static value for all the records....

e.g. optemp column is always 47 in xMII whereas it has many values in xMII.....and start_date is always 27.... this kinda confusing...

Can anyone help me in this??

thanks in advance

[Former Member · Accepted solution]

Mussarat

First of all, always create an XML Document with columns defined as per ur requirement, so that u can map the required columns from the response items in the BAPI to the columns in that configured XML Document.

Of course, for this u should loop the response items from BAPI using Repeater.

For step-by-step way u can use <a href="http://www.esnips.com/web/SomFolder">this</a>

Regards

Som

[Former Member · Accepted solution]

Buddy,

Thanks for the response.... We are using repeater and have created the relevant illuminator document....we are handling the errors too.... but its not returning any errors... al it gives us is incomplete data....just three columns out of 8..... the funny thing is that when we created one more table with same structure... we are able to see proper data.....but we can't use the new table as we are doing various operations on the old table for which we have created various BAPIs...

[Former Member · Accepted solution]

Musarrat

Did u check the table returning all columns directly from SAP system?

in BLS, do link the message of Tracer (Use this Action Tracer just after SAP JCO Interface where u hv connection to get the Data from BAPI) with the items returning from that Table , so that u can check if this table returns all columns or not.

Regards

Som

[Former Member · Accepted solution]

Even in tracer.... its showing the insufficient data..... when we execute BAPI in SAP... it will return proper data....but in xMII...it doesn't show proper data.........funny thing is that if I chnage the BAPI(this BAPI is returning data from different table with same structure) name and change the xPATH in repeater...... then it will show data in all the columns.....

[Former Member · Accepted solution]

Probably this is an issue from BAPI inside itself since one table is NOT showing proper results, whereas another table (with same Structure) is showing.

Apart from the structure also check the data types, length of fields in both tables.

One more thing u r using some operations in the old table, so can u check the same operations applied in the new table again and get the result.

Keep trying to find some clue!

[jcgood25 · Accepted solution]

Musarrat,

If you are changing the BAPI then xMII is out of sync. Run this URL: http://localhost/Lighthammer/JCOProxy?Mode=Reset on the server (or log in and use the server name). xMII is caching the Request and Response XML structures, as a performance optimizer, but this URL should solve your problem.

Regards,

Jeremy

[Former Member · Accepted solution]

Thanks a ton Jeremy..... it solved my problem........:)