Text-to-Speech dengan MS Excel 2007 (Speak Cells)

Tips mengenai Text-to-Speech dari MS Excel ini sebenarnya cukup klasik, tapi masih layak untuk disundul kembali karena mungkin masih ada yang belum mengetahui fitur ini di MS Excel, khususnya versi 2007.

Text-to-Speech digunakan untuk mengkonversi Text (ketikan) menjadi Speech (suara) yang diucapkan oleh komputer. Fitur ini di MS Excel disebut sebagai "Speak Cells"

Speak Cells juga dapat digunakan untuk membantu kita untuk latihan cara pengucapan kata-kata dalam Bahasa Inggris (English Pronunciation). Asalkan, kata-kata/text Bahasa Inggris yang diketik harus benar agar mendapatkan pronunciation yang benar pula.

Cukup dengan memasukan kata/kalimat Bahasa Inggris ke dalam salah satu cell, lalu click toolbar "speak cells" maka Excel akan mengucapkannya untuk Anda.
Tentunya, Anda harus sudah mengaktifkan Speaker Volume di komputer/laptop Anda terlebih dahulu, karena kalau tidak, niscaya tidak akan terdengar pengucapannya-nya :D

Nah, berikut ini adalah cara untuk mengaktifkan fitur Speak Cells pada Quick Access Toolbar Excel yang memang by default belum tampil:

1. Click More Commands...



2. Excel Options
Customize (Choose Commands from "All Commands") lalu pilih Speak Cells3. Click button "Add >>" untuk memasukkan Speak Cells ke bagian di sebelah kanan "Customize Quick Access Toolbar, kemudian click "OK".




Naah, sekarang Speak Cells toolbar sudah tampil.






Sekarang tinggal gunakan saja fitur ini dengan cara Ketik Text dalam Bahasa Inggris dan Click Speak Cells, dan akan terdengar suara komputer mengucapkan text yang sudah diketik







Selamat mencoba.
Semoga bermanfaat. Amiin.

Creating Dynamic Date Variant in Standard Report

When we need to run a monitoring report, sometimes we have to specify selection date within certain period of time (from/to), i.e. current date/daily, monthly.

Dynamic date variant can be used in order to avoid specifying selection date repetitively. We can specify our own selection date and save it as variant. Thus, we only need to recall the variant by the time we run the report.

Followings are the steps for dynamic date variant creation on MB51 transaction - Material document list.



Specify screen field selection



Click Save button to create variant attributes in detail.
Create variant name and meaning as description.
Select field name that we want to set as dynamic field, i.e. posting date
In this sample, we select field "posting date" with variable "From month start to today".
It means that when we call this variant later, value for posting date will be automatically specified as below.

Posting date From 01.04.2010 (month start) To 08.04.2010 (current date)



Once the variant attributes have been specified, click Save button.
Now we have finished creating a dynamic date variant for MB51 transaction

How to locate table names from a known-field name

When you want to write a functional specification for a customized report in SAP, it is necessary to clearlly specify program logic and also detailed technical information so that it will be easily understood by your ABAP programmer. One of technical information required to be provided is a set of technical field names of relevant SAP tables that will be used in your report.

If you know certain technical field name but forget in which table it is located, then you can use transaction SE15 to locate it.

Go to Objects --> ABAP Dictionary --> Fields --> Table Fields



Specify field name that you what to find out table names



Execute it and following list of tables which contain field name that you have specified will be displayed. You can directly click on table name to get into the table structure.

How to convert QuickVIew (SQVI) to SAP Query

Creating a QuickView via transaction SQVI is quite simpler than using SAP Query. However, QuickView is user-dependant as it is attached to specific user id, and other users cannot use it. If you have a QuickView and want to share with others or add more functionalities which are not supported by QuickView, you need to convert it to SAP Query.
Please refer to following steps:
1. Go to transaction SQ01 to display SAP Query tool
2. Select Query --> Convert QuickView. Following Convert QuickViewer dialog box will be shown as below.



3. Click the check (green) button and new fields will be displayed. Enter a name for your SAP query, Query Group (normally it will take default query group) and enter an InfoSet name.



4. Click the check (green) button to complete and your SAP query is now available in your SAP Query list.

Display Doc/Transaction type code at Dropdown List

How to display document or transaction type code at dropdown list in a transaction. For instance in ME21N, purchasing document type.

Search SAP Menu

Searching menu path of a transaction code in SAP can be done by typing 'search_sap_menu' in command field.

Just fill out transaction code or keyword that you want to search.

What SAP Functional Consultants do

SAP functional consultants analyze the business requirement from clients, transform the essence into an abstract and algorithmic business model. Hence, they identify the use cases and transforms them into logical and technical views. And the main task ranges from conducting blueprint workshop and design, customizing SAP as per business requirement and make sure the system reacts in the manner according to what has been requested by client.

The SAP consultants document the settings and prepare proper guidelines that allow other consultants to do further changes or repairs with due efforts.

The SAP consultants ensure that proper training is given to the key users and that the system is usable, performing appropriately and the business flow is complete and correct.

During go live, consultants assists the technical team by testing the behavior of the system. and after go live, they need to guarantee that the procedures remain usable and consistent in real live situation and proposes enhancements. The main duty of an SAP consultant is to transfer knowledge to the clients. It is not manpower that counts but intelligence, understanding of business processes, a feeling for defects and general a common sense.

Source: miscellaneous references

SAP Materials Management (MM)

The Materials Management application component supports materials management functions and processes in day-to-day business operations.

The MM (Materials Management) application component includes the following transactions and functions:

• Material requirements planning
• Material procurement
• Inventory management
• Invoice verification
• Material valuation
• External services management

MM can be logically integrated with other SAP application components including:

• Production planning and control
• Warehouse management

MM provides the basis for materials requirement planning (MRP) through its integration with the R/3 system purchasing and warehouse/inventory systems application subcomponents.

In purchasing or material procurement, comprehensive functionality is provided to optimize relevant work processes. This includes purchase requisition (PR) generation up to printing out purchase orders (PO).

In inventory management, transactions which trigger to changes in stock levels are as below:

• Goods receipts
• Stock transfers
• Reservations
• Stock adjustments
• Physical inventory
• Return deliveries

Goods receipts can be performed with reference to purchase orders (PO), production order or even without any reference for certain case. This process will update the stock information including the values (if valuated) according to automatic account determination that has been defined in configuration.

Basic Command Field Formats

Followings are basic command field formats as shortcut to execute transactions in SAP, such as creating new transaction in existing session or in a new session and logging off the system.

/n Return to main menu screen



/nex Logoff
/oxxxx Call transaction code xxxx in separate session
/o Generate a session list
/nxxxx Call transaction code xxxx in the same session
/h Turn the debug mode on

Special copy and paste

There is a situation where we might need to capture text or figures from SAP screen transactions and place it to another document format i.e. word, excel or maybe email. You can do so by clicking on the area of the text / figures that you want to capture and press CTRL + Y. it is also possible for you to copy multiple lines at once and paste them later.

After highlighting region or data is done, then you can do Ctrl C (copy) as normal copy in windows application so that later the clipboard can be pasted into another application such as excel or word documents.

About SAP

SAP AG is a company that was founded in Germany in 1972 by five former IBM Engineers. It is located in Walldorf, Germany near Heidelberg.

In German, SAP stands for Systeme, Andwendungen, Produkte in der Datenverarbeitung. And in English, it means Systems, Applications and Products in Data Processing. Over the years, SAP has grown to become the leading and well-known provider of enterprise resources planning (ERP) products nowadays. The SAP R/3 enterprise application suite for open client/server systems has established new standards for providing business information management solutions.

SAP products are considered excellent but not perfect. The main problem with software product is that it will never be perfect.

The main advantage of using SAP as your company ERP system is that SAP has a very high level of integration among its individual applications which guarantee consistency of data throughout the system and the company itself.

In a standard SAP project system, it is divided into three environments, Development, Quality Assurance and Production.

The development system is where most of the implementation work takes place. The quality assurance system is where all the final testing is conducted before moving the transports to the production environment. The production system is where all the daily business activities occur. It is also the client that all the end users use to perform their daily job functions.

source: sap-img.com