The most fundamental aspect of master data in SAP S4 HANA is the database tables that make up the object. That is because each data object is a collection of master data tables in SAP. The collection of tables has the object as a primary key to link the tables. For example, there is a single customer number that represents a customer master in SAP and there are 5+ tables that have that customer number as a primary key representing the same object. Let’s take a look at the top 3 key master data objects and the tables behind them
- Business Partner – Customer Master Data Table in SAP S4 HANA
- Business Partner – Vendor Master Data Table in SAP S4 HANA
- Material Master Data Table in SAP S4 HANA
Before continuing with tables, it is important for the reader to understand the overall organization structure of SAP S4 HANA as it relates to master data. If you’d like to learn more of the basics around SAP org structure as it relates to mater data, check this article:
https://techconsultinghub.com/2022/02/18/sap-s4-hana-organization-structure-overview-for-mdm/
Business Partner – Customer Master Data Tables in SAP S4 HANA
Before getting into the customer master, it is important to understand the business partner concept. At a high level SAP S4 HANA merged the customer master and vendor master under a single object called business partner. The interface will be a unified entry point to add new business partners that can act as either customers/vendors or both. In the background there are separate tables that synchronize any fields that overlap automatically.
For example, there is a field for name in both the business partner backend tables and the customer backend tables (they are physically separate tables in SAP that are in sync). SAP automatically updates both tables whenever there is a change from the UI for name. The busines partner & the customer are one to one (SAP does allow a concept of one business partner to multiple customers but it is not widely used). There is a unique link between business partner and customer object key to confirm they are the same entity within SAP
To learn more about the business partner concept and how it relates to customer & vendor in S4 HANA check out the below article:
https://techconsultinghub.com/2022/02/03/sap-s4-hana-business-partner/
Business Partner Customer master can be broken down into three major areas that corresponds to the tables & SAP organization structure
- Business Partner Customer General Data
- Business Partner Customer Sales Area data
- Business Partner Customer Company Code Data
This is a customer master visual break down of the key master data tables stored in customer master data tables in SAP
Business Partner Customer General Data Tables. Tcode SE16N Allows you to view any of these tables & their data stored
Object | Object Area | Table Name | Table Description | Relevant Primary Keys |
---|---|---|---|---|
BP – Customer | General Data (BP) | BUT000 | BP General Data | Business Partner (BP) |
BP – Customer | General Data | KNA1 | Customer General Data | Customer Master |
BP – Customer | General Data | ADRC | Address Data | Address Number |
BP – Customer | General Data | ADRP | Persons Address | Address Number |
BP – Customer | General Data | ADR2 | Telephone Numbers | Address Number |
BP – Customer | General Data | ADR3 | Fax Numbers | Address Number |
BP – Customer | General Data | ADR6 | E-mail Addresses | Address Number |
BP – Customer | General Data | ADR12 | FTP & URL | Address Number |
BP – Customer | General Data | BUT020 | BP Addresses | Business Partner (BP), Address Number |
BP-Customer | General Data | BUT100 | BP Roles | Business Partner (BP), Role |
BP-Customer | General Data | BUT0ID | BP Identification Numbers | Business Partner (BP), ID Type |
BP-Customer | General Data | BUT0IS | BP Industry Sector | Business Partner (BP), Industry |
BP-Customer | General Data | DFKKBPTAXNUM | BP Tax Numbers | Business Partner (BP), Tax Num Type |
BP-Customer | General Data | KNAS | VAT Reg Numbers | Business Partner (BP), Country |
BP – Customer | General Data | BUT050 | BP Relationships General Data | Business Partner (BP), BP Role |
BP – Customer | General Data | BUT051 | BP Relationships Contact Person | Business Partner (BP), Contact Person BP Number |
BP – Customer | General Data | BUT052 | BP Relationships Address | Business Partner (BP), Contact Person BP Number |
BP – Customer | General Data | KNBK | Bank Details | Business Partner (BP), Bank Key, Bank Country |
BP – Customer | General Data | KNVK | Contact Person | Contact Person |
Business Partner Customer Sales Area Data Tables
Object | Object Area | Table Name | Table Description | Relevant Primary Keys |
---|---|---|---|---|
BP – Customer | Sales Area | KNVV | Sales Area Data | Business Partner (BP), Sales Org, Distribution Channel, Division |
BP – Customer | Sales Area | KNVP | Sales Area Partner Functions | Business Partner (BP), Sales Org, Distribution Channel, Division, Partner Function |
BP – Customer | Sales Area | KNVI | Tax Classification | Business Partner (BP), Departure Country, Tax Category |
Business Partner Customer Company Code Data Tables
Object | Object Area | Table Name | Table Description | Relevant Primary Keys |
---|---|---|---|---|
BP – Customer | Company Code | KNB1 | Company Code Data | Business Partner (BP), Company Code |
BP – Customer | Company Code | KNB5 | Dunning Data | Business Partner (BP), Company Code, Dunning Area |
BP – Customer | Company Code | KNBW | Withholding Data | Business Partner (BP), Company Code, Withholding Tax Type |
Business Partner – Vendor Master Data Table in SAP S4 HANA
Business Partner Vendor master can be broken down into three major areas that corresponds to the tables & SAP S4 HANA organization structure.
- Business Partner Vendor General Data
- Business Partner Vendor Purchasing Organization data
- Business Partner Vendor Company Code Data
This is a vendor master visual break down of the key master data tables stored in vendor master data tables in SAP
Business Partner Vendor General Data Tables. Tcode SE16N Allows you to view any of these tables & their data stored
As you can see below the business partner tables are shared between customer & vendor
Object | Object Area | Table Name | Table Description | Relevant Primary Keys |
---|---|---|---|---|
BP – Vendor | General Data (BP) | BUT000 | BP General Data | Business Partner (BP) |
BP – Vendor | General Data | LFA1 | Vendor General Data | Vendor Master |
BP – Vendor | General Data | ADRC | Address Data | Address Number |
BP – Vendor | General Data | ADRP | Persons Address | Address Number |
BP – Vendor | General Data | ADR2 | Telephone Numbers | Address Number |
BP – Vendor | General Data | ADR3 | Fax Numbers | Address Number |
BP – Customer | General Data | ADR6 | E-mail Addresses | Address Number |
BP – Vendor | General Data | ADR12 | FTP & URL | Address Number |
BP – Vendor | General Data | BUT020 | BP Addresses | Business Partner (BP), Address Number |
BP- Vendor | General Data | BUT100 | BP Roles | Business Partner (BP), Role |
BP- Vendor | General Data | BUT0ID | BP Identification Numbers | Business Partner (BP), ID Type |
BP- Vendor | General Data | BUT0IS | BP Industry Sector | Business Partner (BP), Industry |
BP- Vendor | General Data | DFKKBPTAXNUM | BP Tax Numbers | Business Partner (BP), Tax Num Type |
BP- Vendor | General Data | LFAS | VAT Reg Numbers | Business Partner (BP), Country |
BP – Vendor | General Data | BUT050 | BP Relationships General Data | Business Partner (BP), BP Role |
BP – Vendor | General Data | BUT051 | BP Relationships Contact Person | Business Partner (BP), Contact Person BP Number |
BP – Vendor | General Data | BUT052 | BP Relationships Address | Business Partner (BP), Contact Person BP Number |
BP – Vendor | General Data | LFBK | Bank Details | Business Partner (BP), Bank Key, Bank Country |
BP – Vendor | General Data | KNBK | Contact Person | Contact Person |
Business Partner Vendor Purchasing Organization Data Tables
Object | Object Area | Table Name | Table Description | Relevant Primary Keys |
---|---|---|---|---|
BP – Vendor | Purchasing Organization | LFM1 | Purchasing Organization Data | Business Partner (BP), Purchasing Organization |
BP – Vendor | Purchasing Organization | LFM2 | Purchasing Organization Sub Range Data | Business Partner (BP), Purchasing Organization, Plant, Sub Range Vendor |
BP – Vendor | Purchasing Organization | WYT1 | Vendor Sub Range Definition | Business Partner (BP), Sub Range Vendor |
BP – Vendor | Purchasing Organization | WYT3 | Vendor Purchasing Organization Partner Functions | Business Partner (BP), Purchasing Organization, Partner Function, (Vendor Subrange, Plant) |
Business Partner Customer Company Code Data Tables
Object | Object Area | Table Name | Table Description | Relevant Primary Keys |
---|---|---|---|---|
BP – Vendor | Company Code | LFB1 | Company Code Data | Business Partner (BP), Company Code |
BP – Vendor | Company Code | LFB5 | Dunning Data | Business Partner (BP), Company Code, Dunning Area |
BP – Vendor | Company Code | LFBW | Withholding Data | Business Partner (BP), Company Code, Withholding Tax Type |
Material Master Data Tables in SAP S4 HANA
Material master data can be broken down into six major areas that corresponds to the tables & SAP organization structure. The material master has a large number of different views because there are so many underlying tables that make up the material
- Material master general data
- Material master sales organization data
- Material master plant level data
- Material master storage location data
- Material master accounting/costing data
- Material master quality management data
- Material master warehouse level data
This is a material master visual break down of the key master data tables stored in material master data tables in SAP
If you’d like to learn more about the material master in S4 HANA and how it compares with the previous ECC version check out this article below:
https://techconsultinghub.com/2023/11/23/material-master-in-sap-s4-hana-overview/
Table List for Material Master
Object | Object Area | Table Name | Table Description | Relevant Primary Keys |
---|---|---|---|---|
Material | General Data | MARA | Material Master basic data | Material |
Material | General Data | MARM | Units of Measure | Material, Alternate Unit of measure |
Material | General Data | MAKT | Material Master Description table | Material, Language |
Material | General Data | MEAN | Material Master UPC/EAN Table | Material, Unit of Measure |
Material | Plant Level | MARC | Material Master Plant Data Table | Material, Plant |
Material | Sales Level | MVKE | Material Master Sales Data Table | Material, Sales Organization, Distribution Channel |
Material | Sales Level | MLAN | Material Master Tax Classification Data Table | Material, Departure Country |
Material | Accounting Level | MBEW | Material Master Accounting Level Data Table | Material, Valuation Area, Valuation Type |
Material | Storage Location | MARD | Material Master Storage Location Data Table | Material, Plant, Storage Location |
Material | Quality Management Level | QMAT | Material Master Quality Management Data Table | Material, Plant, Inspection Type |
Material | Plant Level | MKAL | Material Master Production Version Data Table | Material, Plant, Product Version |
Material | Plant Level | MDMA | Material Master MRP Area Data Table | Material, MRP Area |
Material | Warehouse Level | MLGN | Material Master Warehouse Data Table | Material, Warehouse Number |
Material | Warehouse Level | MLGT | Material Master Warehouse Storage Data Table | Material, Warehouse, Storage Type |
Material | General Data | DRAD | Material Master Document Object Link Table | Doc Type, Doc, Doc Version, Object |
Material | General Texts | STXH | Text Object Table | Text Object, Text Name, Text ID, Language |
Material | General Texts | STXL | Text Description Table | Text Object, Text Name, Text ID, Language |
Material | HTS Code | /SAPSLL/CLSNR | Trade Classification Number Table | No. Scheme Content (Country) |
Material | HTS Code | /SAPSLL/MARITC | Material Master HTS Assignment (Trade Classification Assignment) Table | Material |
What You Have Learned & Next Steps
Thank you for reading through SAP S/4 HANA latest master data tables. I hope this helped you learn more about the customer master data tables, vendor master data tables & material master data tables in SAP. Now that you’re an expert you can easily assist in master data questions. If this post helped you, consider subscribing below to get the latest content! Feel free to ask any SAP questions but clicking the work with me link below to get in touch.