topic Re: Table / Module Cross Reference in Application Development and Automation Discussions

Table / Module Cross Reference

Former Member — Mon, 01 Oct 2007 13:01:33 GMT

Good day

Sorry if this question is answered already but I couldn't find the answer in any forum.

I have a list of a few thousand table names and I have to identify which module (SD, FI, CO, MM, etc.) each table belongs to. I know some tables are cross- module but I think each table is linked to one Primary module.

1) Is there a Table / Module cross reference anywhere in SAP ?

2) Is there a function module I can use ?

3) Does anybody know the links to work backwards from having a table name to get to the appropriate module.

Thank you for your help.

Gerrie

Re: Table / Module Cross Reference

Former Member — Mon, 01 Oct 2007 13:13:52 GMT

There is no such hardcore rule to distingush between the tables to different modules

but some tips are:

1. most of the tables starting with V* belongs to SD

like vbak,vbap,vbrk,vbrp,vbkd,vbep etc

2. Most of the tables starting with E* belongs to MM purchasing

like ekko,ekpo,eket,eban etc

3.Tables atrting with KN* belong s to Customer master

4.Tables starting with M* belongs to Material Master

5. Tables starting with LF * belongs to Vendor

6.Tables starting with B* belongs to FI module like

bkpf,bseg,bsis,bsas,bsid,bsad,bsik,bsak,bset etc

7.Tables starting with USR* belong to user data

8.Tables starting with TSP* belong to Spool data

9.Tables starting with P* belongs to PP module

plko,plpo

10. Tables starting with Q* belongs to Quality managment

11,

Tables like KONV,KONP are cross client and relates to pricing

Regards

Anji

Re: Table / Module Cross Reference

Former Member — Mon, 01 Oct 2007 19:52:02 GMT

Bieska:

Here is how you can do it. However not all tables can be mapped to the modules.

1) Go to transaction SE81

2) Select the module you are interested in and click "Select subtree" icon

3) Click on "Information System" on the toolbar

4) On the following screen expand "ABAP dictionary" node on the tree

5) Double click on "Database Tables"

6) Execute the selection screen without providing any additional parameters

7) The list is for all tables in the module you had selected.

Hope this helps.

- Cheers