Internal table from RFC TABLES parameter returns incomplete/incorrect data

[Former Member]

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

[Former Member]

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,

[Former Member]

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?