Skip to Content
Author's profile photo Prasanna s

FAQ: What to learn for new comers in SAP B1


FAQ: In my experience i have answered this question so many people. So am writing this document

Question: Am new to SAP B1 What i want to learn

Answer for Functional Consultant:

  1. Business Process
  2. Formatted Search
  3. SQL Query Report
  4. Crystal Reports
  5. Stored Procedure
  6. Preparing Documentation
  7. Good Communication

Note: This 7 points will help you to get good position in SAP B1 field.

Detailed Explanation :

  1. Business Process:


      1. Import purchase process
      2. Local purchase process
      3. Fixed asset purchase process
      4. Subcontract purchase
      5. Service purchase
      6. Non stock item purchase like , paper, pen, tissue cloth etc…
      7. Quality process
      8. Refer this link for more details: How to Implement SAP Business One projects successfully



      1. Stock Revaluation
      2. Stock Taking
      3. Purchase return
      4. Sales return
      5. Returnable Gate Pass “Configure GRPO-QC and Returnable Gate pass using – Inventory Transfer Ctrl + Tab in ITEMCODE field



      1. Production planning like , Daily, Monthly or based on sales order etc…
      2. Set multilevel BOM
      3. Stage wise production
      4. Send one process for subcontract
      5. WIP process
      6. Quality process for each stage.
      7. Re-process
      8. Handle Scrap in each production stage.
      9. Maintenance
      10. Refer this link for more details: How to Implement Production in Default SAP Business one



      1. Export Sales
      2. Local Sales
      3. Consignment Sales
      4. AS IS sales (You will buy sales with same tax value based on selected batch- This scenario related to INDIAN localization)
      5. Service Sales (In this case you will act as sub-contract for other business partner)
      6. Drop ship Sales (In this case stock will not come to factory it will be sale in transit)
      7. Production Scrap sales



      1. Reconciliation
      2. BRS
      3. SAP Account flow of all the documents like , Goods Receipt PO , A/P invoice etc..
      4. Char of account drawers like, What are all P&L drawers and what are all Balance sheet drawers etc..
      5. What is Cost of good sold
      6. Valuation method like FIFO , Moving average and Standard
      7. In which situation we have to use Set G/L method by Item group or by Warehouse
      8. What is the use of Trail balance, P & L, Balance Sheet
      9. Year end process
      10. What are all the stationary reports based on your project localization.
      11. Fixed asset setup : Fixed Asset SAP Business One 9.0 Configuration

  2. Formatted Search

      1. You need basic knowledge of SQL to write this.
      2. Get one field value to other field
      3. How add two field and put a value in other field
      4. How to deal with Quantity and price field, for example you have use “.Number” keyword

     3. SQL Query Report

      1. What is header table(OPOR) and row table (POR1)
      2. What is object types
      3. What is docentry
      4. Refer this link for more details: Database design in SAP Business One

     4. Crystal Reports

      1. PLD in crystal report
      2. Normal reports
      3. Cross tab report
      4. Formula field
      5. Report using SQL quries

    5. Stored Procedure

      1. You need basic knowledge of SQL to write a stored procedure.
      2. What is Object type and Trans Type
      3. What is the use of @list_of_key_cols_tab_del and @list_of_cols_val_tab_del
      4. Same object type should not contain more that one time. (you have to use only if and else if)

     6. Preparing Documentation

      1. How to prepare AS IS and TO BE document
      2. Help document
      3. Technical document for addon.

    7. Good Communication              

      1. Communication is more import bcz we have to conduct meeting with top level people
      2. We have to be very careful what we are giving commitment to customer, if you say yes for not possible things then you will be in trouble of completing that.
      3. How to send a daily project status mail
      4. How to train end user (bcz you have to face educated and un-educated person and then you have train some times who didn’t used the computer in his life.)

Any questions or if anyone has any tips for me please post below.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Nagarajan K
      Nagarajan K


      Valuable information!!! Thanks for sharing.

      Best Regards,


      Author's profile photo Former Member
      Former Member

      Hiii Sir,

      Database design blog  is nice one to learn for freshers..

      Another things want to add is after implementation is done.

      1)To teach the "Super users (manager user id )" about the SAP Customer Portal and S-user id for searching the SAP NOTES for any error messages received. And also find the solution in SCN.

      2)Also main thing handling the ERP server, Where exactly data files are stored (mdf/ldf)

      How crucial these files are and how the backup can be taken through SAP service manager as well through SQL Server.

      3)Approval procedures to be taught and Creation of new Tax code specially for Indian Customers.

      General point from my personal experience to add in for Freshers is Gaining entry to SAP  World through SAP Business one is lot more easier when compared entry into SAP R/3 where minimum entry level is 3 years. And Good thing about SAP B1 you learn each every department how they work together to make business easy and connected and with lot of SME moving to erp SAP B1 is worth a shot...:)

      Thanks & Regards

      Darshan Desai

      Author's profile photo Prasanna s
      Prasanna s
      Blog Post Author

      Hi Darshan,

      Thanks for your valuable feedback, will update this document with you points ASAP.

      Author's profile photo Former Member
      Former Member


      Very good blog for new comers. System architecture missing?

      Author's profile photo Prasanna s
      Prasanna s
      Blog Post Author

      Hi sridhar,

      What do you mean the System architecture, can you give some example so that will help me to include it.

      Author's profile photo Former Member
      Former Member

      Dear Prasanna,

      Very nice blog.........Congratulations


      Umesh Vaidya

      Author's profile photo Former Member
      Former Member

      Thanks for the points.

      Now I find what items all are missing being a functional consultant.

      Author's profile photo Former Member
      Former Member

      Thanks for the blog, found very helpful


      Lanish Kuruvilla George

      Author's profile photo Former Member
      Former Member

      Nice information for new b1 consultant...

      Author's profile photo Former Member
      Former Member


      Good Information...


      Author's profile photo AndakondaRamudu A
      AndakondaRamudu A

      Dear Prasanna

      Thanks for sharing...Valuable information!!!