, , ,

Customer Master Tables:

Description – Table

General Data in Customer Master – KNA1

Customer Master (Company Code) – KNB1

Assign customer-credit card – VCKUN

Customer Master Contact Partner – MASSKNVK

Customer master record sales request form – MASSKNVD

Customer Master Sales Data – KNVV

Customer Master Partner Functions – KNVP

Customer Master Licenses – KNVL

Customer Master Tax Indicator – KNVI

Customer Master Unloading Points – KNVA

Customer master credit management: Control area data – KNKK

Customer master credit management: Central data – KNKA

Customer Master: Legal Control – Sanctioned Party List – KNEX

Customer Master (Bank Details) – KNBK

Customer master (dunning data) – KNB5

Customer master (VAT registration numbers general section) – KNAS

Material Master Tables

Description – Table

General Material Data   – MARA

Material Descriptions – MAKT

Plant Data for Material – MARC

Material Valuation – MBEW

Storage Location Data for Material – MARD

Units of Measure for Material   – MARM

Sales Data for Material – MVKE

Forecast Parameters – MPOP

Planning Data – MPGD_MASS

Tax Classification for Material – MLAN

Material Data for Each Warehouse Number – MLGN

Material Data for Each Storage Type – MLGT

Vendor Master Tables:

Description – Table

Vendor Master (General Section) – LFA1

Vendor Master (Company Code) – LFB1

Vendor master (VAT registration numbers general section) – LFAS

Vendor master (dunning data) – LFB5

Vendor Master (Bank Details) – LFBK

Vendor master record (withholding tax types) X – LFBW

Vendor master record purchasing organization data – LFM1

Vendor Master Record: Purchasing Data – LFM2

Vendor Subrange – WYT1

Vendor Sub-Range Description – WYT1T

Partner Functions - WYT3

You can download master data tables in excel format by Clicking Here

4 Responses to “Customer, Material & Vendor Master Data Tables”

  1. Venkat says:

    Thanks….I got all the table for Master data.

  2. Babu says:

    We are not able to create Material master starting with ZERO numeric without Alpha characters in SAP.

    Kindly provide a solution

    Regards,
    Babu

  3. shailendra says:

    i want to know how create customer master data and automatic payment program

  4. CJ Hu says:

    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!

Leave a Reply