Customer, Material & Vendor Master Data Tables
Below are the list of important tables of Customer, Material and Vendor Master Data in SAP.
| Table | Description | Table Category |
|---|---|---|
| KNA1 | General Data in Customer Master | CUSTOMER MASTER |
| KNB1 | Customer Master (Company Code) | CUSTOMER MASTER |
| KNC1 | Customer Master Transaction Figures | CUSTOMER MASTER |
| VCKUN | Assign customer credit card | CUSTOMER MASTER |
| KNVV | Customer Master Sales Data | CUSTOMER MASTER |
| KNVP | Customer Master Partner Functions | CUSTOMER MASTER |
| KNVL | Customer Master Licenses | CUSTOMER MASTER |
| KNVI | Customer Master Tax Indicator | CUSTOMER MASTER |
| KNVA | Customer Master Unloading Points | CUSTOMER MASTER |
| KNKK | Customer master credit management: Control area data | CUSTOMER MASTER |
| KNKA | Customer master credit management: Central data | CUSTOMER MASTER |
| KNEX | Customer Master: Legal Control Sanctioned Party List | CUSTOMER MASTER |
| KNAS | Customer master (VAT registration numbers general section) | CUSTOMER MASTER |
| KNVK | Customer Master Contact Partner | CUSTOMER MASTER |
| KNVD | Customer master record sales request form | CUSTOMER MASTER |
| KNVS | Customer Master Shipping Data | CUSTOMER MASTER |
| KNBK | Customer Master (Bank Details) | CUSTOMER MASTER |
| KNMT | Customer-Material Info Record Data Table | CUSTOMER MASTER |
| KNB5 | Customer Master Dunning Data | CUSTOMER MASTER |
| LFA1 | Vendor Master (General Section) | VENDOR MASTER |
| LFB1 | Vendor Master (Company Code) | VENDOR MASTER |
| LFAS | Vendor master (VAT registration numbers general section) | VENDOR MASTER |
| LFB5 | Vendor master (dunning data) | VENDOR MASTER |
| LFBK | Vendor Master (Bank Details) | VENDOR MASTER |
| LFBW | Vendor master record (withholding tax types) X | VENDOR MASTER |
| LFM1 | Vendor master record purchasing organization data | VENDOR MASTER |
| LFM2 | Vendor Master Record: Purchasing Data | VENDOR MASTER |
| WYT1 | Vendor Subrange | VENDOR MASTER |
| WYT1T | Vendor Sub Range Description | VENDOR MASTER |
| WYT3 | Partner Functions | VENDOR MASTER |
| LFC1 | Vendor master (transaction figures) | VENDOR MASTER |
| LFMH | Vendor Hieararchy | VENDOR MASTER |
| T078K | Transaction-dependent screen selection for vendor master | VENDOR MASTER |
| LFC3 | Vendor master (special G/L transaction figures) | VENDOR MASTER |
| MARA | General Material Data | MATERIAL MASTER |
| MAKT | Material Descriptions | MATERIAL MASTER |
| MARC | Plant Data for Material | MATERIAL MASTER |
| MBEW | Material Valuation | MATERIAL MASTER |
| MARD | Storage Location Data for Material | MATERIAL MASTER |
| MARM | Units of Measure for Material | MATERIAL MASTER |
| MVKE | Sales Data for Material | MATERIAL MASTER |
| MPOP | Forecast Parameters | MATERIAL MASTER |
| MPGD_MASS | Planning Data | MATERIAL MASTER |
| MLAN | Tax Classification for Material | MATERIAL MASTER |
| MLGT | Material Data for Each Storage Type | MATERIAL MASTER |
| MVER | Material Consumption | MATERIAL MASTER |
| MTQSS | Material master view: QM | MATERIAL MASTER |
| MKPF | Header: Material Document | MATERIAL MASTER |
| MKAL | Production Versions of Material | MATERIAL MASTER |
| MLGN | Material Data for Each Warehouse Number | MATERIAL MASTER |
| MOFF | Outstanding Material Master Records | MATERIAL MASTER |
| MSTA | Material Master Status | MATERIAL MASTER |
| MAST | Material to BOM Link | MATERIAL MASTER |
| MSEG | Document Segment: Material | MATERIAL MASTER |
| MEAN | International Article Numbers (EANs) for Material | MATERIAL MASTER |
Thanks….I got all the table for Master data.
We are not able to create Material master starting with ZERO numeric without Alpha characters in SAP.
Kindly provide a solution
Regards,
Babu
i want to know how create customer master data and automatic payment program
I am new to SAP. Can someone please advise how I can indentify Vendor Type? Need to select the correct type of vendors for certain transactions.
Many thanks!