topic Call RFC that return structure using VB in Application Development and Automation Discussions

Call RFC that return structure using VB

Former Member — Tue, 02 Jan 2007 09:47:49 GMT

Hi, anyone has a sample code to call a custom RFC that returns table structure?

The RFC expect parameters to pinpoint the record and return it in a structure.

*----

*Local Interface:

*----

Here's my vb code, but it return zero entries (I'm sure it should return records).

***Login Process Here***

Set objFunc = objSAPLogon.Add("Z_CUSTOM_SALES_DATA")

Set objSALES = objFunc.Tables("SALES_VOLUME")

With objFunc

.Exports("CUSTOMER") = "1234567"

.Exports("MATERIAL") = "1234"

.Exports("POSTING_DATEFR") = "10012005"

.Exports("POSTING_DATETO") = "10312005"

End With

If Not objFunc.Call Then

Debug.Print objFunc.Exception

Exit Sub

End If

Debug.Print objSALES.RowCount ==> 0

From here, I dont know what to do next. Am I missing something? Please help.

Thanks in advance!

/Noel

andreas_mann3 — Tue, 02 Jan 2007 10:06:03 GMT

are you sure that your date format mmddyyyy is correct.

must'nt it be yyyymmdd?

Former Member — Tue, 02 Jan 2007 10:16:22 GMT

Yes, the RFC developer told me to use this format mmddyyyy.

I think the Exports portion is not working, and I dont know why. I tried remarking the Exports portion and it gives the same result, zero entries.

Thanks!

Former Member — Wed, 03 Jan 2007 08:53:00 GMT

Hi,

the field Customer has 10 Characters and Material has 18 Characters.

Try your call with according leading zeros.

Regards Gerd

Former Member — Wed, 03 Jan 2007 08:58:20 GMT

Yes you're correct! I already resolved this by supplying the leading zeros and separators for the two date fields.

Thanks!

Former Member — Wed, 03 Jan 2007 08:59:49 GMT

I just supplied the leading zeros and separators for the date fields and it works!