what is the difference between transaction table and master table??

[Former Member]

also tell me what is the difference between transaction data and master data and how find in a transaction that it is dealing with transactional or master data

[Former Member]

If you choose the data class correctly while creating database table then your table is automatically assigned to the correct area (tablespace or DBspace) of the database when it is created. Each data class corresponds to a physical area in which all the tables assigned to this data class are stored. There are the following data classes:

APPL0 (master data): Data which is seldomly changed. An example of master data is the data contained in an address file, such as the name, address and telephone number.

APPL1 (transaction data): Data that is frequently changed. An example of transaction data is the goods in a warehouse, which change after each purchase order.

APPL2 (organizational data): Customizing data that is defined when the system is installed and seldomly changed. An example is the table with country codes.

master data table is not changes frequently but transactional data table will change frequently. master data records will be less compared to transactional data records.

customer table ie KNA1 is Master data table and VBAK ie sales order header table is transactional data table.

[Former Member]

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

sales orders, purchase orders, etc are called transaction data VBAK,VBAP, EKKO, EKPO etc

Reward if useful

Narendra

[Former Member]

hi,

The data class logically defines the physical area of the database (for ORACLE the tablespace) in which

your table should be stored. If you choose the data class correctly, the table will automatically be created

in the appropriate area on the database when it is activated in the ABAP Dictionary.

The most important data classes are master data, transaction data, organizational data and system

data.

Master data is data that is rarely modified. An example of master data is the data of an address file, for

example the name, address and telephone number.

Transaction data is data that is frequently modified. An example is the material stock of a warehouse,

which can change after each purchase order.

Organizational data is data that is defined during customizing when the system is installed and that is

rarely modified thereafter. The country keys are an example.

System data is data that the R/3 System itself needs. The program sources are an example.

Hope this is helpful, Do reward.

Edited by: Runal Singh on Feb 5, 2008 5:11 PM

[Former Member]

hi

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.

Transaction Table: Data which frequently changes. For

example, the company is selling some materials to one of the

customer.So they will prepare a sales order for the

customer. When they will generate a sales order means they

are doing some sales transactions.Those transactional data

will be stored in Transactional table.

[Former Member]

Master data: very rarely changed.

Transactional data: frequently changed.

these two tables are linked via primary key.

[Former Member]

Hi,

To change the data in master table a unique key is must.

Both the tables are related using Primary key and forign key

Master data: very rarely changed.

Transactional data: frequently changed.

these two tables are linked via primary key.

Regards,

kavitha

[Former Member]

hi !

Master Data: Data which seldom changes.

For example, if a company has a list of 3 customers, 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.

Transaction Table: Data which frequently changes. For

example, the company is selling some material to one of the

customer.So they will prepare a sales order for the

customer. When they will generate a sales order means they

are doing some sales transactions.Those transactional data

will be stored in Transactional table.