What is transaction and master table?

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 master table and transaction table in SQL?

usually a master table would contain information at a high level.. who it is being sold to, customer id, etc. transaction table would be what you're selling, item number, qty etc.

What is the meaning of master table?

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 master data and transaction data in SAP?

master data :data which is seldomly changed. example is data which is there in address like name ,address and telephone number. transaction data : this data will change frequently .example is goods in ware house data which change after every purchase order.

Expert · Answer