When you are new in SAP its really hard to remember all existed tables inside SAP. You can use below given logic.
Finance module Tables
- The all vendor tables start with L such as lfa1, etc..
- The all customer tables start with K ... Kna1, konv...
- The all sales tables start with V... vbak vbap
- The all master data tables start with T... T001, t001w
- The all bank tables start with B.. Bknf, bkpf....
- The all purchasing tables start with E.. ekko, ekpo etc..
- 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
- 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
No comments:
Post a Comment