Ads

SAP Master Data Tables

-

SAP Master Data Tables

These are very Important Master Data Tables list gathered from different Modules , useful for Functional and Technical consultants to use them in their SAP Applications.


VIMI01 - Rental unit - master data Real Estat - Real Estate Management
BKK42_CC - BCA Account master data: Currency Changeover IS - Master Data
ACCRBD - Accruals/Deferrals master data - Basic Data FI - Financial Accounting
RSOSOHIET - Directory for master data Hierarchies - Texts BW - Data Staging
CRFH - CIM production resource/tool master data PP - Production Resources/Tools
BKK42 - Current Account master data: Operative Data IS - Master Data
CMDT_CC - Generic master data: Cost Center Enhancements CO - Overhead Cost Controlling
RSDBCHATR - master data attributes BW - Metadata (Repository)
EGERS - IS-U Device master data IS - Device Management

Customer Master Tables
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

CSKS - Cost Center master data CO - Controlling
MARA - General Material data Logistics - Material Master
MARC - Plant data for Material Logistics - Material Master
KNA1 - General data in Customer master Logistics - Customer Master
LFA1 - Vendor master (General Section) FI - Financial Accounting
MAKT - Material Descriptions Logistics - Material Master
CDHDR - Change document header Basis - Change Documents
MBEW - Material Valuation Logistics - Material Master
LFB1 - Vendor master (Company Code) FI - Financial Accounting
MVKE - Sales data for Material Logistics - Material Master
KNVV - Customer master Sales data Logistics - Customer Master
MAST - Material to BOM Link Logistics - Bills of Material
KNB1 - Customer master (Company Code) FI - Financial Accounting

Material Master Tables
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

VBAK - Sales Document: Header data SD - Sales
EKPO - Purchasing Document Item MM - Purchasing
VBAP - Sales Document: Item data SD - Sales
EKKO - Purchasing Document Header MM - Purchasing
MSEG - Document Segment: Material MM - Inventory Management
BKPF - Accounting Document Header FI - Financial Accounting
VBRK - Billing Document: Header data SD - Billing
MARD - Storage Location data for Material Logistics - Material Master
ADRC - Addresses (Business Address Services) Basis - Address Management/Business Address
LFBK - Vendor master (Bank Details) FI - Financial Accounting
ANLA - Asset master Record Segment FI - Basic Functions
STXH - STXD SAPscript text file header Basis - SAPscript
ADR6 - E-Mail Addresses (Business Address Services) Basis - Address 

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) (XLFBW)
Vendor master record purchasing organization data(LFM1)
Vendor Master Record: Purchasing Data(LFM2)
Vendor Subrange(WYT1)
Vendor Sub Range Description(WYT1T)
Partner Functions(WYT3)

Vendor Master
LFA1 Vendor master
LFB1 Vendor per company code
LFB5 Vendor dunning data
LFM1 Purchasing organisation data
LFM2 Purchasing data
LFBK Bank details
Customer - material info record
KNMT Customer material info record
Bank data
BNKA Master bank data
Accounting documents
BKPF Accounting documents
BSEG Item level
BSID Accounting: Secondary index for customers
BSIK Accounting: Secondary index for vendors
BSIM Secondary Index, Documents for Material
BSIP Index for vendor validation of double documents
BSIS Accounting: Secondary index for G/L accounts
BSAD Accounting: Index for customers (cleared items)
BSAK Accounting: Index for vendors (cleared items)
BSAS Accounting: Index for G/L accounts (cleared items)
Payment Run
REGUH Settlement data from payment program
REGUP Processed items from payment program
Customizing Tables
Company code
T004 Chart of accounts
T077S Account group (g/l accounts)
T009 Fiscal year variants
T880 Global company data
T014 Credit control area
FI document
T010O Posting period variant
T010P Posting Period Variant Names
T001B Permitted Posting Periods
T003 Document types
T012 House banks

Management/Business Address
LFM1 - Vendor master record purchasing organization data Logistics - Vendor Master
KNVP - Customer master Partner Functions FI - Basic Functions
MARM - Units of Measure for Material Logistics - Material Master
STXL - STXD SAPscript text file lines Basis - SAPscript
MLGN - Material data for Each Warehouse Number Logistics - Material Master
MLAN - Tax Classification for Material Logistics - Material Master
AUFK - Order master data CO - Overhead Cost Orders
PRPS - WBS (Work Breakdown Structure) Element master data Project Systems - Operative Structures
PREL - HR master data (Old Version, For Conversion Only) Personnel Mgmt - Personnel Administration
CEPC - Profit Center master data Table Enterprice Controlling - Profit Center Accounting
EQUI - Equipment master data PM - Equipment
CEPCT - Texts for Profit Center master data Enterprice Controlling - Profit Center Accounting
SKA1 G/L Accounts (Chart of Accounts)
SKAT G/L Accounts (Chart of Accounts: Description)
SKB1 G/L Accounts (Company Code)
Customer Master


KNA1 Customer master
KNB1 Customer / company
KNVS Shipment data for customer
KNVK Contact persons
KNVI Customer master tax indicator
KNVV Customer sales data
KNBK Bank details
KNVH Customer hierarchy
KNVP Customer partners

ACCRFI - Accruals/Deferrals master data FI/CO Account Assignment FI - Financial Accounting
HIKO - Order master data history PM - Maintenance History
BKK40 - Current Account master data: General IS - Master Data
EHSWAT000 - MD (BDT): Master Table for the Waste Management master data Environment.


Comments

  1. harithaTuesday, December 21, 2021

    This post is extremely radiant. I extremely like this post. It is outstanding amongst other posts that I’ve read in quite a while. Much obliged for this better than average post. I truly value it! sap mm institute in hyderabad

    ReplyDelete
  2. navya sreeFriday, March 25, 2022

    This post is extremely radiant. I extremely like this post. It is outstanding amongst other posts that I’ve read in quite a while. Much obliged for this better than average post. I truly value it! sap fico in hyderabad

    ReplyDelete

Post a Comment

Popular posts from this blog

BADI Interview Questions in SAP ABAP

-
BADI Interview Questions in SAP ABAP A BAdI is an object-oriented enhancement option, which makes it the most sophisticated enhancement type. The main characteristic of a BAdI is that it provides a mechanism to change the functionality of a well-defined business function without making changes to the delivered source code. Future upgrades of the original business function can be applied without losing the customer-specific enhancements or the need to merge the changes.  If you want to become a professional and technical blogger practically, read these real-world practical SAP ABAP books . These books will help you to become a more flexible coding developer in future SAP technology. What is a BADI in SAP? BADI (Business Add-In) is a new SAP Object Oriented enhancement technique that is used to add our own business functionality to the existing SAP standard functionality.  BADI follows the Object-Oriented approach to make them reusable. A BADI can be used any number of times
Read more

Sample SAP ABAP Programming Examples for Practice

-
Sample SAP ABAP Programming Examples for Practice Are you a beginner at ABAP Language, you're looking for example programs for practice. Here I collected some sample programs from various objects in ABAP that are useful for beginners to improve their Technical skills. To familiar with coding and ABAP applications, you must be practice all applications. As per my experience, practice makes you perfect, as a technical consultant, should be ready to develop any object based on the need of the client, then only, we will get appreciation from the client and from our team side and it helps us to develop complex objects in SAP. ABAP Syntax ABAP Statements ABAP Program Types SAP ABAP Workbench Tools SAP Modules SAP Transaction Codes SAP Tables SAP ABAP Hello world Program Example ABAP- Simple ALV report Example ABAP- Interactive ALV Report Example ABAP- BDC Call Transaction Method Programming ABAP- BDC Session Method Programming Example ABAP- Smartforms
Read more

Module Pool Programming Interview Questions and Answers in SAP ABAP

-
Module Pool Programming(Dialog Programming)  Interview Questions and Answers in SAP ABAP As an ABAP Consultant, you should be strong in Module pool programming techniques as well as when you face the real-time or fresher interview, Questions, and answers to test your talent to select for the interview. For that purpose, I am sharing my interview experiences in which I faced the most of the times on these topics that are at exit command, events difference between set screen and call screen difference between call screen and set screen in module pool,chain-end chain in module pool. What is the transaction code for the screen painter? SE51. What is the transaction code for Menu painter? SE41. What is the transaction code for the screen painter? SE93. What are the main components of dialog programs? Screens Module pools Subroutines Menus Transactions What is Screen flow Logic? The screen flow logic is like an ABAP program in that it serves as a
Read more

Step by Step tutorial on BDC Session Method Program in SAP ABAP

-
Image
Step by Step tutorial on BDC Session Method Program in SAP ABAP BDC Session Method is used to upload data from Non-SAP to SAP System. Using Session method, we can transfer data through more than one Transaction, Unlike BDC Call Transaction Method Program . We are Processing Batch input Session From SM35 Transaction Code. Session method. 1) synchronous processing. 2) can transfer a large amount of data. 3) processing is slower. 4) error log is created 5) data is not updated until the session is processed. Call transaction Method. 1) asynchronous processing 2) can transfer a small amount of data 3) processing is faster. 4) errors need to be handled explicitly 5) data is updated automatically Go to SHDB and Press Enter Click on New Recording Button and Give the zrecord1 name and enter transaction code MM01 and click on the Start recording button. The system goes to the Create material screen, there give the industry sector and material type and selects ba
Read more

SAP ABAP Interview Questions and Answers for 10 Years Experienced

-
SAP ABAP Interview Questions and Answers for 10 Years Experienced This post will helpful for SAP ABAP experienced candidates who may have 3,4 5, 6,7, and 10 years of experience, all of them can be follow this interview pattern for their successful interview.  SAP Data Dictionary Realtime Interview Questions SAP BDC Realtime Interview Questions SAP ALV Reports  Real-time Interview Questions Module Pool Interview Questions SAP Smartforms Realtime Interview Questions SAP BADI Realtime Interview Questions SAP BAPI Realtime Interview Questions SAP  IDOC Realtime Interview Questions ABAP Check and Value Table Questions SAP SD MM FICO Flow Interview Questions SAP OOPs Realtime Interview Questions SAP OOPs Part One  Real-time Interview Questions SAP OOPs Part two Real time Interview Questions SAP OOPs Part three Realtime Interview Questions SAP OOPs Part four Realtime Interview Questions ABAP  Realtime Interview Questio
Read more