topic Re: Tables in Application Development and Automation Discussions

Tables

Former Member — Fri, 08 Dec 2006 14:58:26 GMT

how to identify the tables?

All vendor tables start with L such as LFA1.

All customer tables start with K such as KNA1, KONV.

All sales tables start with V such as VBAK VBAP.

All master data tables start with T such as T001, T001W.

All bank tables start with B such as BKNF, BKPF.

All purchasing tables start with E such as EKKO, EKPO.

All material tables start with M such as MARA, MAKT, and MARC

i have this matter. is there any thing else to know? can any one help me by telling how to remember the table names?

Re: Tables

Former Member — Fri, 08 Dec 2006 15:00:06 GMT

Hi,

Please check this link as well.

http://www.erpgenie.com/sap/abap/tables.htm

Regards,

Ferry Lianto

Re: Tables

RichHeilman — Fri, 08 Dec 2006 15:01:11 GMT

Your rule is good to use, but this may not always be the case. You can see what tables are hit by a transaction by using the SQL Trace ST05 and running the transaction, this will tell you exactly which tables are used.

Regards,

Rich Heilman

Re: Tables

Former Member — Fri, 08 Dec 2006 15:01:43 GMT

There is no easy way to remember as different requirements have different tables

Check out this link though

https://forums.sdn.sap.com/click.jspa?searchID=343777&messageID=2515238

Re: Tables

Former Member — Fri, 08 Dec 2006 15:02:24 GMT

Hi!

Mostly these names comes from the german shortings, for example:

VBAK, VBAP - Verkauf Beleg Kopf, Position

LFA1 - Liferant 1

LFB1 - Lieferant / Buchungkreis 1

And so on...

If you would like to identify them easily, you have to learn the relevant german words.

Or you have to writh the found table names to your own excel table

Regards

Tamá

Re: Tables

Former Member — Fri, 08 Dec 2006 15:04:26 GMT

Hi Sudhir,

Do not be anxious about remembering table name.

With time & experience, you learn the main ones...

Moreover, you can use F1 ( technical info ) or launch SQL trace to track the used tables....

Erwan

Re: Tables

Former Member — Fri, 08 Dec 2006 15:06:03 GMT

Hi Sudheer,

Your way of remembering is good.

But by experience and by working with reports and bdc's u will remember automatically. So u need to work with tables as much as possible, this is the only and better way to remember all the tables, so that u also come to know the common fields and related transactions and etc..

So, start working more with the different tables..

Regards,

Kumar