topic Re: Abt tables in Application Development and Automation Discussions

Abt tables

Former Member — Sun, 03 Dec 2006 14:02:48 GMT

Hi ,

How we can identify whether a table belongs to FI/CO or SD or MM

Is there any method or some mnemonic to remember .

and how to identify whether the table is master table or transaction table .

Re: Abt tables

Former Member — Sun, 03 Dec 2006 14:20:47 GMT

Hi,

while creating custom table application area can be used to know

whether table belong to sd,fi

zs_details,zf_account here 2 letter s,f are defines application

sales,finamce.

one way of identifying master table is using description of table in se11

by word headerexample vbak ->Sales Document: Header Data

Regards

amole

Re: Abt tables

Former Member — Sun, 03 Dec 2006 15:35:01 GMT

Hi Sagar

SAP has given some naming conventions for each buisness area.Say for example

all the standard MM tables starts with 'E' like ekko,ekpo,eket,...and for SD(Sales) it starts with 'V' like vbak,vbap,.. and for a FI area the tables start with 'B' bseg,..and so (sorry i couldn't remember others).Like that u can get used to that once u start using them.

And to know whether a table is a master or transaction check the attributes of the table..i guess...

Hope u got the answer.

regards,

Praveen.

Re: Abt tables

Former Member — Sun, 03 Dec 2006 16:04:08 GMT

Hi Sagar,

Go to SE11 and give table name (eg: MCHB).

Go to the tab 'Attributes'

Look for the description of the 'Package' field (eg: Application development R/3 material master prior to 3.0)

You will be able to figure out from this to which module this table belong.

Go to the tab 'Delivery and Maintenance'

From the description of 'Delivery Class' you will be able to figure out what type of table it is.

regards,

biju

Note:- Please reward helpful answers