Thursday 13 August 2015

sap fi/co material step by step 2015

SAP FI-CO MATERIAL STEP BY STEP


                        INTRODUCTION OF SAP


SAP stands for System Application and Products in data Processing

FI stands for Financials 
CO stands for Controlling

Version : ECC6

ECC stands for ERP Central Component


Introduction to SAP

SAP was released in 1972 in walldorf, Germany. 
It stands for System ApplicationProduct In Data Processing  over the year it grows and evolved to becomes the world premier provider for client/server business solutions for which it is so well today.
It is an Erp Product.
All the Modules of sap can be classified into 

Technical : a) Basis
                    b) Abap
     
Functional : a) SD (Sales and Distribution)
                      b) MM (Material Management)
                      c) HR (Human Resources)
                      d) Fi/co (Finance and Controlling) …. Etc.


What is ERP?

ERP stands for Enterprise Resource planning, it is integrated all functions in one system.

                                    Organization
                                                |
------------------------------------------------------------------------------------------
            |                                   |                       |                                   |
Purchase Dept.        Store Dept.    Production Dept.      Accounts Dept.

Will have a number of departments in an organization. ERP integrate all the functions into one system. It will facilitate free flow of data among the departments.


Advantages:

Once stores person updates in the system – It can be shared by account person.
No mismatch in reporting – Data Source is only one once updation.

Store Department at Factory: Where the material is received are updates his records send the bill to account person.

Accounts department at City office : Pass an entry in the books


Disadvantages:

Duplicate job
Time gap.

ERP Packages:

 SAP, Oracle, Financials, Peoples soft, BAAN , J.D.Edwards

1972- SAP R/1 – Real time data processing
1980-SAP – R/2 Included no.of countires and no.of currencies
1990 – SAP R/3- R/3 stands for 
Data Structure

1.Application Server
2.Data based server
3.Presentation
1999 – My SAP.com – Web baed
2004 – Net weaver – Integrates information, people and process.

Areas to be covered under FI /CO

FI:
  1. General Ledger accounting
  2. Accounts payable
  3. Accounts receivable
  4. Asset accounting

CO:

1.                  Cost element accounting
2.                  Cost center accounting
3.                  Internal orders
4.                  Profit center accounting
5.                  Product costing
6.                  Profitability analysis

Integration of:

  1. Material Management Module to Financials (MM to FI)
  2. Sale & Distribution module to Financial module integrate (SD to FI)
  3. Data take over(From Non-SAP to SAP)
  4. Closing procedure

Reports:

In all the module systems gives around 2000 reports
You can attaché the reports to favorites
Some important reports you can attach the reports on desk top.

Cross company code transactions:

India version: TDS , Excise and sales tax

Companies Act 1956:  As per Schedule VI Balance sheet and Profit & Loss A/c




What are difference between SAP EE 4.7 and ECC 6.0?

SAP EE 4.7
SAP ECC 6.0
Stands for  Enterprise Edition
Stands for Enterprise Central Compound
No Netware concept (Offline)
Netware concept (Online)
Segment wise report is not possible
Is it possible
Only one currency
Multiple ledgers in currencies

Document splitting

Foreign currency revaluation based on accounting principles

Role of FI /CO Consultant

  1. Project Manger
  2. Senior Consultant
  3. Junior consultant     (Each project 3 to 6 members)
  4. Support Consultant (Eg.IBM, Accenture)
  5. Core Team Members
  6. End User

Open: Double click on SAP Logon Icon                                     


Double Click ECC 6 Server
                                               
First Screen:

First Field : Client 2 Clients
  1. Development client
  2. Production client

In the implementation SAP

  1. Consultants
  2. Company staff (Core Team Members)

The consultant they do the customization in development client
The company staff will do the testing.
The customization will be transferred to client through transport requests.
In the production client you enter day to day transaction.

Some companies they will give 3 clients:

  1. Development client
  2. Testing client
  3. Production client

Client:             800/000/810 – You can copy and give any number 

User:              Cost of package will depend on the no.of users licenses.

100 users license –used by 1000 employees
It fixes the responsibility on employee.

User ID: SAP user: You can use small or capital letters (It’s not case sensitive)

Password: The length of password – Min3 – Max 8
                   (it can be numeric, Alpha Numeric , Alphabets, and Special characters.)
Password is  case sensitive
Not possible to change password more than once in a day
Latest 5 passwords can not be used
Password can not be restored


What is client?       

This is the self contained and top most technical, commercial or organizational units in SAP with separate master data and own set of tables.                                       

Aravind Group                                              Wipro
(Aravind Industries Ltd)                  (Consluting Firm)
(Aravind Steel Ltd)                                      

To Purchase Sap Package From Sap India Bangalore Wipro Will Customize(Map) Aravind Requirement In SAP                                              

ARAVIND                                                                              WIPRO
Project Manager                                                            Project manager
Core team accounts manager                                       FI Consultant
Cost accountant                                                            CO Consultant
Purchase Manager                                                       MM Consultant
Sales Manager                                                             SD Consultant
It staff                                                                           ABAP programmer
                                                                                     BASIS Administrator

Aravind :Core Team As is Process What Is Requested From SAP                                       

Wipro :To Be Process What Should Be Done In SAP                                     

Development                                      Production   
Client                                                      Client

Wipro Customization                       - Transport Request

Aravind Core Team                         - Testing

After testing by Aravind core team customization will be transported to production client through transport request

Production client is live client,where we enter day to day transactions

If the consultant do customization once again in production client, if they commit any mistake all the postings will go wrong where as development client customization is tested customization by the Aravind core team and corrected by Wipro team.

We will not get any mistakes in the development client customization.

In live environment we should have minimum 2 clients some companies they keep 3 clients                                                                                                   


Development  Client           Testing quality Client                Production Client

Wipro Customization   ->      Transport Request     ->     Aravind Core Team ->  Testing


"When SAP is purchased from SAP India we get clients like 000,001,067 and 800" Basis consultant copies 000 client and give the number required by Aravind care team                                                                                                        

Client             :800    (Development Client)                                                                                                         

User    : Cost of package will be based on number of user licenses                                     

User Id Creation Is The Job of BASIS Administrator                                                                                                    
A) Cost Factor                                              
B) User Id Fixes Responsibility on Employee                                       

SAP User:     It Is not Case sensitive (Capital Letters Or Small Letters)                                

Password:     Password Is Case Sensitive (From Ecc 5 Onwards)         

Length of Password: Minimum 6 Maximum 40

"We can use alphabets, Numerical, alphanumeric, special characters-like"                      

Not possible to change password more than once in a day.                                      

System will not permit to use latest previous 5 passwords                                          

EG:     1.09.2014     ABC123                    
           5.09.2014      XYZABC                                                                   
           12.09.2014    ABC123       

System will not permit Password can not be restored.
                                         
BASIS Administrator deletes old password and gives a new password  : oracle

Language  : 41 Languages

If we do not specify any language it takes English by default or we can use EN for English                                                                                          

If we user id : The menu will be in German                                                                 

Client:         800                                                                                   
User:           SAPUSER                                                                           
Password:   oracle                                                                        
           
Press enter                           

Now open SAP                                           

Select and choose the radio button depend on necessity.
   
                                            Employee 1                Employee 2

1st Radio button                  Can not work             Can work
2nd Radio button                 Work                         Can work
3rd Radio button                  Can work                  Can not work

In training institutes we have to select 2nd radio button                                             
Enter                                     

1st row is called menu bar                                    
Menu Edit ,Favorites ,Extras                                             

2nd row is called standard tool bar                                              
3rd row is called in title bar
4th is called application tool bar
5th & last is called status bar

The second row the tick is called enter, beside tick box is called is command field."

One employee can work in number of sessions (windows) at a time -the maximum is 6 sessions

How to create a new session?

Path: From the menu bar  - Select system- Create session

To move from one session to another session (alt+tab)


How to end session?

Path :From the menu bar - select system- End session


To view which version we are using?

Path : From menu bar - Select system- Status-Sap system data                                           


How to use transaction codes (T/C)?                                                  

We want posting of transaction.     
                                              
OPTION-1                                                                          OPTION-2

Go through the path and post                                     Use transaction code in command field
the transaction                                                             and press enter

                                                                                     we can create our own transaction                                                                                              codes they should start with Y or Z


Path: Accounting --> Financial accounting-> General ledger-->Posting ->General posting


To go back to SAP easy access screen: 
                       
Use: /n           in command field and press enter.                      

For Posting Transaction:

Document (Voucher) entry                                    Account display (FS10N)
(F-02)                        

After posting we want to view the ledger.      
                             
a) Use:/n (changing) in command field and enter - to back to sap easy access screen        
                    
b) Use FS10N in command field and press enter- to go to account display Instead
                            
use:/NFS10N in command field and press enter change session with new transaction code.                           

use: /OFS10N in command field and press enter- create session with new transaction code.                            

./N for change
                                   
./O for create            
           

How to activate transaction codes in sap menu?

Path :From the menu bar - select extras - Settings - Display technical names- Enter


HOW TO SET A START TRANSCTION?

To make one screen as beginning screen

Path: From menu bar select extras - set start transactions (transaction code is     F-02)

Enter

Give a message transaction F-02 set as start transaction       


How to Open SAP

To openDouble click on SAP "Logon" Icon.
after logon system asks "user name" and "password"
after complete the that step sap screen will open, here you type "SPRO" command in the command field.
after click on sap reference img 


HOW TO CLOSE SAP?

Path: From the menu bar select system - log off - select ‘yes’ button for the message to logoff    

Select yes button to log off


HOW TO UNLOCK THE TRANSACTION CODE?

At the time of customization -screen will come with display mode not enter mode

Path:Tools-Administrator- Monitor-Lock entries (tr.code is SM12)         

Select list button- Message - No lock entries found     

Path: From the menu bar select lock entry- Delete all-select’ yes’ button for the message 

Delete all lock entries - Enter.
Organization structure:                                                                                                                  
                                                                                                           
            SAP                                                                                                   
            ----------
            |           |
Group             Company
|                       |
Company       Company code
|                       |
Units               Businesses Area


CREATION OF PROJECT:  Group  --> Companies -->Units

In SAP – Group is called as company.

Company is called as company code.

Unit is called as Business area.


ARAVIND GROUP (AVG)
|
            ----------------------------------------------------------------------------------
            |                                   |                                                                       |
Aravind Mills Ltd(AML)        Aravind Steels Ltd(ASL)    Aravind Industries ltd(AIL) 
|                       |                       |                      |                       |                       |
HYD               BGL                HYD               BGL                HYD               BGL

FI consultant will do customization at company code level -company or group is only for information.                                                                                                            

We do customization for Aravind Mills Ltd after words we copy customization including accounts to other company codes in one step and make modifications where ever required.                                                                                                            


NOTE: HERE (BELOW) YOU CAN FIND ALL THE MATERIAL BY CLICKING ON BY ONE


                    SAP FI NOTES
INDEX

PARTICULARS

Introduction

Enterprise Structure
1.    Chart of Accounts
2.    Accounts groups customization
3.     Open and Close Posting Periods

Sales Tax Procedures
1.    Tolerance Groups

General Ledger Accounts (GL Accounts)
                     1.Negative Postings
                     2. Creation of GL Masters
                     3. Parked document

Foreign Currency Transaction (FCT)
1.    Reversal of Reversed document
2.    Mass Reversal
3.    Balance Interest calculation
4.    Accounts Principles

Accounts Payable (AP)


House Bank
1.    Link between sundry creditors and Advance to vendors
2.    Purchase Invoice Posting
3.    Term of Payments-Maximum Cash discount
4.    Automatic payment Program(APP)
5.    Check printing
6.    Credit Memo

Accounts Receivable (AR)
1.    Sales Invoice Posting
2.    Incoming payment
3.    Link between sundry debtors and advance from customers
4.    Advance Receipt posting

Bill of Discounting (Bill of Exchange)
                     1. Define dunning areas

Sales Tax




Reports
                    1.Chart of Accounts List
                    2.Trail balance / Ledger /Vendors List
                   3. Data Takeover
                   4.Up loading of master in SAP (LSMW)
                   5.Balances uploading

Bank Reconciliation Statement (BRS)
                   1.House Bank
                    2.Check Lots
                    3.Sales and Purchase Invoices posting

Cash Journal (CJ)

Withholding Tax(TDS/TCS)
                   1.Maintain Calendar
                    2.Withholding tax codes
                   3.Create Remittance Challan
                   4.Print TDS Certificate
                   5.Quaterly Return




HOW TO CREATE A COMPANY, COMPANY CODE, BUSINESS AREA IN SAP FICO

WHAT ARE CHART OF ACCOUNTS AND HOW TO ASSIGN TO CHART OF ACCOUNTS IN SAP FICO

WHAT IS ACCOUNT GROUP CUSTOMIZATION IN SAP FICO

WHAT ARE TOLERANCE GROUPS IN SAP FICO

WHAT ARE OPEN AND CLOSE POSTING PERIODS IN SAP FICO

HOW TO CREATE GLOBAL PARAMETERS IN SAP FICO

HOW TO POST THE NEGATIVE POSTINGS IN SAP FICO

HOW TO CREATE A GENERAL LEDGER IN SAP FICO

HOW TO POST THE TRANSACTIONS IN SAP FICO

DISPLAY DOCUMENT, CHANGE DOCUMENT AND ACCOUNT DISPLAY IN SAP FICO

WHAT IS ACCOUNT PAYBLE IN SAP FICO

WHAT IS ACCOUNT RECEIVABLE IN SAP FICO

HOW TO CREATE AND SAVE OUR OWN LAYOUT

WHAT IS HOLD DOCUMENT AND HOW TO CREATE AND DELETE IN SAP FICO

WHAT IS PARK DOCUMENT AND HOW TO POST IT IN SAP FICO

WHAT IS SAMPLE DOCUMENT AND HOW TO POST IT IN SAP FICO

WHAT ARE MONTH END PROVISIONS IN SAP FICO

HOW TO POST INDIVIDUAL, REVERSAL AND MASS REVERSAL DOCUMENTS IN SAP FICO

HOW TO CALCULATE THE INTEREST IN SAP FICO

WHAT IS FOREIGN CURRENCY AND HOW TO POST IT IN SAP FICO


BALANCE INTEREST CALCULATION IN SAP FICO

DEFINE ACCOUNT PRINCIPLES, VALUATION METHODS AND VALUATION AREAS IN SAP FICO

AUTOMATIC POSTINGS FOR FOREIGN CURRENCY VALUATION IN SAP FICO

CREATION OF VENDOR ACCOUNT GROUPS, NUMBER RANGES, TOLERANCE GROUPS, VENDOR MASTER IN SAP FICO

WHAT IS HOUSE BANKING

HOW TO POST THE SALES INVOICE IN ACCOUNT RECEIVABLE

HOW TO CALCULATE SALES TAX IN SAP FICO

WHAT IS ASSET ACCOUNTING IN SAP FICO

HOW TO ATTACH  REPORTS IN SAP FICO

WHAT IS DATA TAKEOVER IN SAP FICO

BALANCE UPLOADING PROCEDURE IN SAP FICO


HOW TO RUN AUTOMATIC PAYMENT PROGRAM

WHAT IS PURCHASE INVOICE AND HOW TO POST IT IN SAP FICO

WHAT IS CASH JOURNAL IN SAP FICO

WITH HOLDING TAX (TDS/TCS)


SAP CO MATERIAL STEP BY STEP


                CONTROLLING (CO)


This is used for internal reporting in Co organizational Hierarchy – Highest node is controlling area. In FI Highest node is company , Company code

CONTROLLING AREAS :


1.  Cost Elements Accounting: To update Co records / sub modules cost elements are required.

There are two types of cost elements

    1. Primary cost elements
    2. Secondary cost Elements
    
2.  Cost Center Accounting: This is used to view department wise costs.

3.  Internal orders: This is used to view costs for specific task.
                                                                           
Eg: Vehicle wise running expenses / Petrol expenses, Repairs to that Vehicle,  Telephone wise expenses production order costs / Exhibition costs.

Create each vehicle as an order and capture the costs

Production order:
Create production order as on internal order and capture the costs.

Exhibition costs: Sales men salaries , Advertisement discounts to customers conveyance. Create a exhibition order

4.  Profit center accounting : This is used to view profitability product wise / Division wise / Location wise if business area is not used in FI

 5  Product Costing :This is used for valuation if inventories
Eg: Finished goods and work in process.

6.   Profitability analysis: This is used to view profitability for number of parameters at a time.
Eg. Sales order wise  / Customer wise / Product wise / Plant wise / Sales organization wise profitability this is reporting tool





1 comment: