Tuesday 21 August 2012

Tips to remember SAP Tables used for Development

An easy way to remember all the main SAP tables used for any development.

Remember Bank tables start with B, say "BKNF , BKPF".
Remember Customer tables start with K , say "KNA1,KONV".

Remember Material tables start with M, say "MARA , MAKT , MARC".

Remember Master data tables start with T, say "T001, T001W".

Remember Purchasing tables start with E, say "EKKO, EKPO"

Remember Sales table start with V, say "VBAK,VBAP".

Remember Vendor tables start with L, say "LFA1".


Six important FI tables:


They contain an I if it is an open item.
They contain an A if it is a closed item.

They contain an S if a GL account say "BSIS , BSAS".


To remember the table names of  Billing, Delivery, Sales and Purchasing:

 
Each table had a K if it is a header data, say "VBAK, VBAP, LIKP, VBRK, EKKO".

Each table had a P if it is an item data, say "VBAP, LIPS , VBRP , EKPO".


With a D at the end , the table is a Customer

With a K at the end, the table is a Vendor.


Finally TSTC tables danced for keeping the list of all transaction codes


For Reference : http://scn.sap.com/community/abap/blog/2012/03/23/fishing-with-sap-tables--a-poem-dedicated-to-all-the-sap-tables-we-use-daily

 

1 comment: