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
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
Cool
ReplyDelete