Master data is a collection of information about a person or an object, e.g. a cost object, vendor, or G/L account. For example, a vendor master record contains not only general information such as the vendor’s name and address, but also specific information , such as payment terms and d delivery instructions. Generally for end users, master data is reference data that you will look up and use, but not.
Transactional data is data related to a single business event such as a purchase requisition or a request for payment. When you create a requisition, for example, SAP creates an electronic document for that particular transaction. SAP gives the transaction a document number and adds the document to the transaction data that is already in the system. Whenever you complete a transaction in SAP, that is, when you create, change, or print a document in SAP, this document number appears at the bottom of the screen.
A routing tool in SAP that forwards documents for review or approval. For example, a requisition that needs to be approved is sent to the appropriate approver’s inbox. Workflow is also used to route journal vouchers, credit card charges, and other documents in SAP.
A Cost Object collects expenses and revenues for a particular purpose, such as a research project. In SAP there are three types of cost objects: Cost Center, Internal Order, and WBS (Work Breakdown Structure) Element (see below for definition).
General or operating Cost Objects are known in SAP as Cost Centers. Cost Centers are budgeted on the fiscal year.
A non-sponsored Cost Object (for example, funding from the MIT Provost)used to track costs over periods other than fiscal years. Internal Orders are often created to track gifts or endowments at MIT.
WBS Element: WBS Elements are funded by outside sponsors and are used to track costs of a particular research project over the entire span of its activity. They may also be created to track other sponsored activities, such as gifts.
G/L accounts are also called Cost Elements in SAP. They are a classification by expense or revenue type. In the CO (Controlling) module of SAP, the term Cost Element is used. In the FI
(Financial) module, the term G/L Account is used. These terms are used interchangeably for reporting, requisitions, and journal vouchers.
Database tables and open SQL
Add a single record to a database table
insert into <database table> values <work area>
Inserting all lines from an internal table into a database table:
insert <database table> from table <internal table>
Delete all records
Select * from zmellemtab.
Deleting records using records from an internal table
delete employees from table itab.
Recommended Reading For You
- What are the different Types of Master data in SAP MM?The Master data in SAP is used to be base data that can store all the required inform about the transaction. If someone producing, transferring stock, selling, purchasing, doing physical […]
- What is SAP Workflow?Lets go by the very basic meaning of SAP workflow:SAP workflow, as the name suggests, means ‘FLOW OF WORK’ from one person to another person. It is, in fact, a sequence of connected […]
- What is Alternative Payee in SAP?The Alternative Payee in SAP can make payment to a vendor other than the one to which the invoice was posted. The payment is made to an alternative payee, which must be specified in the […]
- When do you use SAP workflow?SAP workflow
The following factors need to be considered to decide whether sap workflow should be used for the business situations.1. Human factor: SAP workflow is more appropriate […]
- General Ledger Master Data in SAP FICOGeneral Ledger Master Data in SAP FICO: In SAP, the basic element of the master data structure in the General Ledger is the chart of accounts, which is assigned to a company code and […]