Tables to link MM & Document Management System

[Former Member]

Hi All,

I would like to know which table should i join to MARC / MARA to obtain the document information. I tried linking DRAD table with MARA / MARC, but the material number is stored as a key & i cannot directly join these tables.

Hope my question is clear, await inputs.

Vivek

[Former Member · Accepted solution]

1) Filter table DRAD by DOKOB = 'MARA'

2) Link to MARA/MARC by DRAD-OBJKY <=> MARA-MATNR

[Former Member · Accepted solution]

Mr. Bruce,

Thanks for the inputs, but as mentioned in my initial post, i tried joining MARA / MARC - MATNR with DRARD - OBJKY in SQVI just to check, but the system prompts the link cannot be made.

I am not quite sure what you mean by filter DRAD table? Are you suggesting that instead of linking the tables, i should write ABAP lines to filter the table & then build the link with the code?

It would be helpful, if you let me know how to do it, as the system does not allow a direct link of these 2 fields.

Note for Mr. Nathan: Will check the table mentioned by you & let you know if it helps.

Vivek

[Former Member · Accepted solution]

Hi Vivek,

I suppose you try to do in SQ01. If so you can't join two tables there.

But you can create a view by SE11.

1) In Table/Join Condition, normally don't forget adding DRAD-MANDT <=> MARA-MANDT and DRAD-OBJKY <=> MATNR

2) In View Flds, also normally need MANDT

3) In Selection Conditions you need add

DRAD DOKOB = 'MARA'

The above passed in my IDES ECC6.0

[Former Member · Accepted solution]

Mr. Bruce,

Is there any documentation which explains in brief how to create views?

Also if i have understood your inputs correctly, i would need to create 2 views, one for DRAD & one for MARC / MARA & use these views in my infoset.

Await inputs.

NOTE: I am using ver 4.6c

Vivek

[Former Member · Accepted solution]

As your business requirement you only need create two views: One is based on DRAD and MARA, one is based on your created view and MARC.

About how to create view, please refer:

[http://help.sap.com/saphelp_erp2005/helpdata/EN/cf/21ec5d446011d189700000e8322d00/frameset.htm]

You don't need SQ01/SQ02/SQ03. You can query the data by view with t-code SE16.

Maybe you go to find help from an ABAP consultant to create views.

Hope it clear.

Regards,

Bruce

[Former Member · Accepted solution]

Mr. Bruce,

Thank you very much for your help & support. Keep the good work going.

Regards,

Vivek

[Former Member]

Try with table MCH1