Periodic Jobs and Tasks in SAP BW

This whitepaper, provided by SAP, is a must for those use SAP BW and it provides recommendations about jobs and tasks that have to be performed on a regular basis to ensure system performance and stability in a BW system. It may be also useful for you to check Daily BW Systems Checklist

  • Support Package Strategy
  • Backup Strategy
  • Transports and SAP Notes
  • Monitoring Basis Jobs
  • Monitoring Application
  • Monitoring Query Performance
  • Create, Delete Aggregates
  • Data Management and more…

Read more

Useful SAP R/3 Procedures

Below you will find some tips and tricks which are for commonly used procedures in SAP and that will save your time. Mainly the topics are;

  • User File Capture of SAP Print Spool Output
  • Determining Where a Field is Used
  • System Access to Logical Databases
  • Listing Standard SAP Reports Listing Reports by Group
  • Listing the Reports Tree
  • Make a Text File of an ABAP Program
  • Exporting a Report Writer Report

Read more

SAP New General Ledger Accounting Functions

The new general-ledger accounting software in mySAP ERP can help companies like yours address these issues. mySAP ERP now provides a unified structure that combines individual ledgers – such as the cost-of-sales, profit-center-accounting, and consolidation-staging ledgers. With this structure you can:

  • Considerably accelerate your period-end closings
  • Flexibly perform reporting tasks based on data reconciled in real time
  • Efficiently handle financial reporting, according to both local and international accounting principles

This document explains how the new general-ledger software in mySAP ERP incorporates the new features. It also describes how you can make the transition from the general-ledger accounting functionality in SAP® R/3® software to the new general ledger.

Read more

Tips and Tricks for SAP Business One – 2

In my previous post, i shared SAP Business One Tips and Tricks document that i confronted at Clients First site. This is another tips and tricks document you are shown how to find out the description of a field in SAP Business One, the hierarchy of the default layouts when printing, in-depth workings of the Special Pricing functionality, what is a key pre-requisite for posting the journals generated from the Period-End Closing function and much more.

Questions you will find answer for are as follow;

  • What is the hierarchy of the default Print layout?
  • What Price does the price field in the Special Prices for Business Partners main window reflect?
  • Why an error message relating to date deviation appears in Period-End Closing function?
  • How to see the remaining quantities to be delivered to the customer?
  • How to Insert a Watermark in a Printed Marketing Document?
  • Why is the system giving this message: ‘Confirmation amount must be greater than zero [Message 173-18]’?
  • s there a quick way to access the explanation of a specific field in SAP Business One?
  • Non-Included Transactions in the Payment Wizard
  • How to record the validity of tax exemption certificates?
  • How to cancel a journal entry using today as posting date?

Read more

SAP Invoice Verification End-User Training Manual

This course focuses on Verification Vendor Invoices for Materials (Non Stock) and Services in SAP, The invoices from Vendor are recorded in SAP by referring to:

  • Purchase order number (against which the non-materials/services are delivered by the Vendor) and the system would list down all the eligible line items from Purchase order for processing the Invoice. The relevant line items specific to the invoice presented by the Vendor needs to be selected before proceeding further.
  • Vendor code, where the system will list down all the eligible items (materials/services), from various purchase orders, for invoice processing. The relevant items (materials/services) are selected from this list, which is indicated in the Vendor’s invoice, for further processing.
  • The Vendor (Invoice Party Partner), the vendor document number, date of invoice receipt and total value of the Invoice are mandatory fields on the header of the Invoice.
  • The value and currency from the Vendor’s Invoice are entered during Invoice processing and the system gives message for any differences between the value from Vendor’s Invoice and the Purchase order values and the quantity in the Goods Receipt.  The invoice will not be posted until the difference is zero between the debits/credits (or within the allowed tolerances).
  • A document number is generated after successful posting of Vendor’s invoice and this would now enable processing of payment to vendor (against this invoice) using the baseline date of the entered vendors document date and the terms of payment.An accounting document is also created automatically in the background to recognize Vendor liability and to clear the GR/IR.

Read more

Master Data Uploads Using CATT Tool

This article explains the steps involved for uploading of master data & cutover open items by using CATT tool, which will be useful for the functional consultants with out the help of writing BDC program by the ABAP consultant.
As this CATT tool got so many advantages like:

  1. Which can be used with out any ABAP coding,
  2. Save the time at the time of implementations/ upload scenarios.
  3. Which can by done by functional consultants with out any ABAP consultants help
  4. Which can be uploaded from Development client to Testing client to get the testing sign-off and can be directly uploaded in to Production client from Development as well.
  5. To upload from Dev to Prod client we need to check RFC settings at basis module level. At t code: SCC4 this setup should be there.

The objective of this article is to explain you on step by step process to upload master data / open item data at cutover time by functional consultant himself.

Read more

Reduce Your ABAP Development by Using the Mass Maintenance Tool

There are two ways to make mass changes to master and transactional data. The core MASS transaction code enables certain master data fields to be changed all at once. This eliminates the need for users to update fields manually or write one-off ABAP code to make the change. The other way to make mass changes is via the mass change icon in the customer, vendor, or GL account open item transactions.

Did you know that there is a way to change the accounting clerk of 5,000 customers in a matter of minutes without writing a program? Did you know that you can update the baseline date for vendor invoices for a range of vendors at the same time? When you need to perform large changes to master data, do you normally write a custom program to facilitate this?

Read more