Thursday, 30 April 2015

Error “Enter numeric values only” while creating Company code in SAP



Steps to resolve error “Enter numeric values only


This is a bug in enterprise version of SAP.There is a SAP Note . There is one table called TNIW5, We need to adjust the entries .






Basically it should be “012’ instead of 12 .


We need to go to table and adjust the entries .


Navigate to transaction SE16 and select table TNIW5


delete the selected entry

SAP MM Training 2- Setting up of organization structure in SAP


Setting up of Client & Company Code




Am taking TATA group for setting up my organization structure in this trainings . As you all know that Tata group have more than 180 + companies like TCS, Tata tea, TISCO .exc.

TISCO has got plants in Jamshedpur  and Billai for our practice , we will be defining 2 plants as if they were located in USA.

I will be using 1000 chart of account in training , as we need to create all GL accounts if we want our own chart of accounts .

In real implementation Organization structure will be delivered in workshops.People involved in this is Client team , Consulting team & Hierarchy Expert .For small companies this will be completed in couple of weeks . For bigger organization , This activity sometimes take 2-3 months of effort .

Client team explains

  • about their business
  • what they do
  • How they do



Consultant will take this input and arive at enterprise org structuire.As a consultant you would be providing options to business and explain their impliacations of each .


We would be defining below areas as part of SAP Hierarchy

  • Financial Dept
  • Material Management Dept
  • Sales & Distribution




Assuming that we have finished all brain storming sessions and come up with the below org structure :

We will define independent organization elements and then assign them .
As you all know finance be the critical for every organization , we would be defining elements of this Department first.


Finance consultant will define all these elements . Though we deal with MM in this training, for some time we will play FI consultant role .



How to define Client:

When ever am creating a new entry I always go with copy control option , so that we won't  face issue while working . Its not like we should not create new , we will end up by entering lot of information .


Click Copy As


Tata Group Company(represented as Client in hierarchy figure) gets  created .



Select Transport number


You can see data save message in bottom right


We have created Company ,let see how to create credit control area














Steps to create Credit Control Area

Select IMG→ Enterprise structure -->Definition → Define credit Control Area


Select standard CCA and click copy as




Enter the following details

Click Enter



Select Transport number and save these changes


You can see data save message in bottom right


We have created Company ,let see how to create credit control area

Steps to create a Company Code


Select IMG→ Enterprise structure -->Definition → Edit , Copy,Delete,Check Company Code


We can create our own company code data by entering all data using “Edit company Code data” , But I always recommend you to use copy function to avoid integration issues .
Click on ‘ Copy,delete,check company code”




This will take few minutes , as company code data stores in various tables .In general all these information will be stored in T001 , T002,3,4.. etc



You will get the below message’s

As I dont want to create all GL account for training purpose , Click “yes”.But in real time the FI consultant will say NO



As I want to create US company and want to change  currency to USD . CLick “Yes”




Ignore the profit center accounting stuff











We will get a message states that some of the number range information gets copied and some not .






Click “No” as I want to create our own number ranges.These number ranges are non transportable,hence these are called soft configuration’s.There are other ways of transporting number ranges if client really want .



You will get message that all tables has been copied








Click Back and go with Edit Company Code data


Update Company name , city,Country,currency & language and save

Monday, 27 April 2015

SAP MM Training - MM Overview

MM Overview


SAP MM is a part of supply chain application.

Lets take an example , we are buying raw materials outside and manufacturing a Bread.
Process begins with procurement of raw material  from vendor and storing in warehouse (Material Management module),Taking this raw material and baking bread with different sizes (Production Planning Modules) .Selling this to customer (Sales & Distribution Module). Once the sale is performed , this details will be going to Finance for settlement (FI-CO modules).

As explained above SAP is tightly integrated and will help organization to perform operation easily .

The MM application module supports the procurement inventory functions occurring in day to day business operations.






  • Key Elements

    • Enterprise structure
    • Master data maintenance
    • material procurement (purchasing)
    • Inventory management
    • special procurement
    • material requirement planning
    • Invoice verification
    • Material valuation
    • Vendor evaluation
    • External Services management
    • Batch Management
    • Purchasing information System
    • Inventory Controlling Information System




SAP MM Training - SAP Introduction

What is ERP?



ERP software facilitates the flow of information among all the process of an organization's supply chain , from procurement to pay , including Accounting and Human resources . ERP software eliminates the common problem of multiple incompatible software systems and databases in use in the departments or functional areas of many corporations.

With one integrated comprehensive system (which could be distributed internationally ) with one database , whose process run more smoothly with up to date information availability throughout the corporation.

Various ERPs in the market

High End


SAP (Programming Language:ABAP R/4)
Oracle (Programming Lang:SQL)
Peoplesoft  (Programming Lang:People CodeNow Acquired by Oracle)

Mid Range


JD Edwards(Programming Lang:One word Acquired by Peoplesoft and then by Oracle)

BAAN(Programming Lang:BaaN Tools)
RAMCO


SAP as an ERP

Systems, Applications and Products in data processing



SAP AG at Glance


  • SAP comprises of number of integrated modules which covers virtually  every aspect of business

  • Founded by Hasso Plattner in 1972 at in Mannheim, germany

  • Vision :Develop standard application software for real time business

  • Market leader in Industry Enterprise Applications(IEA)
    • About 25 % market share in the ERP market
  • Worldwide presence in 50 countries
    • 50000 Employees
  • 100600 customer in over 120 countries with more than 10 million users
    • 600 new installation per month
  • Strength lies in its high Integration ,mainly for large, global corporate enterprises

SAP Evolution



The R/1 & R/2 Systems
R/1 -developed for tractor manufacture company & released in 1972 with SD  & MM,Discontinued after release of R/2 in 1975 - Added finance applications.First successful implementation is for ICI chemicals.

The system was developed to run on mainframe computers and reorganized as leading mainframe software for large multinational corporations.
This continued till 1993 i.e. the year of SAP R/3 system released in the market .




In 2000 , SAP renamed their solution mySAP and release the latest version of SAP, named as ECC or Enterprise Core Component, and the most recent release is ECC 6.0.

SAP’s current release strategy is to provide Enhancement packs with additional functionality instead of releasing new versions of the software.
SAP’s Enhancement pack strategy eliminates major upgrades and allows customers to choose with enhancements to apply to their systems.



SAP Milestone over 35 years



SAP R/3 Architecture -3 tier architecture




Advantages of SAP



  • Integration of various modules
  • Faster and cheaper
  • Real time reporting
  • Multiple languages(40+)
  • Multiple currencies (200+)
  • Multiple countries (225+)
  • reduced Manpower


Customization Vs Configuration


The adaptation of application software to customer - specific needs is accomplished in two ways :

Coding :


Programming customer specific code that replaces or complements the components of application .

Configuration :


Rendering the application appropriately to a specific customer by specifying the data upon which the application operates  

Role Of Functional Consultant



  • Customizing the respective business area/ application area and making sure the system reacts in the manner according to the constraints of the requested use case

  • Documents the settings and prepares proper guidelines that allow other consultants to do further changes or repairs with due efforts

  • takes care that proper training is given to the users and that the system is usable , performing appropriately and the business flow is complete and correct .

  • Go Live assistance for the technical staff by testing the behaviour of the system .


  • Post go live he guarantees that the procedures remain usable and consistent in real live situation and proposes enhancements.

  • The main duty of a consultant is to transfer external know -how to the client.It os not manpower that counts but Intelligence , understanding of process , a feeling for defects and general a common sense.

Monday, 30 March 2015

SAP BW Training 6-BW Database Design

BW Database Design


BW is multi dimensional.In the case of BW data is stored in the form of cubes .
designing the cube is called SCHEME DESIGN.


Schema designs

Star Schema

  • In the case of fact table or transaction table is kept inside a cube . That means a fact table is created in database when we create Cube .
  • Even the master tables also kept inside the cube . That means a master table also gets generated when we create a cube .
  • Fact table and master table are connected with primary key and foreign key relationship .
  • Cube has 16 dimensions


For every dimension of a cube , One master table is linked .

Any schema design we consider , the below condition will satisfy
Facttable ---------Connected to ---------------> master table
Mastertable ---------Connected to ---------------> Dimension

So Indirectly

Fact Table ---------Connected to ---------------> Dimension

In the above figure we have two master tables , that means two dimensions , we can analyse data in two dimensions (Customer & Material)

C.No   RVN
C1 800
C2 400


M.No   RVN
M1 600
M2 600


BW 1.0,1.1,1.1C,> 2.0,2.1,2.1D

Star Schema have some disadvantages, so sap moved to extended start schema.

DISADVANTAGES:
  • As the master table is inside the cube , we can't reuse fact table which degrades database performance .
  • processing takes more time due to Alphanumerics values in Fact table which degrades the processing performance .
  • As we have 16 dimension in cube and each one linked to mater table , Our analysis limited to 16 characters.



Extended Star Schema

  1. Whenever we create a character info object , system will generate master table and SID table in database .

  1. Whenever we create infocube , system will generate dimensional tables and fact tables .
  2. Whenever we load master data , master table and SID table are filled

  1. Whenever we load transaction data , the dimensional tables and fact table are filled .

  • Fact table is kept inside the cube where as master table is kept outside the cube .
  • Inorder to improve the processing performance , SAP has come up with a concept called SID (Surrogate ID)Technology .
SID concept applicable for only CHARACTERS
  • Whenever we create a character info object, System will generate an additional table in database called as SID table
  • Whenever we load master data , system going to generate unique numeric ID called SID in its corresponding SID table

refer below screen shot for more details














  • In order to improve the analysis SAP has come up with the concept called Dimensional tables .
When we want to create a cube , we need to follow 2 rules
    • We need to specify the number of dimensions required.
      • For every dimension we specify system will generate one dimensional table within the cube .



In each table we can have 256 fields,

1 goes for Dimension ID
7 goes for Internal purpose
remaininig 248 Columns left

for 1 Dimension -- 248 Characters can be assigned.

like that for 16 dimensions , we can have 16*248 Characters .

A single transaction can be viewed in 248 ways

On what basis we  will decide whether to add characters in a single dimension table or in separate table for each characteristic.

All 1:1 , assign to one dimension
All 1:Many assign it to different dimensions


BIW 3.0,3.1,3.1C,3.5 ,BI7.0 & BW 7.3


below  2 schemas in data warehousing and are not related to SAP BW
SNOW FLAKE SCHEMA

Informatica built on Snow flake schema

HYBRID schema