SAP RFC - Numeric character Headache

[Echidna]

Hi All,

Wondering if anyone has encountered this one, and if anyone has a solution (or an insight into what's going wrong)

This has been bugging us now for quite a while, and cannot find a solution.

We are attempting to Write test data from a VFP9 Application local cursor into a SAP Object.
We can create a new line, and the RFC returns that the new line exists, but when we attempt to insert the data into the Object, The RFC returns Incorrect Data Type.

We have been informed by the client that the Data Type is Numeric character, we have attempted to Convert the Numeric to Char, but still no joy.

The Client has supplied an Excel Interface which appears to work, so there is no issues with the RFC itself.

Is there anything anyone can think of that would be limiting VFP to write to a SAP RFC?

Cheers

Leon

[Echidna]

Hi All,

We got it working, was not the Data type at all, but the RFC not accepting the Identifier of the Object Column.
Changing the Reference to the Ordinal number of the object worked.

[Jyoti Ballabh]

Another option would be to transform your .DBF in a plain text file (using Access or Excel, if you have Office installed). It's an easy thing to do, and the file resultant will be uploaded with WS_UPLOAD without problems (and you can do some make-up to the fields if you need it).

The use of GUI_UPLOAD will be wise if your system supports it, because WS_UPLOAD is obsolete and we can expect will disappear in future versions of SAP/ABAP.

[Echidna]

Hiya,

Thanks for the response.

We are using SQL Server as the Backend and the client's SAP Dept has supplied a RFC as the only means of communicating with SAP.

We were thinking of the Excel option (Creating an Excel File and uploading this) but the client's SAP dept refused.

Cheers

Leon