table name

[Former Member]

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.

[Former Member]

hi

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

[former_member189059]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

<b>K-> stands For Customer </b>

bsak

vbak

vbik

mbak

<b>D-> stands For Vendor</b>

bsad

bsid

vbad

<b>S-> stands For General Ledger</b>

bsis

bsas

msas

<b>T-> Text table .</b>

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 <b>DD02L </b> SAP Tables

Reward points if it is usefulll ...

Girish