how to extract meta data of documents from SAP R/3

[Former Member]

dear all,

i`am working in aproject where we connect the documents for SAP R/3 applications.we maintain our own repository for that purpose.it may be in bound or out bound according to customer needs.the meata data related to the documents is stored in SAP.our requirement now is to have that metadata available in our repository .can any one guide me how to write ABAP code for extracting meata data from SAP and enable even nonSAP users to have the access for the documents.

thanks in advance

ravi

[Former Member]

Hi,

I my view you can retrive the meta data and develop BSP to show that to nonSAP user.

Atul

[former_member184569]

Hi Ravi,

Check out this link.

http://help.sap.com/saphelp_nw04s/helpdata/en/85/905640a2f78437e10000000a155106/content.htm

Regards,

Susmitha

[athavanraja]

what sort of documents are you talking about? is it external documents (word, pdf, etc) stored against r/3 objects and you want to get the metadata of these objects?

Can you explain a bit further on your question?

Regards

Raja

[Former Member]

hi raja,

yeah u r right.i want to have metadata of external files only.can we retrive that metadata into our repository.

our project basically has all the documents pertaining to sap r/3 objects and applications. we use connectors for linking the sap and our own database.now we want to have that metadata available in our database too so that even nonsap user can also have access to it.

if u still have doubts , then let me know.

waiting for ur reply.

ravi

[athavanraja]

how are you loading the documents?

if SAP DMS is configured to use external database for storing the contents, then you can get the metadata from the SAP DMS itself.

what sort of external tools you are using.

is it documentum?

Regards

Raja

[former_member927251]

Hi,

One way to do this is probably set a connection between SAP Database and an external database and store the meta data into external database from where a non-sap user will have an eccess to the data.

Steps required are :

1. we have to involve basis team also in that.

2. they will make one entry

in DBCON table

(that entry will point to secondary database/external database)

(suppose the name of this secondary connection is HRCON)

3. Also they will make connection string

in application server.

4. After that,

we should have

the table definition in SAP dd dictionary

and also

the same defintion

in the external database.

5. now in abap code,

we have to use like this.

DATA: mydbcon(30) TYPE c.

mydbcon = 'HRCON'.

INSERT ydev_msg_cur CONNECTION (mydbcon)

FROM msg_cur .

<b>Hope this helps.

Please mark helpful answer.</b>

Regards,

Amit Mishra