Retrieving Data field and table for an Object (Data Provider)? VBA

[JekLuv2Program]

Hi,

I would just like to ask a question:

Does anybody know the command on how to retrieve the actual data field and table for an object in Business objects?

I have a sample (portion of the ) code to elaborate:


Dim docMyDocument As Document
Dim dpMyDataProvider As DataProvider

Set docMyDocument = Application.Documents.Open(strDocPath & strCurrentFile)
Set dpMyDataProvider = docMyDocument.DataProviders.Item(1)

'retrieves the Name of the first column item for that data Provider
temp1 = dpMyDataProvider.Columns.Item(1).Name

HOW OR WHAT COMMAND CAN I USE SO that I'll KNOW WHICH PARTICULAR TABLE OR FIELD this column item is from..

e.g. temp1 = employee Name

from the SQL
select a.empname from temptable a


so i'm looking for the field and table: empname, temptable.

Any Ideas? I would really appreciate it if you can help me out...

THANKS A LOT in advance.