Sunday, January 2, 2011

FI - ORGANISATION STRUCTURE


Tuesday, November 30, 2010

Guide for Testing SAP Financial

Key Features for Testing
Understanding the business scenarios
Organization Structure to incorporate the tune of the script.
Preparation of test scripts
Execute and record results to see if it is fine before going to approval.
Make changes to your test script if required.

What is Test Script (Scenario Testing)
Header Data
Step in Process
Transaction Code / Program (FB60)
Menu Path
Description
Field Data and actions to complete
Expected Results
Actual Results
TPR
Closing Period
F.19 Clearing GR/IR Account
F.13 Adjustments GR/IR Account

Using of these above two accounts will help us in clearing the balances and adjustments to those respective clearing accounts so that the GR/IR account will be zero balance and the balances will appear in respective reconciliation accounts accordingly the balances will be carried forwarded to next fiscal year.

GR/IR Clears the following Documents
GL Document
Customer Documents
Vendor Documents
Assignment Field is important in any document (ZUONR), Amount (DMBTR)

Foreign Currency Valuation
Lowest Value Method, If we are in loss then only we will account for it.

GL Accounts which are important in Testing
Enjoy Transaction - FB50
Normal Transaction - FB01
Document Parking - FV50
Post with Clearing - F-04
Incoming Payment - F-06
Outgoing Payment - F-07

Document Related
Reset Cleared Items - FBRA
Parking Document Posting - FBVO
Reversal Documents - F-14
Company Code Clearing A/C
(Trial Balance purposes) reversal - (FBUB)

Clearing Account
Partial clearing Invoice - 100 - Open Item
Paid - 70 - Open Item
Balance - 30

In Partial Clearing you can see 100 and 70 are cleared line items and 30 as balance and if it is in Residual you can only 30 as balance as it creates new line item and you can’t see the other cleared line items.

As no company will use residual clearing as it affects on ageing reports.

Open Items in Foreign Currency in all Modules GL/AP/AR - F.05
Master Data

Company Code
Currency
Only Balances in local currencies
Reconciliation Account Type

Year End Scripts
Re Grouping Receivables / Payables - (F101)

Bad Debts Provisions – Scripts
We assume that the customer has not paid at the end of the year you doubt whether this receivable will ever be paid. So you make a transfer posting for the receivables to an account for individual value adjustments using special GL Indicator E and Transaction Code F-21

Carry forward Balances
Sub Ledgers and General Ledger balances to be forwarded to next Fiscal Year

Accounts Payables
Vendor Down Payments
Invoice
Parking
Reversal
Outgoing Payments
Automatic Clearing
Manual Clearing
Advance (Down Payment)
Post with Clearing
Post without Clearing
Reset Clearing
Carry forward
Regrouping
Foreign Currency Valuations

Accounts Receivables
Customer Down Payments
Invoice
Parking
Reversal
Incoming Payments
Manual Clearing
Advance (Down Payment)
Post with Clearing
Post without Clearing
Reset Clearing
Carry forward
Regrouping
Foreign Currency Valuations

Source: http://www.sap-basis-abap.com/fico/guide-for-testing-sap-financial.htm

Sunday, October 3, 2010

How to prepare for SAP Cerfitication Exam?

The following are the tips given by my tutor while I was doing the certification course at NIIT. I successfully cleared the exam with 85%. I want to share those tips for the reader of this blog.



1) Believe your study Material: Your study material provided by the SAP is more than enough to clear your SAP Certification exam for any module. Don't spend your money and time in books other than the SAP materials. Because your questions for certification will be asked only from the SAP materials.

2) Don't memorize T-Codes: There are numerous T-Codes in SAP which is not possible for anyone to memorize. SAP rarely asks question in T-Codes.

3) Understand the concepts, not the Menu Path(s): SAP Germany asks question to test your knowledge on the concepts. They never test your memory skill about the menu paths and T-Codes. If you know the concepts very well, you can easily know the menu paths.

4) Do the Exercise provided in your material: Do promptly your exercises which are in your study materials. They will cover all the aspects of your certification. By doing those exercises repeatedly, you can able to answer many questions by remembering the screen of the exercises. Doing exercises will be more advisable than reading the books alone.

5) Try to correlate your knowledge with live scenarios: Now, SAP Germany asking many questions based on the live scenarios. When you undergoing for the training for certification, try to map your knowledge or subject with the live scenario. Many students failed in the examination due to lack of this skill. It is difficult for the beginners to know the live situations. To know the live scenarios you can enroll yourself to any SAP forums and watch others queries and answers from the experts.

6) Don't leave any chapters from your book: You need to study well all the chapters from your book. Because there is no syllabus from SAP Germany to ask questions by chapter wise. They may ask or skip any particular chapter. So, you need to know all the chapters. It is dangerous to skip or omit any chapters from your book.

7) Stay focused during your course: You may do the certification course through Online training module or Instructor led Training module. The most important thing is you need to be stay focused during the time of your Certification course. This is the key element to achieve your certification. Because the available time is less and things to learn are more.

8) Answer the questions which you know very well: You have 3 hours for the exam. It is more than sufficient. It hardly will take just 2 hours to complete the exam. So, you can leave the questions which you don't know or you have doubts. You can think about those questions during the 3rd hour of the exam. If you start worrying about those questions in the beginning of the exam, it will spoil your chances of clearing the certification. So, start with confidence by attempting the easy and known questions.

Thursday, September 30, 2010

SAP FI Month End and Year End Activities

1 - Maintain Activity prices - KP26
2 - Release of Standard Cost Estimate - CK40N
3 - MM period close and open - MMPV
4 - FI period open
5 - Parked documents to be posted - FBV0, MIRO
6 - Reposting of Inter Office CC - KB61
7 - Bank Reconciliation
8 - Update Section Code where missing - J1INPP
9 - Maintain GRIR clearing - F.13
10 - Provision for current month - FB50
11 - Depreciation entry - FB50
12 - Exchange rate - To be Updated
13 - Revaluation of foreign currency open items - F.05
14 - Recognition of Inventory at Bonded warehouse - FB50
15 - Maintain Statistical Key Figures - KB31N/KP46
16 - Variance Calculation of Process Orders - KKS1
17 - Settlement of variances - CO88
18 - Assessment cycles - Aux/WH CC to Main CC - KSU5
19 - Assessment cycles - Functional CC to SBU CC - KSU5
20 - Assessment cycles - SBU CC to COPA - KEU5
21 - Profit Center Reposting - 9KE0
22 - Balance Sheet Adjustment calculation - F.5D
23 - Transfer Profit Center to AR & AP - 1KEK
24 - Transfer Inventory to PCA - 1KEH
25 - Assessment Cycle - Dummy PC to SBU PC - 3KE5
26 - Check for "Delivery made, not Invoiced" - VF03
27 - Match GL and PCA - KE5T
28 - Match PCA and PA
29 - Top Down Distribution in COPA - KE28
30 - Reclassification of GL balances
31 - Balance Carry forward (Year End Only) - F.16
32 - PCA Balance Carry forward (Year End Only) - 2KES
33 - Transfer to FI - 1KE8

Monday, September 20, 2010

Useful SAP FI Related Transaction Codes

Organizational Structure

1. Define Company code – OX02 / Copy Company Code – EC01
2. Define / Edit Chart of Accounts – OB13 / Copy Chart of Accounts – OBY7
3. Assign Company Code to Chart Of Accounts – OB62
4. Maintain Fiscal Year Variant – OB29
5. Assign Company Code to Fiscal Year Variant – OB37
6. Define Posting Period Variant - OBBO
7. Open and Close Posting Period – OB52
8. Assign Posting Period Variant to Company Code - OBBP
9. Define Document Number Ranges – FBN1
10. Define Document Types – OBA7
11. Define Posting Keys – OB41
12. Define Field Status Variant – OBC4
13. Assign Company Code to Field Status Variant – OBC5
14. Screen Variants for document Entry – OB71
15. Define Tolerance group for Employees – OBA4
16. Assign User Tolerance Group – OB57
17. Define Business Area – OX03
18. Company Code Global Parameters – OBY6
19. Define Countries – OY01
20. Define Parallel currencies – OB22

Customer Creation and Payments
1. Define Vendor Account Groups – OBD3
2. Define Number Ranges for Vendor Accounts – XKN1
3. Assign Number Ranges to Vendor Account Groups – OBAS
4. Create Recon Account – FS00
5. Define Customer/Vendor Tolerance Group – OBA3
6. Define Payment Terms – OBB8
7. Create Vendor – FK01
8. Post Invoice – FB60, Doc KR, number range 19
9. Make incoming payments (full, partial or residual payments) – F- 53, Doc KZ, number range 15

Automatic Payment
10. House Bank Configuration – FI12.
Enter Company code and select House Bank tab. Click on the Create bank to create a new house bank Enter Bank Country and bank key details and click Bank Accounts.
Enter the Bank Account num and the Bank GL account.
11. Payment Program Configuration – FBZP
All Company Codes – Enter Sending and Paying Company Code, outgoing payment with cash discount from.

Paying Company Code – Enter Minimum amount of Incoming and outgoing payment and Form for the Payment advice.

Payment methods by country – Select Check will be created, Allowed for personal payments, Street P.O. box or P.O. box pst code (bank details for Wire transfer) and RFFOUS_C (RFFOUS_T for wire transfer) as the print (payment) program.

Payment methods by Company Code – Enter min and max amounts and form for payment transfer. Payment per due day, optimize by bank group or postal code can also be selected.
Bank Selection – If more than one house bank, ranking order can be given. Under Amounts, amount available for outgoing payment should be given. Under Accounts, enter bank-clearing account for bank sub-account.

12. Define Check numbers – FCHI and Void Reasons - FCHV
13. Payment Run – F110

Enter Run Date and Identification and go to parameters tab. Enter Company codes, payment methods, next pay date and vendor accounts. Go to Additional Log Tab and select Due date check, Payment method selection in all cases and line items of the payment documents. Go to Print out/data medium tab, enter variant against the Payment program and select Maintain Variants. Enter Paying company code, House bank details, and check lot number. Select Print Checks and Print payment summary for checks and Print payment advice notes for Wire(enter printer and select print immediately). Also make no. of sample printouts to zero. Then execute Proposal, Payment run and Printout. Number range 20 should be defined.

General Ledger
1. Define G/L Account Groups – OBD4
2. Define Retained Earnings Account – OB53
3. Journal Entry – FB01, F-02, FB50, Document Change / Display – FB02 / FB03
4. Recurring Document – FBD1, FBD2, FBD3, F.56 - Delete
5. Sample Document – F-01, FBM2, FBM3, F.57 - Delete
6. Individual Reversal – FB08, Mass Reversal – F.08
7. Parked Documents – FBV0 – Post/Delete, FBV2- Change, FBV3 - Display
8. FS10N – Display Acct Balances, FBL3N – Display Change Line Items, F-03 - Clear
9. F.19 – Clearing of GR/IR account.

Wednesday, September 8, 2010

SAP - CERTIFICATION EXAM

Now, SAP have changed their question paper for the certification exams. They have eliminated pro-rata marks and negative marks for wrong answers. But now they gave the clue that how many sentences are true or false in a question. So, the student can able to pick the true or false statements according to the question.

The pass mark to get the certification is 66% here in India. But in Dubai it is 55%. I don't know why the variance is like that. There is no proper model test paper or mock test available online. SAP deliberately made it so complex. They don't want many people coming into sap or they want only highly knowledgeable people to come in SAP.

Friday, August 27, 2010

SAP Certification Guides

Certification Guides & Sample Exam Questions



The following link goes to a list of links to sample questions: http://www.sap.com/services/education/certification/schedule/index.epx

I found ten multiple-choice questions on the Sales Order sample. They appeared to be good, solid questions--the kind of questions one would expect to see on a certification exam.

Some of the questions have multiple answers. SAP recently went to a "dichotomous scoring" technique, which means that partial credit is no longer given for partially correct answers. So if a question asks you to identify the two correct possible answers, and you get just one correct, you get no credit for that answer. Using this scoring method has resulted in SAP having to lower the passing score on exams-to sometimes as low as 55%.

Since 10 sample questions can't give you an idea of the full range of topics covered by a certification exam, you'll want to review the competency list provided for each exam.

A typical exam lasts up to three hours and contains 80 questions.

Exam Prep SAP Certification Course Materials Training


It's pretty obvious from my tour of the SAP certification pages that SAP hopes that a good number of people sign up for classes to prep for the exams.

While I don't believe that SAP regular classes for clients and consultants are oriented towards passing the certification exams (can you say "No consultant left behind'?), I have been told that some SAP instructors teach classes as rigorously as they can so that students can pass the exams.

SAP does not offer classes specifically tailored to exam content-in my view that's a good thing. I'd rather have a consultant pass an exam based on their hard earned knowledge and experience, than pass based on a review course.

Many test takers have passed the exams without taking any classes-they've either taken classes in the past or they rely on their years of field experience.


It's pretty obvious from my tour of the SAP certification pages that SAP hopes that a good number of people sign up for classes to prep for the exams.

While I don't believe that SAP regular classes for clients and consultants are oriented towards passing the certification exams (can you say "No consultant left behind"), I have been told that some SAP instructors teach classes as rigorously as they can so that students can pass the exams.

SAP does not offer classes specifically tailored to exam content-in my view that's a good thing. I'd rather have a consultant pass an exam based on their hard earned knowledge and experience, than pass based on a review course.

Many test takers have passed the exams without taking any classes-they've either taken classes in the past or they rely on their years of field experience.