topic Re: table name in Application Development and Automation Discussions

table name

Former Member — Thu, 19 Jul 2007 04:02:45 GMT

hi,

i am learning ABAP/4, but i found the table names very difficult to remember. Is there any specific way of remembering it. Can we make them easier.

regards,

Mohammadi.

Re: table name

Former Member — Thu, 19 Jul 2007 04:06:33 GMT

In the beginning they r tough to remember as such, but as you will start practicaly working on them, slowly you will learn which tables are for what purpose.

Only way is to practice.

Regards

Aarti

Re: table name

former_member189059 — Thu, 19 Jul 2007 04:09:07 GMT

Make a list of the tables you commonly use and store in on some paper or book where you can refer to it easily

Re: table name

Former Member — Thu, 19 Jul 2007 04:10:19 GMT

Hi Madam,

Its not at all difficult remember the names of the tables.

As i understand from your question that you have started abap recently just try to wrile small programs and each time use different tables this is how by practise you will remember all the names.

one sample prg for your ref.

Say you want to display all customers.


Select * from kna1.
write kna1-kunnr.
endselect.

Now from this program you got customer table KNA1 and field for customer number KUNNR. Like that by practise you will learn all tables.

All the best in your new endeavours,

Reward points if useful,

Aleem.

Re: table name

Former Member — Thu, 19 Jul 2007 04:21:05 GMT

Hi,

If you still want to know all the tables in sap.

Go to DD02L table and execute it will give you all the list of tables.

Thanks,

Aleem.

Re: table name

Former Member — Thu, 19 Jul 2007 04:32:22 GMT

you can find it by having the Alphabet . because it was followed in the German language .

K-> stands For Customer

bsak

vbak

vbik

mbak

D-> stands For Vendor

bsad

bsid

vbad

S-> stands For General Ledger

bsis

bsas

msas

T-> Text table .

t100t

t400t

t500t ...etc

and also

then Customer tables starts with K* (KNA1,KNB1,KNBK,etc)

Tne Vedor Tables starts with L* (LNA1,LNB1,LNBK,etc)

For Materail starts with M* (MKBF,MSEG,MARA,etc)

For Purcahse E* (ekko,ekpo ,etc)

For sales V* (VBAK,VBBE,VBIS,etc) ....etc

for finding all tables DD02L SAP Tables

Reward points if it is usefulll ...

Girish

Re: table name

Former Member — Thu, 02 Aug 2007 16:27:22 GMT

Hi,

I'm new in SAP. I use JCo to make connexion with Sap.

how can I find the table DD02L?

I want to know names of tables and its parameters to get the number of client, its address,....

So I want to write something like that :

 repository.getFunctionTemplate("BAPI_SALESORDER_GETLIST");

but with the name of my table contained information about clients.

thank u