Introduction to SAP ERP Implementation
Introduction to SAP ERP Implementation
CHAPTER 1
Introduction to sap
Narendra 2
Introduction:
In the process of organizational evolutionary changes, computers play a
vital role. To achieve the organizational plans, goals, and targets,
computerization of its activities is inevitable. In the early computerization
days, organizations are used to select the individual soft wear products.
These products were replaced the manual environment and helped to
improve the performance of an organization in all spheres. The
independent soft wears were developed to meet the specific requirement
of an organizational activity. The growing requirements prompted for
designing new tools. Consequently, an organization with multifaceted
activities bundled with many independent computer packages. Hence
development and maintenance of individual soft wears has become a
white elephant for the organizations. In addition to the cost concept, the
globalization and growing concept of global village, required more than
the present set up of individual soft wear applications. In the present
Global environment, the soft wear should support cross country
functionalities, with the diversified activities.
To meet such demands of the industry, independent soft wear era has
taken a new turn with integrated soft wears. The integrated soft wear
supports the cross functionalities, multiple languages, and cross-country
activities, without changing the existing environment and organizational
set up as well. The new Integrated Soft wear is coined as an ERP Product
or Standard Soft wear products. The Standard soft wear is developed as
flexible and universal product to meet the requirement of as many
companies as possible. Standardization can be achieved by incorporating
the accepted business common laws, international accounting standards,
and scientific knowledge of business processes. The Enterprise Resource
Planning product caters the requirements of an organization, with a tight
integration among all the business processes.
In my own experience, I would like to say the Banking industry in India is
too slow to accept the technological changes in the before 90s. There
may be so many reasons in the past. However, Now the Banks in India
are ahead to imbibe the technological changes happening around them.
Privatization, globalization and liberalizations have brought the drastic
changes in the facet of Indian Banking industry. The Big Bank i.e. State
Bank India and its associates are the front runners in implementing the
ERP product. Now Each Bank in India is following the foot steps of state
bank. However, Banks ERP product is an Industry solution Product.
The implementation of Core Banking solutions (ERP>industry specific
solution) is taking place in many of the Indian Banks. Many of the banks
which are implemented the ERP product are deriving the benefits.
Narendra 3
Now our discussion is relating to cross country application soft wears.
There are several ERP products are available in the Market. They are
mainly
SAP
ORACLE FINANCIALS
JDEDWARDS
BAWN
EPICORE
PEOPLE SOFT etc.
However, at present the most familiar product is SAP only. Hence, in the
coming chapters I will discuss about SAP Standard soft wear product SAP
only. In the available products, some are cross functional products and
some products are industry specific solutions (banking soft wear).
Industry Specific Products are designed to meet the business processes
of unique business. More or less this type of industries will follow the
similar business processes wherever they exists Example Banking
industry, insurance, retail solutions etc. Cross functional products are
developed as standards soft wears to meet the different type of industry
requirements, throughout the world. The standard soft wears can not be
used as its status. The Soft wear has to be tailored to the requirement of
different industries with the cross-country functionalities and with the
cross-industry business processes. The standard integrated product has
to be customized or configured with the specific industry requirements.
We have to set some pre activities to the standard soft wear, before
using called Parametrization or so-called Customizing. The organizations'
requirement is to be compared with the capabilities and adaptabilities of
the standard soft wear before taking up the Customization task. Many
organizations do not understand how to represent their organization
structures and business processes in the standard soft wears. To take up
the requirement definition task and Customization of Business processes,
requires a specialist organization i.e. called Implementation Company.
The implementation company selects and forms group with an expert
people. This group of People is called a Consultant group. This consultant
group has not only expertise in the standard software definitions but also
to understand the organization’s structures and business processes.
They will map the structures and business processes of the legacy
system to ERP environment. Hence the main role of a consultant is to
map up the business processes with the standard soft wear processes
and customize the additional requirements if required by the
organization. The pre parameterization activities and customization
activities are put together is called as an Implementation of Project.
Narendra 4
The Implementation of the project is more or less similar for all standard
soft wears. In SAP environment also the process of Implementation is
similar. Implementation of a project is so easy to discuss but involves a
lot complexity and cost. Hence has to be properly planned and monitor
project in a systematic procedure. The Consultant team and core team
has to define the Deliverable Milestones and accordingly monitor the
project. Definition of Milestones in the project is a tough task for
reconsulting and senior executives of the company. Then only we can
complete the Implementation task successfully. The total activities and
programmers are to be document in a proper way. This document is a
guide for implementation of a project. This document is called as ASAP
METHODOLOGY OR SOLUTION MANGER. It is road map for the consultant,
to customize the business processes. The success or failure mainly
depends on the methodology we have adopted during the project
implementation. The implementation road map is primarily based on
sequential methodology and consists of five phases that are to be
executed sequentially. Those are
While preparing the above road map the consultants has to meet the core
team members and interact with the people ascertain the required
information relating to the existing process and their requirement in
environment. (Core team is the group of expert people from various
functional activates, to represent the company or the front-line
information providers to the consultants during the project
implementation. For the Project purpose generally, the participating
companies forms a Steering Committee. The steering committee vested
with the executive powers to define the new process or modify the
process if required. It consists of the people from consulting company as
well as implementing company. The steering committee is responsible for
the successful implementation of the project. In Each Stage or Process
certain activities are defined with time bound intervals. If you follow the
pre set time norms in each stage there will not be” analysis in paralysis
“in implementation project. There are no hard and fast common time
bound intervals for each project. These are different from one industry to
industry and country to country also. Generally, the road map is prepared
basing on the Principle of Business processes or so called As Is Processes.
The new processes are defined in the project as “To Be Processes” with
proper authorization from the steering committee or from the vested
authorities. The consultants do not make the configurations beyond the
scope document without proper authorization.
Narendra 5
1. Project Preparation: This is the first phase of implementation of
project. In the phase the core component is Project Implementation
Planning will be done. The Planning consists of all round activities relating
to the implementation activities. Those are mainly defining existing goals
and the new goals in the new environment. This is called as a project
charter. There will not be any changes to the project charter unless and
until the changes are approved by the competent authorities. Besides to
the project charter, we have to define the implementation strategy,
project standards for procedures and documentation procedures are
defined. Apart from the project budget, and project resource planning
(hardware requirement planning, technical requirement planning,
defining system land scopes in new environment, human resources
planning, etc.) is also defined in the project preparation. The project goals
and objectives, and other requirement definitions and planning and
strategies to achieve the defined goals will be approved in the Kick off
meeting. Kick Off meeting is the exact starting of implementation of the
project. By this time all the members in the implementation team are
fully aware
The Each of theofscope
phase document
the road objectives.
map concludes at predefined milestones. The
quality checks to be made to the objectives defined for the phase. If the
results are properly met with the set objectives, then the project manager
from the company side will close the phase and confirms the results. He
signed off the phase document having completed in all respects. Then we
can go for the 2nd phase i.e. blue print preparation.
2. Blue print preparations: The objective of the second phase of
implementation road map is preparation of Business Blue prints. It is
called as a design document for the future r/3 system. Business blue
prints are the basic requirement for the 3rd phase of implementation
(realization). There is no 3rd phase without Business Blue prints. The blue
print for each task will put together as blue print for the project. The
project manager will ascertain the status from each consultant member
and evaluate to the steering committee, at regular intervals. The time
interval for meetings with the members, attending the steering
committee meetings, and other project analysis depend on the size of the
project.
In the Blue print stage a proper knowledge transfer with core team
members is must for effective implementation of the project.
In this phase as is process definition and to be process definition will be
made. Accordingly change management to the new type of environment
also initiated. System land scopes will also be determined. This is a
comprehensive phase. Each area of scope document will be meticulously
examined and prepares the best available business process and evolve
the training methodologies to under stand the new business process
environment is developed.
Narendra 6
Last but not the least activity in the 2nd phase of blue print preparation is
quality check for blue print preparations. For this purpose SAP provides
separate tool for check.
R/3 Architecture
Before entering into project implementation activities every one of the
project related, should at least know the R/3 architecture. It gives an
immense knowledge over the implementation activities. The Sap system
environment is called as Client Service approach. There are different
views to understand the client server approach. The client server may be
embedded in a single system or in different systems. As per the
requirement of the project we can decide the system environment.
Basically, there are 3 types of clients are used in the project
implementation. The first one is development client, the quality client,
and the production client.
[Link] [Link] box
[Link] testing.
1. Quality testing
[Link] or permanent
client for users.
Narendra 8
The three clients are specified for different activities. The development
client is used to do the configurations by the Jr consultants as per the
business blue prints. We can make and define the configurations as per
the requirements. The configurations will be tested in another client
(depending on the system environment) i.e. Quality client. The
configurations made in development client will be transported to the
quality client with the help of transport management (dealt by basis
administration). And the configurations will be checked and ensure that
they are in tuned with business blue prints. Once the quality checking is
completed, the configurations will be transported from development
client to Production client. This is client of end user. Generally, no
changes can be made to the configurations in this client. In exceptional
cases if any changes made has to be documented perfectly ‘as the
changes made in Production client’ However, SAP discourages to make
changes in Production client, make the changes in development client
and test it quality then again transport to production. This is best
business practice of the Implementation. The R/3 architecture can be
viewed as the following way. This type of R/3 view is considered as a
development view. We can have a birds view over the total development
activities in implementation process. Generally, a client is considered a
work area where the user master data is available or configured.
With a view to remember the work areas or the clients, SAP suggested to
name the client with 3-character Ids. There are no had and fact system of
number of clients. We can name it as per the convenience of the project.
However, to maintain the standardization SAP suggests the consultants
000 client name should be accredited to Production client only.
As an application consultant we do the configurations in development
client, and ensure the initial quality checking of the configurations as on-
going process. All configurations have to pass through the quality testing
phase in quality client. Here in the quality client all types of testing, like
intra module testing, business process tests, integration testing, will be
done and finally confirms the customization and integration. Then the
customized settings will be transported to production client. Before
transporting into production client, the final test called User Acceptance
Test will be done.
Narendra 9
The above diagram is flow chart in R/3 structure. The end user queries
first of all processed in the application server (with the help of ABAP) and
sent to data base.(understands only SQL language) In turn the data base
server responds the queries and sent back the necessary information
again to application server in turn to Presentation server. This also can be
considered a Client server system with in a client. The flow of information
in the diagram is defined with the numeric numbers.
I think the readers of this book, might have got an overview functionality
of R/3 architecture by this time. The most complex activity for a
consultant is to under the Organizational structure in the legacy system
and mapping up with the Organizational units in SAP environment. This is
the hard-core problem for the [Link]. Hence mapping of
organizational units and mapping of business process are generally dealt
by the senior consultants.
The Implementation approach vs. learning approach:
The implementation approach in real time is some what different from
the learners approach. However, the end product is same for the two
approaches. The Implementation Approach is coined by me as Parallel
approach. The Learners Approach is called as Horizontal Approach. If you
take up the Implementation approach in the class room may cause a little
bit confusion among the students. Hence, I am taking up the Horizontal
Approach for the students who have attended for work shops or training
classes.
Narendra 10
CHAPTER 2
Organizational
Structure
SAP Financial Accounting Global
Settings
Narendra 11
SAP Financial Accounting - Global Settings
Configuration
These settings are required before you begin with transaction postings
and [Link]-by-Step Configuration Overview
Narendra 12
🏢 1) Company
•Definition: The parent/holding company in SAP that represents the
group at the highest level.
•Purpose: Used mainly for consolidated financial statements
(group reporting).
•Legal status: May or may not be a legal entity itself, but it holds all
company codes.
•Example:
•IN00 – Indigo Group (Head Office, New Delhi)
🏢 2) Company Code
•Definition: The smallest legal organizational unit in SAP for which
you can prepare a Balance Sheet & P&L.
•Purpose: Each legally registered company must have one
Company Code.
•Legal status: YES – must be a separate legal entity (with PAN, GST,
CIN, etc. in India).
•Example:
•IN11 – Indigo Paints Pvt Ltd (Delhi)
•IN12 – Indigo Chemicals Pvt Ltd (Mumbai)
•IN13 – Indigo Exports Pvt Ltd (Chennai)
🏢 3) Branch (Plant/Location)
•Definition: A sub-unit or location of a company code.
•Purpose: Represents physical offices, factories, warehouses, or sales
branches.
•Legal status: NO – branches are part of the company code.
•Example (within IN11 – Indigo Paints Pvt Ltd):
•DELH – Delhi HO
•MUMB – Mumbai Branch
•CHEN – Chennai Branch
•HYD – Hyderabad Branch
🏢 4) Business Area
•Definition: A division of operations (product line or service line)
for internal financial reporting.
•Purpose: Helps in preparing Balance Sheet & P&L by division, not
by legal entity.
•Legal status: NO – internal reporting only.
•Example (IN11 – Indigo Paints Pvt Ltd):
•INPA – Decorative Paints
•ININ – Industrial Paints
•INEX – Export
Narendra 13
🏢 5) Consolidation Business Area
•Definition: A way to combine the same business area across
multiple company codes for group-level reporting.
•Purpose: Consolidated reporting of divisions that exist in many legal
entities.
•Example (Indigo Group):
•Export Division (INEX) exists in:
•IN11 – Indigo Paints Pvt Ltd
•IN12 – Indigo Chemicals Pvt Ltd
•IN13 – Indigo Exports Pvt Ltd
•Consolidation Business Area → INEX – Exports (Group Level)
🏢 6) Profit Center
•Definition: The smallest unit in Controlling (CO) used for
profitability analysis (branch, plant, or department).
•Purpose: To measure Profit/Loss of each branch/segment within a
company code.
•Legal status: NO – management/internal reporting only.
•Example (IN11 – Indigo Paints Pvt Ltd):
•DELH-PC – Delhi Branch Profit Center
•MUMB-PC – Mumbai Branch Profit Center
•CHEN-PC – Chennai Branch Profit Center
•HYD-PC – Hyderabad Branch Profit Center
Narendra 14
Learners Approach or Horizontal
Approach
Transactional End User Miscellaneous
Content Master Data
Data Activities Activities
Map up with the
legacy system
Organizationa
-------- -------- -------- and to create
l Units
org. units and
global settings.
2. Define
3. Data
number ranges,
General postings, 4. Any activity
1. Creation of tolerances,
Ledger ensure the related to GL
GL master data posting keys,
Accounting correctness of accounting
doc. type, and
settings
so on
Define doc.
type, number
Definition of
Accounts ranges, Processing the
groups, number
Payable and tolerances, data to ensure Miscellaneous
ranges, and
Accounts payment terms, the activities
creation of
Receivable automatic configurations
master records
determinations
into calculations
Definition of
Define check
house banks,
Creation of management
Bank account IDs, Miscellaneous
bank master and ensure the
Accounting and related activities
record correctness of
activities into
settings
calculations
Chart of
depreciation,
valuation
Creation of Posting the data
methods,
Asset asset classes to ensure the Miscellaneous
depreciation
Accounting (including pre- correctness of activities
key and
act) the data
automatic
determination
of accounts
Define tax
Defining tax
codes, and
General procedures, And
automatic Post the data
Configuration condition types, miscellaneous
determination for correctness
s jurisdiction activities
of accounts of
codes
tax
Narendra 15
In Horizontal approach each component wise master data, transactional
data and end user data and related activities will be configured, this
methodology is more reachable for the students in class room
environment.
Implementation Approach in real time:
In real time the implementation of the project is slightly differs with the
horizontal approach. The methodology is mentioned under the table.
Accounts
General Payable
Asset
Organizati Ledger and
Particulars Accountin
onal Units Accountin Accounts
g
g Receivable
& Bank
Creation of Creation of
all masters Creation of all masters
Definition of in GL all masters in Asset
organization accounting in AR, AP, Accounting.
units, and and creation and Bank And
1. Master
global of all module. creation of
Data
settings, in masters Creation of all master
each simultaneou all master records
module sly by all records in simultaneou
module all modules sly in all
consultants modules
Transaction
Definitions al data Transaction Transaction
2. are definition al data in all al data in all
Transactio simultaneou will be done modules modules
nal Data sly in all simultaneou simultaneou simultaneou
modules sly in all sly sly
modules
Narendra 16
In the implementation approach is suitable for real time project
implementations, all the master records, will be defined simultaneously
and useful for automatic assignments and default assignment purposes.
And further it is good methodology to ensure the end-to-end tests and
integration tests. Hence this methodology is followed in real time
projects. However, the Horizontal Approach is exclusively useful for the
class room environment for better understanding of the concepts
If you familiar even with the horizontal approach method also, we can
easily under stand the implementation approach in real time. Hence, I
used to take the classes in Horizontal approach for the students. Now you
are equipped with enough overview for taking up the project
configurations as defined below.
NARENDRA PROJRCT
FICO MODULE
CUSTOMIZATIONS
Narendra 17
The success of an implementation mainly depends on the integrity and
involvement of the people in the organization. They should try to extract
the exploit the required business processes from the consultant team. If
they in show any laxity in proactive, the end results of the new product
will not come the organization. Besides they have to face lot of problems
while dealing with the business transactions in the new environment. It
may some times lead to chaos in the organizational work flow.
The consulting company prepares business blue prints by coordinating
with the core team. Accordingly, the configuration will begin. In the
process of configuration every one of the core team members must know
the functionalities of sap screens and also the Jr. Consultants ensure the
familiarity of sap screens as under. The first screen is the entry screen
through which we enter in SAP environment.
There are two types of screens are there in SAP. One is easy access
screen and the other one is IMG screen. Easy access screen is designed to
process the day-to-day business transactions. IMG screen is the purpose
of configurations and customization of the business processes. We have
to mention the client's name in which we are working. This is most
important. Generally, the configurations will be done in Development
client. Hence give the client ID. Give the user's name and maximum 8-
character pass word. And press enter. You will be taken to new screen
Give USER
Enter
Password
Client: an organizational unit, in which the master data and tables are
stored. Username: this is the name of the person who wanted to enter
into sap. It should be predefined by the basis consultant. Password:
personal secret code with which user is identified by the system.
Language: the language in which the user works on.
Note: we can change the pass word by clicking new pass word option.
This can be possible after giving the old pass word only.
Narendra 18
The above screen is called Easy Access Screen. This is the screen from where the end
user begins his routine transactions
The screen prompts will be depending on the roles assigned to the user or the defined
job to the user in the real time environment. All the options are not displayed to all.
This is for security reason and authorization role played by the user in the organization.
This is the screen from where the end user performs his roles.
Narendra 19
This setting knowledge enables the consultant to execute the work
efficiently. These are not directly related to configurations; however, act
as helping aid to the consultants in real time.
However, it is not pertinent to the consultant to take up the configuration
settings as per the project requirement definitions. The screen from which
the consultant will work is called Implementation guide screen i.e. IMG
screen. The following are the ways to reach the area of operation.
There are two ways to enter into other work areas: [Link] method
[Link] method
Navigation method: tools>customizing>IMG>SPRO edit project>sap
reference IMG> display IMG (implementation guide)
Transaction code method: In SAP every screen is identified with
transaction code(T-code). We have to give the transaction code in
command field. Example: SPRO is the transaction code for entering to
sap reference IMG screen and press enter it will take directly to sap
reference IMG screen.
Creation of favorites: Go to menu item favorites>select create: create
folder or transaction. Select the required option. Selected one will be
displayed as above.
General information: [Link] transacting in sap the system used to
give 3 types of messages in 3 different colors. 1. Red: error message:
[Link]: warning message: 3. Green: ok message.
If you got yellow messages, you can skip that message by pressing enter
button. But if you got error messages, you have to identify the mistake
and rectify it, and then only the system allows further information.
To go to IMG screen, we can use either navigation method or transaction
code SPRO. It will take to edit project screen. In real time the project
manger prepares the project details and objects in the sap environment.
The screen will appear as under.
Narendra 20
In the IMG information we will find the sap releases up to the date
information. In the project analysis we can maintain the project details for
the information. SAP reference IMG is defaulted with the soft wear which
includes all modules whether you implement in the project or not. We can
prepare own IMG for project requirement. Those are Enterprise IMG and
Project IMG. Enterprise IMG refers all the modules which are going to be
implemented as a whole. The Project IMG refers the exact the modules
implementing during this implementation. However, we can configure
from any of the IMGs. Once you double click on the reference IMG, takes
you to the IMG screen. in the IMG screen we first ensure the general
settings as under
ENSURE GENERAL SETTINGS:
Before proceeding further customization we have to ensure general
settings available in the system. If any changes you want set you can set
it as per the requirement of the project.
1. Set countries: click on position button give country code IN and
continue. You will be prompted with country details. Ensure them and
save it. If you want configure the regions you can define regions in sap
environment.
Narendra 21
Alternative country key is the used to identify the country by SAP. ISO
code is the code accredited by the international standard organization to
identify the country.
Procedure is the tax calculation procedure for the country. We can the
alternative currencies
Maintain for the country. In the country definitions we can set hard
currency and indexed based currency if the project requires.
Set specific country specific checks:
Narendra 22
2. Ensure currencies in the system: Path: general settings-set
currencies
Narendra 23
Path: enterprise structure>definition>financial
accounting>company: TC 0X15
In the process of implementation of the project we have to begin with a
definition of a company i.e. group company. It is a six-character code.
1. Give company code: 5501(six character code)
2. Company name:SONY Group pvt ltd(it is considered as Group Company
) it is optional only.
3. If second name is there for a project give otherwise make it as blank
only
4. Under detailed information give the street name,
Give the P.O box number and street
(optional)
City: Give city name
Country: Give the name of the country in which the project is being
implemented, the country which are mentioned is called as local country
or home country
Language key: give the language key (for help press f4 for possible
entries list display) select the language from it
Currency: give the currency in which the transactions are being
maintained for the group company [Link] follow (INR) USA ($).
After the details select control+s or save button. Data was saved.
Message will be displayed. The screen will appear as under.
Definition of the group company is optional only. The next step is to
create a company code. The definition of company is code is an
independent organizational unit which has its own set accounting books
and obliged to prepare financial statement under statute of law. The
definition of the company code is mandatory. It is 4-character key or
code. The screen appears as under
Narendra 24
PATH: enterprise structure>definition>financial accounting> edit copy
delete company code: TC: OX02.
A small window will be displayed and double click on edit company code
data: select new entries button to create a new company code for which
you are taking the implementation.
Narendra 25
Give 4-character code: 5500 description: credit control area for: 5500
Update: with this data the system updates the credit limits of customer.
For example to update the credit limits at order delivery or billing
documents. We can select any option as per the request of the company.
Give the fiscal year variant:V3 the screen appear as under:
Narendra 26
Define the various functions with 4-character ids and save the data.
Define financial management area: path is same as above:
Financial management is useful in funds management and to forecast the
cash budgets for the organization. If the organization is following up the
treasury module to manage their funds efficiently, we need to define this
organizational unit.
Click on new entries button Give 4-character id for the financial
management area; and give the description and save the data.
Narendra 27
Give the financial management area currency.
Define business area:
Path: same is above: TC: OX--: business area is the area of responsibility,
within the company code
Give the business area code: 4-character code: 5500(alpha numeric you
can give)
Give the description of the business area: Business area for the company
code: 5500
Narendra 28
The definition of business area is an independent organizational unit
which has its own area of responsibility within the organization, which
can prepare financial statement for internal purposes. The classification
of business area is either geographical or product wise as per the
requirement of the company. We can define any number of business
areas as per the request of the company for which we are taking up the
project. If the organization if following the consolidated business area
approach, we have to define the consolidated business area other wise
we can skip the option. If you define the consolidated business area, we
have to assign the business areas to consolidated business areas without
fail. Hence consolidated business area functionality is optional for
customization. With this simple definition of FI organizational units is
completed. Now we can go for assignment of organizational units what
we have defined. We can treat this job as internal integration within FI
module. The first Assignment of company to company code. The
Path is as under:
Enterprise structure>assignment>financial accounting>assign company
to company code TC: OX16.
1. Click on position button.
2. Give company code:5500
3. Give the company to which you want to assign. Save. The screen will
appear as under
Narendra 29
The assignment of business area is not required because the
business areas can be used cut across the company codes. Hence we
need not assign the business area to any company code. However, if you
define the consolidated business areas, we have to assign the business
areas to consolidated business areas. In this project we have not defined
the consolidated business areas hence no assignment is required for
business areas.
Assign credit control area to company code: path is same as
above: Click on position button give the company code (5500)And give
the credit control area code and save the data.
Assign the financial management area to company code: path is
same as above:
Click on position button, give the company code(5500)
Give the financial management area code and save the data.
The functional area concept is different concept; we need to activate the
functional area by separately, no necessity of assignment task.
Variant principle
The next step in customization is Define Variant Principle. Under variant
principle there are 3 variants. They are [Link] year variant(FYV)
[Link] period variant (PPV)[Link] status variant (FSV). The
first customization is fiscal year variant. The variants defined under
variant principle are at client level.
(1)FISCAL YEAR VARIANT: The fiscal year means a general year in
common. No company can maintain the books for indefinite period. They
have to close the books for certain period. That depends on the company
and the country’s policy. Suppose in India all the companies have to close
their books on 31st march every year. But other countries may follow the
different approach.
The fiscal year is classified as
1. Calendar year
2. Non calendar year.
We can define any special periods within the maximum limit. Special
periods are used to post any information after the close of normal
periods. The special periods are not considered specially but as a part
and parcel of last normal period only.
Narendra 31
For non calendar year variant we have to define the variant first (don’t
select the calendar year check box) give normal posting periods: 12
Special posting periods: 4 maximum. Save
For defining the shortened fiscal year we need to select the check box
only. Shortened fiscal year means the defined periods are less than the
normal fiscal year periods.
Year dependent fiscal year and Year Independent fiscal year:
If the fiscal year and the period start date and end dates does not change
with the fiscal years is called as year independent fiscal years. Calendar
year and non calendar may be called as the independent fiscal years.
Year Dependent fiscal year changes the start and close dates from year
to year.
Narendra 33
Posting period variant: Path: SPRO>RIMG>fa>fags>document>define
posting period variant TC: OBBO
Select new entries button.
1. Give the posting period variant name: 4 character cod (ex.5500)
2. Give the description of the posting period variant
3. Save the data the Screen will appear as under. (For this project we are
using the same company code as the posting period variant to
maintain uniformity and to remember the codes easily)
Define open and close of posting periods: This is the important job in
real time environment. This particular job is entrusted to any authorized
persons only. This job is a part of period end closing job. We can make so
many restrictions depending on the account type and Gl account no wise
also in real time. But to facilitate easy functionality I am configuring the
most liberal functionality (by selecting the option (+) in account types. It
indicates all types of account types are allowed to post in all posting
periods. This is the prerequisite step. Hence I am creating this
configuration. Basing on this we can make restrictions as per the
requirement of the company. This job can be done by the users only,
hence made available in easy access screen also. After making the
customization the screen appears like this.
Path: same as above TC: OB52.
Give posting period variant: 5500
Give (+) in account type
Need not give any account numbers
Give the period you want to open (from 1 to 12 and13 to 16 in 2025 year)
this is most flexible configuration to facilitate all types of postings in all
periods. The last column authorization group is the authorized person to
handle this job.
Narendra 34
ASSIGN THE POSTING PERIOD VARIANT TO COMPANY CODE:
Path: same as above the TC: OBBP.
Click on position button
Give company code:5500
Give the posting period variant:5500
Save the data
The screen will appear as under
Narendra 35
Maintain field status variant Path: spro>IMG>financial
accounting>financial accounting global settings>document>line
item>control>maintain field status variant: TC OBC4
The main purpose of the field status variant is to defining the screen
templates for the users to process the business transactions in real time.
The requirement of the input levels is different for different business
transactions. Accordingly sap already preconfigured the screen outlays.
We can copy them and change the name of variant as we required. Here I
request the [Link] to go for copy function rather than creation.
Select the FSTV 0001 select the copy as button and change the code as
you require. Here I have changed the variant as 5500. (While copying the
variant the system asks to copy all and only entry. I request you to select
the button copy all. Then the system prompts one pop up box with the
message all dependant entries 41 coped.) the field status variant is
defined at client level. We can use any of the field status variant.
However, we need to ensure the status of various fields before assigning
to our company code.
You can make filed status settings as per the requirement for the project,
but we must doubly ensure while setting any field as required entry. The
required entry status stops the end user to input the relevant information
while processing the documents. The screen shot of the FSTV is as under:
Narendra 36
Note: you are requested to take up all the groups which are mainly used
fin module do the same process and ensure no fields are set as required
entry. The exception is the G005 the Value date is defaulted as required
entry. Keep that as it’s only
Narendra 37
Narendra 38
Assign the field status variant to company code: Path is same as above
TC OBC5
Click on position button.
Give company code: 5500
Give the field status variant: 5500 and save the data
The screen appearance for this company will be prompted as per the filed
status of the variant.
DOCUMENT TYPES AND NUMBER RANGES:
Document types are used to identify the business transactions. Sap has
already defined the document types for various transactions; we can use
those document types. Otherwise, we can create the document types as
per the request of the client. But, make all possible efforts to make use of
the defaulted document types. Every document type should subscribe
with the reverse document type.
Account type
The following are the important document types for finance
module. The other document types will be discussed latter.
Narendra 39
Every document type should be assigned with a number range (which
was defined by sap). For that number range we have to assign the
number range interval. With the help of number range interval, the
system stores the data in serially. The screen appearance of the
document type is as under. The number range can be given in the
following screen itself by selecting the number range information button
or if we want to give separately we can go the transaction code: FBN1.
Select the document type and click on details button. You will be
displayed with the attributes of the document type. You have observed
the main points as follows.
1. Account types which can be allowed with this type of document.
2. Whether it allows the negative posting or not?
3. The foreign exchange rate type applied with the document type.
4. The field status of the header data of the document.
5. And other control functions can be allowed for this document type.
Document type controls the field status of the document header data.
It controls the reference number and document header text. If you
select any
check box while creating, the systems promts those field as ready for
input mode while entering the document.
We can restrict the document type for specific purpose by selecting the
special usage check boxes. Accordingly system controls the applicability
of the document. You can not use the document except for the specified
purpose.
Document type controls the exchange rate type to be applied with the
document type. Specify the exchange rate type in the provided column.
Narendra 40
To give the number range interval click on number range information give
company code: 5500
Click on change interval button
Click on insert interval button (top left corner)
Give no: 03 (which is the number range for sa document type)
Give the year: current year Give the from number to number
Click on insert button (bottom left) and save the data. A message will be
displayed click on continue button and save .The screen appearance will
be as under.
Other wise we can give the number ranges through navigation also. The
transaction code is FBN1. We can copy these number ranges from year
to year sometimes from company code to other company code also. The
number ranges are defined to store the business transaction in the
system serially. It is useful to identify the documents posted in the
system. While configuring the number range intervals we must assign the
number object invariably.
Narendra 41
if you want continuous number rage irrespective of the years give the
year up to which you want the number range interval is applicable.
Otherwise, you want year specific number range give the present year
only. If you select the external check box you have to maintain the
striatum manually, if you don’t select that check box the system
maintains the striatum as per the request of the client we have to
configure. The current number displays the number of documents posted
so far.
Posting Keys: Posting keys are used either to debit the account or credit
account. With definition of posting keys, we can also control field status
of accounts. Sap has already defined the posting keys we can use those
as it is. Otherwise, if the client specifically requests you to create defined
postings we can define them as per the request. The following are the
important posting keys.
Narendra 42
I suggest you to verify the attributes and convince the client to use the
default posting keys. The screen of the posting keys will appear as under.
If you want to know the attributes select any posting key and click on
details button or double click on the posting key.
Path: spro>img>financial accounting>financial accounting global
settings>document>control> line items>define posting key: TC OB41
Narendra 44
TC: OBD4
Select new entries button
Give chart of accounts: 5500 (same as company code)
Account group code: (any four character code)
Give description the group.
Narendra 45
DEFINED RETAINED EARNINGS ACCOUNT: This step is prerequisite
step to open the general ledger accounts latter. If you don’t define this
step the system will not allow creating the general ledger account.
Path: same as above: TC: OB53
Give the P&L statement account type as: X
Give any account number in the liability account group: 199999(herein
this step we are presuming that this account is our retained earnings
account only. Hence the system gives a warning message: the particular
account is not opened in chart of accounts. Ignore the message pressing
button. And save the data. The appearance of the screen will be like this.
Narendra 46
In real time most of time we upload the data form legacy system, which
reduces the implementation time of the project. The creation of general
ledger accounts depends on the clients accounting system they follow. If
they are following centralized accounting system we can open the
account in chart of account level first and set the company code
customization requirement latter. If the company is following
decentralized system of accounting we can open the general ledger
accounts in centrally option. Depending on the requirement of project
we can adopt any suitable method of opening the GL accounts.
For the purpose of opening GL account, we need bi-furcation of all
accounts as under and select the minimum configuration requirements
made in the following box. For opening the GL account the Path is:
spro>img>fa>gla>gl accounts>master data>preparations>gl account
creation and processing>edit gl account (individually)>edit GL account
centrally.
TC: FS00 or you can access the screen through easy access
screen also. General ledger accounts groups for the purpose of
creation only (do not compare with account groups)
1. All expenses will be formed into group (because the master data
requirements are similar to all expenses accounts hence made
expenses. You open one account in expenses; with the help of those
expenses we can create any number of accounts as required.
2. All incomes
3. Clearing accounts (expenses payable and income receivable gr/ir
clearing accounts cash clearing accounts)
4. Reconciliation accounts :( accounts payable account, accounts
receivable account, asset acs)
5. Bank accounts (all cash accounts, bank accounts, including loan
accounts)
6. General liabilities (share capital, misc) 1. Opening of expenses
accounts: give the company code and give the account number you
want to open and select the create button give details as in the second
box.
1. Opening of expenses accounts: give the company code and give the
account number you want to open and select the create button give
details as in the second box.
Narendra 47
For opening of many expenses accounts you can select with template
button and give account number as reference number and company
code. System copies all details into the new account and change short
description and long description and saves. (Need not change other
details)
2. All income accounts
Narendra 48
5. Bank accounts:
Narendra 49
[Link] Year GL Account Year Account Description
1 2006 100000 2025 share capital account
2 2006 140000 2025 accounts payable account
3 2006 141000 2025 expenses payable account
4 2006 142000 2025 sbi term loan account
5 2006 142500 2025 sbi foreign currency loan account
6 2006 143000 2025 cross company clearing account
7 2006 144000 2025 bill of exchange payable account
8 2006 145000 2025 check/bill of exchange account for payables
9 2006 146000 2025 down payments received account
10 2006 147000 2025 bank bill discounting account
11 2006 150000 2025 excise duty payable account
12 2006 151000 2025 edu cess payable account
13 2006 152000 2025 vat payable account
14 2006 153000 2025 tds payable account
15 2006 160000 2025 stocks clearing account
16 2006 170000 2025 GR/IR clearing account
17 2006 171000 2025 special reserves account
18 2006 200000 2025 bank account
19 2006 222000 2025 interest clearing account
20 2006 223000 2025 transformers account
21 2006 240000 2025 accounts receivable account
22 2006 241000 2025 down payments made account
23 2006 242000 2025 tax on down payment clearing account
24 2006 243000 2025 cash discount clearing account
25 2006 245000 2025 check/bill of exchange account for payables
26 2006 246000 2025 bill of exchange receivable account
27 2006 250000 2025 vat paid account
28 2006 251000 2025 educational cess paid account
29 2006 252000 2025 excise duty paid account
30 2006 260000 2025 finished goods inventory account
31 2006 270000 2025 raw material inventory account
32 2006 271000 2025 interest clearing account
33 2006 280000 2025 land account
34 2006 281000 2025 building account
35 2006 282000 2025 plant and machinery account
36 2006 283000 2025 assets under construction account
37 2006 283500 2025 assets under construction (investment purpose)
38 2006 284000 2025 low value assets
39 2006 284100 2025 leased assets a/c
40 2006 285000 2025 accumulated depreciation account
Narendra 50
S.N GL
Year Year Account Description
o Account
41 2006 300000 2025 sale revenue account
42 2006 317000 2025 sale of asset account
43 2006 320000 2025 profit on sale of asset account
44 2006 321000 2025 purchase of raw material inventory account
45 2006 401000 2025 manufacturing expenses account
46 2006 402000 2025 exchange dif account
47 2006 403000 2025 interest account
48 2006 404000 2025 administrative expenditure
49 2006 405000 2025 cash discount a/c
50 2006 406000 2025 payment dif account
51 2006 407000 2025 bank charges account
52 2006 410000 2025 raw material inventory changes
53 2006 411000 2025 cost of goods sold account
54 2006 412000 2025 cost/price differences account
55 2006 413000 2025 inventory difference account
56 2006 414000 2025 stock transfer loss/profit account
57 2006 415000 2025 changes in stock account
58 2006 416000 2025 raw material consumption account
59 2006 417000 2025 depreciation account
60 2006 417100 2025 loss on asset sale account
61 2006 417200 2025 special depreciation account
62 2006 418000 2025 asset scrapping account loss
63 2006 420000 2025 reconciliation account
64 2006 421000 2025 bonus
65 2006 422000 2025 telephone expenses a/c
66 2006 423000 2025 welfare expenditures a/c
67 2006 424000 2025 warehouse expenses account
68 2006 425000 2025 job fair expenses account
69 2006 426000 2025 repairs to property (capitalization)
70 2006 427000 2025 sales commission
Narendra 51
General notes:
1. System by default the account currency as local currency. If you want to open any
account with other than local currency, you can mention the currency. However, the
account opened with other than the local currency will allow the transactions in that
particular currency in which you have opened the account.
2. If you open the account with local currency, the system allows postings in any
currency and converts into local currency also. The screen shot of one account is as
under
The above list is the list of chart of accounts created for the requirement of the
project.
Click on create button and give the account group (select from the list)
Select account type and give the short text and long text and press enter
to go the company code data.
Narendra 52
* Account currency: automatically defaulted from company code currency
you can change the currency if required. If the account currency is local
currency, we can post the transaction in any currency to this account. If
you defined other than local currency, we need to post the transactions in
the respective currency only.
* Only balances in local currency: with a view to maintain the balances
only in local currency, select this check box other wise not required. Only
some clearing accounts needs this definition.
* Exchange rate difference key; is used to valuate the foreign currencies
* Valuation groups are used in parallel valuations
* Tax category, and post without tax allowed. This will enable the type of
tax to collect with this account. The second selection is used to post the
transactions without tax allowed.
* Reconciliation account type: determines the account as a reconciliation
account* discussed in latter chapters
* Alternative account numbers: is used to define and integrate with the
country specific chart of accounts.
* Accounts maintained in external system: it is applicable for
decentralized accounting systems in the organization.
* Inflation key: is used to maintain the index based accounting in the
system. We need to define the inflation keys.
* Tolerance group: if you mention the group, allow the differences set in
the tolerance amount for general ledger accounts.
* Open item and line item: this will indicate the account maintenance as
general or as open item (discussed later) line item displays the individual
transactions for display
* Sort key: will sort the transaction and create the reference or allocation
number according to this field.
* Authorization group and accounting clerk: it will restrict the account to
be used by the authorization group and accounting clerk named in.
*Recovery indicator: specifies the sharing pattern of this account
balances in joint account business transactions.
Narendra 53
* Field status group: the end user screen will be prompted as per the filed
status group assigned to the master record.
* If you select the post automatically, no manual postings are allowed in
this account
* If you select the reconciliation account ready for input: allows the
change of reconciliation account during the postings.
* Bank financial details are used for treasury module: we can main the
account is maintained with the house bank and the account id of the
account with house bank
* Commitment item shows the commitment details for the account in
commitment accounting.
* Interest indicator is used to calculate the interest on this account
* Key date and other last run date shows the interest calculated up to the
period and date of calculation is displayed in the master record.
* Key data and translation: is used to translate the particular general
ledger account in the other languages
* Information details reveals the user name created this account and the
other information in company code.
Narendra 54
DEFINE TOLERANCE: These tolerances are 3 types
1. Tolerances for GL accounts
2. Tolerances for Employees
3. Tolerances for Vendors and Customers.
In real time the system does not allow the users to process and
post transactions beyond these limits set according to the tolerance
groups. The screen shot of the GL tolerances after giving the input is as
under.
Note: Don’t give the tolerance groups in your individual systems. Null
group permit all users. If you mention the user group it allows the
particular group only. For lab environment. It is advisable to process with
null group. Other create the groups and assign the users to groups
Path: spro>img>financial accounting>general ledger accounting>business
transactions>open item clearing>clearing diff> define tolerance for gl accounts.
T-Code: OBA0
Give company code Give description of the tolerances Give debit
absolute amount credit absolute amount and Dr % and Cr %. Save. If
you assign this group to particular general ledger master the tolerances
mentioned for this group applicable for the GL account
Narendra 55
Tolerances for employees: path: same as above: TC: OBA4.
* Select new entries button
* Give company code
* Give the description of the tolerances
* Give the maximum of amount per document: 99999999
* Give the maximum amount per line items: 999999999
* Give the maximum cash discount as: 5%
* Give permitted differences revenue: 500 expenses: 500 and Dr% and Cr
% * Give cash discount adjusted to: 100
Tolerances groups are created basing on the authorizations vested with
the employees in the organization. We can create as many as employee
tolerance groups and assign them the tolerance limits. Accordingly,
system will not allow the user beyond their limits. It is exclusively for a
security and a sense of discipline while discharging the duties in the
organization.
With the above configurations we have completed the basic settings like
as organizational units, general ledger accounting, tolerances, and other
Global settings required for posting entries by the user in GL accounting.
Amount per document: this is the maximum amount for the user groups
to deal with the document limits.
Narendra 56
Maximum line item or open item: this is maximum amount to make the
payment of line item while doing the clearing function.
Maximum discount: the discount allowed by this user group while dealing
with the incoming and outgoing payments.
1. Define number range interval for number range: X2(no object) in fbn1
transaction
Creation code. document: f-01 Path: accounting-financial accounting-
of sample
general ledger-document entry-reference documents-sample document.f-
01
Give the line one data and amount text and the related information and
give the line item two data and save the entry.
Narendra 58
Narendra 59
You can select the other parameters to block the session to certain date
by giving the block date. up to the date it will lock the session. We can
execute after the lock date.
By selecting the hold data option we can retain the faulty processed
session without deletion.
And click on execute button. System creates a session with SAPF120; go
to menu item system>>batch input>services>sessions. Select the
session sapf120 and click on execute process button select display errors
only and again enter.
Click on new entries button and give the details as appear in the screen.
Narendra 60
Run dates entered as per the requirement and save the data now create
the recurring document in FBD1. (As same as the previous process)
Do not give the first run and last run instead give the run schedule in the
column provided. Remaining processes are similar to the previous one.
Recurring document also cannot update the balances till they posted.
Go to menu item select recurring entry data. The system displays the
data
This is another type of reference document. It is generally used to post
the amount with different business areas and among various general
ledgers with % share. It useful to distribute some expenses among
various general ledgers. The creation of Account Assignment Model
template is two types;
Note: we can create our own template the account assignment model or
we can use the default template and create the document.(creation of
template is in IMG screen>fa>fags>document>account assignment
template)
Narendra 61
From the possible fields select the field and double click (it will go to
current field box)
Like the way select the template fields and save the template for your
purposes. (The maximum length if 85 fields only (within the limit we can
select any fields for template) save it
Keep the cursor on the template and click on activate button to activate
for the template.
Creation account assignment model document: with equilance.
Path: accounting-financial accounting-general ledger-document entry
reference document-account assignment document: FKMT
Give the account assignment template number: 2006
Click on create option
Narendra 62
Give the currency and chart of accounts if you want calculate the tax on
the items processed through this template select the tax check box and
give the details as under
Narendra 63
Give the general ledger number and dr/cr indicators amount and give the
required information in the screen variant. No posting keys are required
in this screen. We can post multiple debits and multiple credits as per the
requirement. We can observe the whether the dr/cr balance is equal while
posting itself. This is easy for posting in day-to-day processing.
Business scenario: 2
The client requested to advise the easy processing of documents to their
end users while doing the day-to-day transactions.
SAP Solution: to make the end user job easy, and avoid the delay and
inconvenience sap suggests opting for HOLD AND PARK DOCUMENT
process.
HOLD DOCUMENT: This is one of the required and regular functionality;
while processing the day to day operations. It will help to temporarily
suspend the work without losing the data which already entered. The
requisite condition is assigning the temporary number to hold the
document.
How to hold document: Post the transaction as usually in F-02 general
posting, go menu item Document>simulate>Hold or Document>hold
How to post the hold document: Go to F-02 general posting, Give header
data, click on held document button or go to menu item document>get
held document. System asks for the temporary number and give the
number and press and post the transaction.
PARK DOCUMENT: This is one of the other functionality used in daily
transactions. It will not also update the general ledger balances till final
posting is completed. It can be used when there are no proper
authorizations to the user and has to send the document to other user for
confirmation of the document.
1. Park document can also be deleted, modifiable, and can be rejected
by the user.
2. The main differences between the hold document and park
document are park document is parked with the regular document
number where as the hold document held with temporary number.
3. The main feature of the Park Document is, we can change the
header data details including the posting date and document type.
This is the only area we can change the posting date, and document
type in SAP environment.
How to park the document: go to normal posting i.e. f-02 and give the
header data and line item data as usual. Go to menu item document click
on . Document will be parked with original number. Or we can park the
general ledger document in separate posting screen. Transaction code: F
65. Usual posting screen but exclusively for parking of document.
Narendra 64
Posting of Parked document: Accounting>fin.
Accounting>general ledger>document entry>parked
document> FBV0 post/delete park document. Give the
company code: [Link] the parked document number
Pre requisites: The prerequisite to reverse any entry (a) define the reason
code for reversal
Path: spro>img>financial accounting>general ledger
accounting>business transactions>adjustment posting/reversal:
Give the reversal reason: two character code
Give the description: standard reversal and negative reversal
Select the Alternative posting date for the both the codes
Select Negative posting check box for negative reason code.
Narendra 65
If you want to do the negative reversal the following conditions should be
met.
1. Reason code must be selected with negative posting check box
2. 2. The company should also permitted with negative posting
3. 3. The document type should also permit with negative posting. The
reversals are four types.
3.1. Individual reversal
3.2. Mass reversal
3.3. Reversal of clearing document
3.4. Reversal of reversal document
The reason code screen will appear as under Satya info Tech Company
has created two reversal reasons as appearing in the screen
Narendra 66
Narendra 67
Mass reversal functionality will be done to reverse the multiple entries. To
reverse the clearing entries, we have to reset the clearing document in
TC FBRA
We can reset and reverse the clearing document in the same screen it
self.
Click on new entries button; select the message number change the
online and batch input option fields as warning: there by the system give
the warning message. We have to define it once for a client.
Accrual/Deferral documents
In real time accrual nature of either income or expenditure is
common. Every organization has to consider this type of income and
expenditure accurately for period it belongs. Then only the balance sheet
or profit and loss account reflects as correctly in the financial statements.
Hence this of activities is as important as a mater of practical in real
time. Hence as a consultant we have to guide the end user properly in
this regard.
Narendra 68
Accrual/Deferral:
Expenses or Revenues posted in one period may sometimes pertain to
either previous periods or future period also. In this scenario, we have to
consider this income or expenditure, relating to this period only. The
remaining amount has to be considered as accrual/deferral. ACCRUAL
means adjusting the amount relating to the past period received/paid in
present period is called as accruals. DEFERRAL means adjusting of the
future period amount received/paid in the present period is called
deferral. In the both instances, we have to adjust and post the correct
amount in the present period accurately. For this purpose, we need to
define the accrual/deferral document.
Pre requisite: define reversal reason code:
Financial accounting-general ledger accounting-business transactions
adjustment posting/reversal-define reasons for reversal.
Click on new entries button
Give two character codes: and description.
Select the alternative posting date check box and negative posting check
box and save. The screen is as under
05 is the code defined by SAP. We can use it for the project requirement.
Accounts required: expense and revenue accounts.
Accrued income and pre paid expenses account as clearing account or
we can use
Expenses payable or income receivable accounts also.
Narendra 69
BUSINESS SCENARIO:
Post the expenditure in F-02(insurance for the quarter).15000/- per month
5000/- each. However, actual expenses for this month are 5000/-only the
remaining 10000/- expenses paid in advnces. We need the bifurcation of
insurance expenses as above. Other wise the total 15000 amount reflects
in profit and loss account
Define Accrual/Deferral Document: accounting-financial accounting-
general ledger-periodic processing-closing-valuate-FBS1 accrual/deferral
document.
Give the document date: 31.10.2006
Posting date: 31.10.2006: document types. SA
Give the reversal reason: 05 accrual
Give the reversal Date: 01.11.2006 (next month on which it has to be
reversed)
Posting key: 40 General ledger accounts: pre paid insurance account Give
the amount and text second posting key 50 general ledger account:
insurance exp account simulate and save the transaction
Narendra 70
CLEARING FUNCTION:
This function is used to clear the outstanding entries in the general
ledger accounts. Example: outstanding amounts in expenses payable and
income receivable accounts. To clear the amounts we can do three types
of clearing functions.
1. Standard clearing
2. Partial clearing
3. Residual clearing.
While doing the clearing function we can select the additional selections
to make the payments.
If you want to make the payment document number we can select this
option and give the Document from number and to number to clear the
items. Other wise if you want to make the Payment basing on the option
of dunning area wise we can make the payment like that.
We can see the other accounts of the same customer/or vendor by
selecting the particular option.
Can see the items with special GL heads also can be viewed from this
screen.
The clearing function is one of the excellent functionality in SAP
environment.
The main difference between the partial clearing and the residual clearing
is the former one display the original open item amount and partial
payments as open items until the account is settled in full.
Narendra 71
The final settlement will convert all the entries as cleared item. In case of
the latter one, the it clears the original open item as cleared item and
creates a new open item with the residual amount. If you mention the
reason code in residual clearing function the residual amount
automatically posted to Payment diff ac (automatic determination should
have been done in the chart of account level). If no Reason code is
assigned it will credit/debit to the same account.
Post the transaction in open item accounts. And clear it with partial
clearing option. There by both the items appear as open items. Now
execute the Automatic clearing Programme as under:
Narendra 72
Give the details and select the accounts for executing the programme
It automatically clears the open items. This programme is useful for
clearing the open items with automatic posting transactions.i.e. GR/IR
clearing account.
Give the 4 character key for the exchange rate type and give the
description of the rate type. TC: OB07
Narendra 74
3. DEFINE TRANSALATION RATIOS FOR CURRENCY TRANLATION: In
this step we have to define the translation ratio for each currency pair for
which we want to take up the foreign exchange transactions. In the
present case it is US dollars against Indian Rupee.
The Path: same as above the TC: OBBS. The screen will appear as under.
ENTER EXCHANGE RATES: FOR EXCHANGE RATE TYPES: We have to enter the
exchange rates to all exchange rate types if necessary or if you are following one type
of rate, we can maintain the rates for that type only. Give the details as under
Narendra 75
Give exchange rate type :B
Give valid from date:010406
Give ratio from:1
Give currency: USD
Give rate: applicable
Give ratio 1
Give to currency: INR
Save
We can maintain different rates for different exchange rate types with
different validity periods. Generally these rates will be downloaded from
everyday from RBI. These data will be maintained in currency table.
Narendra 76
Valuation of foreign exchange balances on key date:
Path: financial accounting>general ledger accounting>business
transactions>closing>valuating>foreign currency valuation>define
valuation method
TC OB59
Narendra 77
Valuation group: It is used to group the all customer, vendor, and general
ledger accounts into group and apply the same exchange rate type as a
group as a whole
Valuation area: It is applicable legal reporting the financial statement
as per the different accounting principles.i.e. Indian accounting
standards, and GAAP, in such cases we have to create valuation areas, to
valuate the foreign currency and customer and vendor balances
Lowest value principle: if you select this check box the system calculates
the exchange rate difference valuation basing the lowest rate of the two.
If you select revalue check box only revaluation as income will only be
considered for revaluation and devaluation will not be considered for the
purpose of valuation.
If you set any minimum difference amount in the column provided the
system will not revaluate the currencies up to this amount of difference.
Narendra 78
BUSINESS SCENARIO: Satya info tech has availed a Bank term loan
from State Bank of India, Pimpri Branch. Bank is charging every month
interest on the term loan. Like the way Satya InfoTech has availed
different other loans and given loans to some of its employees@10%.
How to calculate the interest on the term loans? Bank is charging 12%on
the outstanding. Make the customization in SAP environment.
SAP ENVIRONMENT FOR CALCULATING INTEREST: SAP has provided
with the interest calculation methods. There are two types of methods are
available. One is Balance Interest calculation and another one is Item
interest calculation. Balance method is applicable to interest calculation
on gl balances and item interest will applicable to vendor and customer
balances. The customization process is under:
Narendra 79
PREPARE ACCOUNT BALANCE INT CALCULATION (GENERAL
SETTINGS) TC OBAA
Path is same:
Select new entries
Give interest indicator
Narendra 80
Define reference interest rates :( separately for debit into and credit
into)
Give the above details and select next entry button. Give the ref into rate
for cr balances. Save the data the screen will appear as above
Narendra 81
Give ref into rate: 2001
With effect from: 010406
Interest Rate: 12
And do the same process for rest of the reference interest rate also. The
screen will appear as inthe figure.
Enter Time Dependant terms (path is same) TC: OB81
Narendra 82
Give the into indicator: 20 currency key: inr eff from: 01.0406 sequential
no:2 term:cr. Bal. int. cal
Ref into rate: 2002 like the way create for dr balances, ref into rate 2001
also. The screen is above.
If you mention any percentage in the premium column, system considers
this rate as additional rate specified in reference rate. The effective would
be reference rate plus premium rate if any.
In the amount from column, if you specify any amount the system
considers the over and above amount at this rate. This configuration is
required for any graduated interest rates applicable for the different
amount scales.
For automatic posting of interest we have to make automatic
determination of accounts in transaction code: OBV2.
Narendra 83
Note: masking is done to take care of all general ledger accounts for the
purpose of calculation of interest rather than mentioning any single
account(single ac no. will apply the interest on that ac only)
2. Account symbols are defined by sap do not change it.
3. Open the loan account with (bank account conditions) and give the
interest indicator in loan account master
4. Post the loan transactions and go for executing of interest application
in F.52 balances(under periodic processing in general ledger folder.
5. For posting of interest select post interest settlement check box and
update the interest details select the update master record check box. A
programme is created with name RFSZIS00 Now go menu item
system>services>batch input>sessions> select the above session and
click on process button select display errors only click on process button.
System will apply the interest to loan ac go and verify the document in
FB03.
OTHER IMPORTANT BUSINESS SCENARIO CUSTOMISATION:
Deletion of General ledger account: in this connection I would like to
advise deletion is not possible once the data was posted into the
accounts. Then the option only to block the particular account .Before
posting the transactional data we can delete the accounts by selecting
deletion flag for the accounts to be deleted. The deletion of gl account in
IMG screen only. Path: a>gla>master records>deletion>deletion of gl
account TC: OBR2.
Give required details
Delete the test run button
Execute.
The programme name for executing the gl account is SAPF019
Narendra 84
Transport the chart of accounts from one client to another client or
another system. For this purpose we have create the correction request,
and with the help of this correction request we can transport the chart or
accounts from one client to anther client. (We have to select the areas to
copy to transport) the transaction code: OBY8 the Programme name:
SAPMFKM
COPY OF GL ACCOUNTS:
Copy of gl accounts can be done either for chart of accounts level or
company code level:
Path: financial accounting>general ledger accounting>master
records>general ledger account creation and processing>alternative
methods>copy gl accounts>copy chart of accounts TC: OBY7 and copy
company code accounts: TC: OBY2
Give the chart of accounts in which you want to copy:
Give the reference chart of accounts from which you want to copy the gl
chart of account level
Click on copying capability, once it is completed save. Programme name:
SAPMFKM8
CREATION OF GL ACCOUNTS WITH REFERENCE :( GL account
creation and processing)
Select creation of gl account with reference:
Give the chart of accounts to which the accounts to be copied down
Give the chart of accounts from which you want to copy the gl accounts
Click on details button
Click on account reference button; give from gl account and to gl
account (range to be copied)
Select all the gl accounts to be copied
Check the check button (for consistency of the data to be copied down)
Create gl accounts button and account determination button also
System copies all accounts and automatic determinations also
Finally check the Check button for verification.
THE PROGRAMM NAME FOR COPY OF GL ACCOUNTS WITH
REFERENCE IS SAPLGL_ACCOUNT_MASTER_REFERENCE. CHANGE
OF GL ACCOUNTS MASS MAINTAINENCE:
Path is same:
We can change the general ledger data collectively in 3 levels. The first
one is chart of account level and company code level and account name
level also
The programme name for change gl account collectively is:
SAPLMASSINTERFACE
Creation sample account: TRANSACTION CODE: OB15
Narendra 85
Path: financial accounting>general ledger accounting>general ledger
accounts>master records>preparations>additional activities> sample
accounts
Maintain sample account rules;
Select new entries.
Give: 4character code (2006) description. Save. The screen as
under
Narendra 86
we set in sample account. Accordingly we can create any number of
sample accounts and keep as reference further creation of accounts.
TEXT IDs CREATION: These are helpful to quicken the process of creation
of gl master records and the ids can be stored in the system for further
processing.
Path: Fa>gla>gl accounts>master records>preparations>additional
activities>creation of text ids for chart of accounts and company code
master data. TC: OBT6and OBT7
We can also define the text ids for documents also in transaction code:
OBT8.
We can set the required screen lay out for activity wise or general ledger
account wise. We can take the print out of the field status of the activity
by clicking print field status
Narendra 87
DEVELOPMENT OF ENCHANCEMENTS FOR CREATION OF GL
ACCOUNTS: These enhancements are useful for creation additional
actions to be used for the specific request of the client or the project
requirements. For this purpose we have to create the project name create
the enhancements with the help of user exists.
DEFINE SORT KEYS: We can define the sort keys as the requirement of
the project. Path: spro>[Link]>financial accounting>general ledger
accounting>general ledger accounts>master records>line items>line
item display>define sort variant TC: OB16
Select new entries button
Give 3 character sort key variant name and description
Give 3 fields which are to used as allocation fields
Save
CREATION OF WORK LISTS: These are helpful for view the reports as a
whole instead of individual. Example, if we want to see all the bank
accounts balances we can see the balances of all bank accounts by
creating work lists. We can create as many as work lists, and used for
user master record. TC: OB55
Path: spro>[Link]>financial accounting>general ledger accounting
General accounts>master records>balances> creation of work list
Narendra 88
SAP QUERIES:
These queries are used by the functional people to prepare the reports
basing the cross information embedded in the tables. BY using these
queries we will create a report basing on the information available in
different tables, and combine them for the purposes of reporting. For this
purpose we have to first set info set queries, and assign them to user
groups and create sap queries. These reports are called sap list viewer
reports. These can be prepared by the users even without the help of
technical support.
Narendra 89
System stores the same number in the header data of the document also.
We can change the cross company code documents also reverse the
documents also. Transaction code for reversal of cross company code is
FBU8.
Enter Global Parameters:
Narendra 90
Enter Global parameters: spro> rimg> financial accounting> financial
accounting global settings> company code> enter global parameters.
TC:OBY6
Click on position button
Give company code
Select company code
Click on details button
See the parameter check boxes; select the check boxes you require:
example:
1. If you want business area financial statement select that check box
2. If fiscal is to be defaulted to you select
3. If value date is posting date to be defaulted select
4. Maximum ex rate deviation set any percentage you require as per the
client requirement
5. Select the negative posting allowed check box
Note: if you want to know the field information keeps the cursor
on the field and press F1.
Maximum exchange rate deviation: if you set any percentage here the
system gives a warning message while posting a document with
deviation beyond the percentage.
Tax base is net value: If you want to consider that the tax is to be
collected on the net off discount value select this check. Otherwise the
system calculates the taxes on the total invoice value.
Discount base is net value: if you want to collect the cash discount after
deducting the tax select this check box. Other wise the system
calculates the discount on the invoice value i.e. inclusive of tax.
No exchange diff when clearing in Lc: If you select this check box
the system will not consider the exchange diff while clearing the
amounts.
The Global settings, can be configured here, otherwise while doing the
respective component we can do the customization individually also.
Under first method, posting are made into either single additional
account or joint account (defined for this purpose) for all valuation
methods, evaluation will be done at the time year end closing process
As per the second method different ledgers will be defined for different
valuation methods, and the data will be stored in the respective ledger.
The definition of ledgers will be generally done in Special purpose
Ledgers. The data in respect of one Ledger will be used for the purposes
of controlling; the particular ledger data is called LEADING ACCOUNTING
PRINCIPLE DATA. The additional ledger data cannot be used for the
purpose of controlling.
In the Third method we have to define separate company code and store
the data relating to additional valuation data in the company code. This
scenario will support by only financial accounting application component
and asset accounting component only. No other component will support
this functionality.
When we have adopted the parallel valuation methods the following areas
will be affected by the method of valuation.
1. Regrouping of receivable and payables
2. Value adjustments
3. Foreign exchange valuations
4. Accruals.
Narendra 92
MULTIPLE CURRENCIES: Like the way of, maintaining additional
valuation methods for meeting various reporting requirement, we can
define multiple currencies in SAP system. We can maintain additional two
currencies in sap. The system will update the balances in all the
currencies in real time. The selection of other additional currencies will
depend on the company requirements. We can define any currency type
as our additional currencies.
Narendra 93
DOCUMENT ARCHIVING This is the methods adopted to keep the data
aside from the data base. When the data base is in high volume and
some data relating to old fiscal years, we can keep the old data
separately. For that purpose we have to define the archiving rules. Once
the archiving rules were defined, the system checks data base and
archive it. We can delete the archiving data for this purpose we have to
set deletion flag in Master records.
Path: financial accounting>financial accounting global
settings>document>document archiving:
TAX ON SALES AND PURCHASES: Every country has its own tax
calculation procedure. It is the main revenue source for the Government.
Government can levy the taxes and changes the procedure from time to
time as per the tax plan for the nation. There are two tiers in tax
jurisdiction.
1. Country level
2. 2. State level.
Or some times at both levels also. Generally tax procedure not in sap
system it is a separate soft wear and made generic interface with the soft
wear. SAP supplies country version tax system. Accordingly we will follow.
As far as customizing is concerned, major part of the customization will
be done by the material management people and sales and distribution
people. However, we as a finance consultant we should know about the
outline configuration of the taxes.(for India we have Country India
Version,5.0 to meet the country requirements)
There are two types of taxes:1. Input tax and [Link] put tax.
Input tax is defined with code: V
Out put tax is defined with code: A
Business Scenario: Satya InfoTech is supposed to pay the input tax i.e.
excise tax on purchases @16%, educational cess 2% and supposed to
make the payment of VAT12%.like the way supposed to collect the output
tax i.e. excise duty 16% educational cess 2% and 12% VAT.
Narendra 95
CHECK AND CHANGE SETTINGS FOR TAX PROCESSING: In this step
we have to define the process keys or account keys. These account keys
or process keys are used to determine general ledger accounts and
posting keys for tax line items. SAP advice not to change the keys and
use the defaulted keys only. If you want to change the account keys copy
down the defaulted keys and change the name of the account keys and
used for your project.
For this project we are using the processing keys or account keys as
under:
I10: excise duty paid
I11: [Link] paid
I12: vat paid
O10: excise duty payable
O11: [Link] payable
O12: vat payable
With the help of the above keys the system will credit the respective
amounts in determined accounts either as debit or credit.
Define 4character procedure and description and keep the cursor on the
procedure double click on control data button (in the left side of the
dialogue structure box)
Select new entries button. Give the table contents with the condition
types and respective process keys.
Define the input tax conditions step 10 base amounts. This is the base
amount to calculate the excise duty
2. Educational cess is to be collected on excise duty hence in step 20:
condition key I201 base value for calculating the edu cess is excise duty,
hence made as from 20 to 20 in the column
Like the way we have to define for all types of taxes and also the account
keys in the extreme right of the screen (not visible in the screen).
Narendra 96
Now the calculation procedure for your country is ready for use. To make
account for the same to our customization we have to assign the same to
country. TC: OBBG
Narendra 97
Give country name
Give tax code: 2 character name:I0 (input tax with 0%)
Description.:0% tax for input tax and continue
In the next screen give all input tax as all zero and keep the cursor on
output column and click on deactivate line button and save. The system
creates the I0 tax.
Narendra 98
Repeat the same process for all output tax codes also
Output tax code: o0 (o zero)
Output tax code o1 (excise duty payable educes payable+vat)
While creating out tax codes give tax rates in output tax column and keep
the cursor on input column and select the deactivate line and save .
Accordingly now for this project we have created 4 tax codes as per the
requirement
Tax procedure: requirement of general ledger accounts: To take of
about the automatic determination of tax amounts we need to define
accounts for tax.
In put tax accounts:
1. Excise duty paid
2. Educational cess paid .
3. Vat paid account
4. As asset group and allowed only input tax
1. Post the loan transaction in old date (with value date also old data)
2. Automatic determination of accounts for interest. Path:
spro>rimg>fa>fags>tax on sales and purchases posting TC: OB40.
Select the process key what we have defined
Select the tax code check box and save
Give the tax and GL accounts as mentioned in the figure and save.
Narendra 99
NOTE: for input tax only vat paid account will be displayed
because we have given the posting indicator as 2(separate line
item for that only) rest of the input tax account keys having
indicator as 3(distribute to respective expenses/revenues)
Solution:
1. Since the satya info tech is following group concept. We have to define
the Group chart of accounts maintaining language is English. While
defining the chart of accounts for individual company we will assign the
group chart of accounts. And assign the each general ledger account to
group account.( we can assign any number of accounts to one group
account)
2. We will define one of the additional local currency is group
currency i.e. Us dollars.
Narendra 100
3. We will define country specific chart of accounts to meet the
requirement of countries and assign it company code along with the
operative chart of accounts. Then the system prompts the account
number while creating the accounts in operative chart of accounts.
4. Give the account number in alternative account no field of the gl
master record. However, we have to assign the account numbers in 1:1
ratio only. 5. If you do this functionality, the rest of reporting can be taken
by the system.
GENERAL LEDGER PLANNING: Planning can be done for general ledger
wise in financial accounting exclusively. For that purpose we have to
define the plan periods for the variant.
Narendra 101
Narendra 102
PERIOD END CLOSING IN FINANCIAL ACCOUNTING:
As part of period end closing job we have to perform the following
functions.
Day end closing: Ensure all the posting are made properly
Ensure the cash balance is tallied.
Ensure the bill of exchanges payment or list of bill of exchange
Narendra 103
6. S_alr_87012344: To see the posting totals with document type and
debit and credit and [Link] items.
7. S_alr_87012347: To see the period wise line items account type wise.
8. S_alr_87012282: to see the general ledger accounts with open items
accounts or parked item selection.
9. S_alr_87012332: to print the account statements with selection
parameters.
10. S_alr_87012277: to verify the general ledger balances with period
wise and currency wise and balance wise also.
11. S_alr_87012301: to verify the month wise, account wise, debit and
credit totals with balances;
12. S_alr_87012279: structured balances sheet report:
13. S_alr_87012336: to verify the assets and liabilities with local currency
and transaction currency report.
FSIB: to execute the balance sheet reports in back ground environment
Narendra 104
End user important reports in general ledger accounting:
Display of balance sheet and profit and loss account reports in different
views: path: unto- Information system is same >balance sheet and profit
and loss statements>general:
Narendra 105
THA
END
RTOR
Narendra 106