SAP How to Guide 20 Jan 2010
How to efficiently use the new SAP Netweaver BW intregration in SAP BusinessObjects Xcelsius
SAP BusinessObjects Xcelsius is a widely used dashboarding tool. It has the capability to show data from various sources and data bases, including data residing in the SAP NetWeaver BW. With the latest version of Xcelsius and SAP NetWeaver BW 7.01 SP5, we offer a new connection type for BW data that offers a tighter integration of BW data into Xcelsius dashboards.
In addition, the Xcelsius dashboard can be stored on the BW server and is integrated into the BW infrastructure, providing features such as transport, translation support, where-used lists, and collection of dependent objects.
With the new SAP NetWeaver integration in Xcelsius users have the possibility to use a great number of features of SAP NetWeaver BW directly.
Viewed 9192 times by 3000 viewers
SAP : Batch Input Session
Displaying Session Logs
The batch input system keeps a detailed log of each session that is processed. The log contains not only progress messages from the batch input system itself, but also error messages from the transactions that are processed.
For analyzing an SAP error in a session, you should start by checking the session log for relevant messages. A session log is kept only if the session was generated with the KEEP option or if the session is aborted or contains an error.
Viewed 9329 times by 3145 viewers
SAP Process : Reorganize Sessions and Logs
Some question about the processed items in Batch Input Session. We found that there is no any processed item/log under processed tab in batch input session.
So the question is why the processed items are deleted?
Batch Input: Reorganize Sessions and Logs
The program RSBDCREO will delete only successfully “processed” batch session. This SAP standard program will do reorganization on APQD table (control BDC session). Otherwise, the table will become so big.
The SAP program RSBDCREO does the following:
- Deletes (sucessfully) processed sessions still in the system and their logs. Only these sessions are deleted and not “sessions still to be processed”, “sessions with errors”, and so on.
- Deletes logs, for which sessions no longer exist.
Viewed 9251 times by 2882 viewers
SAP Tip : How to default translation date for Foreign Currency document
Normally translation date of SAP document, posting with foreign currency is taken as posting date. So if you want the translation date should be the same to document date.
Go to GGB1 transaction for substitution creation
The next step is create step for substitution: now a popup comes up and you have to select translation date.
If BKPF-WWERT is not in the list you have to change the corresponding entry in table GB01 (BEXCLUDE has to be empty). When you select translation date, you choose field-to-field substitution and you enter BKPF-BLDAT (document date) as source field.
Save then! After that you have to activate in OBBH transaction as well.
Viewed 9716 times by 3436 viewers
SAP Business : Evaluation of Actual Values Process
This SAP business refers to the process of generating cash management reports.
Periodically, apart from cash position report and liquidity forecast report, other reports in cash management module should also be generated for further analysis.
Detailed and Design
The following types of reports should be generated
- Comparison reports : Reports comparing bank terms and value dates versus actual transaction dates.
- Cheques reports : Reports providing information on cashed/ outstanding cheques. These reports are relevant only if countries track cheques within the cash management module.
- Reconciliation reports : Reports displaying the reconciliation of values from financial accounting, materials management and, sales and distribution modules to cash management module.
Viewed 9558 times by 3261 viewers
Input and Output Tax Definition
Input / Output Tax:
At month-end, Input tax is offset with output tax and balance have to pay/receive the goverment.
Some countries allow setoff of output tax against inout tax which is called VAT in European countries and MODVAT in India ( hta is tax payable on sold items against tax paid against bought out items) based on materials and products.
Input Tax is receivable account and Output Tax is liability account. Output tax is periodically set off against input tax.
Viewed 10059 times by 3776 viewers

















