Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Abt tables

Former Member
0 Likes
543

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 .

3 REPLIES 3
Read only

Former Member
0 Likes
469

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

Read only

Former Member
0 Likes
469

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.

Read only

Former Member
0 Likes
469

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