Document object link information

[Former Member]

Hi Experts,

We are working with documents linked to WBS elements and networks. Now, we need to know which objects have links to a certain type of document without using development.

We have explored several solutions:

• Using Object Link tab on CV04N - it is not working, since PRPS object links don't allow wildcards

• Extracting to an excel file the information on a certain document on the object link tab - how can we extract it?

• Using some report????

We know info is stored on table DRAD but we need to extract the information through user transactions.

Any suggestion will be appreciated.

Thanks.

Kind regards,

Neil

[MangeshP]

Hi Niel

I agree with Jennifer. You can create a Query.This will solve your Problem.

Also you know the Table where these values are available.So it would be a Half day job

for ABAP Consultant.

With Regards

Mangesh Pande

[jennifer_kramer2]

Can you create a query using table DRAD? Users could access the query you write for them in tcode SQ01.

(You would need to build the infoset in tcode SQ02. Assign users to use the infoset in SQ03. And create the query in SQ01. This tcode is the same for users accessing it.)

Hope it helps!

-J

[Former Member]

Hello,

I think, you will have to develop a program which will use data from DRAD table to give required output.

Regards,

Milind

[Former Member]

Thanks Milind, but I'm looking for a process to do this without development.

Is there anyway that I can extract to a file the information on the object link tab?

[christoph_hopf]

Dear Neil,

the easiest way for achieving this function without special developmentwould be to use transaction SE16 and made the selection for table DRAD.

Maybe function module 'CV100_OBJECTLINK_SEARCH' could also be useful for you. This module is also used in CV04N search. Here you can enter a value for the document type (STDOKAR) and a search criteria for object type (OBJECTLINKS). At OBJECTLINKS just enter the object type (e.g. MARA) and value '*' for the object key.

Best regards,

Christoph

Edited by: Christoph Hopf on May 7, 2009 1:43 PM