What is master and transaction tables?

Question

A transaction is an activity performed by entities(master tables) within the system. These activities are captured in transaction tables and usually, these transaction entries have foreign keys to master records. Transaction tables are designed to store events in the system. 17 мар. 2020 г.

What is master table and transaction table in SAP?

The permanent data is called MASTER data like Employee Information, departmrnt info. Day to day business data is called TRANSACTION data like sales, salaries, expenses. In SAP, Material , customer and vendoe etc.. are called master data tables MARA, KAN1,LFA1 etc.

What is a master table?

« Back to Glossary Index. The tables that hold the records containing general information about the participants or objects of transactions within a module. In General Ledger the master table contains the account names, numbers, and balances.

What is difference between master data and transactional data in SAP?

The main difference between master data and transaction data is that the master data is the data that represent people, places or things that are related to an organization whereas, the transaction data is the data used by the master data. Data is important to every business organization.

What is master table in SQL with example?

Master Data: Data which seldom changes. For example, if a company has a list of 5 customer then they will maintain a customer master table having the name and address of the customers alongwith other data which will remain permanent and is less likely to change.

Expert · Answer