SAP_FICO_NOTES_FI
SAP_FICO_NOTES_FI
GL
AM AR
FI
CON AP
Spl GL
Class: 1
Afzal Page 1
SAP FICO
ERP:ERP Stands for Enterprise Resource Planning. Moto of ERP System is Planning of Resources
in the Organization in an effective manner in order to get more Profitability.
Planning in organization we do below Planning Activities.
Productivity (Relates to Men and Machines)
Effectiveness (related to Methods Employed)
Efficiency (relates to men, Methods and Machines)
SAP
SAP stands for Systems Applications and Products in data processing and founded by Five
IBM engineers in the year of 1972.
The current version of SAP is ECC6.0 EHP 8
EHP= Enhancement Package ECC= Enterprise Central Component
Modules of SAP:
FICO (FINANCE AND CONTROLLING)
MM (MATERIAL MANAGEMENT)
SD (SALES AND DISTRIBUTION)
Afzal Page 2
SAP FICO
HR (HUMAN RESOURCES)
PP (PRODUCTION PLANNING)
Basis
CRM
ABAP - Programming
QM (QUALITY MANAGEMENT)
PM (PLANT MAINTENANCE)
PS (PROJECT SYSTEMS) Etc…
SAP Landscape:
The System Landscape represents the SAP System deployment at implementation.
SAP System landscape consists of below 3 systems.
UAT – stands for User Acceptance Test
Development Quality Server Production / Live
Server Testing and Training Server
Day to Day
Customization or Configuration UAT transactions
Development System: This system is used for configuration according to the business
requirements. All the configurations will be stored in the respective server tables and saved under
Transport request.
QAS: the changes done in the development server we will be copy to quality server for testing and
training activities. The changes will be more through transport request.
Production server: this is the end server which is used for posting of day to day Business
transactions by the users.
Transport Request: It is the Media used to move the changes from development server to quality
and production servers. While saving the changes in development server system will save the data
in the respective tables and stores the information with TR Number. While moving the TR the table
contents of development server will get copy to respective destination servers.
Configuration data: the configuration must be done only in development server to meet the
business requirement. System will generate Transport Request while saving the configuration data.
Ex: Interest calculations settings, Enterprise structure, depreciation terms, AP, AR, Asset
management settings etc…
Master data: all transactional data get posted into SAP with reference to Master data.
Note: There will be no TR generated for master data and transactional data. This data must be
maintained by the business users in the respective servers.
Ex: GL A/C’s, Vendor Masters, customer masters, asset masters, cost centre, production order.
Transactional Data: The Day to Day business transactions are called as Transactional data
Ex: Sales posting, Asset Purchases, Depreciation calculations etc…
Afzal Page 3
SAP FICO
In your desktop Double click on SAP GUI or SAP Log on place the curser on ECC6 item click on
“LOG ON” button
Client: 800 User: sapuser
Password: sapuser
Note:
Password is case sensitive
Password can be alpha numeric
Continuous Login trials 3 times with wrong User ID & password will cause locking of client
for further process.
Option 1: Continue with this log on end other logins in the system.
Option 2: Continue with this log on without ending of any other logins
Option 3: Terminate this login.
The transactions in SAP can be executed in 2 ways.
1. Through path (step by step approach)
2. Through T-Code (Short Cut) (T-Code = Transaction Code)
Each and every transaction in SAP is associates with T-Code.
T-Codes can be directly used by using “Transaction Code Bar”
SAP EASY ACCESS Screen which is called Gate of SAP SEA
To open new session or screens or working with multiple screens.
Option1: Select create a new session button in the standard tool bar. So that a new session will be
open with the screen SAP Easy Access.
Option2: If you are aware of transaction code you can type the transaction code in the Transaction
code bar with a Prefix of ‘/O’ or ‘/N’ to the T-Code.
/O: Creates new session without ending the existing session.
Use “alt + tab” to parallel work with multiple screens.
/N: Closes the existing screen and opens the new screen with the given transaction code.
Types of Projects:
1. Implementation
2. Support
3. Rollout
4. Upgrade
5. Enhancement
Afzal Page 4
SAP FICO
Implementation
Implementations are 2 types.
1. Big-Bang implementation
2. Phase-Wise implementation
Big-Bang Implementation: Implementing of SAP at a stretch for all the business units of the
clients (irrespective of countries, industry type, segments) is called as Big-Bang Implementation.
Very few companies will go with such type of implementations because
a. High Risk
b. More Investment
c. High Monitory requires
d. Less quality etc…
Phase-Wise Implementation: implementation of SAP for business entity at country level, segment
level one after one is called as Phase-Wise implementation.
The implementation of SAP project was given to IBM by APPLE Group for their Line of
Business (LOB) (Phase-Wise Implementation)
Always implementation project majorly handled or done at on site or client place.
IBM will identify project managers, delivery managers, team leaders and respective
consultants for this project.
Implementation Process
Company Profile
Note: During the implementation phase Business has to identify core team members and Super
users who will provide information to the consultants on their business process.
Ex: GM, BP, CFO, CEO etc...
ASAP Methodology:
Accelerated SAP (ASAP) is SAP’s standard implementation methodology.
It contains the road map, a step by step guide that incorporates experiences from many years for
implementing of SAP R/3.
Afzal Page 5
SAP FICO
3. Realization
4. Final preparation
5. Go-Live and Support
Preparation of To-be document (Business Blue Print) this document consists of how the business
want tracking of their business transactions in SAP. Our understanding of their enterprise structure,
modules. They want to implement and their business process.
Interface:
Afzal Page 6
SAP FICO
The connection between SAP system to other third party systems is called as interface.
Preparation of Base line Scope document
Trainings to the End users or Super users
Phase 3:Realization:
The purpose of this phase is to implement all the business process requirements based on the
business blue print. The customization in the development system will be done in step by step in
two work packages.
1. Base configuration
2. Final configuration
FI Organization Structure
Company
Company code1, company code2………… company code n
Business Area1, Business Area2…………. Business Area n
FICO Scope:
Below sub modules want to be implement for FICO.
1. General Ledger
2. Accounts Payables
3. Accounts Receivables
4. Asset Accounting
Afzal Page 7
SAP FICO
5. Banking
6. Reporting system
7. Taxation
a. Excise
b. VAT
c. CST
d. TDS
Ashraf Group wants the below transactions to be posted in respect to the G/L Accounting.
1. Journal entries 11. Financial statements maintenance
2. Parked documents 12. Finalization of Accounts
3. Recurring entries 13. Carry forward balances to next years
4. Document reversals
5. Foreign currency transactions posting
6. Accrual / Deferral postal
7. Interest calculations
8. Analysis of GL Accounts
9. Month end closing operations
10. Bank reconciliation
GL Configuration Steps
Configuration of organization structure
1. Define company
2. Define Credit Control Area
3. Define Company Code
4. Define Business Area
5. Define Functional Area
6. Maintain Consolidated Business Area
7. Maintain FM Area
8. Define Segment
9. Define Profit Center
A new column with Transaction codes will be displayed next to the IMG Activity. The last 4 digits is
called as T-Code.
Afzal Page 8
SAP FICO
Company : TR10
Company Name : Group of Industries ltd.
Street : Hyderabad
PO Box : 500020
Postal Code : 500020
City : Hyderabad
Country : IN
Language Key : EN
Currency : INR
Save – V_T880
Work Bench Request: the changes done by technical consultants (ABAP) in order to meet
Business requirements are called as Bench request.
Ex: Changes to existing screen layouts, menus, new reports and program developments,
Forms development etc...
Request Status
Modifiable
Released
Display
If the TR status was modifiable we can add more customization changes to the same TR No. Till
the TR status was change into released.
Released: the Basis consultants can move the TR’s from one server to another server only if the
status of TR is Released. One cannot append (add) customization changes to the released TR.
Display press enter on this button.
Each request consists of Task. Hence expand the task
Afzal Page 9
SAP FICO
Representative group:
In detailed overview of credit control area will be discussed during AR and SD Modules.
Click on Back Button.
Description : Credit control area of Ashraf
Save -Table V_T014
Click on own request select or doAshraf click on your TR click on Enter Button.
We can have ‘n’ no.of company codes within the organisation depends on Business requirements
and to meet legal reporting requirements.
We can have Transactions between inter company codes in such scenario the affiliated company
codes will be treated as customers and vendors in order to initiate initial stock transports and
elimination of inter company transactions etc...
Afzal Page 10
SAP FICO
Country : IN
Currency : INR
Language : EN
Click on Address Button
Title : Company
Name : AshrafTrading Co
Search Terms
Search Term ½ : Street :
Postal Code/Street:
Country : IN Region : 13
PO Box Address
For Address Screen press the Enter.
Click on object Attributes Button to view Tables Effected
Save -Table is T001
The reason for non assignment of Business areas to company code is the business wants to get
consolidated reporting at Business area level irrespective of company codes.
Business area is one of the organisationalunit which is used for internal reporting purpose.
The business area mapping with geographical level always we done at plant level or Branch
Offices.
Step 05 - Define Functional Areas: (OKBD) – This view is obsolete (Out dated)
Functional areas one of the organizational unit in FI used to classify the expenses of an
organisation into functional areas to meet the needs of cost of sales accounting.
Functional areas are sales, production, marketing, administrating, research & development
etc...
Afzal Page 11
SAP FICO
All the conversions related to Financial year will be maintained under Fiscal year variant.
Types of Fiscal Year:
I. Calendar year (January to December)
II. Non-Calendar year
April to March
October to September
Afzal Page 12
SAP FICO
July to June
A fiscal year should normally consists of 12 regular periods and maximum of 4 special
periods. This periods are called as virtual periods.
Special Periods:
In SAP we can additionally maintain Four Special periods (maximum) to meet year-end
closing activities of the Business.
These are virtual periods and any posting done using this special periods will get updated to
the last period of (Normal) your fiscal year variant.
Special periods will be identified with 13 to 16 periods.
Conversion of calendar periods to non-calendar periods:
Calendar No.of Days SAP FY SAP FY SAP FY
month Periods April – Periods Oct – Periods July –
March Sept June
January 31 10 4 7
February 28 11 5 8
March 31 12 6 9
April 30 1 7 10
May 31 2 8 11
June 30 3 9 12
July 31 4 10 1
August 31 5 11 2
September 30 6 12 3
October 31 7 1 4
November 30 8 2 5
December 31 9 3 6
Year Shift : +1 for Previous Periods 0 for Current Period -1 for Future Periods In
SAP the system will not take 2years as financial year. Then we will take which year has maximum
months has financial year.
Afzal Page 13
SAP FICO
8 31 5 0
9 30 6 0
10 31 7 0
11 30 8 0
12 31 9 0
System will Display warning messages ignore the warning messages by pressing Enter.
Company Code:
Assign Fiscal year Variant: TR
Save Table is T001
Afzal Page 14
SAP FICO
The Factory Calendar used to maintain Holiday calendar and Public holidays. It will be used
by FI, MM, SD and HR modules.
Afzal Page 15
SAP FICO
The periods open and close will be controlled along with the Account type.
Account Type: In SAP Account Types are used to Identify and control nature of Business
transactions.
S: General Ledgers
A: Assets
D: Customers
K: Vendors
M: Materials
+: All
Step1: Define Posting period variant (OBBO)
Path: SPROFA(NEW) FA GLOBALSETTINGS LEDGERSFISCAL YEAR AND POSTING
PERIODSPOSTING PERIODS DEFINE VARIANTS FOR POSTING PERIODS
Variant Name
New Entries APPLEBL Posting Period Variant
Save it
Own Request
Table is: T001
Step2: Assign Variants to Company Code (OBBP)
Same Path
Position
Company Code:
Variant:
Save it.
Step 3: Open and Close Posting Periods (OB52)
Same Path
New Entries
Afzal Page 16
SAP FICO
FSTV(Field status variant) Consists of n. No of Field status groups. Each group consists
common 80 fields.
Under this group fields will be maintain with below statuses.
1. Suppress
2. Require
3. Optional
4. Display
These field status groups will be maintain according to the Nature of GL Accounts.
Ex. G003 – Material Consumption Accounts
This group will be assign to the GL Accounts which are in Nature of material consumption
Accounts.
Ex. Raw Material Consumption, packing material consumption etc...
For G003 the fields related to materials management will be maintained with Status ‘optional’.
G005 Bank Accounts
This group will be assign the GL Accounts belongs to Bank Accounts.
Class 15
The field status variant consists of n.no of Field status groups. All the groups commonly
consists of 80 fields. According to the nature of GL Accounts these fields will be maintained with
below Status.
Support
Require
Optional
Note 1.While creation of GL Accounts we must assign the field status group to the GL Account.
Hence while posting Business transactions system will validate the status of the fields against that
group and accordingly the respective fields will get populated.
Note. 2 Standard SAP recommended only to copy field status variant from the existing variants
0001 OR 1000.
Define Field Status Variant (OBC4)
Path: SPROFA (NEW)FA GLOBAL SETTINGS (NEW)LEDGERSFIELDSDEFINE
STATUS VARIANTS
Select the variant 1000
Click on Copy as Button
Change the field status to
Description: FSTV for APPLE Group
Press Enter
Select Copy all Button
The message is Number of 47 Dependent entries copied
Select the variant:
Double click on Field Status Groups
All the groups were copied
Save it
Table is T004V.
Afzal Page 17
SAP FICO
Save it.
The table is T001.
Tolerance Groups for Employees or Users.
Tolerance are used to maintain upper limits for below transactions. That the user can
post.
1. Upper limit for amount that an user can post to a document.
2. Upper limit for line item amount
3. Maximum cash discount that an user can grant or take
4. Maximum allowed payment difference gain or loss
Null Tolerance Groups
Tolerance group always maintained at company code level. If any tolerance group
maintain without providing group number or value is called as Null Tolerance group.
The properties maintained under this groups are by default applicable to all the users
authorized for this company code.
In case of tolerance group with number business has to expressively assign the
tolerance group to the respective users.
Define Tolerance Groups for Employees (OBA4)
Path: SPROFA (NEW)FAGBDOCUMENTTOLERANCE GROUPSDEFINE
TOLERANCE GROUPS FOR EMPLOYEES
New Entries
Group:
Company Code:
Currency: INR
Upper Limits for Posting Procedures
Amount per Document: 999999999999
Amount per Open Item Account item: 9999999999
Cash Discount for Line Item: 10%
Permitted Payment Difference
Amount Percent Cash Discount Adj to
Revenue 10/-
Expense 10/-
Save it.
Class 16
Afzal Page 18
SAP FICO
Afzal Page 19
SAP FICO
Charts of Accounts:Charts of Account (COA) is list of GL A/C. We will control or maintain the
parameters related to GL accounts creation at COA level.
There are 3 types of COA’s can be used in SAP.
a. Operative chart of accounts - INDIAN
Afzal Page 20
SAP FICO
Class: 19
Define Account Group (OBD4)
Path: SPROGL A/C (NEW)MASTER DATA GL A/CPREPARATIONSDEFINE
ACCOUNT GROUP
Grouping of GL A/C’s according to its nature. The account group controls
The number ranges of your GL Accounts
Controls field status of GL Masters
Field Status
Afzal Page 21
SAP FICO
Save it.
Table is T077S
Class: 20
Note: there is a tight integration between Operative chart of account, company code and Account
Groups for creation of GL Accounts.
Define Retained Earnings Account: (OB53)
Afzal Page 22
SAP FICO
Retained Earnings A/C is a nature of reserves GL A/C. Which captures the previous year
carry forward profit and loss result in the current year.
Note: We must maintain this GL A/C before creation of other GL A/C
According to the Business requirements we can define one or two Retained Earning A/C’s
Path: SPROFA (NEW)GL A/C (NEW)MASTER DATAGL
A/CPREPARATIONSDEFINE RETAINED EARNINGS A/C
Chart of Accounts:
Transaction : BIL (Balance Carry Froward)
Account Assignment
P&L Statement Account
A 100100
Save it.
The message is Account 100100 not created in COA
Press Enter
Save in your Request.
Assignment of Tax Procedure to Country India: (OBBG)
Tax procedure consists of the calculation parameters of taxes against particular country.
In India the below taxes will be calculated.
1. Excise Duties (Cenvat)
2. Tax on Sales or Purchase
a. VAT
b. CST
3. Custom Duties
4. TDS (Tax Deducted at Source)
In SAP TDS will be called as with holding taxes.
The above components are Taxations we follow in SAP against country India is called as CIN.
CIN stands for Country India Version.
Note: In detailed Taxation will be covered during AR Module. Now we are just assigning standard
Tax procedure to Country India.
Path: SPRO FA (NEW)FAGS (NEW)TAX ON SALES OR PURCHASE BASIC
SETTINGS ASSIGN COUNTRY TO CALCULATION PROCEDURE
Position
Country : IN
Cty Name Procedure
IN INDIA TAXINN
Press F4 for Tax Procedures
Save it.
Enter (or) Maintain Global Parameters: (OBY6)
Global parameters are used to maintained or view the parameters maintained against a company
code.
Path: SPROFA (NEW)FAGS (NEW) GLOBAL PARAMETERS FOR COMPANY CODE
ENTER GLOBAL PARAMETERS
POSITION
Double click on Company Code:
COA:
Company: TR10
Credit Control Area: TR10 Fiscal Year Variant: 95
Field status variant:
Posting Period Variant:
Other Control indicators at Company Code level
Maximum Exchange rate deviation: 10%
Business area Financial Statement
Select this indicator only in case the Business wants to Generate internal financial
statements at Business area level.
Afzal Page 23
SAP FICO
If this indicator selected system will make sure the availability of Business area field ready to input
while posting of transactions from MM, SD and Controlling Modules.
Select Propose Fiscal Year
If this Indicator is selected the current fiscal year will get defaulted for Display and change
transactions.
Note: This indicator must be selected with the company codes which are maintained with year
dependent document number ranges.
Select Define default Value Date
Value date will be used as base for Bank Transactions and interest calculation settings.
If this indicator selected system date as value date while posting of line items.
Click on Additional Data
Name Parameter Value
Detail Tax Entry with MIRO:
TDS No. : TDS1234
PAN No. : PAN12345
Click on Back Arrow Button
Save it.
Class 21
Master data for GL:The Day to Day Business transactions (Transactional Data) will get posted with
the base of Master data. Master data will be used as reference for all the reporting and the
transactional figures will get stored under respective master data.
Example for Master Data: GL A/C’s, Customer and Vendors A/C, Assets, Bank keys and Cost
Centres etc...
For Master data there will be no TR generated. This Data must be maintained against
the respective servers. It can be either manually or upload from legacy system or excel file to SAP
using upload methods.
Ex: LSMW (Legacy System Migration Work Bench)
BDC (Batch Data Conversion)
Creation of GL Masters or Accounts:
GL A/C’s are one of the primary master data which captures all the financial transactions,
financial reporting also done through GL A/C’s.
GL A/C creation will be controlled majorly by below parameters.
1. Chart of Accounts
2. Company Code
3. Account Group
The GL A/C creation always dependent on the relationship between Chart of Accounts and
Company Code. If same Chart of A/C assign to multiple Company Codes one GL A/C number can
be used across the Company Codes.
The GL A/C master will be maintained at Chart of Account level and Company Code Level.
Afzal Page 24
SAP FICO
Chart of Account data will remains same across the company codes.
Ex: A/C groups, GL account Type, GL Description, Trading Partners etc...
Company code data can be changed according to the company code requirements or
business requirements.
Ex: Currency, Tax Codes, Field status group, reconciliation A/C’s etc...
Create GL A/C’s (Share Capital)
The GL A/C can be created in following ways.
1. Only in Chart of Accounts
2. Extend GL A/C to Company Code
3. Centrally (COA + Company Code)
Path: ACCOUNTINGFAGENERAL LEDGERMASTER RECORDS GL A/C’S
INDIVIDUAL PROCESSING FSP0-IN CHART OF ACCOUNTS
Note: While creation of GL A/C’s refer A/C Groups for GL A/C Number
GL Account: 100000
Chart of Account:
Click on Create Button
Under Tab
Type/Description
Control in COA
Account Group: Share Capital
P&L Statement A/C
Select Balance Sheet A/C
Description
Short Text: Eqty Share Capital
GL A/C Long Text: Equity Share Capital Account
Consolidation Data in COA
Trading Partner
Trading Partner: It is the ID of subjected companies with whom we are dealing for Business
transactions (Inter Company Transactions). Trading Partners will be used for consolidation of
Multiple company code transactions and elimination of Inter Company Business Transactions.
Under Tab
Key word Translation
Key word in COA
Language Keyword
Afzal Page 25
SAP FICO
This indicator must be selected only for Balance sheet GL A/C’s except below nature GL
A/C’s.
GL A/C’s maintained A/C Currency other than company code currency
For Reconciliation A/C type GL A/C’s
Select Line Item Display
Selection of this indicator the Business can view in detailed itemised report on GL A/C’s.
Sort Key: 001 (Posting Date)
While posting of Business transactions to this GL A/C the value of the sort key will get
updated to the assignment field. This assignment field will be used as base for sorting of GL line
item reports.
Create Bank Interest Tab
Field Status Group: G001
While posting of transactions to this GL A/C’s System will check the field status of the group
assign to this GL A/C’s and populate the respective fields while posting.
Save itTable is SKB1.
Create GL Account Centrally: (FS00)
Cash in Hand A/C
Same path
To check the A/C Group T- Code is – OBD4
The A/C Group is Cash & Bank – 200400
GL A/C No. 200400
Company Code:
Click on Create Button
Type or Description
A/C Group: cash and Bank
Select Balance Sheet A/C
Description
Text: Cash in Hand A/c
Text: Cash in Hand A/c
Control Data
Account currency: INR
select only Balances in Local Currency
Select Line Item Display
Sort Key: 001
Create/Bank Interest
Field Status Group: G001
Select Relevant to Cash Flow Button
Select this indicator for the GL A/C’s which are relevant to cash flow. System will determine
that this GL A/C’s are relevant to payments and receipts.
Ex: Bank and Cash A/C’s, Bank charges A/C’s, Check clearing A/C’s, the clearing A/C’s used for
payments.
Save it.
Afzal Page 26
SAP FICO
Afzal Page 27
SAP FICO
Class 23
System will be shown error message No Item category assign to GL A/C 200400
Analysis is we are using ECC6.0 version. System will automatically activated document
shifting against the company code.
Document Splitting to use generate Financial Statement. Internally we archive 0 balances
field reporting.
Note: in order to reefing the issue temporarily we are deactivating document splitting.
Path: SPROFA NEWGL NEWBUSINESS TRANSACTIONSDOCUMENT
SPLITTINGACTIVATE DOCUMENT SPLITTING
Double Click on Deactivation for Company Code
Position
Company Code:
Select Inactive Check Box
Save it.
After this configuration step again Share Capital Receipt Journal Voucher
Document Number 100000 was posted in Company Code:
Tables
Document Header Data: BKPF
Document Line Item: BSEG
View A/C Document: (FB03)
Path: A/CFAGLDOCUMENTDISPLAY – FB03
Document Number: 100000
Company Code:
Fiscal Year: 2013
Press Enter
To View additional Header Details
Click on Display Document Header Button
We will get additional details.
Entered By:
Entry Date:
Time of Entry:
Document Type:
Change Accounting Document:
Afzal Page 28
SAP FICO
Once Accounting Document got posted one cannot change below fields.
GL Account Number
Amounts
Additional A/C assignments
In case any changes require to above fields we must reverse the document and post a fresh
entry with correct values.
The following fields can be changes
Value Date
Assignments
Text
Change Document (FB02)
Same path:
Doc No. 100000
Company Code:
Fiscal Year: 2013
Press Enter
Double click on Cash in Hand line item change the text to Share Capital for AP Andhra Pradesh
Click on Next arrow Button (Shift + F7)
Give the text as “+”
Document
Save
Message is changes have been Saved.
Testing of Reversal Scenario
The accounting document must be reversed in case of wrong header details. GL A/C,
Amounts and Additional A/C assignments. While reversing of Accounting document we must refer
reversal reason code.
Reversal Reason Code: the reason codes are used to identify the reason for reversal and it also
controls below parameters.
1. Alternative posting date is allowed
2. Negative reversals is allowed or not
Note: standard SAP provided n no. Of reason codes which can be used by reversing to meet our
business requirements we can define new reason codes as well.
Define Reason Code:
SPROFA NEWGL A/C NEW BUSINESS TRANSACTIONSADJUSTMENT
POSTING/REVERSALREASONS FOR REVERSAL
New Entries
Reason Text Negative Posting Alternative Posting
Date
9A Wrong GL A/C
9B Wrong Business Area
9C Wrong Amount
9D Wrong Document Header
Save it.
Permit Negative Postings:
Company Code Company Name City Negative Posting
Permitted
APPLE Group Mumbai
Save it.
Alternative posting Date:
If this indicator was selected system will allows you to reverse the document with alternative
date which is different than your original accounting document.
Ex: Document posting date is 22-04-2013 reversed date is 23-04-2013
Afzal Page 29
SAP FICO
Class 24
If this indicator was activated system reduces the transactional figures from the same side of
the GL A/C instead of increasing opposite side Balances.
Testing of Reversals:
With Wrong GL A/C (F-01)
Doc Date: 24-04-2013
Type: SA
Company Code:
Posting Date: 24-04-2013
Posting Key: 40
Press Enter
GL A/C: 400400 press Enter
Amount: 1000
Business Area: 95S1
Text: Maintenance Expenses
Posting Key: 50
A/C: *
Text: +
DocumentSimulatesave it
Document NO. 100001
View GL A/C Balances. (FAGLB03 OR FS10N)
Path: A/CFAGLACCOUNTDISPLAY BALANCES NEW
Account Number: 400401
Company Code:
Fiscal Year: 2013
Execute
The message is No data found for fiscal year 2013.
User that entry might posted to wrong GL A/C to get confirmation he wants to check A/C entry.
Hence Display Document (FB-03)
Doc No: 100001
Company Code:
Fiscal Year: 2013
Entry is
Rent A/c Dr
To Cash A/C
User realized maintenance posted to wrong GL A/C Rent(400400).
View GL Balances for Rent (FAGLB03/FS10N)
GL A/C: 400400
Co code:
Fiscal Year: 2013
Execute
Period Debit Credit Balance Cumulative
Balance
Balance carry forward
1 1000 1000 1000
Afzal Page 30
SAP FICO
The reason is after posting A/C entry one cannot change GL A/C hence reverse the entry
and post correct document.
For Reversal A/C Document (FB08)
Path: ACCOUNTINGFAGLDOCUMENTREVERSEINDIVIDUAL REVERSAL
Doc Number: 100001
Company code:
Fiscal Year: 2013
Specifications for Reverse Posting
Reversal Reason: 9A
Posting Date: 25-04-2013 press Enter
The Error Message
Reversal reason 9A only posting date 24-04-2013.
Reason alternative posting date check box was not maintained for reason code 9A
Remove the date
System will post the reverse Doc with the Date 24-04-2013
DocumentPost or Save
Document Number is 100002.
View Reversal Document FB03 or Document Display
A/C Entry is
Cash in Hand A/C Dr
To Rent A/C
Click on Doc Header Button
Reverse Doc for 100001
Double click on 100001
Click on Doc Header
Reversed By: 100002
Reversal Reason: 9A
View A/C Balances (FS10N)
GL A/C: 400400
Co Code:
Execute
Post Maintenance Entry with Rs. 1000/-.
F-02
Enjoy Screen (FB50)
A/CFAGLPOSTINGENTER GL A/C DOCUMENT
Click on Switch Company Code
Company Code: press Enter
Basic Data
Doc Date: 24-04-2013
Currency: INR
GL A/C: 400401
Select Debit
Amount: 10000
Text: maintenance Charges
Business Area: 95S1
GL A/C: 200400
Credit
Amount: *
Text: +
Note: user wrongly posting entry with 10000/- instead of Rs. 10000/-.
DocumentSimulate & Save
Doc No. 100003.
Afzal Page 31
SAP FICO
Co Code:
Fiscal Year: 2013
Execute
Debit Balance of Rs. 10000/-.
user realized Amount Rs. 10,000/- posted wrongly Hence reverse the document.
FB08
Doc Number: 100003
Co Code:
Fiscal Year: 2013
Reversal Reason: 9C
Save it.
Doc 100004 was posted.
View A/C Balance (FS10N)
GL A/C: 400401
Company Code:
Execute
Output is the Debit balance 10000/- removed from GL A/C instead of increasing credit
balance.
Class: 25
Foreign Currency Transactions
The transactions posted other than company code currency are called as Foreign Currency
transactions. To meet statutory reporting requirements like Financial statements. All foreign
currency transactions must be valuated or translated to Local currency or company code currency.
In SAP we use Exchange Rate Type for translation of Foreign currency to local currency
while posting of a document we refer following currencies.
Document currency or Transaction currency: The currency which is used to post the
document is called as Document currency or transaction currency.
Local Currency: Currency of the company code is called as local currency. If document
currency is other than company code currency the transaction must be translated into local
currency.
Important terms in Foreign Currency Transactions
1. Exchange Rate Type: during foreign currency transactions exchange rate type is key
indicator which is used for
a. To maintain the relationship between two currencies
b. Conversion factors of those currencies
c. Maintain exchange rates date wise
2. Conversion Factors: With reference to Exchange rate types we maintain relations between
two currencies and their conversion factors
3. Exchange Rates: Exchange Rates will be maintained with reference to exchange rate type
date wisely while posting of business transactions and Foreign currency system will refer
this exchange rate type and rate maintained in the table with the translation date and
converts foreign currency into local currency.
Configuration Steps
1. Maintain Exchange Rate Type (OB07)
SPROSAP NET WEAVERGENERAL SETTINGSCURRENCIESCHECK EXCHANGE
RATE TYPES
According to the nature of business transactions we maintain multiple exchange rate types.
Below are standard exchange rate types provided by the SAP.
Afzal Page 32
SAP FICO
Afzal Page 33
SAP FICO
Posting key: 40
Account: 200400
Press Enter
Amount: 100$
Amount in local currency: 5300/-
Business Area: 95S1
Text: FC transaction
Posting Key: 50
Account: 100300
Amount: *
Text: +
Simulate
To change currency press Display Currency Button to shift amounts from local currency and
document currency
Save it.
Note: while posting of transactions in foreign currency initially system will check any default
exchange rate type maintained to the document type if not found automatically search for exchange
rates for the rate type ‘M’.
Class 26
Assignment of Default Exchange Rate Type in the document type (OBA7)
Doc Type: SA
Default Values
Exchange rate type for foreign currency Docs: 9M
Save it.
Post Foreign currency transaction
Date: 26.04.2013
Currency: USD
Posting Key: 40
Account: 200400
Press Enter
Amount: 10$
Business Area: 95S1
System validated document type SA and picked up the exchange rate type ‘9M’ and
according to the translation date in the document extracted the value of “47” from exchange rate
table.
Posting key: 50
Account: 100300
Amount: *
Text: +
Simulate
Save it.
Maintain Exchange Rate Manually: (F-02)
Doc date: 26.04.2013
Currency/Rate: USD 57
The warning message Exchange Rate 57/- deviated from table rate 47/- by 21.28%.against
the company code maximum exchange rate deviation maintained with 10%. Hence any exchange
rate deviation between exchange rate table and manual exchange rate with through warning
message.
Posting of Foreign currency other than USD (F-02)
Date: 26.04.2013
Currency: SAR
Afzal Page 34
SAP FICO
Press Enter
The error is conversion factors missing for rate type 9M currency SARINR.
Now maintain conversion factors (OBBS)
Select Yes
NEW ENTRIES
Exchange From To Valid from Ratio from Ratio to
rate
9M SAR INR 01.04.2013 1 1
Save it.
Maintain Exchange Rates (OB08)
NEW ENTRIES
Exchange Valid from From Currency Dir Quotation To Currency
Rates
9M 01.04.2013 SAR 17 INR
Save it.
Post Data (F-02)
Date: 26.04.2013
Type: SA
Currency: SAR
Posting key: 40
Account: 200400
Press Enter
Amount: 1000 SAR
Amount in Local currency: 17000/- INR
Save it.
Group Currency:
Currency used for consolidated reporting purpose. This currency will be maintained at client
level. If business wants to get the consolidated report at Group Currency level are must activated
group currency at each company code.
Hence the transactions posted at company code level automatically get translated or posted
parallel at Group Currency as well.
Class 27
Identifying of Group Currency Indicator (SCC4)
Group currency can be identify by going through the client settings. The client currency is
terms as Group currency.
Double click on Client 800
The currency is EUR
Maintain Additional Currencies against Company Code (Parallel Currency) (OB22)
The transactions posted against company code can parallel update additionally with two
currencies. They are
Groups currency
Company currency
Hard currency
Index Based currency
Press NEW ENTRIES
Company Code:
System automatically populates 1st local currency
Currency Type: 10 Company code currency
2nd Local currency
Currency Type: 30 Group Currency
40 Hard Currency
Afzal Page 35
SAP FICO
50 index-based currency
60 global company currency
Valuation: 0 Legal Valuation (1 – Group Valuation, 2 – Profit Centre Valuation)
Currency: EUR
Exchange Rate Type: M
Source Currency: 2 Translation taking first local currency as basis
1 Translation taking transaction currency as basis
Translation Date Type: 3 Translation Date (1 – Document Date, 2 – Posting Date)
Save it.
Save it.
Testing of Group Currency (F-02)
Doc Date: 27.04.2013
Company code:
Currency: INR
Posting Key: 40
A/C: 400401
Press Enter
Amount: 10000/-
Business Area: 95S1
Text: Testing of group currency
Posting Key: 50
A/C: 200400
Press Enter
Amount: *
Text: +
Click on Document Over View Button (Shift + F2)
Click on Display Currency
Select Group Currency
Press Enter
Amount: 140EUR Save it.
Posting of Foreign currency Transaction
Doc Date: 27.04.2013
Currency: USD
Posting Key: 40
A/C: 400401
Press Enter
Amount: 100$
Amount in Local Currency: 4,700/-INR
Afzal Page 36
SAP FICO
Posting key: 50
Parking Document
Parked Documents are subjected to approvals. The document parked by the user will be
sent to authorised person for cross check or verification. The person can be accept or reject the
document.
Parked Documents are called as Preliminary documents and No Transactional Data will get
updated or posted to GL Account till the parked document was accepted and posted by the user or
by authorised person.
The parked functionality can be handled
Manually
Through Work Flow
Class 28
Parking Functionality through Manual Concept
When the user or Accountant parked the document and send the document information
through mail to the authorised user for validating the correctness. The authoriseduser validate the
document and he can approve or reject the document. This information again sent to the user
manually by mail.
Activate Users in SAP (SU01)
To view list of users available in the system
Place the cursor on User and Press F4
Press Enter
Select the user SAP
Click on change password
Give New password
Press enter
Parking of Document by SAP user (FV50)
Path: A/CFAGLPOSTINGEDIT OR PARK GL DOCUMENT
Company Code:
Doc Date: 29.04.2013
GL A/C: 400400
Debit
Amount: 1000
Text: Testing of Park Document
Business Area: 95S1
GL A/C: 200400
Credit
Amount: 10000
Text: +
DocumentPark
Document 100009 was parked.
Afzal Page 37
SAP FICO
View inbox
SAPMENUOFFICEWORK PLACE-SBWP
Press enter
Expand Inbox
The observation of User SAP is Document 100009 posted incorrectly with wrong amounts
and hence sending a manual mail rejecting the document and for corrections.
Class 29
Posting Functionality through Work Flow
Work Flow is the feature used to send the information automatically when the scenario
executed. Work flow will be developed by ABAP consultants. The work flow can be extensively
used in case of authorisations and approval process.
Steps or Process of Parking in case of Workflow
Initiator parks the document – FV50
Workflow will get triggered automatically once the initiator parks the document
A mail will automatically triggered to Authorized person or Finance officer with park
document information
Automatically if he opens the screen system will provide two options Accept or Reject
Afzal Page 38
SAP FICO
If he clicks on Reject Button system automatically calls up transaction – FBV6 and a mail will
triggered to initiator with rejection reason
If he accept the document transaction – FBV0 will be triggered and again mail will be sent to
initiator with comments
T-Code for Workflow creation or maintain SWDD
Recurring Documents
Recurring Documents are called as template documents and periodically accounting entries
will be generated with reference to template document. Based on the frequency maintain in the
recurring document we will execute and post Accounting Entries. All recurring nature transactions
will be maintain under this document with the respective amounts and additional account
assignments. These documents will save the time of the users for month end closing activities.
Creation of GL A/C (FS00)
GL Account: 400402
Create
Type/Description
A/C Group: Administration expenses
Select P&L Statement Account
Text: Stationary Expenses
Select Line Item Display
Sort Key: 001
Field Status Group: G001
Save it.
Define Number Ranges for Recurring Document (FBN1)
Recurring Documents will use same document type but Number range will be “X1”.
Company Code:
Click on Change Intervals
Click on Insert Intervals
No Year From Number To Number
X1 2013 1 9999
Save it
Define Recurring Document Templates (FBD1)
Note: These Recurring Documents will be maintained by the Business according to their
requirements.
Path:ACCOUNTINGFAGLREFERENCE DOCUMENTSFBD1-RECURRING DOCUMENT
Company code:
First Run on: 01.04.2013
Last Run on: 31.12.9999
Intervals in Months: 01 Per Month
Run Date: 5
Document Type: SA
Currency: INR
Posting Key: 40
Account: 400400
Press Enter
Amount: 10,000/-
Business Area: 95S1
Text: Rent
Posting Key: 40
Account: 400401
Press Enter
Amount: 5000/-
Text: +
Posting Key: 40
Account: 400402
Afzal Page 39
SAP FICO
Press Enter
Amount: 1000/-
Posting Key: 50
Account: 200400
Press Enter
Amount: 16,000/-
Text: +
Save it.
Document 1 was stored in Company Code
Execution of Recurring Documents
The Recurring Documents will be periodically executed in order to generate financial
accounting entries.
Class 30
While execution of Recurring Document system will generate Batch Input Session for
processing of Accounting Document in background instead of online.
Batch Input Session (BTIS)
Batch Input Session is the feature provided by the SAP to post documents in background.
When business needs to execute or post or process multiple transactions we use batch input
sessions. The BTIS consists of the parameters related to posting of transactions and we can view
Log related to the execution of BTIS. If transactions consists of errors and again BTIS can be
executed.
Path: A/CFAGLPERIODIC PROCESSINGRECURRING ENTRIESEXECUTE – F.14
Company Code:
Fiscal Year: 2013
Settlement period: 01.04.2013 to 30.04.2013
Batch Input Session Name: SAPF120_
Select Hold Processed Session
Execute
Message is Session SAPF120_ was created.
Note: The BTIS consists of the data transferred from the recurring documents. If we process BTIS
the Recurring data will be posted to Accounts.
Process Batch Input Session (SM35)
SYSTEM MENUSERVICESBATCH INPUTSESSIONS
Select the Session SAPF120_0510
Press Process Button
Processing Mode
Select Process/Foreground
If this option selected all the screens will be displayed while processing.
Press Enter
Document Date: 05.04.2013
Next Run: 05.05.2013
Document No. 1
Keep on press Enter till you get the message processing of BTIS completed.
Click on Session Overview
Double Click on your Session
Log Created
Document No. 100000
Afzal Page 40
SAP FICO
Class 31
Afzal Page 41
SAP FICO
Afzal Page 42
SAP FICO
Afzal Page 43
SAP FICO
Afzal Page 44
SAP FICO
One of the option of partial payment but Accounting treatment will be different.
Features of Residual
While doing the partial payment using residual option system will Reverse Original invoice
amount. Post payment Amount and creates New Open Item for the Balance amount to be
cleared.
There will be no connectivity or relation between original invoice and partial payment
Testing of Residual (FBL3N Report)
Open item is Rs. 5,000/-
Partial payment using residual option (F-07)
Dt: 06.05.2013
Type: SA
A/C: 200400
Amount: 2,700/-
Text: residual
GL: 100400
Residual Items
Activate the item 5,000/-
Double click on Residual Item (New Open Item)
2,300/-
Simulate
Insurance payable A/C Dr 5,000/-
To Cash A/C 2,700/-
To Insurance Payable A/C 2,300/-
Class 33 0
Foreign Currency Revaluation
Revaluation of Foreign Currency transactions in order to know Exchange Gain or Loss is a
statutory requirement. We must revaluate these transactions at item level or Balance level
periodically or yearly.
Creation of GL A/C’s (FS00)
GL: 400510
Group: Financial Expenses
Select P&L Statement account
Text: Exchange Loss
Select Line Item Display
Sort key: 001
Field status Group: G001
Save it.
GL: 300100
Group: Other Income
Select P&L Statement account
Text: Exchange Gain
Save it.
GL: 100900
Afzal Page 45
SAP FICO
Company Code:
Account Group: clearing Accounts
Select Balance Sheet accounts
Text: Clearing Exchange account
Select Only Balances in Local Currency
Select Line Item Display
Sort Key: 001
Save it.
Configuration Steps
Define Valuation Methods
Path: SPROFA(N)GL ACCOUNT PERIODIC PROCESSING VALUATE DEFINE
VALUATION METHODS
New Entries
Method:
Description: Valuation Method Always
Valuation Procedure
Select XAlways Evaluate
Document Type: SA
Exchange Rate Determination
Exchange Rate Type for Debit Balance: M
Exchange Rate Type for Credit balance: M
Determine Exchange Rate Type from Account Balance
If this indicator selected Exchange Rate Type will be identified from GL Balance level.
X Exchange Rate Type from Invoice Reference
X
If you selected this indicator the Exchange Rate Type determine from each invoice
reference and currency combination.
Select option 2
Save it.
Define Valuation Areas
Same path
New Entries
Valuation Valuation Method Currency Type
95 Co. Code Currency
Save it.
Check Assignment of Accounting Principles to Ledger Group
Same path
Identify the Accounting principle assigned to the Ledger Group 0L
Accounting Principle Target Ledger GL
IAS 0L
Assign Valuation Areas and Accounting Principles
Same path
New Entries
Valuation Area Accounting Principle
95 IAS
Save It.
Prepare automatic posting for Foreign Currency Valuation
Path: SPRO FA GL PERIODIC PROCESSING VALUATE FOREIGN CURRENCY
VALUATION PREPARE AUTOMATIC POSTINGS FOR FOREIGN CURRENCY VALUATION
Double click on KDF Exchange rate difference open items GL Accounts
Chart of Accounts:
New Entries
GL A/C: 100400
Currency: INR
Currency Type: 10
Afzal Page 46
SAP FICO
Class 34
Testing of Exchange Gain or Loss
Post Foreign Currency transaction (Loan Receipt at Exchange Rate 40 in USD) (F-02)
Doc Dt. 08.05.2013
Currency: USD Rate: 40
Posting Key: 40
A/C: 200400
Press Enter
Amount: 1000$
Business Area: 95S1
Text: Testing of Foreign Currency Transaction
Posting Key: 50
Account: 100300
Afzal Page 47
SAP FICO
Press Enter
Amount: *
Text: +
Document Simulate
Save it.
Doc no. 100018
Maintain or change Exchange Rate to 48/- with Exchange Rate Type 9M (OB08)
New Entries
Exchange Rate Valid From From Currency Direct To Currency
Quotation
9M 08.05.2013 USD 48 INR
Save it.
Foreign Currency Valuation (New) FAGL_FC_VAL)
Path:ACCOUNTFAGLPERIODIC PROCESSING CLOSING VALUATEFOREIGN
CURRENCY VALUATION
General Data selection
Co. Code:
Valuation Dt. 31.05.2013
Valuation Area: 95
GL Balances
Select Valuate GL Account Balances
GL Account: 100300
Exchange Rate Difference Key:
Execute.
Output:
GL Account: 100300
Loan Amount: 1000$
Old Value: 40,000/-
New Value: 48,000/-
Gain/Loss: 8,000/-
The Exchange Gain or Loss transactions are
FC transaction valuations can be executed periodically or yearly basis in case of periodic execution
relevant to Account Balances must be reversed in the future month.
Class 35
Interest Calculations
Creation of GL Accounts (FS00)
GL Account: 400501
Group: Financial Expenses
Select Profit and Loss Account
Text: Interest Expense or Loss
Select Line Item Display
Sort Key: 001
Field Status Group: G001
Save it.
Afzal Page 48
SAP FICO
GL Account: 300001
Group: Other Income
Select Profit and Loss Account
Text: Interest Gain Account
Select Line Item Display
Sort key: 001
Field Status Group: G001
Save it.
GL Account: 100401
Group: Current Liabilities
Select Balance Sheet Account
Text: Interest Payable Account
Select Only Balances in Local Currency
Select open Item Management
Select Line Item Display
Sort Key: 001
Field Status Group: G001
Save it.
GL Account: 200600
Group: Current Assets
Select Balance Sheet account
Text: Interest Receivable Account
Select Only Balances in Local Currency
Select Line Item Display
Sort Key: 001
Field Status Group: G001
Save it.
GL Account: 100200
Group: Secured loans
Select Balance Sheet account
Text: Loan from Third Party
Select Only Balances in Local Currency
Select Line Item Display
Sort Key: 001
Field Status Group: G001
Save it.
Configuration Steps:
Define Interest indicator or Interest Calculation Types (OB46)
Path: SPRO FA (NEW) GL NEW BUSINESS TRANSACTIONS BANK ACCOUNT
INTEREST CALCULATION INTEREST CALCULATION GLOBAL SETTINGS DEFINE
INTEREST CALCULATION TYPES
New Entries
Interest Indicator Name Interest Calculation Type
95 Balance Interest Indicator S
Save it.
S = Balance interest Calculation
P = Item interest Calculation
Z = Penalty interest Calculation
Prepare Account Balance interest Calculation (OBAA)
Same path;
New Entries
Interest Calculation Indicator: 95
Afzal Page 49
SAP FICO
Period Determination
Interest Calculation Frequency: 01 (1Month)
Interest Determination
Calendar Type: G
Standard SAP delivered below Calendar types
No.of days in year No. of Days in Month
B – Bank Calendar - 360 30
J – French Calendar 365 30
F – French Calendar 360 exact No. of Days in a calendar month
G – Gregorian Calendar 365 Exact No. of Days in a Calendar month
Select Balance Plus Interest
Save it.
Define Reference Interest Rates (OBAC)
Same path till Bank A/C interest Calculation Interest Calculation Define Reference Interest
Rates New Entries
In this step we create indicator for Reference Interest which is used to maintain interest
rates periodically or date wise.
Afzal Page 50
SAP FICO
Class 36
Assignment of Interest Indicator to the Loan Accounts (FS00)
GL Account: 100200
Click on Change Button
Create/Bank Interest
Assign Interest Indicator: 95 Balance Interest Indicator
Save it.
Loan Receipt Entry on 16.04.2013 (F-02)
Doc Dt. 10.05.2013
Posting key: 40
Account: 200400
Press Enter
Amount: 10,000/-
Text: Loan Receipt
Posting Key: 50
Account: 100200
Press Enter
Amount: *
Value Dt: 16.04.2013
Note: interest Calculation will be based on Value Date.
Text: +
Save it.
Calculation interest on Loan from party for the month of April (F.52)
A/C FA GL PERIODIC PROCESSING INTEREST CALCULATION BALANCE
INTEREST CALCULATION
Chart of Account:
Afzal Page 51
SAP FICO
Co. Code:
Calculation period: 01.04.2013 to 30.04.2013
Interest Calculation Indicator: 95
Execute
Loan Amount: 10,000/-
Interest %: 11%
No. of Days for Interest Calculations: 15days
Interest is: 45.21/-
Select Back arrow button
Output Control
Select Additional Balance line
Select Interest Rate Overview
Posting Control
Select Post Interest Settlement
Select Update Master Records
Session Name: RFSZIS00
Posting Date of session: 30.04.2013
Select Hold Process session
All the above selection parameters can be stored under a variant so intern next time when
you execute the transaction we can get the input values and can be modified accordingly.
Click on Save Button
Variant Name:
Meaning: Interest calculation
Click on Save (Variant Saved)
Select Back Arrow Button
Execute the Transaction F.52
Click on Get Variant Button
Execute the Variant Dialog Box
Select your variant
All the selection parameters populated on screen.
Execute
End of the page the message is Batch Input Session Created.
Executed Batch input Session (SM35)
Select and process your session in Process/Foreground
Keep on press Enter
System update the GL Master record with key date of last Interest calculation 30.04.2013
The date of last interest Run: 10.05.2013
Double click on Processed Batch Input Session
Go to Log
Doc No. 100024
View Accounting Document (FB03)
Doc No. 100024
Co. Code:
Fiscal Year: 2013
Interest Expense or Loss A/C Dr
To Interest Payable A/C
Execute Interest for the Month of May (F.52)
Click on Get variant Button
Variant:
Execute
Calculation period: 01.05.2013 to 31.05.2013
4days 11%
27 days 10.80%
Total Interest: 91.94/-
Batch Input Session Created.
Afzal Page 52
SAP FICO
Afzal Page 53
SAP FICO
i. Excise Duties
ii. VAT
iii. CST
iv. Services taxes
v. Custom Duties
vi. TDS.
Configuration Steps
Create GL Accounts (FS00)
GL Account: 100700
Account Group: Sundry Creditors
Select Balance Sheet Account
Text: Domestic payables
Currency: INR
Do not select Only Balances in Local Currency
Reconciliation Account for Account Type: Vendors
Select Line Item Display
Sort Key: 012 (Vendor Number)
Field Status Group: G067 (Reconciliation A/C)
Save it.
GL A/C: 400100
Group: Payroll Expenses
Select P&L Account
Text: Professional Service Charges
Select Line Item Display
Sort Key: 001
Field Status Group: G001
Save it.
Afzal Page 54
SAP FICO
Configuration Steps
Define Vendor Account Groups (OBD3)
SPROFA (NEW)A/C RECEIVABEL & A/C PAYABLEVENDOR ACCOUNTSMASTER
DATAPREPARATIONS FOR CREATING VENDOR MASTER DATA DEFINE A/C GROUPS
WITH SCREEN LAYOUT (VENDORS) New Entries
Account Group:
Name: Domestic Vendor Group
Field Status
Double Click on Company Code Data
Double Click on A/C Management
Select Reconciliation A/C as Required Entry
While Creation of Vendor Master Reconciliation A/C will be the Mandatory Entry.
Save it. Create Request AP Configuration Settings.
Next Entry button
A/C Group: 9511
Name: Foreign Vendor Group
Maintain Reconciliation A/C has Required Field.
Save it.
Next Entry Button
A/C Group: 9512
Name: Affiliated Vendor Group
Save it.
Next Entry Button
A/C Group: 9513
Name: Employee Vendor Group
Save it
Next Entry Button
A/C Group: 9514
Name: Service Vendor Group
Save it.
Next Entry Button
A/C Group: 9515
Name: One Time Vendor Group
Select One Time Account
Reconciliation Account as Required Entry
Save it.
Create Number Ranges for Vendor A/C (XKN1)
Note: Vendor Master Number Ranges will be maintain at Client Level. Which indicates same
Vendor Master can be used in Multiple Company Codes
Change Intervals
Insert intervals DOMESTIC PAYABLE
No From No To No
T1 20611 20619
nsert Button
Insert Intervals FOREIGN PAYABLE
No From No To No
T2 20620 20629
Insert Intervals
No From No To No
T3 20630 20639
Insert Intervals
No From No To No
T4 20640 20649
Afzal Page 55
SAP FICO
Insert Intervals
No From No To No
T5 20650 20659
Insert Intervals ONE TIME PAYABLE
No From No To No
T6 20660 20669
Save it.
Ignore the message & press Enter
Save it.
Class 39
Define Tolerance for Customer and Vendors OBA3
Path: SPROFA (NEW)AR & AP BUSINESS TRANSACTIONS OUTGOING PAYMENT
MANUAL OUTGOING PAYMENTS DEFINE TOLERANCE (VENDORS)
New Entries
Co. Code:
Tolerance Group: APPLE Group Tolerance
Permitted Payment Differences
Amount Percent
Gain 10 1% EX 10000 9990
Loss 10 1%
Save it.
Define Document Types & Number Ranges for Vendor Transactions (OBA7)
Document Type Description Number Range
KA Transfers and Reserves 17
KG Vendor Credit Memo 19
KR Vendor Invoice 17
KZ Vendor Payment 15
Afzal Page 56
SAP FICO
Afzal Page 57
SAP FICO
Bank key is the unique identity for any Bank which holds the Bank Address details
Click on Bank Data
Bank Name: ICICI
Region: 10
Bank Branch: JP Nagar, Bangalore
Press Enter
Next Screen
Screen 4Account Information
Reconciliation Account: 100703 Employee Payables
Sort Key: 001
Cash Management Group: A5 (Personal Cost)
Select Next Screen
Screen 5Payment Transactions
Select Check Double Invoice Button
If any invoice posted with the same reference key system will through warning message.
Select Next Screen
Screen 6Correspondence
Save it.
Vendor No. 400700 was created in Co. Code
Date: 27.05.2013
Doc Type: KR
Co. Code:
Posting key: 31
Account: 400700
Press Enter
GL Account: 100703
Amount: 50,000/-
Text: Salary Payable
Posting Key: 40
Account: 400101
Press Enter
Amount: *
Text: +
Document Simulate
Save it.
Doc No. 1900000
GL Account creation
GL Account: 400101
Group: Payroll Expense
Select P&L Account
Text: Salaries Account
Select Line Item Display
Sort Key: 001
FSTG: G001
Save it.
Afzal Page 58
SAP FICO
Class 40
View GL A/C Balances (FS10N)
Accounting Financial Accounts Accounts Payable Accounts Display Balances
GL Account: 100703
Co. Code:
Execute
Credit balance of 50,000/- updated to GL A/C
Create Vendor Master (XK01)
Co. Code:
A/C Group: 9513
Address Screen
Title: Mr.
Name: Somayajulu K
Search Term: Somk
Country: IN
Region: 10
Payment Transactions
Country: IN
Bank Key: HDFC
Bank A/C: 00098765
A/C Holder: Somayajulu
Click on Bank Data
Bank Name: HDFC
Bank Branch: Bangalore
Accounting Information Accounting Screen
Recon A/C: 100703
Cash Management Group: A5
Select Check Double Invoice
Save it. Vendor No. 400705.
Post Salary Payable of 35,000/- against Vendor No. 400705 (F-43)
Doc Date: 28.05.2013 Type: KR
Posting Key: 31
Account: 400705
Press Enter
GL A/C: 100703
Amount: 35000
Text: Salary Payable
Posting Key: 40
Account: 400101
Amount: *
Text: +
Document Simulate
Save it
Doc No. 1900001.
Display GL Balances (FS10N)
GL A/C: 100703
Co. Code:
Execute
Afzal Page 59
SAP FICO
Afzal Page 60
SAP FICO
The payment terms will be assigned to the Vendor Master as per the agreement had with
the vendor.
Note: If Required we can assign the payment terms while posting of Business Transactions
Define Payment Terms (OBB8)
SPROFA (NEW) AR & AP BUSINESS TRANSACTIONS OUTGOIG INVOICES OR
CREDIT MEMOS MAINTAIN TERMS OF PAYMENT
Base Line Date: The date from which system will Payment Terms
The Base Line Date can be a posting date, document date or defaulted to fixed day or a
month.
Create a Payment Term with 15 days due net from the date of posting date.
New Entries
Payment Terms: TR10
Account Type
Select Customer
Select Vendor
Default for Baseline Date
Select posting Date
Payment Terms
Term no. of days
1 15
Save it.
Afzal Page 61
SAP FICO
Afzal Page 62
SAP FICO
Save it.
Define Terms of Payment for Instalment Payment (OBB9
Same Path
New Entries
Terms of Payment Instalment Percent Payment Term
Z950 1 40% Z951
Z950 2 30% Z952
Z950 3 30% Z953
Save it.
Post Invoice (F-43)
Doc Dt: 29.05.2013 Type: KR
Posting key: 31 A/C: 400700
Press Enter
Amount: 10,000/-
Payment Term: Z950
Posting Key: 40 A/C:400101
Press Enter
Amount: *
Text: +
Simulate
Vendor Invoice Splitted according to the payment terms
Item1: 4000/-, Item2: 3,000/-, Item3: 3,000/-
Save it. Doc no. 1900004.
View Line Item Display (FBL1N)
Layout: /Z
4,000/- Due Date is 29.05.2013
3,000/- Due Date is 05.06.2013
3,000/- Due Date is 05.07.2013
Afzal Page 63
SAP FICO
Note: at each change of Bank address we must define it has a New House Bank.
One House Bank can consists of Multiple A/C ID’s
Create GL A/C (FS00)
GL: 200420
A/C: cash & Bank
Select Balance Sheet A/C
Text: STATE BANK OF INDIA Current A/C
Select Only balances in Local Currency
Select Line Item Display
Sort Key: 001
FSTG: G001
Select Relevant to cash flow.
Save it.
GL A/C: 200421
With Template
GL A/C: 200420
Press Enter
Text: STATE BANK OF INDIA Check issue Clearing A/C
Select Open Item Management
Select Line Item Display
Sort Key: 001
Save it.
Define House Banks (FI12)
SPROFA (NEW) BANK ACCOUNTING BANK ACCOUNTS DEFINE HOUSE BANKS
Co. Code:
Note: House Banks are Co. Code dependent.
New Entries
House Bank: 1000
House Bank Data
Bank Country: IN
Bank Key: SBI
Note: Bank Key maintained at Country Level
Create
Bank Name: State Bank of India (Hyderabad)
City: Hyderabad
Double click on Bank Accounts Folder
New Entries
A/C ID: acct1
Description: Current A/C No. 1
Bank A/C Number: 123456789
Currency: INR
GL A/C: 200420
Save it.
Maintain Check Lots (FCHI)
Check lots consists of from and to check no’s issued by the Bank. We can also maintain the
cheques are sequential or non sequentialcheque lot. Business will create check lots on
requirement.
Accounting Fin AccAcc Payable Periodic Processing F110 – Payments
Menu Environment Check Information Number Ranges
Paying Co. Code:
House Bank: 1000
A/C ID: acct1
Click on Change Button
Click on Create
Afzal Page 64
SAP FICO
Lot
Lot Number: 01
Check Number: 000001000
To :000001099
Short Info: Check lot No. 1
Purchase Dt: 01.04.2013
Save it.
Class 43
Testing of Manual Payment by Check
Create New Vendor (XK01)
Co. Code:
A/C Group: 9154
Press Enter
Title: Mr.
Name: Salman Khan
Country: IN
Region: 10
Recon A/C: 100704
Sort Key: 001
Cash Management Group: A1
Save it. Vendor No. 400710
Create GL Master
GL A/C: 400110
Group: Payroll Expense
Select P& L A/C
Text: Professional charges
Select Line Item Display
Sort Key: 001
FSTG: G001
Save it.
Post Vendor Invoice (F-43)
Doc Dt: 31.05.2013 Type: KR
Posting Key: 31 A/C: 400710
Press Enter
Amount: 10,000/-
Text: Professional charges
Posting Key: 40 A/C: 400110
Amount: *
Text: +
Simulate
Save it, Doc No. 1900005
Vendor Business transactions will update below Tables.
BKPF – Accounting Document Header
BSEG – Accounting Document Line Items
Vendor Line Items are subjected to Open Item Management. Hence the Vendor Line Items
additionally update below Tables.
BSIK – Vendor Open Invoices
BSAK – Vendor Cleared Items
View Vendor Line Item Display (FBL1N)
Vendor : 400710
Co. Code:
Select open Items
Execute
Afzal Page 65
SAP FICO
System populate the selection parameters under BSIK table and extract the information in a
user defined format.
There is a Open Line Item of 10,000/-.
Check Payment of 10,000/- to Vendor 400710 (F-53)
Doc Dt: 31.05.2013
Type: KZ
Bank Account
A/C: 200421 Amount: 10,000/-
In case of Check payments and Bank transfers it is always advisable to post to a clearing
account till business receive confirmation from the Bank about realization of check transactions.
Text: Check Payment
Open Item Selection
Account: 400710
Type: K
Press Process Open Items
Activate Vendor Line Item which you want to clear.
Document Simulate
Save it. Doc No. 1500001.
View vendor Line Item Display (FBL1N)
Vendor: 400710
Co. Code:
Select Cleared Items
Execute.
Once the Open Items were cleared system removes the entry from Open Item Table (BSIK)
and place it in Cleared Item Tables (BSAK).
Under Open Item Document (1900005) the Clearing Document No. 1500001 got updated.
Afzal Page 66
SAP FICO
Bank Statement Received that Check No. 000001000 encashed by vendor (Updation of check
encashment date) FCH6
A/C FA AP Environment Check Information ChangeFCH6 – Additional Info / Cash
Co. Code:
House bank: 1000
A/C ID: acct1
Check No. 000001000
Press Enter
Check Encashment Date: 31.05.2013
Save it, Check No. 000001000 saved Successfully.
Post check Transactions to Main Bank A/C after check Realization (F-02)
Doc Dt: 31.05.2013 Type: SA
Posting Key:40 A/C: 200421
Press Enter
Amount: 10,000/-
Text: Check Clearing
Posting Key: 50 A/C: 200420
Press Enter
Amount: *
Text: +
Document Simulate
Save it. Doc No. 100028.
Class 44
Check Void or Cancelled in case of
1. Un used checks (check damage, destroy or old one) void
2. Issued Checks
The check issued to the vendor assigned to the payment document number but the
same will be voided in following scenarios.
Issued check dishonoured by bank due to signature mismatch, insufficient
funds and vendor lost the checkin all above cases we can avoid the issued check
and give a new check to the vendor to the same payment document
InvoiceOutgoing PaymentCheck IssueDishonourVoid Issued Check (Cash or Issue New
Check)
In the above scenario the payment document will remains same and issue a new check
against that document.
Testing of Voiding
Void Unused Checks (FCH3)
Afzal Page 67
SAP FICO
Issue check to the vendor against payment Doc No. 1500002 (FCH5)
Doc No. 1500002
Co. Code:
House Bank: 1000
A/C ID: ACCT1
Check No. 000001002
Press Enter
City: Bangalore
Save.
Afzal Page 68
SAP FICO
Simulate
Save.
Update Check EnCashment Details (FCH6)
Check No. 000001003
Check Encashment Dt: 03.06.2013
Save.
Class: 45
Special GL Transactions
Afzal Page 69
SAP FICO
Special GL Transactions will be identified with special GL indicators. Below are list of
Special GL Transactions.
Special GL Indicator Description
A Used for Down Payment/Advances
F Down payment Request
G Guarantees
H Security Deposit
L Letter of Credit
Q Bills of Exchange
For each Special GL Indicator we will assign reconciliation A/C and Special GL A/C or
Alternative Reconciliation A/C.
Alternative GL A/C: The GL A/C which will be assigned in the Special GL Indicator. If any
Transactions posted with Special GL Indicator will bypass Recon A/C and update to Special GL
A/C.
Create GL Account (FS00)
GL: 200610
Group: Current Assets
Select Balance Sheet
Text: Advances to Vendors
Recon A/C for A/C Type: Vendors
Select Line Item Display
Sort key: 012
FSTG: G067 (Reconciliation A/C)
Save it.
Automatic assignment of GL A/C’s for Special GL Indicators or Down Payments made on
Vendors (OBYR)
Spro FA (New) AR& AP Business Transactions Downpayment Made Define
Alternative Recon A/C For Down Payments (Obyr)
Double click on Special GL Indicator A against A/C Type K
Chart of Accounts:
Recon A/C Special GL
100700 – Domestic Payable 200610
100701 – Foreign Payable 200610
100702 200610
100703 200610
100704 200610
100705- one time vendor account 200610
Save it.
Testing of Advances to Vendors
Create New Vendor Master (XK01)
Co. Code:
A/C Group: 9514
Press Enter
Vendor Name: Ram
Country: IN Region: 10
Press Enter
Recon A/C: 100704 Sort Key: 001
Cash Management Group: A5
Save it.
Vendor No. 400711.
Vendor Advance Payment (Posting (F-48)
A/C FA AP Document Entry Down Payment Down Payment F-48 Down Payment
Dt: 04.06.2013 Type: KZ
Afzal Page 70
SAP FICO
Transfer Advances to Normal Vendor A/C (Recon A/C) for clearing of Invoices (F-54)
A/C FA AP Document Entry Down Payment Clearing F-54
Afzal Page 71
SAP FICO
Class 46
Afzal Page 72
SAP FICO
Special GL Indicator: A
Bank A/C: 200400
Amount: 2,000/-
Press Enter
Amount: *
Text: Advance Payment
Simulate
Vendor A/C Dr
To Cash A/C
Save. Doc No. 1500005.
Transfer of Advance from Special GL A/C (200610) to Recon A/C (100704) (Clear Vendor
Down Payments) (F-54)
Doc Dt. 05.06.2013 Type: KA
A/C: 400711
Click on Process Down Payments
Transfer Posting: 1200/-
Simulate
Vendor A/C Dr (100704)
To Vendor A/C (200610)
Save. Doc No. 1700002.
View FBL1N Report
Vendor: 400711
Select Special GL Transactions
Execute.
The Advance of 800/- remains under Special GL transactions.
Select Back Arrow Button
Select Normal Items
Execute.
Vendor Auto Clearing (F-44)
A/C: 400711
Click on Process Open Items
Select the Line Items belongs to 1200/-
Simulate
No Line Items Generated as this transaction is used to auto clear Open Items which have
Debit and Credit entries with the same amount and to set status to clear.
Save it.
Scenario3: Advance Less than Invoice Amount
Balance Advance is 800/- post Vendor Invoice with an amount of 1,100/- (F-43)
Vendor A/C: 400711
Afzal Page 73
SAP FICO
Press Enter
Information Message: 800/- down Payment on Current Assets Exists.
Amount: 1100/-
Text: Vendor Invoice
Posting Key: 40 A/C: 400110
Amount: * Text: + Save. Doc No. 19000010.
Transfer Advance of 800/- (F-54)
Dt. 05.06.2013 Type: KA
Vendor A/C: 400711
Press Enter
Transfer Posting: 800/-
Simulate and Save. Doc No. 1700003.
Class 47
Special GL Request
Special GL Indicator for Request is “F” the Settings are
Assignment of Special GL A/C against Indicator “F” (OBYR) or (FBKP)
Afzal Page 74
SAP FICO
Save it.
Configuration Steps
Configure Automatic Payment Program for Country (FBZP)
SPRO FA (NEW) AP & AR BUSINESS TRANSACTIONS OUTGOING PAMENTS
AUTOMATIC OUTGOING PAYMENTS PAYMENT METHOD/ BANK SELECTION FOR
PAYMENT PROGRAM SET UP PAYMENT METHOD FOR COUNTRY FOR PAYMENT
TRANSACTION
Afzal Page 75
SAP FICO
APP configuration maintained at payment method which will be created under a Country.
New Entries
Country: IN
Payment Method: C
Description: Check Payment
Payment Method
Select Out Going
Payment Method Classification
Select Check
Required Master Record Specification
Select Street, PO Box, Postal Code
Posting Details
Document Type for Payment: KZ
Clearing Document Type: KA
Payment Medium
Select Use Classic Medium Programs (RFFO*)
Payment Medium Program: RFFOUS_C
Name of Print Data Set: LIST1S
This consists of the List of all Printer details in order to Check Printing and Payment
Advices.
Printing settings related to Advices and Checks.
Double click on Currencies Allowed
Maintain currencies here if the Business wants to restrict payment method with a particular
currency.
To Apply the payment method for all sort of currencies do not maintain any values.
Save it.
Set up Payment Methods for Company code for Payment Transaction - FBZP
Same path
New Entries
Paying Co. Code:
Payment Method: C
Amounts Limits
Minimum Amount: 1000
Maximum Amount: 500000
Select Payment per Due Day
Select Foreign Partner Allowed
Select Foreign Currency allowed
Expand Form Data
Form for the Payment Medium: F110_PRENUM_CHCK
Drawer on the form
Accounts Executive
Execute.
Afzal Page 76
SAP FICO
Class 48
Set up Bank Determination
Same path
This step is used to assign House Bank and Respective A/C ID’s to the Payment Method.
Position
Select Co. Code:
Double click on Ranking order
New Entries
Payment Method Currency Rank order House Bank
B INR 1 1000
Double click on Bank A/C’s
New Entries
House Bank Payment Method Currency Account Bank Sub A/C
1000 B INR ACCT1 200421
Double click on Available Amounts
New Entries
House Bank A/C Days Currency Available for Outgoing Payments
1000 ACCT1 999 INR 99999999
Save it.
Afzal Page 77
SAP FICO
Vendor: 400705
Amount: 2,000/-
Business Area: 95S2
Save it.
Afzal Page 78
SAP FICO
This date must be at least 1 day ahead to the Run Date. System will also include the Vendor
Invoices which will become over due by Next Payment Date. In order to avoid loss of cash
discounts and loss the credibility from the Vendor
The system will includes those line items also in this run business can decide whether
include those invoices in this payment run or can be excluded by rejecting the invoice (Blocking) in
the Edit Proposal.
Vendor: 1 to 999999
Additional Log
Select Due Date Check Button
Select Payment Method selection in all cases
Select Line Items of the Payment Documents
Vendor No. 1 to 999999
Based on the above selection parameters system will extract the Vendor invoices and
creates a proposal. The proposal consists of list of items to be cleared. Business can view the
proposal and edit the proposal. You can edit proposal for
1. Lock the Vendor Line Items against Payment
2. Change the cash discounts amounts and percentages
3. Re allocate or change House Bank Details
Save Parameters.
Details Have been saved for the run on 07.06.2013, Identification is T1.
Go to Status
Click on Proposal
Dt. 07.06.2013
Afzal Page 79
SAP FICO
Class 49
Double Click on Error Line Item
Double Click on Line Item
Popup Displayed with Change Line Items
Error Message: Error in Creating the Payment Document
Click on Reallocate
House Bank: 1000 ACCT1
Press Enter
Select Back Arrow Button
The Vendor No. 400711 displayed under Exceptional List.
An Amount of 6,000/- displaying with Red Colour.
Double click on Line Item
Against the Vendor 400710 we created a down payment request 6,000/-
APP is considering the Due Date and Advance Payment is done through APP.
Additional Log
Click on Payment Run Log
System generated Doc No. 1500008, 1500009
Error with 400705 Vendor.
Exchange rate Different Accounts are incomplete for A/C 100703, Currency INR to EUR
payment is not possible.
Printout/Data Medium
Program Variant
RFFOUS_C _ABN
Select Maintain Variants
Select for All Selection Screens
Click on Continue
Co. Code Selection
Paying Co. Code:
Sending Co. Code:
Further Selection
Payment Method: B
House Bank: 1000
A/C ID: ACCT1
Afzal Page 80
SAP FICO
Print control
Select Print Checks Printer LP01 Select Print Immediately
Select Print Payment Advice Notes Printer LP01 Select Print Immediately
Select Payment Summary Printer LP01 Select Print Immediately
Afzal Page 81
SAP FICO
Class 50
Execution of APP
Create Vendor Master (XK01)
Co. Code:
A/C Group: Other Income
Address
Title: Company
Name: XYZ Manufacturers
Street: Street No. 10
Postal code: 500016
Country: IN Region: 10
Po. Box: 500016
Press Enter
Recon A/C: 100704
Cash management Group: A5
Payment Method: B
Save.
Vendor No. 400712.
Afzal Page 82
SAP FICO
Afzal Page 83
SAP FICO
Go to Status tab
Place the cursor on Payment Run has been Carried out
Edit payments Delete Output
Select YES.
Chart of Accounts:
Press Enter
Save the Posting Rules
Account
300102
Save it.
The calculated Cash discounts automatically posted to this GL A/C.
Execute F110
Run Date: 10.06.2013
Identification: T1
Click on Payment Run
Select Start Immediately
Keep on Press enter
Posting orders 1 Generated, 1 Completed.
Additional Log
Click on Payment Run Log
Doc No. 1500010
Entry is (FB03)
Vendor A/C Dr 5500/-
To Cash A/C 4950/-
To Cash Discount Gain A/C 50/-
Print out / Data Medium
Program Variant
RFFOUS_C P1
Click on Maintain Variant
Select for all Selection Screens
Press Enter
Afzal Page 84
SAP FICO
Status
Click on Printouts
Select Start Immediately
Job Name change ?with
Press Enter
Class 51
New GL Concept (Accounting)
New GL Accounting is introduced from SAP ECC5.0 version onwards. The below Three
important features were introduced from ECC5.0 Version onwards.
1. Document Splitting
2. New General Ledger
3. Real Time FI-CO Reconciliation
The Business can decide weather they want to use above new features are not to their existing
system. If the Business is using older than ECC5 version they must upgraded their systems to new
versions in order to use this features. Such type of projects are called as upgrade projects.
Upgrade is Two Types
a. Technical Upgrade: It means system will technically upgraded to New Version but
business don’t want to activate New Features of that Version.
Note: for technical upgrades we must make sure the functionality of older and new versions
should remains same.
b. Functional Upgrade: If Business wants to use the new features of the upgraded
version that is called as Functional Upgrade Project.
Note: for Functional upgrade first System must be upgraded technically.
Document Splitting: Document Splitting is the New Feature introduced from ECC5.0 version. This
will make sure the generation of Zero Balance internal reporting or Financial Statements.
Note: till 4.7 Version Business had faced many issues to achieve Zero Balancing internal reporting.
Hence SAP related New Versions to avoid all the issues faced by the clients.
Characteristics of Document Splitting
Afzal Page 85
SAP FICO
Splitting Rules
1. GL Accounts: in case of GL Accounts system will validate existence of
characteristics in any of the GL Line Item and the same will be populated to other Line
Items. If multiple business areas entered system split the off setting entry also according to
the characteristics used in the document.
2. Assets: all asset transactions will get posted through asset masters. System will
derive or extract business area or profit centre from the asset master. The business area for
vendor transactions will be extracted from Asset Line Item.
3. Customer and Vendors: the Business area will be extracted from the expense or
Revenue GL A/C or Asset Line Item of the transaction.
4. Materials: In case of Logistics or Material transactions system will extract Business area
with the combination of Plant and Division.
In case of Profit centre: Profit Centre will be assign in the respective Material Master.
Class 52
Configuration Steps
Activation of Document Splitting against Co. Code
SPRO FA (NEW) GL A/C (NEW) BUSINESS TRANSACTIONS DOCUMENT
SPLITTING ACTIVATE DOCUMENT SPLITTING
Activate Document Splitting
Select Document Splitting Check Box
Splitting Method: Z000000012
Level of Details
Select Inheritance
If this Indicator was selected the splitting characteristics for GL accounts are extended or
forwarded to other lines that do not have assignments.
Double Click on Deactivation for Co. Code
Co. Code:
Deselect Inactive Check Box
Save it.
Afzal Page 86
SAP FICO
New Entries
New Entries
GL A/C Description
100910 Zero Balance Clearing A/C
Save it.
Afzal Page 87
SAP FICO
Text: +
Simulate
Observation: No Business Area assign to Vendor Line Item.
Document Simulate General Ledger to view line items after splitting.
Professional charges A/C Dr 600/- 95S1
To Vendor A/C 600/- 95S1
Professional Charges A/C Dr 400/- 95S2
To Vendor A/C 400/- 95S2
Select Back arrow Button
Leave list Press YES
Save it. Doc No. 1900015.
Afzal Page 88
SAP FICO
Note: Always Make sure No transactions should hit Zero Balance Clearing Account
Select Back Arrow
Save it. Doc No. 100032
Class 53
New General Ledger
This is one of the New feature introduced from ECC5.0 version to meet parallel accounting
requirements of the Business. Which indicates to maintain the books of accounts in Multiple
Accounting standards or principles.
Purpose of Ledger Concept
1. For parallel Accounting
2. Using of Multiple Currencies
3. Reporting in different Fiscal periods other than co. Code fiscal reporting
Ledger are Two Types
a. Leading Ledger
b. Non – Leading Ledger
While creation of co. Code itself system will assign co. Code to leading ledger. This is the default
ledger used by system for statutory requirements.
Leading Ledger identified with Indicator 0L.
Non – Leading Ledger: these ledgers are user define and n. No. of Non – Leading Ledgers can be
defined based on the Business requirements. This ledger concept was introduced in order to avoid
the issues faced by the Business for parallel accounting maintenance. Till 4.7version we used
“Special Purpose Ledgers” for parallel accounting which is very tough.
Features of Non – Leading Ledgers
1. Should be created and activated manually
2. Used to meet parallel accounting, currency requirements and different Fiscal year reporting
3. Transactions posted in leading ledger automatically get updated in Non – Leading Ledger
4. If requires direct adjustment entries can be posted to Non – Leading Ledgers
5. While creation of Ledger system automatically creates ledger groups
6. Ledger groups can consists of Multiple ledgers
7. In each ledger group we must define one representative ledger. Which indicates other
ledgers of the group must follow the currency and fiscal periods of representative ledger.
Configuration Steps
Define Ledgers for General Ledger Accounting
SPRO FA (NEW) FINALCIAL ACCOUNTING GLOBAL SETTINGS (NEW) LEDGERS
LEDGER DEFINE LEDGERS FOR GENERAL LEDGER ACCOUNTING
New Entries
Ledger Ledger Name Totals Table
9Z -Non – Leading Ledger FAGLFLEXT
Save it.
Till 4.7 we have table up to GLTO.
Note: Ledger Group 9Z is created only with Ledger 9Z
Press Enter
Afzal Page 89
SAP FICO
Afzal Page 90
SAP FICO
KG 9Z
KR 9Z
KZ 9Z
DA 9Z
DG 9Z
DR 9Z
DZ 9Z
AF 9Z
AB 9Z
PR 9Z
RV 9Z
WE 9Z
WL 9Z
WA 9Z
Save it.
Afzal Page 91
SAP FICO
Posting Period: 6
Ledger: 9Z
Select Back Arrow
Save it. Doc No. 1900016.
Class 54 1
Legacy System Migration Work Bench
It is used to upload Master data and transactional data from Excel or Notepad to SAP. This
tool majorly used by functional consultants without taking the help of development team.
Testing of LSMW for GL A/C Upload
Open an Excel file and maintain a template which details you want to upload.
In Excel file
GL A/C Co. A/C P& Balanc Short Text Lon Currenc Only Reco Ope Sor LI FST
No. Cod Group L e Sheet g y Balance n n t D G
e Text s in Type Item Key
Local MGT
currenc
y
Afzal Page 92
SAP FICO
Afzal Page 93
SAP FICO
Afzal Page 94
SAP FICO
Class 55 1
With Holding Taxes (TDS)
With Holding Tax is formally called as TDS. The customer reduces or deduct the with
Holding Tax portion from the Vendor and he pays the with held amount directly to the appropriate
Tax Authorities. According to the legal requirements below are few Examples for TDS.
Section
192 TDS on Salaries
193 TDS on Interest on Securities
194A TDS on Other than Securities
194C TDS on Payment to Contractors
194H TDS on Commission & Brokerage
194I TDS on Rent
194J TDs on Professional & Technical Services
Afzal Page 95
SAP FICO
The TDS can be deducted by the customer either at the time of Invoice or Payment.
In SAP with Holding Taxes are 2 Types
1. Classic With Holding Tax
2. Extended with Holding Tax
Classic is the Old Feature of SAP and Extended is New Version available from 4.0 version.
Configuration Steps
Check With Holding Tax Countries
Path: SPRO FA (NEW) FAGS (NEW) WITHHOLDING TAX EXTENDED
WITHHOLDING TAX CHECK WITHHOLDING TAX COUNTRIES
New Entries
Country: IN
Withholding Tax Country: IN
Press Enter
Description: INDIA
Save it.
Base Amount:
Select Gross Amount
Rounding Rules
Select Withholding Tax Commercial Rounding
Select Post withholding Tax Amount
Accumulation Type
Select Per Year Starting with Month: 1
Control Data
Select With Hold Tax Base Manual
Select Manual Withholding Amount
Select No Certificate Numbering
Base Amount
Select Withholding Tax Code Level
Withholding Tax Amount
Select Withholding Tax Level
Save it.
Define other Tax Types for Education cess and Higher Education cess
Except Withholding Tax type and description all other settings reamains as above for New
Tax Types.
Next Entry
Tax Type: Y2
Description: Education cess
Base Amount
Select Tax Amount
Click on Inherite Base
Accumulation Type
Afzal Page 96
SAP FICO
Afzal Page 97
SAP FICO
Country: IN Region: 01
Press Enter
Save.
Afzal Page 98
SAP FICO
Next Entry
Co. Code:
Withholding Tax Type: Y2 Receipient Type: OT
Select Withholding Tax Agent
Withholding Tax Obligated from: 01.04.2013
Obligation to Withholding Tax Until: 31.12.2014
Afzal Page 99
SAP FICO
Next Entry
Co. Code:
Withholding Tax Type: Y3 Recipients Type: OT
Select Withholding Tax Agent
Withholding Tax Obligated from: 01.04.2013
Obligation to Withholding Tax Until: 31.12.2014
Save it.
GL A/C: 100801
Group: Tax A/C
Select Balance Sheet
Text: Education cess
Save it.
GL A/C: 100802
Group: Tax A/C
Select Balance Sheet A/C
Text: Higher Education cess
Save it.
Remittance Challan
A document, in India, that you present to a bank, when depositing aby form of withholding
tax that you have retained. The Challan states how much tax is being deposited. A separate
Challan is required for each form of withholding tax.
Maintain Number Groups
Path: SPRO FA (NEW) FAGS (NEW) WITHHOLDING TAX EXTENDED
WITHHOLDING TAX POSTING INDIA REMITTANCE CHALLANS MAINTAIN NUMBER
GROUPS
New Entries
Co. Code Section Code Official Withholding Number Group
Tax Key
1000 Y001 01
Save it.
Class 56 1
Maintain Number Groups and SAP Script Forms
Path: FA (NEW) FAGS (NEW) WITHHOLDING TAX EXTENDED WITHHOLDING TAX
POSTING INDIA WITHHOLDING TAX CERTIFICATES FOR VENDORS AND CUSTOMERS
ASSIGN NUMBER RANGES TO NUMBER GROUPS
New Entries
Co. Code:
Section Code: 1000
Official Withholding Tax Key: Y001
Form: J_1IEWT_CERT
Number Group: 001
Save it.
View: J_1IEWTNUMGR_N
Maintain
Validate Co. Code:
Section Code: 1000
Official Withholding Tax Key: Y001
Number Group: 001
View: J_1IEWTNUMGR_1
Maintain
New Entries
Co. Code Section Code Official Tax Key No. Group
1000 Y001 001
Save it.
Testing of Withholding Tax Transactions
Posting Vendor Invoice (F-43)
Dt. 17.06.2013 Type: KR
Posting Key: 31 A/C: 400700
Press Enter
Amount: 20000/- Business Place/Section Code: 1000, 1000
Text: Vendor Invoice
Posting Key: 40 A/C: 400110
A popup message displayed with withholding tax code information
Press Enter
Amount: * Business Area: 95S1
Text: +
Save it.
Professional charges A/C Dr
To Vendor A/C
To TDS
To Education cess
Accounts Receivable
GL A/C: 200301
GL A/C: 200302
A/C Group: Sundry Debtors
Select Balance Sheet
Description: Affiliated Receivables
Recon A/C for A/C Type: Customers
Select Line Item Display
Sort Key: 031 Customer No.
Field Status Group: G067
Save it.
GL A/C: 200303
A/C Group: Sundry Debtors
Select Balance Sheet
Description: One Time Customer Receivables
Recon A/C for A/C Type: Customers
Select Line Item Display
Sort Key: 031 Customer No.
Field Status Group: G067
Save it.
GL A/C: 300000
Group: Sales
Text: Domestic Sales
Select P&L A/C
Select Line Item Display
Sort Key: 001
Field Status Group: G001
Save it.
Next Entry
A/C Group: 9511
Name: Foreign Customer
Double Click on Co. Code Data
Double Click on Account Management
Next Entry
A/C Group: 9512
Name: Affiliated Customer
Double Click on Co. Code Data
Double Click on Account Management
Select Reconciliation as Required Entry
Save it.
Next Entry
A/C Group: 9513
Name: One Time Customer
Double Click on Co. Code Data
Double Click on Account Management
Select Reconciliation as Required Entry
Save it.
Change intervals
Insert intervals
No Year From No To No.
16 2013 1600000 1699999
Save it
Type Description No. From No To No
Range
DG Customer Credit Memo 16
DR Customer Invoice 18 1800000 1899999
DZ Customer Payment 14 1400000 1499999
Save it.
Posting Keys (OB41)
Key Description Dr/Cr A/C Type
01 Customer Invoice Debit Customer
11 Credit Memo Credit Customer
15 Incoming Payment Credit Customer
Master Data Creation
Create Customer Master (FD01 or XD01)
A/C FA AR MASTER RECORDS CREATE – FD01 or MAINTAIN CENTRALLY
CREATE – XD01
A/C Group:
Click on A/C Group Overview Button
A/C Group No.
Press Enter
Double Click on A/C Group:
Co. Code:
Press Enter
General Data Screen
Title: Company
Name: ABC Enterprises
Country: In Region: 10
Click on Company Code Data
Recon A/C: 200300 Sort Key: 001
Save it. Customer No. 500540.
Customer Master Tables
KNA1 General Data
KNB1 Customer Master Co. Code Data
KNB5 Customer Master (Dunning Data)
KNB4 Customer Payment History
KNBK Customer Bank Details
Class 58 1
Customer VS Vendor
Post Sales Invoice against Customer 500541 with an Amount of 1,50,000/- (F-22)
Dt. 19.06.2013 Type: DR
Posting Key: 01 A/C: 500541
Press Enter
Amount: 150000/-
Text: Vendor VS Customer
Posting Key: 50 A/C: 300000 (sales A/C)
Amount: * Business Area: 95S1
Text: +
Simulate
Save it. Doc No. 1800001.
Correspondence
Correspondence is the feature provided in SAP to send statements to the customers in
regular intervals or frequency. For sending of statements we must use correspondence.
Configuration Steps:
Define Correspondence Type
SPRO FA (NEW) AR & AP BUSINESS TRANSACTIONS CLOSING COUNT
BALANCE CONFIRMATION CORRESPONDENCE MAKE & CHECK SETTINGS FOR
CORRESPONDENCE DEFINE CORRESPONDENCE TYPES
Ignore the message the table is cross client.
New Entries
Correspondence:
Correspondence Type: Individual Correspondence
Select Account Required
No. Of Date Specifications: 2
Save it.
Sendor Details:
Sort Variant for Correspondence: K1
Line Item Sorting: P1
Print Control
Output to Printer: LP01
Select Print Immediately
Save as Variant
Variant Name:
Meaning: Correspondence
Save it.
Class 59
Dunning: Dunning is sending Reminders to Customers on their Over Due items. This can be used
to both with the Customers and Vendors. This is nothing but a reminderr statement to the
customers starting from Gentle reminder to till legal notice.
Configuration Steps for Dunning
Testing of Dunning
Assign Dunning Procedure in Customer Master (XD02)
Customer: 500541
Co. Code:
Press Enter
Co. Code Data Screen
Correspondence
Assign the Dunning Procedure:
Save it.
Detailed Steps
Selection parameters Co. Code, Customer No, analysis period.
Detailed or Logic for Statement
1. From the provided Co. Code in the selection parameters go to Table T001 and Extract
Address.
2. Go to table ADRC and populate this address No and retrive company address, Telephone
No, Fax No. Etc...
From the Customer provided in selection paramters go to Table KNA1 get the address Number and
populate in ADRC table to fetch Customer address details.
Extraction of Credit Terms
From Table KNB1 system will check customer details like payment term populate customer
No. And payment term in table T052U and extract description of Payment Terms.
Extraction of Customer Line Items
From the selection parameters (Co. Code, customer, analysis date or key date) system will
extract customer open line items from BSID table.
Calculation of Aging or Due Date
Due date of the Invoice can be calculated based on Document Date or Due Date.
In case of Document Date considered your
Aging = Key Date – Document Date
In case of Due Date
Aging = Key Date – Due Date of the Invoice
Class 61
Taxation
Taxes on Sales & Purchases
In India the taxation comprises of
1. Direct Taxes – Income Tax, Professional Tax
2. Indirect Taxes – sales & purchases Tax
Different Types of Taxes
GL A/C: 100810
Group: Tax Account
Select Balance Sheet A/C
Text: Input Tax on VAT
Select Only Balances in Local Currency
Select Line Item Display
Sort Key: 001
Field Status Group: G001
Save.
GL A/C: 100811
Group: Tax Account
Select Balance Sheet A/C
Text: Output Tax on VAT
Select Only Balances in Local Currency
Select Line Item Display
Sort Key: 001
Field Status Group: G001
Save.
Asset Accounting
Steps in Asset Accounting
Step 01 : Check Country Specific Settings(Optional)
Step 02 : Assign 0% Tax Codes for Non-Taxable Transactions
Step 03 : Copy reference Chart of Depreciation
Step 04 : Specify Description of Chart of Depreciation
Step 05 : Delete other than book depreciation
Step 06 : Check whether depreciation area are copied or not
Step 07 : Assign chart of dep to the company code
Step 08 : Define Account Determination
Step 09 : Create Screen Layout rules for asset class
Step 10 : Create number ranges for asset master
Step 11 : Define Asset Class
Step 12 : Determine Depreciation area in Asset Class
Step 13 : Maintain Depreciation Key
Step 14 : Create GL Accounts
Step 15 : General ledger account assignment to account determination
Step 16 : Define Base Method for Depreciation
Step 17 : Maintain Declining-balance methods
Step 18 : Define Multilevel methods
Step 19 : Define Period Control Method
Step 20 : Define Document type and number ranges for asset depreciation
Step 21 : Create Asset Master Records
Step 22 : Create Sub-Master Records
Asset Accounting:
Asset Accounting Component supports Monitoring of Assets or tracking of assets. This Component
supports Purchase of asset, Sale of asset, Profit on sale of asset, loss on sale of asset, Scrapping
of asset, depreciation on asset etc.
Step 01 Check Country Specific Settings:
Path: Spro>Img> FA (N) > Asset Accounting > Org Stru> Check country specific settings
(Optional)
>Position = Country = IN
> Country Currency - INR
Save
Asset Type
Account determ. : - Building
Scr.layout rule : - Building
Number range : 01
Asset Type
Account determ. : TR11 - Plant & Mach
Scr.layout rule : TR11 - Plant & Mach
Number range : 02
Inventory Data
XInclude Asset
X No AUC or Summary management of AUC
X Mange Historically
Save and enter
Click NEXT Entry
Account determ. : TR12- Furniture & Fix
Scr.layout rule : TR12 - Furniture & Fix
Number range : 03
Inventory Data
XInclude Asset
X No AUC or Summary management of AUC
X Mange Historically
Save and enter
Click on NEXT Entry
Account determ. : TR13- Vehicles
Scr.layout rule : TR13 - Vehicles
Number range : 04
Inventory Data
XInclude Asset
X No AUC or Summary management of AUC
X Mange Historically
Save and enter
Path: SPRO- Financial Accounting- Asset Accounting- Valuation- Determine Depreciation Areas in
the Asset Class
Execute
ChDep :
Enter
Go to position button
Asset Class :
Enter
Select _______
Double click on Depreciation Areas
Screen layout : 2000
Deselect Area deact.
Save and enter
Execute
Click on Select All (F7)
Click on Activate (Ctrl+F3)
Enter
Save and enter
18.Scrap on asset:
Path: Accounting - Financial Accounting - Fixed Assets - Posting - Retirement – ABAVN-Asset
retirement by scrapping (Tcode: ABAVN)
Execute
Click on change company code
Company code : Scrap on asset a\c Dr.
Asset : Accumulate depreciation a\c Dr.
Go to transation data tab To Asset a\c
Document date :
Asset value date :
Click on simulate
Save and enter
19.Asset transfer
19.1 Asset transfer with in company code: (Business area to business area)
Path: Accounting - Financial Accounting - Fixed Assets - Posting - Transfer – ABUMN-Transfer with
in company code (Tcode:ABUMN)
excute
Asset : (Giver area asset number)
Goto transaction data tab
Document date :
Asset value date :
Select Existing asset : (Receiver area asset number)
Go to Menu bar
System -services - output Control
Execute (F8)
Select Spool no.
Display contents (F6)
MM Integration
1. Define plant
Definition: Plant is an operational area.
Path: SPRO- SAP Reference IMG- Enterprise Structure- Definition- Logistics - General- Define
copy, delete, check plant (Tcode: OX10)
Execute
Double click on Copy, delete, check plant
Click on copy org.object (F6)
From plant : 1000
To plant :
Enter, Enter, enter and enter
One time go back
Double click on Define Plant
Go to position button
Plant :
Enter
Select ______
Click on Detail (Ctrl+Shift+F2)
Name1 : Bollaram Plant
Click on Address (Shift+F5)
Name : Bollaram Plant
Street : Bollaram
House number : 1-234
Postal code : 123456
City : Hyderabad
Country : IN
Enter
Save and enter
Definition: Whenever you create a material master record, you must assign it to a material type.
Path: SPRO- SAP Reference IMG- Logistics General- Material Master- Basic Settings- Material
Types- Define Attributes of Material Types (Tcode: OMS2)
Execute
Go to Position button
Material type : ROH
Enter
Select ROH
Double click on Quantity/Value updating
Go to position button
Valuation Area :
Material type : ROH
Select Qty updating
Select Value update Save and enter
Path: SPRO- SAP Reference IMG- Materials Management- Logistics Invoice Verification- Incoming
Invoice- Maintain Default Values for Tax Codes (Tcode:OMR2)
Execute
Click on New Entries (F5)
Company Code :
Save and enter
Enter
Company Code :
Enter
Company Code :
Enter
Company Code :
Enter
Company Code :
Enter
Company Code :
Enter
Company Code :
Enter
Save and enter
Go to Type/description Tab
Account Group : ASST Assets
Select Balance sheet Account
Short Text : Raw Material A/C
G/L Acct Long Text : Raw Material Account
Go to Control data Tab
Select only balances in local crcy
Select line item display
Sort Key : 001
Go to Create/Bank/Interest Tab
Field Status Group : G006
Select post automatically only
Save
17.2. GR/IR Clearing A/C
.G/L Account : 190500
Company Code :
Click on Create
Go to Type/description Tab
Account Group : LIAB Liabilities
Select Balance sheet Account
Short Text : GR/IR Clearing A/C
G/L Acct Long Text : GR/IR clearing Account
Go to Control data Tab
Select only balances in local crcy
Tax Category :*
Select Posting without tax allowed
Select line item display
Sort Key : 001
Go to Create/Bank/Interest Tab
Field Status Group : G001
Save
Go to position button
Country : IN
Enter
Proc. :
Save and enter
Go to Create/bank/interest Tab
Field status group : G001
Save
18.5. Define Tax Accounts
Path: SPRO- Financial Accounting- Financial Accounting Global Settings- Tax on Sales/Purchases-
Posting- Define Tax Accounts (Tcode: OB40)
Execute
Double click on Input Tax VST
Chart of accounts :
Enter
Select Tax code
Save
Tax code :
Account : 290400
Save and enter
One time go back
Double click on Output Tax MWS
Select Tax code
Save
Tax Code :
Account : 190400
Save and enter
18.6. Maintain Tax Category * and Select posting without Tax allowed in Service account
and Service Revenue A/C G/L Master Records in control data Tab. (Tcode:FS00)
19. Configure Automatic Postings
Path: SPRO- SAP Reference IMG- Materials Management- Valuation and Account Assignment-
Account Determination- Account Determination Without Wizard- Configure Automatic Postings
(Tcode: OMWB)
Execute
Click on Cancel (F12)
Click on Account Assignment (Shift+F4)
Double click on Inventory posting BSX
Chart of Accounts :
Enter
Select Valuation Modif.
Select Valuation
Save
Valuation modif. : 0001 (Valuation Grouping Code)
Valuation class : 3000
Account : 290500 (Raw Material Account)
Save and enter
One time go back
Double click on GR/IR clearing account WRX
Save
Account : 190500
Save and enter
20. Create Material Master Record
Path: Logistics - Materials Management - Material Master - Material - Create (General) - MM01 -
Immediately (Tcode:MM01)
Material :
Industry Sector : C Chemical industry
Material type : ROH Raw Material
Enter
Select Basic Data 1
Select purchasing
Select General Plant Data / Storage 1
Select Accounting 1
Plant :
Stor.location :
Enter
Material :
Base Unit of measure :
Material Group : 0001
Enter
Purchasing Group : 004
Enter and enter
Valuation Class : 3000
Price Control :V
Moving price :
Save
21. Vendor Master Record
Path: Accounting- Financial Accounting - Accounts Payable - Master Records - Maintain Centrally -
XK01 - Create (Tcode: XK01)
Vendor :
Company Code :
Purchasing organization :
Account Group : 0001
Enter
Title : Company
Name :
Search Term :
Street :
House number :
Postal code :
City : Hyderabad
Country : IN
Enter, enter and enter
Recon. Account : 190100
Sort key : 012
Cash mgmnt group : A1
Enter, enter and enter
Order currency : INR
Terms of payments : 0001
Inco terms : EXW
Select GR-based Inv.verif.
Purchasing group : 004
Planned deliv.time :1
Save
22. Procure to process (P2P)
22.1. Purchase Requisition
Path: Logistics - Materials Management - Purchasing - Purchase Requisition - ME51N - Create
(Tcode: ME51N)
Go to Items
Material :
Quantity :
Delivery Date :
Material Group : 004
Plant :
Stor.Loc. :
RFQ :
Enter
Net price :
Save
Purchasing organization :
Collecting RFQ :
Execute (F8)
Purchasing organization :
Purchasing group : 004
Company Code :
Keep blank Vendor Field
Execute (F8)
Select Purch.Doc.
Click on Adopt
Go to Item details
Go to Invoice Tab
Tax Code : R4
Click on Check (Ctrl+Shift+F3)
Save
PO Number :
22.6. Maintain number ranges 50 and 51 for Document types WE (Goods Receipt) and
RE (Invoice Verification) (Tcode: FBN1)
Invoice date :
Purchase order/Scheduling agreement: 4500017174
Enter
Select calculate Tax
Copy Balance Field amount to amount field
Click on Simulate (Ctrl+Shift+F7)
Click on post or save
SD Integration
1. Define sales organization
Definition: Sales organization nothing but sales department.
Legally, a sales organization is included in exactly one company code. You can assign one or more
plants to one sales organization. The sales organization has an address.
Path: SPRO- SAP Reference IMG- Enterprise Structure- Definition- Sales and Distribution-
Define, copy, delete, check sales organization (Tcode: OVX5)
Execute
Double click on Copy, delete, check sales organization
Click on copy org.object (F6)
From sales org. : 1000
To sales org. :
Enter, enter, enter and enter
One time go back
Double click on Define Sales Organization
Go to position button
Sales org. :
Enter
Select
Click on Details (Ctrl+Shift+F2)
Sales organization : Hyderabad
Click on Address (Shift+F5)
Name : Hyderabad
Street : Ameerpet
House number : 1-234
Postal code : 123456
City : Hyderabad
Country : IN
Region : AP
Language : EN English
Enter, enter and enter
Save and enter
2. Define Shipping point
Definition: The shipping point is the top level in the organization for shipping. A shipping point can
be allocated to several plants. A shipping point can be divided into several loading points.
Path: SPRO- SAP Reference IMG- Enterprise Structure- Definition- Logistics Execution- Define,
copy, delete, check shipping point (Tcode: OVXD)
Execute
Account : 400070
valuationmodif. : 0001
General modification : BSA
Valuation class : 7920
Account : 400070
Save and enter
One time go back
Double click on Inventory posting BSX
Valuation modif. : 0001
Valuation class : 7920
Account : 290600
Save and enter
7. Assign Sales G/L Account
Path: SPRO- SAP Reference IMG- Sales and Distribution- Basic Functions- Account
Assignment/Costing- Revenue Account Determination- Assign G/L Accounts
(Tcode: VKOA)
Execute
Double click on Cust.Grp/MaterialGrp/AcctKey
Click on New Entries (F5)
App :V
CndTy. : KOFI
ChAc. :
SOrg. :
AAG : 01
AAG : 03
ActKy : ERL
Account : 300100
Save and enter
8. Maintain number ranges for 49 (Tcode: FBN1)
Company code :
Click on change interval
Click on Insert Interval (Shift+F1)
No : 49
Year : 2014
From Number : 4900000000
To Number : 4999999999
Enter
Save and enter
Distr.Channel :10
Enter
Material :
Base Unit of measure : TO
Material Group : 0001
Division : 00
Gross Weight : 10000
Net Weight : 10000
Enter
Delivering Plant :
T :1
Click on conditions
Scal Quantity Amount
1 100000
10 TR10
100 90000
One time go back
Enter
Acct assignment grp : 03
Enter
Trans.Grp : 0001
Loading Grp : 0001
Enter and enter
Valuation Class : 7920
Price Control : S (Standard price)
Standard price : 100000
Save
Delivering plant :
Go to Billing documents tab
Incoterms : EXW
Terms of payments : 0001
Acct assgmt group : 01
Tax classification :1
Save
11. Initial Stock posting
Path: Logistics - Materials Management - Inventory Management - Goods Movement - Goods
Receipt - MB1C - Other (Tcode: MB1C)
Movement type : 561
Plant :
Storage Location :
Enter
Material :
Quantity :
Enter
Save
Go to Menu bar
Other Goods Receipts- Display
Enter Click on
Accounting Document (F7)
11.1. Maintain Condition Records
Path: Logistics- Sales and Distribution- Master Data- Conditions- Select Using Condition Type-
VK11 – Create (Tcode: VK11)
Condition type : MWST (Output Tax)
Enter
Select Domestic Taxes
Enter
Country : IN
T : 1 (This is maintained in Customer Master)
T : 1 (This is maintained in Material master)
Tax code : M4
Save
12. Creation of Sales order
Path: Logistics - Sales and Distribution - Sales - Order - VA01 - Create (Tcode: VA01)
Order type : OR
Sales organization :
Distribution Chennel : 10
Division : 00
Enter
Sold to party :_________ (Customer Number)
PO Number : 10
Go to Sales Tab
Material :
Order Quantity : 10
Enter
Double click on Material
Go to Conditions Tab
Save
Sales order N
Path: Logistics - Sales and Distribution - Shipping and Transportation - Outbound Delivery - Create
- Single Document - VL01N - With Reference to Sales Order
(Tcode: VL01N)
Shipping point :
Selection Date :
Order :
Enter
Go to Picking Tab
SLoc :
Picked Qty : 10
Enter
Click on post goods issue (Shift+F8)
Go to Menu bar
Outbound delivery - Display
Outbound Delivery :
Enter
Go to Menu bar
Environment - Document Flow
Select GD Goods Issue:Delivy
Click on Display Document (F8)
Click on Accounting Documents (F7)
Delivery Document No: 80015175