Skip to Content
author's profile photo Former Member
Former Member

Easy Way To Remember Table In SAP

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Oct 19, 2014 at 09: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 05, 2019 at 04: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)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2014 at 09: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 😔

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2007 at 06: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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.