SAP Master Tables
| Vendor Master (General Section) | LFA1 |
| Vendor Master (Company Code) | LFB1 |
| Vendor Master (Bank Details) | LFBK |
| General Data in Customer Master | KNA1 |
| Customer Master (Company Code) | KNB1 |
| General Material Data | MARA |
| Material Descriptions | MAKT |
| Plant Data for Material | MARC |
| Storage Location Data for Material | MARD |
| Units of Measure for Material | MARM |
SAP Header and Item tables
It is good idea to get familiar with SAP standard tables. SAP has tables with Header and Item relationship and below I am displaying a limited list of header and items tables for learning purpose. These tables will be used frequently throughout this course.
| Process | Header Data | Item Data |
| Sales Document | VBAK | VBAP |
| Purchasing Document | EKKO | EKPO |
| Billing Document | VBRK | VBRP |
| SD Document: Delivery | LIKP | LIPS |
| Accounting Document | BKPF | BSEG |
| Material Document | MKPF | MSEG |
Below is a simplified relationship diagram of SAP Materials Management table. This is not the complete list of SAP MM tables.
Some common tables of SAP FI and its relationship with other tables is shown below.
The good part is that SAP follows a naming convention and the blow table highlights the common naming convention. Remember that there can always be an exception.
| Customer | KN* |
| Sales | VB*, VA*, VK* |
| Shipping | VT*, VB*, VE* |
| Delivery | LI* |
| Material Master | MA*, MB*, MK*, MS*, MV* |
| Billing | VB*, VR*, VK* |
| Pricing | KO* |
| Purchasing | EK*, EI* |
| Vendor Master | LF* |
| FI tables | BS* |
| Cost center accounting | CO*, CS* |
| Organisational elements | T001* |