Tuesday, April 9, 2013

How To Remember Table In SAP

When you are new in SAP its really hard to remember all existed tables inside SAP. You can use below  given logic.



  1. The all vendor tables start with L such as lfa1, etc.. 
  2. The all customer tables start with K ... Kna1, konv... 
  3. The all sales tables start with V... vbak vbap 
  4. The all master data tables start with T... T001, t001w 
  5. The all bank tables start with B.. Bknf, bkpf.... 
  6. The all purchasing tables start with E.. ekko, ekpo etc.. 
  7. The all material tables start with M... mara, makt, marc...


  • 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 ....




Finance module Tables


  1. If the table name contains I, that is open item 
  2. If the table name contains A, that is closed item 
  3. If the table name ends with S, that is GL account 
  4. exp BSIS- GL master open items 
  5.     BSAS- GL master closed items 
  6. like wise... 
  7. If the table name ends with D, that is customer 
  8. If the table name ends with K, that is vendor




No comments:

Post a Comment