Sunday, 16 August 2015

Mass Creation of Vendor (Supplier) Master Records through LSMW

Easy 12 steps for mass creation of vendors(suppliers) using Legacy System Migration Workbench - SAP Standard Tools.

Step 1: Maintain Object attributes
Step 2: Maintain Source Structures
Step 3: Maintain Source Fields
Step 4: Maintain Structure Relations
Step 5: Maintain field mapping and conversion rules
Step 6: Maintain fixed values, translations, user-defined routines
Step 7: Specify files
Step 8: Assign files
Step 9: Read & Display imported data
Step 10: Convert and Display converted data
Step 11: Create batch input session
Step 12: Execute Batch Input Session

First, call Legacy System Migration Workbench by entering transaction code LSMW.

Thursday, 13 August 2015

Distinguish FI Documents Doc Type for corresponding Controlling Documents

Probably we may have noticed that all FI documents for corresponding controlling document that are generated from the controlling application component is most of the times same i.e. AB or any other document type that we might have configured.

However there might be a Business Requirement that we should be able to distinguish the FI documents that are generated because of the corresponding controlling document from other FI documents generated out of non-controlling application component.

How to address this Business Requirement
  • First: We can definitely look at the business transaction from FI Table – BKPF & BSEG and Text field in BSEG in order to check if the FI document is related to a Controlling Document however this may not be very handy as more analysis might be required.
  • Second: We can create & designate a different document type for the FI postings that are generated because of corresponding controlling document posting and in that way only by referring the document type it is quite easier to identify instead of depending on text or business transactions.
Now the question comes where we configure the Document Type that is used for FI posting for a controlling document:

Monday, 10 August 2015

Simple Finance - The Convergence of the GL Account and the Cost Element

In this post we will look at the convergence of long standing pieces SAP ERP finance master data, the GL Account and the Cost Element. As anyone that has worked with SAP CO in the past knows the cost element is key to the controlling side of SAP. It in an object that allows you to identify the type of activities that can be done within controlling with that account. They are generally divided into Primary and Secondary cost elements.

  • Primary cost elements have an associated GL account and are generally expense or revenue accounts.
  • Secondary cost elements exist only in CO and are used for internal settlements, assessments, and allocations.

When creating a new revenue or expense account in the GL you have to create a corresponding cost element in CO and typically all you were doing was selecting a Cost Element Category.

With the Simple Finance Add-on 2.0 (now called On Prem 1503) the traditional cost element create, change and display transactions are gone. The functions have been combined in FS00 - Manage G/L Account Centrally. This greatly simplifies the act of creating a new account and eliminated the need to maintain separate masters.