I never got a chance to actually interface with SAP, but I did take a couple classes.

I believe that your only choice is to go thru the SAP tools. At least for the reason that the data dictionary is so complicated, you would need their tools to get at selected data.

I think without IT involvement, you are SOL.

PF


>I guess I will need to do a little more research before my next reply, but here is what I do know (which is not much):
>
>I work as a contract programmer for a company that uses SAP with Oracle. I have no problem getting to some of the tables using the Oracle driver, but I am trying to figure out what table specific information resides in. Our "IT" dept plays DUMB whenever someone inquires about specific requests like this (most likely because they want to control the data for job security). Another programmer I was discussing this with told me that he knows in a roundabout way where the data comes from in SAP (what four character table), but he is not able to access the field, because it appears to be compressed or something like that. He said there is a function in BAPI or ABAP called READTEXT that uncompress the field(s) into readable text, but I do not live in the SAP environment so it is not an option. He also said that one of daily process that IT runs is to take the first 150 characters and push it into a view. I need to get to all of the info, but I know they will not help me.
>
>Any ideas?
>
>
>>>Has anyone ever used VFP (and I guess BAPI) to access SAP and retrieve, what we would call, memo fields?
>>
>>David - i can hit SAPdb with my favorite odbc drivers.
>>
>>what kind of issues are you having ??? If the 'memo field' is becoming truncated or corrupt, etc etc ...
>>
>>mondo regards [Bill]