07-23-2007 6:58 AM
Just try to remember the sap terminology of representing the business or buisness objects... such as
all vendor tables start with L such as lfa1, etc..
all customer tables start with K ... Kna1, konv...
all sales tables start with V... vbak vbap
all master data tables start with T... T001, t001w
all bank tables start with B.. Bknf, bkpf....
all purchasing tables start with E.. ekko, ekpo etc..
all material tables start with M... mara, makt, marc...
and
in sales, delivery, billing, purchasing...
if the tables name contains K init it is Header data
such as vbak, likp, vbrk, ekko...
if the tables name contains P init it is Item data
such as vbap, lips, vbrp, ekpo ....
Coming to FI tables... there are only 6 important tables in whole Finance module which are mostly used by abapers.
They can be remember by:
if the table name contains I, that is open item
if the table name contains A, that is closed item
if the table name ends with S, that is GL account
exp BSIS- GL master open items
BSAS- GL master closed items
like wise...
if the table name ends with D, that is customer
if the table name ends with K, that is vendor
Finally, table TSTC contains the list of all transaction codes.
10-19-2014 10:47 AM
Hi,
I think that it is more important for a programmer to remember and use good programing principles like encapsulation , reduce the number of global variables to the minimum required , typed parameters in a form etc . .
If a good programmer is being judged by remembering table names then something is very wrong here....
The data model is the in the domain of the module consultant they should have this knowledge and pass it to the programmer to do his/her job.
Regards.
07-23-2007 7:11 AM
Good compilation...
As you keep developing reports/interfaces etc...you will get used to remembering the tables associated...
Anyways, it useful for people who are new to ABAP.
Regards
Raj
10-19-2014 10:15 AM
Sir actually , You said " if the tables name contains K init it is Header data " . Then in the name of the table LIKP we have both K and P in the name. please can you please tell me a apt way
10-19-2014 10:47 AM
Hi,
I think that it is more important for a programmer to remember and use good programing principles like encapsulation , reduce the number of global variables to the minimum required , typed parameters in a form etc . .
If a good programmer is being judged by remembering table names then something is very wrong here....
The data model is the in the domain of the module consultant they should have this knowledge and pass it to the programmer to do his/her job.
Regards.
08-05-2019 5:08 AM
Table start with:
K = CUSTOMER(KNA1,KONV).
L = VENDOR.(LFA1,LFB1)
V = SALES.(VBAK,VBAP)
T = MASTER DATA TABLE.(TOO1,TOO1W)
B = BANK.(BKNF,BKPF)
E = PURCHASING.(EKPO,EKKO).
M = MATERIAL.(MARA,MAKT,MARC)
Table Name Contains:
K = HEADER DATA.(VBAK,LIKP,VBRK,EKKO)
P = ITEM DATA.(VBAP,LIPS,VBRP,EKPO)
I = OPEN ITEM.(BSIS,BSID,BSIK)
A = CLOSE ITEM.(BSAS,BSAK)
Table Name Ends With ‘S’:(GL_ACCOUNT)
BSIS_GL = MASTER OPEN ITEM.
BSAS_GL = MASTER CLOSE ITEM.
TABLE NAME ENDS WITH ‘D’: CUSTOMER(BSAD, BSID)
TABLE NAME ENDS WITH ‘K’: VENDOR.(BSAK,BSIK)
08-05-2019 6:24 AM
Now when everyone is making it easy to remember, could you add more info about or example for -
I = OPEN ITEM.
A = CLOSE ITEM.
TABLE NAME ENDS WITH ‘D’: CUSTOMER.
TABLE NAME ENDS WITH ‘K’: VENDOR.