topic Internal table from RFC TABLES parameter returns incomplete/incorrect data in Application Development and Automation Discussions

Internal table from RFC TABLES parameter returns incomplete/incorrect data

Former Member — Mon, 21 Nov 2005 09:59:54 GMT

Hi all,

Would anyone ever have any experiece getting incomplete and incorrect data in the table being returned by Tables parameter? Data is complete and correct when the RFC-enabled FM is ran in SE37. However, when I display the data in VB, some of the fields show incorrect values while others don't have any value anymore.

Here's the code snippet which calls the RFC from VB:

Sub RFC_DISP_ZSINQ_PER_JO(mJobOrderNo As String, _

mPlateNo As String, _

Optional mJobOrderData As Object, _

Optional mStatus As Object, _

Optional mWFP As Object, _

Optional mWorkNotes As Object, _

Optional mWorkRec As Object, _

Optional mBilldocs As Object)

bResult = cSap.oFunction.RFC_DISP_ZSINQ_PER_JO(vException, _

V_AUFNR:=mJobOrderNo,_

V_EQUNR:=mPlateNo,_

IT_DATA:=mJobOrderData, _

IT_JCDS:=mStatus, _

IT_WFP:=mWFP, _

IT_WNOTES:=mWorkNotes, _

IT_WREC:=mWorkRec, _

IT_BILLDOCS:=mBilldocs)

End Sub

bResult returns True.

Code which reads contents of internal tables

cSap.RFC_DISP_ZSINQ_PER_JO sJobOrderNoTemp,_

sPlateNo, _

oJobOrderData, _

oStatus, _

oWFP, _

oWorkNotes, _

oWorkRec, _

oBilldocs

Set oRowJobOrderData = oJobOrderData.Rows

For Each oRowJobOrderData In oJobOrderData.Rows

Label2(1).Caption = oRowJobOrderData("CLASS")

Label2(2).Caption = oRowJobOrderData("SPNAME")

...

Next oRowJobOrderData

Above code is where I'm getting incorrect data. Also, no errors were obtained whatsoever. vException is also empty.

Any help is greatly appreciated in advance. Thanks!

Sheila

Re: Internal table from RFC TABLES parameter returns incomplete/incorrect data

Former Member — Mon, 21 Nov 2005 11:32:23 GMT

Hi,

Please try this. Check if all the data from the RFC is of character type or not. Mostly we experience these problems when calling RFC when the data is not in character format.

If the data that you are trying to get is not in character format convert the data into character format and then call the RFC.

reward points of this helps.

cheers,

Re: Internal table from RFC TABLES parameter returns incomplete/incorrect data

Former Member — Thu, 01 Dec 2005 04:41:16 GMT

Hi,

With the structure I created for this table, I have 2 DATS, 2 TIMS, 1 CURR and 13 CHAR fields. What's weird is that I actually have another RFC table with varied data types which produced the right results the first time.

Would anyone have anymore ideas please?