Fundamentals of SAP Customizing

Number Ranges for Trans./Event type WL in year xxxx does not exist

As part of SAP Training,when you try to do a PGI to an SAP Delivery in our SAP SD Training Exercises or SAP MM Training exercises, the following error message pops-up “Number Ranges for Trans./Event type WL in year xxxx does not exist” Solution : This problem occurs because the SAP goods movement number ranges were not extended for the fiscal period. Go to Tcode [ OMBT ] and open up the groups in it. Select the group that contains the event type in question. In this case it is “WL”  and hit enter. Insert a new Interval for the fiscal year that does not exist. In this case, 2011 does not exist yet. So, create a new entry for the same in the number ranges and save the transaction.

SAP ABAP Training by Naresh

Summary : A SAP Certified SAP ABAP Training expert with experience conducting 3 batches to-date. Here is a little brief about his Professional and Training Experience

Professional Experience : Naresh is an SAP ABAP Consultant and has worked in the US for a considerable number of years.

Training Experience : Naresh has been doing SAP HR Training part time for close to 20+ batches to-date and has done a phenomenal job with them all. Listed below are some testimonials from his previous Customers and best word to describe most of them is “Awesome”.

 

 

 

 

SAP Database Tables – April 2011 SAP Training Batch

We have discussed some SAP Database tables/Structures in today’s SAP SD Training class. For more information on other SAP Training modules, please visit our home page.

VBAK  – Sales Document Header

VBAP  – Sales Document Item

VBEP   – Sales Document Schedule Lines

LIKP – Delivery Header

LIPS – Delivery Line Items

VBRK – Billing Document Header

VBRP – Billing Document Item

VBFA – Document Flow

Exercises : Please complete the following exercises without going through the front end transactions. Only use the transaction codes SE11 or SE16 ( SAP Data Browser ). Please do not use front end transactions like VA01, VL01 etc.

Question 1 : Find out from the SAP Database tables the following fields for the SAP Sales Order # 4982. For each of the questions below, give the technical name.

For example, for the question, “Who created the order” , the answer should be “BOLLINGER   and the technical name is VBAK-ERNAM”

  1. Who created the Order ?
  2. What is the Document Date ?
  3. What is the Document Category ?
  4. What is the Document Currency ?
  5. What is the Net Value of the Order ?
  6. What is the Customer Credit Group ?

Question 2 : Find out from the SAP Database tables, the following fields and their values for the SAP Sales Order # 4982 , line item 20.

  1. What is the Description of the material ?
  2. What is the item category of the material ?
  3. What is the Product Hierarchy of the material ?
  4. What is the net value of the material ?
  5. What is the volume unit of the material ?
  6. What is the delivering Plant ?

Question 3 : Find out from the SAP Database tables, the following fields and their values for the SAP Sales Order # 4982, line item 30 and the corresponding schedule lines

  1. How many schedule lines are available for line item # 30 ? How did you find out without going through the front end ?
  2. For the second schedule line of line item # 30, what is the SAP Schedule Line category ?
  3. What is the Transportation Planning Date ?
  4. What is the movement type ?

Question 4 : What is the delivery document for Sales Order # 4982 ?

Question 5 : What is the billing Document for Sales Order # 4982 , line item # 40 ?

Explain how you found out answers to Q.4 and Q.5 ?

Question 6 : Find out from the database table/view, the relationship between Company Code and Plant as specified in the Enterprise Structure for Plant 1200?

 

 

SAP GUI Installation Sofware and Hardware Requirements

Windows 2000
Minimal Recommended
Memory 128 MB 192 MB
Processor 200+ Mhz 500+ Mhz
Windows xp/2003 Server
Minimal Recommended
Memory 128 MB 192 MB
Processor 233+ Mhz 500+ Mhz
Windows Vista/2008 Server/ Windows 7
Minimal Recommended
Memory 512 MB 1 GB
Processor 800+ Mhz 1+ Ghz

 

Know the official,  SAP Note 26417 – SAP GUI Resources Hardware & Software Requirements here.

 

Hard Disk Requirements :

110 MB (minimum packet SAP GUI + SAP Logon) up to 510 MB (70 MB – 470 MB, if operating system files (MFC, IE, Office) do not have to be updated). The amount of disk space required will increase if additional components like Adobe Lifecycle Designer have to be installed as well, but the size of  SAP GUI itself does not differ much when releases 6.20 and 7.10 are compared.

SAP VOFM Routines – SAP Training 2011 Batch

Many areas in SAP SD Training like SAP Copy Controls, SAP Pricing Requirements, SAP Data Transfer Routines use ABAP routines configured and coded in VOFM transaction.

The following routines are available in VOFM transaction.

  • Copy Control Routines
  • Data Transfer Routines
  • Requirements
    • SAP Pricing Requirements
    • SAP Account Determination Requirements
    • SAP Listing and Exclusion Requirements
    • etc
  • Forumas
    • SAP Pricing Formulas
    • SAP Pricing Rounding Rules

You can view the routines by selecting the right menu path, selecting the routine number and clicking on the  view code button. For example, if you want to view the Copy Control requirements for orders, select the following menu path,

and selecting the right requirement number ( Please ensure that the routines are marked as  “Active” in order to really work.

Select the routine and click on the view button. The system will display the code in SAP ABAP Editor.


*---------------------------------------------------------------------*
*       FORM -  Routine for copying checks
*---------------------------------------------------------------------*

*---------------------------------------------------------------------*
*       FORM BEDINGUNG_PRUEFEN_001                                    *
*---------------------------------------------------------------------*
*      The following work areas are available:                        *
*                                                                     *
*       HVBAK - Header which can be produced from the reference       *
*        VBAK - Header of the reference sales document                *
*        VBUK - Header status of the reference sales document         *
*        TVAK - Sales document type                                   *
*       HVBPA - Partner segment of the sold-to                        *
*        VBPA - Partner segment of the sold-to in the reference doc   *
*                                                                     *
*      The messages are stored in table 100 with Message-ID 'V2'      *
*                                                                     *
*                                                                     *
*---------------------------------------------------------------------*

FORM BEDINGUNG_PRUEFEN_001.

 DATA: BP_DATUM_AUSGABE(10).   " Datumsfeld für editierte Ausgabe

* Is the reference document complete?
 IF VBUK-UVALS CN ' C' OR
 VBUK-UVALL CN ' C'.
 MESSAGE E021.
 ENDIF.

* Was the reference document fully referenced?
 IF VBUK-RFGSK = CHARC AND
 HVBAK-VBTYP NE CHARH AND
 HVBAK-VBTYP NE CHARI AND
 HVBAK-VBTYP NE CHARK AND
 HVBAK-VBTYP NE CHARL.
 MESSAGE E015.
 ENDIF.

....

This is especially used to set up break-points that can be used for debugging.
Also, new routines that are created are assigned. If you want to create your own routine ( See SAP ABAP Training related posts for the same ), then you would have to enter an Object Key as shown below.

Question 1 : Give the menu path for Delivery level Copy Control Data Transfer Routines

Question 2 : Which of the following is TRUE ?

  1. Order related Copying Requirement routine 001 is same as Delivery related Copying Requirement Routine 001
  2. Order Header Level Copying Requirement Routine 001 is same as Order line item level copying requirement routine 001
  3. Output Control Requirement routine 001 is same as Pricing Requirement Routine 001

Question 3 : How do you activate VOFM routines ?

Question 4 : What are the pre-requisites to create custom VOFM routines ?

Question 5 : What is the SAP suggested number range for creating custom VOFM routines ?

How to view the Contents of a Database Table in SAP ? – Feb 2011 SAP Training Batch

Many SAP Training students find it a little difficult to initially understand database tables. Here is a quick tutorial on how to view the contents of a database table in SAP. Use Transaction code [ SE16 ] or use the menu path

Demo Video

SAP Easy Access -> Tools -> ABAP Workbench -> Overview -> SE16 Data Browser


Enter the SAP Database table of your choice and hit enter.

The initial screen will show the fields for selection. All the fields in the database are not shown. If you want to see more fields in the initial data browser field selection screen, goto Settings -> Fields for Selection and choose the fields.

For example, if you want to select the orders from the Sales Org 1000, enter 1000 in the SAP Sales Org field and hit execute button.

You can double select each of the fields in the subsequent screen to view more on the details of the entries.

This post is useful for other SAP Training modules like SAP MM Training, SAP CRM Training, SAP FICO Training etc as well.

How to input stock into SAP – Jan 2011 SAP Training Batch

Problem : When doing delivery, some of our students faced issues with stock not being available. This is a very common problem faced by anybody who is currently training in SAP.

Solution : To resolve this, you would have to put dummy stock into the storage location ( As though real stock has come in ) . The easiest way to do this is via Transaction code [ MB1c ]. The menu path for the same is [ SAP Easy Access -> Logistics -> Logistics Execution -> Inbound Processes -> Goods Receipt for PO -> MB1c Goods Receipt for other activities ]

Step 1 : Use Transaction Code MB1c

Step 2 : Enter the Movement Type of 561, enter the plant and storage location where you want to input the stock

Step 3 : Enter the Materials and Quantities that you want to input. Save the Transaction. You can immediately go to MMBE ( Verify Stock in SAP ) and check the increase in quantity under the respective plant/storage location combination.

As usual, in order to practice these, please use the user id provided to you. If you are an ex-student and SAP Access has expired, you can extend it at a nominal price from Fuze Server.

This post is useful for both students doing SAP MM Training, SAP SD Training and SAP PP Training .

Toubleshooting :

1. Warning Message Saying “MRP Controller will be notified..” – Ignore it

2. Period xxx/2011 is not open for account type…”

–> There could be multiple reasons why this could be happening. One of the primary reasons why this happens is because of material accounts not being open. Use MMPV Transaction to do the same ( How to Open new Material Posting Periods in SAP )

Question 1 : Describe what Movement type 561 stands for in your own words ?

Question 2 : Using MB1c enter the following materials and quantities in Plant 1000 and storage location number 0001

  1. M-01    100
  2. M-02   250
  3. M-03   300

Give the SAP Material Document Number generated.

Question 3 : Which Transaction do you use to view SAP Material Documents ?

Question 4 : Specify the Accounting Document Number generated for the corresponding Material Document Number and the Description of the G/L Accounts updated by the A/C doc