Fi Total
Fi Total
Fi Total
FI-CO
SAP is one of the ERP product which is developed in 1972 by 5 former IBM engineers
First time SAP was released in 1972 in Germany. SAP Head Quarters are in Germany
Enterprise Resource Planning. It integrates all the systems in one system. It facilitates free flow of data
among departments.
Various Types of ERP Packages: SAP, Oracle-Financials,JD Edwards, BAAN, Peoplesoft are various
types of ERP packages available in the Market. Among them SAP is Famous in the world
Productivity
Effective
Efficiency
The Moto of ERP systems is planning of resources in the organization in an effective manner of get more
Profits.
USER NAME:Cost of the SAP is based on Number of Users Major Benefit of Users is it fixes the responsibility
of the employee. Who has done ,what can be identified. So the responsibility will be fixed on employees. User
name is not case Sensitive. We can use either Small Letters or Capital Letters
PASSWORD:Benefit of Passwords are for restricting the Un-authorized use of Users,Length of the Password
can be Minimum 6 and Maximum 40 characters. It is case sensitive. We can use Alphabetic, Numeric's,
Alphanumeric or Special Characters like " * " or "#" etc.
Note: It is not possible to change the password more than once in a Day
System will not permit us to use the last 5 passwords.
If we lost Password itcan not be restored. Basis Consultant has to allot New Password
LANGUAGE: Along with package SAP has given 41 languages . If we do not specify the language, by
default system will use English ( EN) as language
If any user want to work on different screens at a single time, he can open up to a max of 6 windows or
Sessions
WHAT IS SESSION: A session is a window or screen where SAP user will do day to day activities One user
can open 6 Sessions at a time.
HOW TO CLOSE SESSION:To close one session, path is Menu Bar---->System---->End Session
WHAT IS TRANSACTION CODE: Transaction Code is a code number given for each activity . SAP has given
some Transaction Codes ( TC's ) which are common in SAP through the world.If customer / Purchaser want to
give their own TC's it should start either with "Y" or "Z". Other Alphabets are not allowed in SAP.
ACTIVATING TRASACTION CODES IN SAP MENU Some times TC's will not appear in SAP Easy Access
Menu. To activate them path is Menu Bar---->Extras---->Settings---->Display Technical Names Check Box and
Press Enter
What is Client ?
Client: Each Server can be configured with single client or multiple clients according to the business
requirement.
Each client will have they own set of tables
Normally when a Company ( ex. NCC) intends to start SAP in its Company, it purchases SAP software from
SAP-India. Price of SAP software is based on the Number of Users. Once company purchased the software, it
recruits / engage another Company (ex Cap Gemini) forimplementation purpose. Both the purchaser and
implementer will recruit some employees for implementation of SAP. They are called as Core Team Members.
Structure of Core Team will be like below
Core Team from Purchaser analyze the present situation in the Company and preparethe Process Document
for SAP Implementation
Basis Consultant will install or copy the SAP in Server and Create the Client Numbers
By default SAP-India is allotting 000 (or) 001 (or) 067 (or) 800 as Development Client #
Number of Production Client will be given by Basis Consultant after Discussing with
Purchaser. There will be Minimum of 2 Clients. Some companies are creating 3 clients
Server: Server is a physical device used to store organizational data, the server are managed with the database
and all types of data is stored in the table format (Rows&column)
Transport Request: TR are generated for configuration or customization and for development changes.
Transactional data: The day to day business transactions are called transactional data.
Ex: Posting general entries ,customer ,vendor and asset posting ext........
No transport request for transactional data the direct real time transactions are posted in production server by
business users.
Master data: Master data is base for posting transactional data and used for reporting.
Ex: GL Accounts
Customer
Vendor
Asset Master data
Material Master data
Cost Centre Master data
Profit Centre Master data Ext.......
Using upload methods the master data and transactional data will be loaded to quality and production server
Upload Methods
FI Finance Accounting (module) is used to meet or achieve all statutory and internal financial reporting
requirements for generating P&L and Balance sheet reports.
Co Controlling is the module used to control the overhead cost and to generate more profits with in the
organization.
1)Define Company
A company is the organizational unit used in the legal consolidation module to roll up financial statements of
several company codes.
In Sap the basic information about company is stored with a key 6digit.
In normal terminology company is used to join independent branches together as a legal unit by the
consolidation.
Company : II02
Name of Company 2 :
Details information
Street : Kukatpalli
Po Box : 57002
City : Hyderabad
Country : IN
Language Key : EN
Currency : INR
Select Save Button ( or) Ctrl + S Buttons for saving the Company Information
Credit Control area is an organizational unit which is used to maintain credit limits against customer of the
organization
One company code must be assigned to only one credit control area, but same credit control area can be
assigned to multiple company codes
Currency : INR
The Company Code is the smallest organizational unit for which a complete self-contained set of accounts can
be drawn up for purposes of external reporting.
Company Code is central organizational unit and all other logistic payroll controlling module structure are to be
assigned to the company codes
For Consolidation reporting company code must be assigned to the respective companies
Path: SPRO-SAP Reference IMG- Enterprise Structure-Definitions-Financial Acc-Edit Copy Delete Check
Company Code OX02
Title : Company
Name : II Solutions
Street Address
Country : IN Region: 01
Po Box Address
Po Box : 57002
Business area is an organizational unit that corresponds to a specific business segment or area of responsibility
in a company. The financial statements are created business areas
for internalreporting purpose only. you can create as many business areas as you require. the definition of
business area is optional. you cannot assign the business areas to company.
II02 Hyderabad
Functional Areas are used to generate cost of sales reporting using departments like
Sales
Production
Marketing
Administration
It is an organizational unit, in accounting used to classify the expenses of an organization by the departments.
Sap has standard multiple functional areas if they met business requirements so we can use existing
Functional areas.
0100 - Manufacturing
0110 - Direct Production Cost
012 - Overhead Production Cost
0300 - Sales and Marketing
0400 - Administration
0600 - Other operating income
Business areas are financial organizational units which are used to generate individual financial statements at
branch level product level
Business areas are maintain independent by the company code these areas are not assign to any company
codes can be used across all company codes.
COA must be assigned to a company code. One Chart of Account can be assigned to many Company codes.
Based on business organization structure and reporting requirements of country we can use three types of chart
of accounts.
Operational Chart of Account: The regular business transactions are posted to G\L accounts created with
reference to operational Chart of account
Group Chart of Accounts: Consolidation purpose will use group chart of accounts.
Country Chart of Accounts: As per country legal requirement will use country chart of accounts.
Language : English
Length of GL : 8
Account groups determine which fields you can configure on the G/L master record.
The standard SAP require at least two account groups, one for balance sheet accounts and one of the profit
and loss accounts.
Maintain the Groups Liabilities Assets Revenues Incomes Expenses Fixed Assets
At the end of a fiscal year, the system carries forward the balance of the P&L account to the retained earnings
account.
X 1000100
July to June
October to September
Year Shift:Year shift is the indicator used with non calendar fiscal years convert to two calendar periods into
one financial year
Variant:Variant is a key within which we maintain settings relevant to certain configuration, the variants are
maintained at a client level and assign to the company codes
Fiscal Year is a period of 12 months and SAP provides 4 special periods. Fiscal year determines .Posting
periods are used to assign business transactions. Fiscal year may be year dependent or year independent.
The Special periods in a fiscal year variant can be used for things like posting audit or tax adjustments.
Year Dependent
The financial year is same as calendar year. Starting from 1st Jan to 31st Dec (where posting periods and the
calendar months are equal)
Year Independent
The financial year is different from calendar year Starting from 1st April to 31st March (where the posting period
months are not equal to calendar year months)
PATH: Financial Accounting New--Fin. A/c Global Setting-Fiscal Year-Maintain Fiscal Year Variant
OB29
Click On Position Button and Enter Company Code II02 and Enter
The Posting period variant controls which posting periods, both normal and special, are open for each company
code. It is possible to have a different posting period variant for each company code in the organization. The
posting period is independent of the fiscal year variant.
Variant Name
Var. A From per.1 Year To period Year From per.2 Year To period Year
SAVE
Account Types
A Asset
D Customer
K Vendor
M Material
S General Ledger
Select Standard Field Status Variant 1000 and Click On Copy as Button
Change FSV From 1000 to II02 and Name Field Status for II02
Enter
If there is any business requirement we need to control the transaction level fields. Select FSTV and Double
click on Field Status variant
When We select Suppress --------- Field will not be visible on Screen at the time of Posting
When We select Required --------- Field will appear with √ Mark. Withoutentering data in the
field , we cannot go to next field.
When We select Optional --------- Field will appear on Screen, but it is our choice to enter the data
or not
Click On Position Button and Enter Company Code II02 and Enter
SAP has standard document types, based on client requirement we can use same document type or
create new document type or copy
Are defined at the specific interval with in which documents should be created in sap and document number
ranges depends upon company code and valid for the defined year. We can assign one or more document
types to each number range. The number range becomes effective by the document type specified in document
entry and Posting.
Click On Define Document Number Range and Enter Company Code ' II02' and Click On Change Interval
Button
Posting keys determine whether a line item entry is a debit or a credit as well as the possible field status for the
transaction
NOTE:SAP has standard Posting Keys, based on Client requirement we can use same Posting Keys or
create new Posting Key.
26) EX-- If we want to control posting key level double click on 06 posting key.
amounts.
A calculation procedure is defined for each country, each containing the specifications required to calculate and
post tax on sales/purchases. Each calculation procedure contains several tax types, which are called condition
types in the procedure.
The system defaults condition types when you define a tax code. The condition type (such as input or output
tax) specifies the base amount on which the tax is calculated and the account key that is used to post the tax.
The specifications necessary for calculating and posting tax have been defined for the condition type and
account key.
Procedure Description
Enter Procedure 'ZTAXIN' and Description' Sales Tax- India' and Select Line Item and Double Click On''Control
Data'
Click on New Entries
SpetCTtp Description From Accounting Key
100 BASB Base Amount -
200 MWVS Input Tax 100 VST
300 MWAS Output tax 100 MWS
Currency Type 10
Currency INR
Enter
Click on “YES”
SAVE
Click on “YES”
SAVE.
Enter
SAVE
Component Active
Cost Objects
PATH: SPRO – Financial Accounting New – General Ledger Accounting New – Business Transactions –
Document Splitting
General ledger
The General ledger is a collection of the group of accounts that supports the value items shown in major
financial Statements
The GL account is made up of two segments namely company code segment and chart of accounts segment.
Creation of G/L account can be done in three ways namely,
This functionality gives a basic template of the GL account. The account is created with entire data required from
the COA.
This can be used by all CC with same COA; in this case CC-1000 & CC-2000 can use the same GL.
This functionality is used to assign the Company Code relevant data to the GL account.
1. Currency.
4. Tolerance group.
5. Authorizations. Etc.
The purpose of creating GL account centrally is to create GL account in both the segment together,
Screen shot gives the overview of the field which has the' Chart of Account' related data
Screen shot gives the overview of the field which has the ' Company Code' related data
Enter
Every month end, by coping Sample Document Number and modify the date and amount and post the
transaction.So that we will not for get any provisions for that month.
Note: This is used for Month end Provisions and Sample Document template will not update the
Rent Ac Dr25000
If you store a sample document, the system automatically assigns a number to this special document. To
do this, the system uses the number interval X2. This number range may only be used by the system.
You cannot assign it to any document type. You have to set up this number range in all the company
codes where sample documents are used. You have to use key X2 for this number range.
number range--Document in Entry View--Define Document Number Ranges for Entry View
Go to FBN1
Screen shot gives the overview of the field which has the' Chart of Account' related data
Screen shot gives the overview of the field which has the ' Company Code' related data
Screen shot gives the overview of the field which has the' Chart of Account' related data
Screen shot gives the overview of the field which has the' Chart of Account' related data
Document Type - SA
Currency - INR
Enter
Pstky 50(Credit)
Enter
Enter
Click On Document
Post
Documents--Sample Documents—Display
Enter
Click On Document
Enter
Enter
Remove 35000
Maintain "0"
Remove 5,35,000
Maintain "* “
Enter
Click On Document
Simulate
EXECUTE
07Outgoing Payment
Type SA
Account 2000102
Amount 500000
Enter
Click On Document
Simulate
Periodically recurring entries posted by recurring entries program based on recurring entry documents. This
process is comparable to the standing order you give to your bank to deduct your rent, premium payments, or
loan repayments. Recurring entries are business transactions that are repeated regularly, Such as rent or
insurance.
You enter this recurring data in recurring entry original documents. This documents does not update the
transaction figures. The recurring entry program uses it as a basis for creating accounting balance.
The system uses the recurring entry original document that you enter as a reference. It is not an accounting and
therefore does not affect the account balance.
In the recurring entry document,you define when a posting is to be created with this document . You have two
options for scheduling. Postings can be made periodically or in a specific date.
For periodic postings, specify thefirst and last day of execution, as well as the interval in months.
To post recurring entry documents. You have to set up a separate number range for the company codes that use
them. You have to use key x1 for the number range. The system takes numbers for the recurring entry original
documents from this number range.
Go to FBN1
Path: Easy Access – Accounting – Financial Accounting – General Ledger – Document Entry – Reference
Documents
Maintain Fields
IntervalIn Months 01
Document Type SA
Currency INR
Posting Key 40
Enter
Posting Key 50
Enter
Maintain Fields
Amount 6000
Path: Easy Access – Accounting – Financial Accounting – General Ledger –Periodic Processing –
Recurring Entry – F.15 –Lists
Click On F.15
Maintain
Click On Execute
Path: Easy Access – Financial Accounting – General Ledger Accounting Periodic Processing - Recurring
Entries- F.14 – Execute
Click On F.14
Maintain Fields
Click On Process
You can park a document before you post it. This is useful for example ,If the data you want to enter is incomplete.
Or the parking and posting functions are carried out by different accounting clerks.
Go to FV50
Amount 1500
Amount 15000
Text 06.04.2015
Enter
Go To FBV0
Maintain Fields
Enter
An accrual of an expense refers to the reporting of an expense and the related liability in the period in which
they occur, and that period to the period in which the payment is made An example of an accrual for an
expense is the electricity that is used in December, but the payment will not be made until January.
Go To FS00
Click On Create/Bank/Interest
Path : Accounting – Financial Accounting – General Ledger – Periodic Processing – Closing – Valuate – Enter
Accrual/Deferral Accounting Document
Type SA
Posting Key 40
Enter
Amount 15000
Posting Key 50
Enter
Amount 15000
Enter
Path : Accounting – Financial Accounting – General Ledger – Periodic Processing – Closing – Valuate – F.81 –
Reverse Accrual/Deferral Document
Click On Execute
Go To FB03
Enter
Cash Journal
Cash Journal is a sub ledger of Bank Accounting it is used to manage a company’s cash transactions the
system automatically calculates and displays the opening and closing balances, and the receipts and postings
to G/L accounts, as well as vendor and customer accounting.
Path : Financial Accounting(New) – Bank Accounting – Business Transactions – Cash Journal –Create G/L
Account for Cash Journal
Short Text
Path : Financial Accounting (New) – Bank Accounting – Business Transactions – Cash Journal – Define
Number Ranges for Cash Journal Documents
011000 1999
Path : Financial Accounting (New) – Bank Accounting – Business Transactions – Cash Journal - Set Cash
Journal
Co Cd CJ No CrcyDT G/L A/C DT VPT DT VPT DTPCT DT PCT Cash Journal Name
Currency INR
Path : Financial Accounting (New) – Bank Transactions – Cash Journal – Create, Change, Delete Business
Transactions
Company Code Business Transaction Type G/L Account CJ Business Tran Account Mod
Path: Financial Accounting (New) – Bank Accounting – Business Transactions – Cash Journal – Set Up Print
Parameters for Cash Journal
Path: Accounting - Financial Accounting – General Ledger – Document Entry – FBCJ – Cash Journal
Posting
Enter
Click On Receipts
Enter
Sales Account1800
Back
Enter
Interest Calculation
In S –Type interest Calculation on a the few balance outstanding in an accounting this is an account
This is generally used in case of G/L accounts
Ex: Term Loan Account
In P – Type Interest is calculated on a few selected open items only, and not on the entire balance in an
account. This is generally used in case of overdue receivables or payables. Hence it is also known as
Interest on Arrears.
In z – Type is calculated on interest arrears (per item)or in the account balance interest calculation
(interest Scale)
The basic parameters (procedure) for calculating interest are defined in an interest Calculation indicator
(ICI) These parameters including the following.
Note: Every ICI is identified by a user –defined two -digit a code defined at the client level.
Note: Every account for which interest is to be calculated must have an ICI mentioned in its master
record
Calendar Types
Example
Path: Financial Accounting (New) – General Ledger Accounting (New) - Business Transactions – Bank
Account Interest Calculation – Interest Calculation Global Settings – Define interest Calculation Type
Path: Financial Accounting (New) – General Ledger Accounting (New) – Business transactions - Bank Account
Interest Calculation
Calendar Type G
Path: Financial Accounting (New) – General Ledger Accounting (New) – Business Transactions – Bank Account
Interest Calculation – Interest Calculation – Define Reference Interest Rates
Currency INR
Time Dependent Terms can have one of the following four system-defined options.
Path: Financial Accounting (New) – General Ledger Accounting (New) – Business Transactions –Bank
Accounting Interest Calculation – Interest Calculation – Define Time-Dependent Terms
Sequential Number 01
Sequential Number 02
Path: Financial Accounting (New) – General Ledger Accounting (New) – Business Transactions – Bank
Account Interest Calculation – Interest Calculation – Enter Interest Values
G2 10%Monthly 01.07.2015 10
Go To FS00
Click On Create/Bank/Interest
Interest Indicator G1
GO TO FS00
Go To FS00
Path: Financial Accounting (New) – General Ledger Accounting - Business Transactions – Bank Account
Interest Calculation – Interest Posting – Prepare GL Account Balance Interest Calculation.
Click On Accounts
Enter
Go To F-02
Posting Key 40
Enter
Amount 100000
Posting Key 50
Enter
Amount 100000
Go To FS00
DocumentDate 25.07.2015
Posting key 40
ENTER
Amount 30000
Posting Key 50
Enter
Amount 30,000
Path: Accounting – Financial Accounting – General Ledger – Periodic Processing – F.52 Balances
Click On F.52
Execute
Click On Process
Click On Process
Validation
Validation in sap is used in document posting. In sap all input values are valuated either by a program or with a table.
However certain validations not carried on by these standard programs so you can have to specifically use validation
program to create validation rules in sap for your specific requirements
While entering a transaction in sap system will validate the combination that is entered and if it matches with the
requirement that is defined in validation rule in sap then it will allow you to post the transaction or else it will shown as error
message that the combination is not allowed.
If this type of validation error occurs then either you have to change the combination that you entered or you need to
change the validation rule.
Click On Validation
SAVE
Select AS01
Click On Step
SAVE
Click On Prerequisite
Click On =
Click On Constant
Enter
Click On Check
Click On =
Click On Constant
Enter
Click On Message
Enter
Message Variables
To Activate Validation
Go To F-02
Document Type SA
Posting Key 40
Account 4000000
Enter
Amount 10,000
Note: If you are not entered correct business area which we defined in validation rule. System throws error
message as above
Substitution
The substitution tools can be used to substitute data immediately upon entry.
Providing the profit center contents using a certain combinations of expense accounts, company code and business
partner. This can be set as a substitution in the system.
Substitution- In Substitution, the values entered into the SAP system are validated according to a prerequisite defined by
the user. If the prerequisite is met the system replaces the value entered with other values.
Click On Substitution
Click On Step
Enter
Enter
Select Prerequisite
Click On =
Click On Constant
Enter
To Activate Substitutions
Go To FB60
Vendor 9000000
Amount 100000
Enter
Text Service Vendor (System will pick the text from Substitution rule)
Accounts Payable
The Account Payable application Component records and administers accounting data for all vendor .It is also
an integral part of the purchasing system . Deliveries and Invoices are managed accounting according to
vendors. The system automatically makes postings in response to the operative transactions.
Posting made in Accounts Payable are simultaneously recorded in the General Ledger where different G/L
accounting are updated based on the transactions involved (payable and down payments, for example). The
system contains due date forecasts and other standard reports that you can use to help you monitor open
items.
Business Transactions are posted to accounts and managed using those accounts You must create a master
record for each account that you require. The master record controls that you can use to help you are recorded
and processed by the system.
As default values when you post items to the account. For example, the terms of payment you specify in the
master record are defaulted for document entry For processing business transactions For instance, bank details
and the payment methods (check or bank transfer, for example) are required for automatic payments.
For working with master records. You can present certain users from accessing an account by setting up
authorization groups’
Reconciliation accounts are managed implicitly using Sub Ledger Open item function.
Vendor 25 31
Vendor 29 39
Document Types
KR – Vendor Invoice
KZ – Vendor Payment
Vendor Accounts Could be grouped into Account Group. This Account Group can be defined on the basis of
various parameters defending upon business requirements
Note: Every Accounting Group is assigned to a number range .You can assign one number range to multiple
Account Groups. However ,You cannot assign multiple number ranges to the same Accounting Group.
General data segment: It contains total information of vendor Like address fields, poster code, telephone etc…
Company code segment: It contains total company code detailLike reconciliation account, payment terms,
house bank, interest indicator, dunning Ext….
Path: Financial Accounting (New) – Account Receivable and Account Payable – Vendor Accounts – Master
Data – Preparations for the Creative Vendor Master Records – Define Account Group With Screen
Layout(Vendor’s)
Maintain Fields
Internal Number Range: System will pick the number Range Automatically
Path: Financial Accounting (New) – Accounts Receivable and Accounts Payable – Vendor Accounts – Master
data –Preparation for Creative Vendor Master Records – Creating Number Ranges for vendor Accounts
Maintain Fields
No FromNu
m To Number
08 800000 899999
Path: Financial Accounting (New) – Accounts Receivable and Accounts Payable – Vendor Accounts – Master
data –Preparation for Creative Vendor Master Records – Assign Number Ranges to Vendor Account Group.
The Tolerance are used for differences in payment and residual items which can occur during payment
settlement. We can specify the Tolerances one or more tolerance groups. Allocate a Tolerance Group to each
vendor via the master records.
Tolerances Up to which differences in payment are posted automatically to Expenses or Revenue account
When Clearing Open item.
The handling of the terms of payments for Residual Items, If they are to be Posted During Clearing
Employee Tolerances also Can be specified. Employee Tolerance is used to control the Upper Limits for
posting procedures(Posting Authorizations) and Permitted Payment Differences. While Clearing The Lower
Limit of the 2 will be taken.
Path: Financial Accounting (New) – Accounts Receivable and Accounts Payable –Business Transactions –
Outgoing Payment – Manual Outgoing Payments – Define Tolerance.(Vendor’s And Customers).
Maintain Fields
Note: To Post the vendor invoice (we need create expenses G/L)
Maintain Fields
G/L Account 4001000(Expenses)
Company Code II02
Path: SPRO – Financial Accounting New – Account Receivable and Account Payable – Business
Transactions – Down payment Made – Define reconciliation accounts for down payment
Creation OF special G/L Indicator
Maintain Fields
Maintain Fields
Enter
Maintain Fields
Vendor Invoice KR
Vendor Payment KZ
Go To OBA7
Define document types and Number ranges for Vendor Payment OBA7
Path: Financial Account Global Settings (New) – Document – Document Types – Define Document
Type for Entry View
Go To OBA7
Number range 15
Maintain Fields
Cash Discount is a reduction in the price of Vendor Invoice, allowed in those cases when payment is
made within a stipulated period.
In general business scenario, the cash discount will depend on the payment terms agreed with the
Vendor .. Generally, in the invoice a payment term may be mentioned. For example, if the payment term
mentioned in the invoice is “2/10, 1/10 Net 30” this means that the Vendor is entitled to a 2% discount if
the payment is made within 10 days of the delivery of the delivery of goods. And 1% discount if the
payment is made within 20 days of the delivery of goods if the payment is being made beyond 30 days
of the delivery of goods then full payment is expected. In any case, the full payment is expected to be
made within 30 days.
PATH: Financial Accounting New – Accounts Receivable and Account Payable – Business
Transactions – Incoming Invoices/Credit Memos – Maintain Terms of Payment OBB8
Maintain Fields
Payment Terms II02
Company CodeII02
Path: Financial Accounting (New) – Account Receivable and Account Payable – Business Transaction –
Outgoing Payments –Outgoing Payment Global settings – Accounts for Cash Discount Taken
Enter
Note: In SAP, the standard transaction key SKE to determine accounts or posting keys for line items
which are created automatically by the system for cash discount granted.
In this configuration step the G/L account number to which the automatic posting for the cash discount is
to be made is assigned.
Vendor master records contain important data on your vendors. You can also in the vendor master
record that applies to certain specific organizational levels (e.g. Company code, purchasing
General data
Data that applies equally to each company code within your enterprise (address, telephone number,
language in which you communicate with your vendor, etc)
Data kept at the Company Code Level (Payment transaction data or number of control account, for
example)
Purchasing data
Data that is of Importance with regard to your enterprise’s purchasing activities and which is kept at
purchasing organization level ?(Such as contact person or terms of delivery).
PATH: Easy Access – Accounting – Financial Accounting – Account Payable – Master Records –
Create FK01
Maintain Fields
Enter
Maintain Fields
Title Company
Name SR Enterprises
Street/House number Ameerpeta 6-442
Postal Code /City 570002Hyderabad
Country IN
Region 01
Post Box 570002
Postal Code 570002
Enter
Note: Same Customer and Same Vendor Scenario Will Maintain “Customer Account” in this screen.
Enter
CODE Tables
IBAN TIBAN
Routing Code BNKA
Swift Code BNKA
Vendor Bank Masterdata LFBK
Enter
Enter
NOTE: The terms of payment can be maintained in the Vendor master. If the terms of payment are
maintained in the Vendor master, while entering an invoice against the Vendor, the terms of payment
maintained in the Vendor, master will default to the invoice. Like the baseline data, the terms of payment
can also be modified while entering the invoice, If required.
The terms of payment can be maintained in the company code segment.
Enter
This Screen will use while doing dunning
Enter
Click On Yes
Maintain Fields
Document Type KZ
Special G/L Q
Amount 20000
Enter
Enter
In the screen we can see the ‘Debit and Credit Line Items’
A commercial document that itemizes a transaction between a buyer and a seller. An invoice will usually include
the quantity of purchase ,price of purchase, price of goods and services and/or services, data , parties involved,
unique invoice number, and tax information. If goods or services were purchased on credit, the invoice will
usually specify the terms of the deal, and provide information on the available methods of payments
Maintain Fields
Amount 10000
Go To Document Simulate
SAVE.
PATH: Accounting - Financial Accounting – Account Payable – Display Change Line items
Maintain Fields
Click On Execute
Transfer Advance from Spl G/L to Normal by clearing Special GL Items F-54
PATH: Accounting - Financial Accounting – Account Payable – Document Entry – Document Payment –Clearing
Maintain Fields
Enter
We can see the balance transfer from spl down payment to normal Enter and SAVE.
PATH: Accounting - Financial Accounting – Account Payable – Document Entry – Outgoing Payment – Post
Maintain Fields
Amount 1
We can see cash discount in the screen which should be maintained in payment in ‘OBB8’
PATH: Accounting – Financial Accounting – Account payable - Document Entry – out going payment – post
Maintain Fields
Amount 30000
In this screen we can see the Debit and Credit line items for partial amount Enter and SAVE
PATH: Accounting – Financial Accounting – Account Payable – Account – Display change line items
Note: In this screen system will generate separate line item, and it will show the remaining balance.
Clearing of Normal Items (Same Down Payment and Same Invoice) F-44
Click On F-44
Save
Path: Easy Access – Accounting – Financial Accounting – Accounts Payable – Document – Parked Documents –
FV60 – Change: Single Screen Transaction
Amount 100000
Amount 100000
Text Expenses
Path: Sap Easy Access – Accounting – Financial Accounting – Account Payable – Document Parked Documents –
FBV0 – Post/Delete
Click on FBV0
Click on Execute
Enter
Enter
Enter
Note: No Need to Maintain Vendor number in customer master data, once will update customer Account number in
vendor master data, automatically system will pick vendor number in customer master data
Amount *1*
Amount 8000000
Remove “1”
Maintain “*”
Enter
Account Receivable
The Account Receivable application component and administers records and accounting data of all customer. It is also an
integral part of sales management. All postings in Accounts Receivable are also recorded directly in the General Ledger.
Different G/L accounts are updated depending on the transaction involved (for example, receivable, down payment).The
system contains a range of tools that you can used to monitor open item, such as account analysis, alarm reports, due
date lists, and flexible dunning requirements. This is also the case for payment notices, balance confirmations, account
statements, and interest calculation.
The Payment Program can automatically carry out direct debiting and down payments. There are a range of tools
available for documenting the transaction that occur in Account Receivable Including balance lists, journal, balance and
audit trails, and other standard reports. When drawing up final statements, the items in foreign currency are revalued,
Customer who are also Vendor are listed, and the balance on the accounts are sorted by remaining life.
It also provides the data required for effective credit management, (as a result of its close integration with the Sales and
Distribution component), as well as important information for the optimization of liquidity planning, (through its link to
cash Management).
Customer Invoice DR
Customer
PATH: Financial Accounting New – Account Receivable and Account Payable -- Customer Accounts -- Preparing for
Customer Master Data – Define Account Group With Screen Layout(Customer)
Note: Account Group Controls Number Ranges and Master data Fields
PATH: Financial Accounting New – Account Receivable and Account Payable – Customer Account – Master Date –
Preparations for creating Customer Master Data – Create Number Ranges for Customer Accounts
10 13000 13999
PATH: Financial Accounting New – Account Receivable and Account Payable – Customer Account – Master Date –
Preparations for creating Customer Master Data – Assign Number Ranges To Customer Account Group
Enter
The Tolerance are used for differences in payment and residual items which can occur during payment settlement. We
can specify the tolerances under one or more tolerance groups. Allocate a Tolerance Group TO each Vendor via the
master record
Tolerance up to which differences in payment are posted automatically to expense or revenue account when clearing
open items.
The handling of the terms of payment for residual items, if they are to be posted during clearing.
Employee Tolerances also can be specified. Employee Tolerance is used to control the Upper limits for posting procedures
(posting Authorizations) and Permitted Payment Differences.
PATH: Easy Access – Accounting – Financial Accounting – General Ledger – Master Records – G/L Accounts – Individual
Processing – FS00 – Centrally
PATH: Easy Access – Accounting – Financial Accounting – General Ledger – Master Records – G/L Accounts – Individual
Processing – FS00 – Centrally
Note: To Post the Customer Invoice (We need to create Sales Account GL (Revenue)
PATH: Easy Access – Accounting – Financial Accounting – General Ledger – Master Records – G/L Accounts – Individual
Processing – FS00 – Centrally
SPRO: Financial Accounting New – Account Receivable and Account Payable – Business Transaction – Down payment
Received – Define Reconciliation Accounts for Customer Down Payment
Name Domestic
Enter
Enter
200030 100030
Define document Types & Number Ranges for Customer Invoice OBA7
Customer Invoice DR
PATH: Financial Accounting Global Settings (New) – Document – Document Types – Define Document Type Entry View
Go To OBA7
Enter
Define document types & Number ranges for Customer Payment OBA7
Customer Payment DZ
PATH: Financial Accounting Global Settings (New) – Document – Document Types – Define Document Type Entry View
Go To OBA7
Enter
Cash Discount is a reduction in the price of Customer Invoice, allowed cases when payment is made within a stipulated
period.
In general business scenario, the cash discount will depend on the payment terms agreed with the customer.. Generally,
in the invoice a payment term may be mentioned. For example, if the payment term mentioned in the invoice is
“2/10;1/20 Net 30”, this means that the Vendor is entitled to a 2% discount if the payment is made within 10 days of the
delivery of goods. And 1% discount if the payment is made within 20 days of the delivery of goods if the payment is being
made beyond 30 days of the delivery of goods then full payment is expected. In full payment is expected to be made
within 30 days.
PATH: Financial Account New – Account Receivable and Account Payable – Business – Incoming Invoices/Credit Memos –
Maintain Terms of Payment
1 2% 10
2 1% 20
3 - 30
Explanations
Go To FS00
PATH: Financial Accounting (New) – Account Receivable and Account Payable -- Business Transactions – Incoming
Payments – Incoming Payment Global settings – Define Account for Cash Discount Granted
Enter
Note: In SAP, the standard transactions key SKT is used to determine accounts or posting keys for line items which are
created automatically by the system for cash Discounts granted.
In this configuration step the G/L account number to which the automatic posting for the cash discount is to be made is
assigned.
General data :Consists of Address, Control data, Payment Transaction etc. The account number is assigned to the
Customer at the client level. This ensure that the account number for a customer is the same for all company codes and
sales area.
Company Code Data: Consists Accounting Information, Payment Transactions Correspondence , Insurance, Withholding
tax etc.
Search Item: Should field with the short version of the customer name according to company rules/desires. An additional
search field also can be filled up
Group Key: Customer who belong to one corporate group can be bundled together by a user – defined group key. This
group key can be used for running reports, transaction processing or for match codes.
Accounting Clerk: The accounting clerk’s name has to be stored under an ID can be entered in the customer master
record of the account he or she is responsible for the accounting clerk’s name is then printed on correspondence and this
ID is used to sort dunning and payment proposal lists
PATH:`
Enter
Country IN
Region 01
Enter
NOTE: The terms of payment can be maintained in the Customer in the master. If the terms of payments are maintained
in the Customer master, while entering an invoice against the Customer, the terms of payment maintained in the
Customer master will default to the invoice. Like the business date, the terms of payment can also be modified while
entering the invoice, if required.
An initial amount paid at the time of purchase, in installment buying, time sales ,etc
PATH: Accounting – Financial Accounting -- Account Receivable – Document Entry – Down payment
Document Type DZ
Special GL 8
Amount 20000
Enter
In this Screen we can see the debit and credit line items
SAVE.
PATH: Sap Easy Access – Accounting – Financial Accounting – Account Receivable – Document Entry – FB70 – Invoice
Click On FB70
Amount 500000
Amount 500000
Enter
Click On FBL5N
Click On Execute
Enter
SAVE
Maintain Fields
Amount 50000
Business II02
SAVE.
Maintain Fields
Document 02.06.2015
Amount 60000
Maintain Fields
Document 02.06.2015
Amount 1
Enter
SAVE.
Account 1300000
Special GL 8
Amount 50000
Enter
Maintain Fields
Amount 50000
SAVE.
PATH: Sap Easy Access – Accounting – Financial Accounting – Account Receivable – Document Entry – FB70 – Invoice
FB70
Click On FB70
Amount 500000
Amount 500000
Enter
Clearing Normal Item (Same down Payment and same Invoice) F-32
PATH: Accounting – Financial Accounting -- Account Receivable – Clear F-32
SAVE.
Credit Memo
A credit memo is a contraction of the term “credit memorandum,” which is a document issued by the seller of goods or services to
the buyer, reducing the amount that the buyer owes to the seller under the terms of an earlier invoice. The credit memo usually
includes details of exactly why the terms of an earlier invoice. The credit memo usually includes details of exactly why the amount
stated on the memo has been issued, which ca n be used later to aggregate information about credit memos to determine why the
seller is issuing them.
A credit memo may to be issued because the buyer retuned goods to the seller, or there is a pricing dispute, or a marketing
allowance, or other reasons under which the buyer will not pay the seller the full amount of the invoice. The seller records the credit
memo as a reduction of its accounts receivable balance, which the buyer records it as a reduction in its accounts payable balance.
KG 17
Go To FBN1
Company Code II02
Vendor 8000000
Amount 100000
Amount 100000
Enter
Go To Document Simulate
In this Screen we can see the Expenses Debit 100000
PATH: Accounting – Financial Accounting – Account Payable – Document Entry – FB65 – Credit Memo
Amount 20,000
Amount 100000
Enter
Click On Execute
In this screen we can see the vendor balance amount after Credit Memo 80,000-
Debit Memo
Debit memo request is a sales document used in complaints processing to request a debit memo for a customer. If the
prices calculated for the customer were too low, for example , Calculated with the wrong scaled prices. You can create a
debit memo request. The debit memo request can blocked so that it system uses the debit memo request to create a
debit memo.
DG 16
Go To FBN1
Company Code II02
Go To FB70
Customer 1300000
Amount 200000
Amount 200000
Enter
Customer 1300000
Amount 40000
Amount 200000
Enter
Click On Execute
In this screen we can see the vendor balance amount after Credit Memo 40,000-
Tax configurations are done in SAP at the country level. This is because of all businesses in the same country
need to follow the same taxation policies and generally accepted accounting principles while preparing their
financial statements. Therefore, tax configurations in SAP are done for each country. Any company code which
is created in that country then automatically use the tax configuration that is done for that country.
Input and output tax is calculated on revenue or expense items (base amount).The tax amounts are posted to
separate tax accounts and refunded by the tax office (input tax) or paid to the tax office (output tax).The tax
percentage rates vary from country to country and are determined when you define the tax codes.
The tax amount is determined as a percentage of the base amount, meaning that the tax amount is included in
the invoice amount. The tax amounts are automatically posted to tax accounts.
Tax Code
TheTax code is a 2-digit code specifying the percentage of tax to be calculated on the base amount. While
defining the tax code, you will also specify the ‘Tax Type’ to classify a tax code relating to either ‘Input Tax’ or
‘output Tax’. The tax types are country specific and determine how a tax is calculated and posted.
Tax Rate
The Tax Rate is the percentage of tax to be calculated on a base amount. You will be able to define tax rates for
one or more tax types when you define a single tax code.
Enter
Maintain Country IN
Enter
IN India ZTAXIN
SAVE
Note : No Need to change anything we can use existing Input and Output Tax Account Keys
Tax Category *
Tax Category *
In ob40,you can assign Tax GL accounts against respective tax codes. For this you have to tick tax codes under
rule in OB40 for the accounting processing keys.
And while creating tax codes. You have to define whether the code is for input tax or output tax by selecting V
or A. From there the system derives whether the tax code is for input tax or output tax.
Enter
SAVE
Account 1000900(Liability)
SAVE
Account 2000900(Asset)
SAVE
Click On Define Tax Codes for Sales and Purchases for INPUT TAX
Maintain Country IN
Enter
Enter
Enter
SAVE
Click On Define Tax Codes for Sales and Purchases for OUTPUT TAX-FTXP
Maintain Country IN
Enter
Enter
Enter
SAVE
Go To FB60
Maintain Fields
Vendor 8000000
Text Expenses
Enter
Note : Once you click on enter, Automatically system will calculate tax and it will update in header level Balance
Box “1100”(System Shows including tax amount)
Enter
Maintain Fields
Customer 2000005
Enter
Note : Once you click on enter, Automatically system will calculate tax and it will update in header level Balance
Box “1150”(System shows including tax amount)
Enter
DUNNING
Dunning In Sap Is The Process To Send Remainders To Business Partners From Whom Payments Are
Due.SAP Allows The Messages Which Are Sent To range from simple remainders to strong messages
indicating legal action. SAP makes use of payment terms to identify the credit period that is offered to a
particular customer and subsequently the line items for which the payments are due. The Dunning Process
picks up these items and sends a message to the concerned business partner reminding about the due
payment.
The Dunning program makes use of the dunning areas to identify the entities for which the Dunning is to be
carried out. It is not necessary to carry out Dunning for a company code. Dunning can be carried out for a
smaller entity within a company code like a sales organization. The Dunning program also allows the Dunning
charges to be imposed to customers who have delayed the payments. Interest calculation is possible in the
Dunning program for the payments which have been delayed.
Different messages are sent to the business partners at different Dunning levels. The tone of the messages can
move from a gentle reminder to one indicating legal action as the Dunning level increases. Grace period can be
provided to customers to provide them with tome to make the payments depending on their past payment
record and overall credibility. The Dunning procedure is defined at the client level and is therefore available to
be used in multiple customer masters.
Maintain Fields
Dunning procedures are company code independent. They determine the dunning
interval, the grace periods for the due date determination, and the number of dunning
levels. You can also set the dunning levels at which you want to list all due items from
an account in the dunning notice.
Maintain Fields
No of dunning levels 3
ENTER
ENTER
ENTER
Maintain fields
1 F150_BE_DUNN_02
2 F150_BE_DUNN_02
3 F150_BE_DUNN_02
Click on charges
ENTER
1 100
2 200
3 300
Customer Invoice
Go To FB70
Amount 200000
Amount 200000
ENTER
SAVE
Maintain fields
Identification II02
Customer 1300000
Click on schedule
Click on continue.
ENTER
Click on continue
ENTER
Customer 1300000
Click on execute
Click on continue
Withholding Tax
Withholding tax is applicable in few countries.Some of the countries which have withholding
tax are United
Kingdom,Slovakia,Turkey,Argentina,Brazil,Chile,Colombia,Mexico,India,Phillippines,Thailand
and South Korea.SAP has given an excellent solution to map the withholding tax scenario.
In any business transaction there are two parties involved.One is the customer and another is
the vendor.A customer is authorized to deduct withholding tax for services rendered by the
vendor.When the vendor raises the invoice on the customer.The customer deducts the
withholding tax as per the rates specified by the tax authorities and pays the balance money to
the vendor.
The tax deducted by the vendor is remitted to the tax authorities on specified due dates.The
vendor gives a withholoding tax certificate to the customer for the withholding tax deducted.
The customer can claim this withholding tax(as advance income tax paid) in his annual returns
to income tax authorities.In some countries(like India) the withholding tax is deducted on
Invoice or payment whichever is earlier.Thus when an advance is paid to the vendor the
customer is required to deduct withholding tax on the advanced payment
When the Vendor submits an Invoice the customer is now required to deduct tax on the Invoice
amount reduced by the advance payment.
To calculate pay and report the withholding tax,the SAP system provides two functions:-
Extended Withholding tax includes all the function of classic withholding tax;SAP therefore
recommends the use of extended withholding tax.
Tax – Extended Withholding Tax – Basic Settings – Check withholding Tax Countries
Country IN
Enter
IN IN INDIA
Tax – Extended |Withholding Tax – Basic Settings – Check Withholding Tax countries
Country key IN
Enter
192 Salary
194A Interest
194I Rent
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax – Basic Settings – India – Define Business Places
Enter
Title Company
Street Madhapur
Enter
SAVE
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax – Basic Settings – India –Assign Factory Calendars to Business
Places
Company Code Business Place Factory Calendar Tax Due Date Rule
Note: Once you enter the parameters you will get this message
Table/View J_1BBRANCH
Table/View J_1BBRANCH
Enter
Enter Back
Company Code Business Place Factory Calendar Tax Due Date Rule
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax – Basic Settings – India –Define Section Codes
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax – Calculation – Withholding Tax Type – Define Withholding Tax
Type for Invoice Posting
Country Key IN
Enter
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax – Calculation – Withholding Tax Type – Define Withholding Tax
Type for Payment Posting
Country Key IN
Enter
Enter
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Withholding tax Code: it determines the various percentage rates for the withholding tax type
Country Key IN
Posting Indicator 1
Posting Indicator 1
Posting Key Indicator: If you set the Posting Indicator “1”,The withholding tax amount is
deducted from the vendor line item amount and or bank line item, and a withholding tax line
item automatically created.
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax - Company Code-Assign Withholding Tax Types to Company
Codes
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Enter
SAVE
Go To FS00
Check 001
SAVE
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax – Posting-Accounts for Withholding Tax-Define Accounts for
Withholding Tax to be Paid Over
Enter
Z1 Z1 1002000
Z2 Z2 1002000
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Numbering Class 01
Enter
Note: Once you press enter automatically system will pick numbering group
SAVE
Note: Once you press save button system will pick number range automatically
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
II02 KZ
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Company Code Section Code Official Withholding Tax Key Number Group
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
19 01
Enter
and SAVE
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Click On Groups
Enter
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax – Posting-India-Withholding Tax Certificates for Vendors and
Customers-Maintain Number Groups and SAP script Forms
Company Code Section Code Withholding Tax Key From Number Group
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax – Posting-India-Withholding Tax Certificates for Vendors and
Customers-Assign Number to Number Groups
19 01
Path: Financial Accounting (New) – Financial Accounting Global Settings (New) – Withholding
Tax – Extended Withholding Tax – Posting-India-Withholding Tax Certificates for Vendors and
Customers-Maintain Number Ranges
Click On Groups
SAVE
Table/View J_1IEWT_CERTNO
Click On Maintain
19 01
Table/View J_1IEWT_CERT_N
Click On Maintain
Back
Table/View J_1IEWTNUM
Click On Maintain
Back
Table/View J_1IEWTNUMGR
Click On Maintain
Number Group 19
Table/View J_1IEWTNUMGR_1
Click On Maintain
Back
Table/View J_1IEWTNUMGR_N
Click On Maintain
Back
Table/View J_1IEWT_ACKN
Click On Maintain
Back
Table/View J_1IEWT_ACKN_N
Click On Maintain
Vendor 8000000
Enter
Note:If you maintain payment Tax Code in Vendor MasterData.TDS will be deduct while doing
the final payment using F-53/F110 which should not deduct the TDS.Hence will not maintain
the payment tax code in vendor master(Those tax code well always be blank)
Liable:If you set this indicator,you tell the system that the vendor is subject to withholding tax
for this withholding tax type.
Click On Assign users to material master screen sequence for Excise Duty
Name SAPUSER
Go To FK02
Vendor 8000000
Enter
SAVE
Go To F-48
Account 8000000
Account 2000102
Amount 50000
Enter
Amount
Text
Enter
Z2
Enter
Go To FB60
Vendor 8000000
Amount 100000
Amount 100000
Enter
Go To F-54
Note:While doing the down payment TDS will be deducted from the down payment and need
to reverse the amount using the F-54 with reference of invoice.
Go To J1INCHLN
Section 192
Vendor 8000000
Click On Execute
Amount 1
Enter
Remove 1
SAVE
Go To J1INBANK
Maintain
Enter
Click On Execute
Go To J1INCERT
Section 192
Vendor 8000000
Signatory SRIRAM
Designation Lead
Click On Execute
In this form 16 Certificate we can see the Deducted TDS Amount 10000
The Automatic Payment Program has been developed for both national and international
Payment transaction with vendors, and handle outgoing payments.
Automatic Payment Program serves the purpose of posting accounts payable (Payment to a
vendor) based on vendor invoices automatically shortly termed as APP
APP automatically issues cheques, prints covering letters for mailing along with cheques &
posts entries in the books of accounts
You have the option of paying Special G/L Transactions(Ex:Advancdes to vendors)using APP
APP can be configured to take into account Terms of Payments for the purpose of obtaining
Cash Discount benefit
A Consistenly high volume of invoices have to be processed. Accounts Payable Invoices have to
be paid on time to receive possible discounts. The accounting department wishes to perform
this processing of invoices automatically.T he Automatic Payment program is a tool that will
help users manage payables
CONFIGURATION PHASE
Here, we define the configuration setting for implementing APP. It consists of the following
steps.
EXECUTION PHASE
The Configuration Phase is performed from SPRO/IMG menu as a one-time activity. The
Execution Phase is performed from the Main Menu as a routine business activity at
periodic intervals
The list of all execution parameters specified by the users for running an APP,are
Defined in a Payment Program Run. Every Run is uniquely identified by Run ID (5-digit
user-defined code)
Run Date
The Run Date is generally taken as the actual date of execution of the Payment Program
Run. But the user has the option of giving any other Run Date.
The Run Date serves as an identification feature.
The Run Date and Run ID under which a given payment document has been generated
will be mentioned in the header of the payment document
You can include more than one co.code in the same APP Run. However, in such a case all
the co.codes included in the APP Run should belong to the same country.
Examples of payment Methods for which we can use APP are cheque Payment,
Electronic Transfer, Bills of Exchange etc.
The amounts for minimum incoming payment and minimum outgoing payment
could be given as per the organization standards.
Before APP Run,we must have an open item.for that we have to create a vendor invoice
You will see the open line item with a red colored indicator as show above.Now go to
Rransaction ‘F110’,give the date of APP Run and any 5 digit alpha-numeric characters as
identification.
Click On All Company Code
Click On New Entries
Company Code II02
Sending Company code II02
Check Separate Payment per business area
Enter and SAVE
Back
Click On Paying company code
Click On New Entries
Paying Company code II02
Minium amount for incoming payment 100
Minium amount for Outgoing payment 100
Check Separate Payment for each reference
Click On Forms
SAP Script F110_IN_AVIS
Click On Sender Details
Text ID ST
Enter and SAVE
Back
Click On Payment Methods in Country
Click On New Entries
Country IN
Payment Method F
Description Check
Check Radio Button Outgoing Payments
bank account ID.a Check lot needs to be maintained.This will correspond with the Check
Serial numbers in use.The first and last number has to be defined in the system and
system automatically allots / tracks the check number with payment documents and
update the latest check number issued/ used from the system
Financial Accounting (New)- Accounts receivable & Accounts payable-Business
transactions-Automatic outgoing payment-payment media-Check management-Define
number ranges for checks FCHI
Paying Company Code II02
House Bank HDFC
Account ID HDFC
Click On Change Button
Click On Create
Lot Number 01
Check Number 1000
To 1999
Lot Number Short Information on the Lot Check No From Check Number to
1 Check Lot for HDFC 1000 1999
Enter and SAVE
Vendor Invoice Posting
Go To FB60
Vendor 8000000
Invoice Date 03.06.2015
Posting Date 03.06.2015
Amount 200000
Text Customer Invoice
G/L Account 4000000
Amount 200000
Text Salary Paid
Enter
Go To Document and simulate
Enter and Save
Due On 07.03.2015
Text Down Payment Request
Enter and SAVE
To View Vendor Line Items
Go To FBL 1N
Vendor Account 8000000
Company Code II02
Check Open Items
Check Special G/L Transactions
Check Noted Items
Click On Execute
In this screen we can see the Vendor down payment request (F) 50,000
Vendor Invoice 2,50,000
Maintain Down Payment Request In FBZP
Go To FBZP
Click On All Company code
Company Code II02
Enter
Double Click On Line Item II02
Special G/L Transactions to be paid FQ
Note : F For Vendor Down Payment Request
Q For Special G/L Indicator for Vendor
Enter and SAVE
Automatic Payment Run F110
Path : Accounting-Financial Accounting-Accounts Payable-Periodic Processing-
Payment
Run Date 05.07.2015
Identification 100
Click On Parameter
Company Code II02
Payment Method F
RFFOUS_C II02
Click On Maintain Variants
Check Full Screen
Enter
Program Run Date 05.07.2015
Identification feature 100
Payment Method F
House Bank HDFC
Account ID HDFC
Check Lot Number 1
Check Print Checks Printer LP01 Check Print Immediately
Check Print Checks Printer LP01 Check Print Immediately
Check Print Checks Printer LP01 Check Print Immediately
Remove Number of Sample Print out
Check Do Not Void Checks
Click On Attributes
Maintain Description II02
SAVE and Back
SAVE
Click On Printout
Remove ? Mark and Maintain II02
Enter
Click On Execute
House Banks
Each house bank in sap system is associated with a country key representing the country where the bank is located.
House bank can have more than one account id, account id is unique for a specific bank id and company code. The
account id is used for entering specifications for the payment program.
Configuration of bank accounts for payment transactions is an important step. This is to ensure that for each house bank
and payment method (and currency, if required), you specify which bank account is to be used for payments. Bank
subaccounts are used to post incoming and outgoing payments (accounts for outgoing checks, outgoing bank transfers,
and bank collection).
Bank Country IN
Region 01
Street Madhapur
City Hyderabad
Enter
Account ID HDFC
Currency INR
Path: Financial Accounting (New) -- Accounts receivable & Accounts payable -- Business transactions -
- Automatic outgoing payment-- Payment media -- Check management -- Define number ranges for
checks
Account ID HDFC
Click On Create
Lot Number 01
To 1999
Lot Number Short Information on the Lot Check No From Check Number to
Manual Check Creation is used to assign Check number from the system to a manually issued Check. This willrecord the
Check number for the payment document posted directly for a handwritten Check.
Account ID HDFC
Account ID HDFC
Execute
Account ID HDFC
Enter
Account ID HDFC
Execute
Enca./Vaid 22.07.2015
Account ID HDFC
Execute
Click On Yes
Account ID HDFC
Execute
To void unused Checks in the system. This can be used to prevent users from selecting the unused Check lots before
payments.
Paying Company Code II02
Account ID HDFC
Click On Void
Account ID HDFC
Execute
Path: SPRO -- Financial Accounting -- Accounts Receivable and Payables -- Business Transactions -- Outgoing
Payments -- Automatic Outgoing Payments -- Payment Media -- Check Management -- Define Void Reason Codes.
70 Stop Payment
Account ID HDFC
Execute
Account ID HDFC
Reversal Reason 01
Execute
Bank reconciliation Statement is reconciliation between the account maintained by your company and the
account maintained by the bank. There can be instances where both the accounts will not tally.
EX Suppose you have given a cheque to your vendor has not presented it to bank for payment till date.
Because of these transaction there will be a mismatch between the account maintain at your
company and account maintained by bank While giving a cheque to your vendor you have entered it as a
business transaction in your books of account by crediting your bank account, but bank is not is aware such
transaction as they have not received the cheque yet. There can be some other reason for which your
company’s account and the bank statement will not tally. Periodically it is the responsibility of the accounts to
prepare a bank reconciliation statement and produce the same before the management to know if they are any
discrepancies.
If you receive an electronic statement then you just need to upload it to sap for the purpose of preparation of
bank reconciliation statement, if it is manual one then you need to enter statement manual one then you need to
enter statement manually into sap.
System provides automatically as well as manually, transaction facility for all receipts and payment entries in
the bank statement and our bank book.
System provides list of un-reconciled entries, for further decision making and matching. In SAP system the
reconciliation process is known under two methods. Manual and Automatic. Every Bank account will have 4
General Ledger Accounts. First will be a main GL for the bank, second will be “Incoming Clearing” for all
receipts, third will be “Out going Clearing” for all payment and fourth will be “un reconciled account , After the
reconciliation process , payment and receipt entries in the incoming, outgoing and un reconciled GL will be
transferred in to the bank Main GL. The balances in the main bank account will be equal to the bank statement
amount.
Bank Charges Dr 40
To Main Bank Cr 50
To Main Bank Cr 50
Main Bank Dr 40
To Interest received 50
In case of Non – Availability of bank statements in the desired electronic formats. We can create and upload
Bank Statement data to be provided by the user.
In the header data, Bank statement operating opening and closing balances are provided before creating the
bank statement. This is the control check after entering all the lines in the bank statement.
After providing the bank statement header data we need to enter or create the bank statement in the system.
The posting of this statement or after batch input session. This process creates postings in the main bank
account. The accounting entries are passed as mentioned below.
Unmatched entries generated by the system are to be matched manually through?(FEBA). Later on these
unmatched entries need to be manually transferred to “Un reconciled Account”.
For the process of automatic bank reconciliation , electronic bank statement is required in pre defined format
only
Uploading the bank statements received from banks in the above mentioned format using transaction code
FF_5
After the uploading of this statement the process creates postings in the main bank account. The accounting
entries are passed as mentioned above.
The un-reconciled items will remain as open items in “un reconciled account” which can be reconciled manually
Through this session we can clear the un-posted (un-reconciled)items from the above mentioned
manual &automatic processes
The session enables us to select any of the bank statements created by us based on statement date
and identification key.
We can correct the selected items one after another. At the end, post again for all changed items
PATH: Financial Accounting (New) – Bank Accounting – Business Transactions – Payment Transactions –
Payment Transactions – Manual Bank Statement – Create and Assign Business Transactions
Define Posting Keys and Posting Rules for Manual Bank Statement
PATH: Financial Accounting (New) – Bank Accounting – Business Transactions – Payment Transactions –
Manual Bank Statement – Define Keys and Posting Rules for Manual Bank Statement
Click On Define Posting Keys and Posting Rules for Manual Bank Statement
Enter
Account Text
Debit Credit
Posting Key 40
Debit Credit
Debit Credit
Posting Key 40
Debit Credit
Posting Key 40
Debit Credit
Posting Key 40
Click On Position
Enter
Z001 + Z001
Z002 - Z002
Z003 - Z003
Z004 - Z004
Z005 + Z005
Click On Create
Variant II02
Enter
Enter
Click On Activate
Note: Before going to update ‘Manual Bank Statement’ need to have debit and credit line items in bank
accounts (Incoming and Outgoing Bank)
Go To FBL3N
Click On Execute
Currency INR
Statement Number 1
Opening Balance 0
Click On Process
Enter
Enter
Go To FBL3N
Click On Execute.
For the process of automatic bank reconciliation, electronic bank statement is required in pre defined format
only.
Uploading the bank statement received from banks in the above mentioned format using transaction code FF_5
After the uploading of this Statement, the process creates postings in the main bank account. The accounting entries are
passed as mentioned above.
The un-reconciled items will remain as open items in “un reconciled account “ which can be reconciled
manually.
Through this session we can clear the un-posted (un-reconciled) items from the above mentioned manual &
automatic processes.
The session enables us to select any of the bank statement created by us based on statement date and
identification key
We can correct the selected items one after another, At the end, Post again for all changed items
PATH: Financial Accounting New – Bank Accounting – Business Transactions – Payment Transaction –
Electronic Bank Statement – Make Global Settings for Electronic Bank Statement
: 20:20150805
: 25:2254879124514
:28C:02
:60f: C150805INR290.000,00
:61: 1508050805C30.000.00FCHAONREF//
:61: 1508050805C30.000.00FCHBONREF//
61: 1508050805C1.000.00FCHCONREF//
61: 1508050805C2.000.00FCHDONREF//
:61: 1508050805C3.000.00FCHEONREF//
:62f:C150805INR267.300,00
Note: If we want to upload Electronic Bank Statement we need to maintain format like
60f:Opening Balance
Click On FF_5
Click On Execute
Click On Allow
Enter
Enter
Enter
Click On FEBA
Click On Execute
Click On FF_6
Company CodeII02
Statement Number 1
Execute
The Automatic Payment Program has developed for both national and international payment transactions with
vendors, and handle outgoing payments.
Automatic Payment Program serves the purpose of posting accounts payable (payment to vendor) based on
vendor automatically shortly termed as APP.
APP automatically issues Cheques, prints converting letters for mailing along with the cheques& posts entries in
the books of accounts
You have the option of paying Special G/L Transaction (Ex: Advance for Vendor) using APP. Discount benefit
A consistently high volume of invoices have to be processed Account Payable have to be paid on time to
receive to possible discounts. The accounting department wishes to perform this processing of invoices
automatically .The Automatic Payment Program a tool that will help users manage payables.
CONFIGURATION PHASE
Here we define the configuration settings for implementing APP, It consists of the following steps.
EXECUTION PHASE
The Configuration Phase is performed from SPRO/IMG menu as a one – time activity.
The Execution Phase is performed for the Main Menu as a routing business activity at periodic intervals
The list of all execution parameters specified by the users running an APP , are defined in a payment program
Run ID (5- digit user – define code)
Run Date
The Run Date is generally taken as the actual data of the Payment Run , But the user has option of giving any
other Run Date.
The Run Date and Run ID under which a given payment document has been generated, will be mentioned in
the header of the payment document
You can include more than one co code in the same APP Run, However, in such a case all the co. codes
Example of payment Methods for which we can use APP are Cheque Payment, Electronic Transfer. Bill of
Exchange, etc.
PATH: Financial Accounting New – Account Receivable and Account Payable – Business Transactions –
Outgoing Payments – Automatic Outgoing Payment – Payment Method/Bank Selection for payment program
The amounts of minimum incoming payment and minimum outgoing could as per the organization standards.
Before APP Run , we must have an open item, for the we have to create a vendor invoice
You will see the open line item with a red colored indicator as shown above. Now go to Transaction ‘F110’,give
the date of APP Run and any 5 digits alpha-numeric characters as identification.
Text Id ST
Back
Country IN
Payment Method G
Description Check
Back
Payment Method G
Back
G INR 1 HDFC
G INR 2 ICICI
Vendor 8000000
Enter
Payment Method G
Go To FBN1
PATH: Financial Account New – Account receivable & Account Payable –Business Transaction – Automatic
Outgoing Payment – Payment media – Check management – Define number ranges for Checks
Account ID HDFC
Click On Create
Lot Number 01
To 1999
Amount 200000
Amount 200000
Go To FBL1N
Click On Execute.
Go To OBYR
Enter
1001000 2001000
Click On Properties
Click On F-47
Account 8000000
Enter
Amount 50000
Due On 03.07.2015
Click On Execute
In this screen we can see the vendor down payment request (F) 50,000
Enter
Identification 100
Click On Parameter
Payment Method G
Vendor 8000000
Enter
Enter
In this payment proposal screen we can see the down payment request and vendor invoice
Document No Amount
Enter
Enter
In This Screen we can see the Payment Run has been carried out
Payment Method G
Account ID HDFC
Click On Attributes
SAVE
Click On Printout
Enter
Click On Execute
A data medium exchange is data exchange file which is used to send payment information of enterprise to
banks. Basically these files contain financial data which can be in flat file or xml file format. Different file format
can be created for different countries and different banks based on their own which replaces conventional
ABAP programs.
Relevant Acronyms:
Go To FBZP
Click On Display
Click On Source
Here we can see the constant Value which is available in standard sap 02
Click On Source
Here we can see the constant Value which is available in standard sap 1001
Click On Source
Here we can see the constant Value which is available in standard sap 98989898
Click On Source
Here we can see the constant Value which is available in standard sap 0021
Note: In this DMEE Screen no need to do any changes we can observe the Fields
Go To OBPM1
Go To OBPM4
Click On Yes
Check Created
Enter
Enter
Installation ID 10
User ID 100
Holiday Calendar Id 90
Enter
Enter
Go To AL11
Click On Attribute
SAVE
Click On Back
SAVE
Asset Accounting
The Asset Accounting component is used for managing and supervising fixed assets. In SAP Financial
Accounting, it serves as a subsidiary ledger to the FI General Ledger, providing detailed information on
transactions involving fixed assets.
Fixed Asset Management is an accounting process that seeks to track fixed assets for the purposes of financial
accounting.
Organizations face a significant challenge to track the location, quality, condition, maintenance and depreciation
status of their fixed assets. A popular approach to tracking fixed assets uses serial numbered assets tags,
which are labels often with bar codes for easy and accurate reading. The owner of the assets can take
inventory with a mobile code reader and then produce a report.
The depreciation posting run and its parallel valuation is a main feature within Asset Accounting
Fixed asset can be divided into:-- Tangible fixed assets (machinery, buildings)
When the SAP is being implemented, the main task to map theorganization and structure of the enterprise in
the system.
Chart of Depreciation
Chart of depreciation is a list of depreciation areas arranged according to business and legal requirements. The
chart of depreciation enables you to manage all rules for the valuation of assets in a particular country or
economic region
SAP provides with predefined chart of depreciation for certain countries. These are also known as Reference
COD’s
Copy one of these Reference chart of depreciation to a user-defined COD, and make appropriate modifications
based on your business and legal requirements
Note: It is mandatory to assign a chart of depreciation to every co. code that uses Asset Accounting.
Note: You May assign multiple co. COD. But you cannot assign one co code to multiple COD’s.
Note: Every COD may contain several depreciation areas. You may activate only those DA’s that you require at
present and deactivate the rest
Cost Depreciation
Book Depreciation: Is usually post to the Accounts monthly base as u can calculate day wise also, which will
be creating a accounting document with accumulate depreciation
PAHT: SPRO – Financial Accounting New -- Asset Accounting – Organization Structures – Copy Ref chart of
Depreciation / Depreciation AreasEC08
Enter
Click On No
Enter
Select the rest of depreciation areas except the book depreciation and Tax Depreciation select delete button
SAVE
In this activity you define an incoming and outgoing tax code for each company code, to be used for posting
non-taxable Transactions posted like this are, for example; goods issue delivery, goods receipts purchase
order, goods receipt production order, order accounting.
PATH: SPRO – Financial Accounting New – Financial Accounting Global Settings – Tax on Sales and
purchases – Postings – Assign Taxable Transactions
OBCL
Enter
V0 A0
PATH: Financial Accounting New – Asset Accounting – Organization Structure – Assign Chart of Depreciation
to Company Code OBOB
The key of an account determination for must be stored in the asset class. In this way , the account
determination links an asset master record to the general ledger accounts to be posted for an accounting
transactions using the asset class
You specify the general ledger accounts to be posted for the individual accounting transactions in later
implementation activities. You can specify various accounts for each depreciation area to be simultaneously
posted to G/L.
PATH: SPRO – Financial Accounting New – Asset Accounting – Org. Structure – Asset Class – Specify
Account Determinations
Maintain Fields
Z111 Buildings
Screen Layouts for maintaining asset master data Using the screen layout rule. You can define which fields are
required, optional and suppressed, which fields are copied, when creating an using another asset master record
as a reference.
You can define screen layout rules for general master data and for depreciation parameters within depreciation
areas.
Note: Screen Layout Rules is nothing but a field statues variant we can control the fields Asset Master Data
level and Depreciation Area level
PATH: Financial Accounting New – Asset Accounting – Org. Structure – Asset Classes – Create Screen Layout
Rules
Z111 Buildings
PATH: SPRO – Financial Accounting New – Asset Accounting – Org. Structure – Asset Class – Define Number
Range Interval AS08
Maintain Intervals
01 1000 1999
02 2000 2999
03 3000 3999
04 4000 4999
The asset class is the main criterion for classifying assets. Every asset must be assigned to only one asset
class. Examples of asset class are Plant & Machinery, Furniture and Fixtures, Computers, etc. The asset class
also contains the G/L accounts which are debited when any asset is procured. It also contains the gl accounts
for depreciation calculation, scrapping etc.
Whenever you create an asset master you need to mention the asset class for which you are creating the
required asset. In this manner whenever any transaction happens the gl accounts attached to the asset class is
automatically picked up and the entry passed. You can specify certain control parameter and default values for
depreciation calculation and other master data in each asset class.
PATH: SPRO – Financial Account New – Asset Accounting – Org. Structure – Asset Class – Define Asset
Classes OAOA
Maintain Fields
Number Range 01
Maintain Fields
Number Range 02
Maintain Fields
Number Range 03
Maintain Fields
Number Range 04
Check Line Item Settlement (Auc was need to settle line itemwise)
PATH: SPRO – Financial Accounting New – Asset Accounting – Valuation – Set Chart of Depreciation
Enter
Calculation Methods
Note: It will calculate depreciation on Posting Base, will use standard Base Method in SAP ‘0014’
In this Method we can define whether it is straight line method or written down method based on the base value
Maintain Fields
Maintain Fields
9999 999 12 24 10
Maintain Fields
Maintain Fields
9999 999 12 24 11
Maintain Fields
Maintain Fields
9999 999 12 24 12
In this method it controls the postings of asset transactions like acquisition and retirement. According to the
posting period control only we can have the addition of the asset
The specifications and parameters that the system requires to calculate depreciation amounts are entered in
Calculation methods. Calculation methods replace the internal calculation key of the depreciation key,
Depreciation keys are defaulted in Asset Master from the asset class.
It contains the rate of depreciation (10%,5%), Method of depreciation (Straight line methods or written down
method), Default values from company code (Memo Value and Cut off Value), Mode of depreciation
(Depreciation start from purchase date or start from ordinary depreciation and it will calculate day wise
depreciation also. It contains Valuation of the methods (Base Method, Declining Balancing Method, Multilevel
Method, Period Control Method).
Maintain Fields
Maintain Fields
Maintain Fields
Maintain Fields
Maintain Fields
Maintain Fields
PATH: Financial Accounting New – Asset Accounting – Valuation – Determine Depreciation Areas in the Asset
Class OAYZ
Enter
Maintain Fields
Layout 1000
Enter
Back
Maintain Fields
Layout 1000
Enter
Back
Maintain Fields
Layout 1000
Enter
Back
Maintain Fields
Layout 1000
Enter
Screen Layout
Define Screen Layout for Asset Master Data
PATH: SPRO – Financial Accounting New – Asset Accounting – Master Date – Screen Layout – Define Screen
Layout for Asset Master Data
Enter
Select Z111(Buildings)
SAVE
SAVE
SAVE
SAVE
PATH: SPRO – Financial Accounting New – Asset Accounting – Master Data – Screen Layout – Define Screen
Layout for Asset Depreciation AreasAO21
ORDINARY
400040 EXPENS
II04 X DEP. FOR P & X X 001 G004
2 ES
M
ORDINARY
400040 EXPENS
II05 X DEP. FOR F & X X 001 G004
3 ES
F
PATH: Financial Accounting New – Asset Accounting -- Integration with General Ledger Accounting – Assign
G/L Accountings
Enter
Maintain Fields
Enter
Maintain Fields
Acc.dep. account for ordinary depreciation 5000001 Accumulated depreciation for Building
Expense account for ordinary depreciation 4000001 Ordinary depreciation for Building
Maintain Fields
Enter
Maintain Fields
Acc.dep. account for ordinary depreciation 5000003 Accumulated depreciation for P&M
Maintain Fields
Enter
Maintain Fields
Acc.dep. account for ordinary depreciation 5000004 Accumulated depreciation for F&F
Expense account for ordinary depreciation 4000004 Ordinary depreciation for F&F
Maintain Fields
Maintain Fields
Depreciation Key Z11 No need to enter ‘D key’ system will pick automatically
Use life 99
Period 11
Maintain Fields
Depreciation Key Z12 No need to enter ‘D key’ system will pick automatically
Use life 50
Period 11
Maintain Fields
Depreciation Key Z13 No need to enter ‘D key’ system will pick automatically
Use life 10
Period 11
PATH: Accounting -- Financial Accounting – Fixed Assets – Posting – Acquisition – External Acquisition –F-90 –
with Vendor
Maintain Fields
Document Type AA
Posting Key 31
Account 8000000
Enter
Account 20000
Posting Key 70
Account 1001
Enter
Amount *
Text +
Enter
Note : In this screen we can see the debit and credit for Asset purchase
Asset 1001
Enter
Click On Comparisons
Click On Parameters
In this screen we can see mainly the Depreciation Key and Percentage and Method
Click On S_ALR_87011965
Execute
Maintain Fields
Document Type AA
Posting Key 01
Account 1300000’
Enter
Amount 200000
Posting key 50
Account 3000001
Enter
Amount *
Text +
Enter
Enter
Check 30.06.2015
Enter
SAVE
Period 11
Back
SAVE
Enter
Click On Simulate
SAVE
Click On Simulate
SAVE
Click On Simulate
Click On Simulate
SAVE
Asset UnderConstruction
As asset that you produce yourself has two stages in its life that are relevant accounting from the point of view
of your company.
Generally, an asset has to be shown in different balance sheet items, depending on the phase that it is in
Therefore, it is necessary to manage the asset as a object or asset master record during the construction
phase. The transaction between these two phases is called ‘Capitalization of the asset under construction’ in
the following
You can manage the asset construction in the system in two different ways, depending on the types of
functions that you need. The asset construction can be either a normal asset record, or a master record with
line item management. As a result, the transfer from the asset under construction to completed fixed assets can
be handled in one of two ways.
Line item settlement of an asset under construction that has line item management
Distribution Rules
Line item settlement is carried out by using distribution rules are asset-specific, Several distribution rules from a
distribution rules group. You can assign these group to one or more line items of an asset. Distribution rules
consist of a distribution key and a receiver. The distribute keys can be equivalence number or percentage rates.
In this way, you can distribute any number of combination of line items to any number of combinations of
receivers.
PATH: Financial Accounting (New) – Asset Accounting – Transactions – Capitalization of Assets under
Construction – Define/Assign Settlement Profiles OK07
Click On Position
Enter
Note: No Need to Create New Settlement Rule we can use existing ‘Settlement Rule’
Maintain Number Ranges for Documents for Line Item Settlement SNUM
PATH: Financial Accounting (New) – Asset Accounting – Transactions – Capitalization of Assets under
Construction – Maintain Number Ranges for Document for Line item Settlement
Click OnMaintain Number Ranges for Document for Line item Settlement
Click On Group
Select Element
Select Element/Group
SAVE
Maintain Fields
Document Type AA
Posting Key 31
Account 8000000
Enter
Amount 200000
Posting Key 70
Account 4002(AUC)
Enter
Amount *
Text +
Enter
Enter
Use life 25
Period 11
Click On Execute
Maintain Fields
SAVE
Maintain Field
Document Type AA
Click On Execute
Note: We can get Message Asset transaction posted with document no.1018
Creation of Number Range Intervals for Depreciation Run Document Type (AF)
FBN1
Go To FBN1
Posting Period 1
Click On Continue
Click On Continue
Click On Immediate
Posting Period 2
Click On Continue
Click On Continue
Click On Immediate
Click On Execute
Click Yes
Back
Click On Program
Click On Continue
Click On Continue
Click On Immediate
Go To Menu Bar
Click On Execute
Click On Spool
Note: In this screen we can see the Planned and post depreciations
64,983.60- 8,631.14-
Foreign Currency
Average Rate M
When posting and clearing documents, the system uses the exchange rate type”M” for foreign currency translation.
This exchange rate type must be contained in the system.
Exchange rate difference can be defined as the amount arising where a foreign currency amount is translated at
different exchange rates.
Here, we can define for each company code, a maximum difference between exchange rates for postings in foreign
currency.
For this, we mention that how much the exchange rate entered manually in the document header may differ in terms
of percentage (%) from the one stored in the system.
If an exchange rate or the local and foreign currency amount were entered manually during document entry, then a
comparison is made with the exchange rates stored in the system. If any deviation occurs and it exceeds the
percentage rate specified here, then a warning appears.
For each foreign currency, specify the exchange rate in the local currency in the system. You must specify an
exchange rate type.
Use the validity date to specify the date from which the exchange rate should apply. The system then refers to either
the posting date or the translation date and uses the current exchange rate from the system. You can use either direct
or indirect quotation to specify exchange rates.
If you maintain your exchange rates on a daily basis, you should delete the exchange rates that you no longer require
from the system, so that there are not too many entries in the system.
Note: In this screen no need to create exchange rates exciting we can use
Once we follow one conversion Factor, follow continuously for all the years, don’t change in between, it givens
wrong results.
Conversion factors are given at Client Level but not at Company Code level
Click On ‘yes’
This is Called Forex table. We can enter Foreign Exchange rates Daily, Weekly, Monthly, for each type we can enter
only one rate in a day.
Translate foreign currency amounts when posting or clearing an exchange rate entered manually
Evaluate open items in foreign currency and the foreign currency balance sheet accounts.
The system uses the type M Exchange rates for foreign currency translation when posting and clearing documents in
the activity Enter Exchange Rate. An entry must exist in the system for this exchange rate type. The exchange rates
apply to all company company codes.
Note :If we are not maintain exchange rate in document type’s by default system will pick average exchange rate type
‘M’
Posting Key 40
Account 4000000
Enter
Amount 1000 (Transaction Currency New Zealand Dollar)
Text Salaries Paid
Posting Key 50
Account 2000102
Enter
Amount 1000 (Transaction Currency New Zealand Dollar)
Amount in LC 19000 (INR System will pick currency from exchange rate table OB08)
Value Date 23.06.2015
Text Salaries paid
Enter
Go To Document and Simulate
Note :In this screen we can see the amount in Transaction Currency “New Zealand Dollar”
1)Secured Loan
Go To FS00
G/L Account 1000200
Company Code II02
Click On Create Button
Account Group Liability
Check Balance Sheet Account
Sort Text FC Term Loan
G/L Account Long text FC Term Loan
Click On Control Data
Account Currency NZD
Check Line Item Display
Sort Key 001
Click On Create/Bank /Interest
Field Status Group G001
Enter and SAVE
Go To FS00
G/L Account 3000600
Company Code II02
Click On Create Button
Account Group Incomes
Check P&L Statement Account
Sort Text Exchange Gain
G/L Account Long text Exchange Gain
Click On Control Data
Account Currency INR
Check Line Item Display
Sort Key 001
Click On Create/Bank /Interest
Field Status Group G001
Enter and SAVE
Go To FS00
G/L Account 4000700
Company Code II02
Path : SPRO —Sap Reference IMG—Financial Accounting (New)—General ledger Accounting (New)—
Periodic Processing –Valuate—Define Valuation Methods
Path : SPRO —Sap Reference IMG—Financial Accounting (New)—General ledger Accounting (New)—
Periodic Processing –Valuate—Foreign Currency Valuation—Prepare Automatic Postings for Foreign
Currency Valuation
Double Click On Exchange Rate Difference using Exchange Rate Key KDB
Chart Of Accounts II02
Enter
Note: In this Screen we can see the amount In Transaction Currency “New Zealand Dollar”
Click On Display Currency
PK BusA Acct INR Amount Tax amt
001 40 004000000 Salaries Paid 19,000.00
002 50 II02 002000102 Outgoing Bank 19,000.00-
Note :In this screen we can see the amount in Company Code Currency “INR”
SAVE
Go To FB03
Go To FS00
Double Click On Exchange Rate Difference using Exchange Rate Key KDB
Loss 4000700
Balance Sheet Adjustment Loss 4000700
Gain 3000600
Balance Sheet Adjustment Gain 3000600
Enter and SAVE
NOTE : We Should Maintain Exchange Rate Difference Key in Open Items(Valuated Items)
Go To FS00
G/L Account :1000700
Company Code: II02
Click On Change Button
Click On Control Data
Exchange Rate Difference Key INR
Enter and Save
1) Maintain Exchange Rate Difference Key in HDFC Incoming Bank
Go To FS00
G/L Account:2000101 (Incoming Bank)
Company Code: II02
Click On Change Button
Click On Control Data
Exchange Rate Difference Key INR
Enter and Save
2) Maintain Exchange Rate Difference Key in HDFC Outgoing Bank
Go To FS00
G/L Account :2000102 (Outgoing Bank)
Company Code: II02
Click On Change Button
Click On Control Data
Exchange Rate Difference Key INR
Enter and Save
Vendor 8000000
Invoice Date 29.06.2015
Posting Date 29.06.2015
Amount 1000
Currency NZD(New Zealand Dollars)
Text Vendor Invoice
G/L Account 4000000
Amount 1000
Text Salaries Paid
Enter
Go To F-53
Note : Some time foreign currency will not update from table ob08 since this Demo System. Hence we need to
update the currency manually while doing the payment.
Enter
Go To Document and Simulate
PK BusA Account Account short text NZD Amount Text amnt
001 50 II02 0002000102 HDFC Outgoing Bank 1,000.00-
Go To FB70
Customer 1300000
Invoice date 29.06.2015
Posting date 29.06.2015
Amount 1000
Currency NZD (New Zealand Dollars)
Text Customer invoice
G/L Account 3000000
Amount 1000
Text Sales Account
Enter
Go To Document and Simulate
Itm PK Account Account short text Assignment TX Amount
1 01 1300000 Domestic Customer 1,000.00-
Go To F-28
Note :Some times foreign currency will not update from table ob08 since this Demo System. Hence we need to
update the currency manually while doing the payment.
Enter
Go To Document and Simulate
PK BusA Account Account short text NZD Amount Text amnt
001 40 II02 0002000101 HDFC Incoming Bank 1,000.00
002 15 0001300000 Domestic Customer 1,000.00-
003 50 0003000600 Exchange Gain 0.00
Back
SAVE
Go To FB03
Document 1048
Company Code II02
Fiscal Year 2015
Enter
Co Item PK S Account Description Amount Curr.TxCost Cen
II02 1 40 3000600 Exchange Gain 0.00 SGD
2 50 1000800 Balance Sheet Adj.0.00 SGD
LSMW
LSMW
The LSMW (Legacy System Migration Workbench) is a tool based on SAP software that supports single or periodic data
transfer from non-SAP to SAP systems.
Converting data from its original (legacy system) format to the target (SAP) format
Importing the data using the standard interfaces of SAP (IDoc inbound processing, Batch Input, Direct Input)
The standard transfer programs: a wide range of master data (e.g. G/L accounts, customer master, vendor master, material master, bills
of material) and transaction data (e.g. financial documents, sales orders)
1) Using LSMW we can upload any kind of data like Master data and Transaction data
2) Once we upload master data then only we upload transaction data
3) In Asset at a time we can upload asset master data and transaction data using AS91 Transaction code
4) While upload asset master data the GL account balance will not be updated in to the sap
5) Accumulated depreciation and main GL account balance that has to be uploaded individually using OASV
Transaction Code
6) Vendor Master Data due date wise and invoice wise we can upload into SAP
7) GL data we can upload one time because those are Balance sheet items
Need to create the document types for uploading the transaction data to identify the legacy data. Document types should
have separately for GL, Vendor, Customer and Asset.
Before upload we should create number ranges for these document types.
GL Balances Upload
There are two types of uploads
Mid of the year
Year and upload
Note: Will not upload Sundry Creditors and Sundry Debtors' separately those balances will update while uploading the
open items of vendors and customers.
Note: P&L Balances we can upload in the single document also we can upload the balance sheet balances, except Bank,
Customers, Vendors, Fixed Assets, Stock.
Note: During the Fixed Assets upload GL balances (Asset recon account and Accumulated Depreciation account) will not
update, once upload the Asset balances using AS91 we have to upload the Asset recon and Accumulated Depreciation
account balances separately using OASV t.code.
If you are going on live on mid of the year we will upload the net book value and Accumulated depreciation for previous
year also we need to upload the current year Asset acquisition and ordinary depreciation of current year using the AS91.
Based on the transfer date which we have maintained in the configuration input value fields will enable and capitalization
date will play the major role to enable and disable the fields. Hence we have to take care of the capitalization date while
uploading the Fixed assets.
We need to run the AFAB transaction code to post the current year depreciation accordingly P&L account will update with
ordinary depreciation based on the AO90 setup.
Note: During the Fixed Assets upload GL balances (Asset recon account and Accumulated Depreciation account) will not
update, once upload the Asset balances using AS91 we have to upload the Asset recon and Accumulated Depreciation
account balances separately using OASV t.code.
Project II02
Description Project 1
Enter
Enter
Click On Execute
Click On Execute
Recording GLMASTER
Enter
Enter
Tax Category *
Note: In this GL Master date select all fields and enter, Automatically system will record all field then whichever fields you
want maintain and remove unnecessary field and SAVE
Save and Back (In this screen we can see the recording fields)
Back
Click On Execute
Enter
Click On Table
Select TABNAME
Click On CTRL+Y
Click On Execute
Go To Excel Sheet
Click On Execute
Click On Relationship
Once Click On Relationship button you will get this message Enter and Save and Back
Click on Execute
Enter and Enter and Enter you will get this message' Auto Field Mapping Complete'
Go To Excel Sheet
Click On Sheet 2
Click On Home
Click On Paste
Click On Transpose
Click On Sheet 2
Click On Home
Click On Paste
Click On Transpose
Click On Sheet 2
Click On Home
Click On Paste
Click On Transpose
P&L Statement X
Delete
CTRL+ Home
CTRL + END
SAVE
Save
CTRL+ Home
CTRL + END
Select Desktop
SAVE
Click On Ok
Click On Yes
Go To SAP
Click On Execute
Check Tabulator
Assign Files
Click On Execute
Back
Read Data
Click on Execute
Click On Execute
Allow
Click on Execute
Enter
Convert Data
Click On Execute
Click on Execute
Click on Execute
Enter
Back
Click On Execute
Click On Execute
Enter
Check Process/foreground
Click On process
Financial Statement Version is a Balance Sheet and Profit and Loss Statement. The FSV should be linked with our chart
of account, The accounts can be arranged in accordance with the legal regulations used to generate your financial
statements. Alternatively, you can arrange the accounts in accordance with your requirements.
The standard system is delivered with predefined financial statement versions. You can copy these or modify them for your
own versions.
You can define several different financial statement versions. This may be necessary if you want to generate the financial
statements using different formats:You can create a financial statement version for different organizational units, such as
the corporate group, a company code, or a business area.You can create financial statement versions in different
languages, for example, in the language of the country in which the company code is based or in the group language.
You can create the financial statement version in any currency you like or according to a specific currency type. This may
be necessary if you want to create consolidated financial statements for a group of company codes with different local
currencies, or if you record transactions in other additional currencies in addition to the company code currency.
You can choose between different types of financial statements, for example, opening financial statements or closing
financial statements.You can vary the level of detail of your financial statements. For your accounting department, for
example, you want to list the individual accounts with their respective balances. For senior management, you might want to
summarize this information to create one set of financial statements for the whole group.
Path:Financial Accounting (New) -- General Ledger Accounting (New) -- Periodic Processing -- Document -- Define
Financial Statement Versions OB58
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Note: If you want to maintain group order wise,we can do like this.
Click On Reassign
Click On Reassign
Share Capital
Current liabilities
Loans
Provisions
Enter
Enter
Select Loans
Enter
Select Provisions
Enter
Enter
Current Assets
Fixed Assets
Investments
Enter
Enter
Enter
Expenses
Revenues
Incomes
Enter
Select Expenses
Enter
Select Revenues
Enter
Select Incomes
Enter
Check Button
Enter
Balance Sheet
Path: Information Systems --Accounting - Financial Accounting -- General Ledger -- F.01 - Balance Sheet
Execute
Execute
Profit 1,04,900.00
Controlling Area
Controlling Area is an organizational unit from the Accounting component. used to represent a closed system for cost
accounting purposes. the Controlling Area constitutes the framework for planning, allocation and monitoring of costs.
A controlling area may include one or more company codes which must use the same operative chart of accounts as the
controlling area. A Controlling Area can contain multiple company code assignments but a single company code can be
assigned to only one controlling area.
A Controlling area can have the following 2 type of relationship with a Company code
This means that one single controlling area can be assigned to several different company codes.
Controlling can have a one is to one relationship or a one is to many relationship with different company
codes.
Controlling Area is the umbrella under which all controlling activities of Cost Center Accounting, Product
Costing, Profit Center and Profitability Analysis are stored.
In a similar way Company Codes is the umbrella for Finance activities.
Currency Type 10
Currency INR
II02 II Solutions
Path: Spro -- Controlling -- General Controlling -- Organization -- Maintain Number Ranges for Controlling
Documents KANK
Click On Groups
Click On Group
Click On Insert
Text COIN
1 500
Enter
Check COIN
Click On Element/Group
Select 0 Version
Enter
Note: If Current Year is not available we should create the Fiscal year
New Entries
Note: Go to OBC4 and Maintain Required Fields Cost Centre and Business Area in G004
Cost Center
A cost center is a business unit that is only responsible for the costs that it incurs. The performance of a cost center is
usually evaluated through the comparison of budgeted to actual costs. The costs incurred by a cost center may be
aggregated into a cost pool and allocated to other business units.
Cost Centers are the organizational units within a controlling area that represents a location where costs occur.
Click on Create
Enter
Name Department A
Description Department A
Person Responsible Mr A
Department Production
Currency INR
Enter
Name Department B
Description Department B
Person Responsible Mr B
Department Sales
Currency INR
Enter
Name Department C
Description Department C
Person Responsible Mr C
Department Admin
Currency INR
Enter
Enter
HYDII02 Hyderabad
Dep A Department A
Dep B Department B
Dep C Department C
General Posting
Click on F-02
Posting Key 40
Account 4000000
Enter
Amount 5000
Posting Key 50
Account 2000102
Enter
Amount 5000
SAVE
Click on KSB1
Execute
General Posting
Posting Key 40
Account 4000000
Ente
Amount 2000
Posting Key 40
Enter
Amount 3000
Posting Key 40
Enter
Amount 4000
Posting Key 50
Enter
Amount 9000
Text Expenses
SAVE
Execute
Click on KSB5
Execute
Path: Accounting -- Controlling -- Cost Center Accounting -- Actual Postings -- Repost Line Items -- KB61 - Enter
Click On KB61
Company II02
Execute
Amount 300000
Amount 100000
Execute
Note: In this Screen we can see the Amount transfer from DEPC to DEP D and DEPA
Path: Accounting -- Controlling -- Cost Center Accounting -- Actual Postings -- Manual Reposting of Costs -- KB11N - Enter
Enter
Execute
DEPA 200,000
DEPD 200,000-
Version 0
From Period 1
To Period 12
To 4099999
4000000 5,000,000.00
4000001 4,000,000.00
Note: In this screen we can see the planning amount period wise
From Period 12
To Period 12
Or Value DEPA
Or Value 4000000
Click on Execute
Cost Element
All Profit and Loss GL account defined in Finance Chart of account shall be created, as Cost Element This is in order to
avoid Reconciliation of FI and CO module.
Cost Object could be Material, Cost Center, Internal Order, Production Order etc.
Path: Accounting -- Controlling -- Cost Element Accounting -- Master Data -- Cost Element -- Individual Processing -- KA01
-Create Primary
Enter
Enter
4000001 4000010 1
Valid to 31.04.2015
Execute
Click On Process
Click On KA03
Enter
Click on KAH1
Enter
Controlling Area
Controlling Area is an organizational unit from the Accounting component. used to represent a closed system for cost
accounting purposes. the Controlling Area constitutes the framework for planning, allocation and monitoring of costs.
A controlling area may include one or more company codes which must use the same operative chart of accounts as the
controlling area. A Controlling Area can contain multiple company code assignments but a single company code can be
assigned to only one controlling area.
A Controlling area can have the following 2 type of relationship with a Company code
This means that one single controlling area can be assigned to several different company codes.
Controlling can have a one is to one relationship or a one is to many relationship with different company
codes.
Controlling Area is the umbrella under which all controlling activities of Cost Center Accounting, Product
Costing, Profit Center and Profitability Analysis are stored.
In a similar way Company Codes is the umbrella for Finance activities.
Currency Type 10
Currency INR
II02 II Solutions
Path: Spro -- Controlling -- General Controlling -- Organization -- Maintain Number Ranges for Controlling
Documents KANK
Click On Groups
Click On Group
Click On Insert
Text COIN
1 500
Enter
Check COIN
Click On Element/Group
Select 0 Version
Enter
Note: If Current Year is not available we should create the Fiscal year
New Entries
Note: Go to OBC4 and Maintain Required Fields Cost Centre and Business Area in G004
Cost Center
A cost center is a business unit that is only responsible for the costs that it incurs. The performance of a cost center is
usually evaluated through the comparison of budgeted to actual costs. The costs incurred by a cost center may be
aggregated into a cost pool and allocated to other business units.
Cost Centers are the organizational units within a controlling area that represents a location where costs occur.
Click on Create
Enter
Name Department A
Description Department A
Person Responsible Mr A
Department Production
Currency INR
Enter
Name Department B
Description Department B
Person Responsible Mr B
Department Sales
Currency INR
Enter
Name Department C
Description Department C
Person Responsible Mr C
Department Admin
Currency INR
Enter
Enter
HYDII02 Hyderabad
Dep A Department A
Dep B Department B
Dep C Department C
General Posting
Click on F-02
Posting Key 40
Account 4000000
Enter
Amount 5000
Posting Key 50
Account 2000102
Enter
Amount 5000
SAVE
Click on KSB1
Execute
General Posting
Posting Key 40
Account 4000000
Enter
Amount 2000
Posting Key 40
Enter
Amount 3000
Posting Key 40
Enter
Amount 4000
Posting Key 50
Enter
Amount 9000
Text Expenses
SAVE
Execute
Click on KSB5
Execute
Click On KB61
Company II02
Execute
Amount 300000
Amount 100000
Execute
Note: In this Screen we can see the Amount transfer from DEPC to DEP D and DEPA
Enter
Execute
DEPA 200,000
DEPD 200,000-
Version 0
From Period 1
To Period 12
To 4099999
4000000 5,000,000.00
4000001 4,000,000.00
Note: In this screen we can see the planning amount period wise
Path:Accounting -- Controlling -- Cost Center Accounting -- Information System -- Reports for Cost Center Accounting --
Plan/Actual Comparisons --- S_ALR_87013611 - Cost Centers: Actual/Plan/Variance
From Period 12
To Period 12
Or Value DEPA
Or Value 4000000
Click on Execute
Cost Element
All Profit and Loss GL account defined in Finance Chart of account shall be created, as Cost Element This is in order to
avoid Reconciliation of FI and CO module.
Cost Object could be Material, Cost Center, Internal Order, Production Order etc.
Path: Accounting -- Controlling -- Cost Element Accounting -- Master Data -- Cost Element -- Individual Processing -- KA01
-Create Primary
Enter
Enter
4000001 4000010 1
Path: SPRO -- Controlling -- Cost Element Accounting -- Master Data -- Cost Elements -- Automatic Creation of
Primary and Secondary Cost Elements -- Create Batch Input Session OKB3
Valid to 31.04.2015
Execute
Click On Process
Path: Accounting -- Controlling -- Cost Element Account -- Master Data -- Cost Element Accounting -- Individual
Processing --
Click OnKA03
Enter
Path: Accounting -- Controlling -- Cost Center Accounting -- Master Data -- Cost Element Group -- KAH1 - Create
Click on KAH1
Enter
Select HYDII02
From To
4000000 4000011
Profit Center
Profit center is an organizational unit in accounting that reflects a management-oriented structure of the
Profit Center Accounting evaluates the profit or loss of individual, independent areas within an organization.
Path: Controlling -- Profit Centre Accounting -- Basic Setting -- Set Controlling Area
Enter
Path: Controlling -- Profit Centre Accounting -- Basic Setting --Controlling Area Settings -- Maintain Controlling
Area Settings
Path: Controlling -- Profit Centre Accounting -- Master Data -- Profit Center -- Create Dummy Profit Center
Path: Controlling -- Profit Center Accounting -- Basic Settings -- Controlling Area Settings -- Activate Direct Postings -- Set
Control Parameters for Actual Data
Enter
Path: Controlling -- Profit Center Accounting -- Basic Settings -- Controlling Area Settings -- Activate Direct Postings --Plan
Versions -- Maintain Plan Versions
Select 0 Version
Click On Interval
Click On Maintain
Enter
2015 1 1000
Click On Interval
Click On Maintain
Enter
Click On KE51
Entre
Name Dep A
Department Dep A
Enter
Name Dep B
Department Dep B
Name Dep C
Department Dep C
Click on KDH1
Enter
Enter
3000000 4099999
Click On KS02
Enter
Note: If you are getting this Error double click on error message
Copy FAGL_ORG_UNITS
Enter
Back
SAVE
Enter
Enter
Path: Controlling -- Profit Center Accounting -- Actual Postings -- Maintain Automatic Account Assignment of Revenue
Elements
II02 Production
Version 0
From Period 12
To 12
3000000 500000-
4000001 400000
Version 0
From Period 12
To 12
1000500 100000-
2000102 100000
Note: Before going to post customer invoice maintained required field business area in G029
Posting Key 01
Enter
Amount 200000
Posting Key 50
Account 3000000
Enter
Amount *
Text +
Enter
Note: Once Press Enter system will pick the profit center from Maintain Automatic Account Assignment of Revenue
Elements OK59
Path: Accounting -- Controlling -- Profit Center Accounting -- Information System -- Reports for Profit Center
Accounting -- Interactive Reporting -- S_ALR_87013326 - Profit Center Group: Plan/Actual/Variance
From period 1
To Period 12
Plan Version 0
Execute
Path: Accounting -- Controlling -- Profit Center Accounting -- Actual Postings -- Profit Center Document -- 9KE0 -
Enter
Enter
Execute
Version 0
Posting Period 5
Execute
In this Screen we can see the balance (10000-) from Profit centre production to admin(10000)
` 1