Procedure
1. Start the activity using the transaction code ZFI05.
|
|
2. Perform one of the following:
|
If |
Then |
Go To |
|
The report will be run using a short date range (a week or less) |
Execute the report in foreground. |
Step 3 |
|
The report will be run using a long date range (more then a week) |
Execute the report in background and export the output to an Excel file. |
Step 18 |
3. As required, complete/review the following fields:
|
Field Name |
R/O/C |
Description |
|
Transaction/Event Type |
R |
This specifies what type of inventory event or inventory movement is being selected.
Example: WE (goods receipt for a purchase order) |
|
Posting Date in the Document |
R |
This field shows the date the inventory document was posted to the purchase order. Example: 11/27/07 to 11/30/2007 |
|
Article Number |
O |
This field can be used to specify a particular article or range of articles that you are looking for postings against.
Example: 20000000 to 299999999 |
|
Consumption posting |
R |
This specifies what type of posting was made (consumption, sales order, etc). Example: V (this represents a goods receipt consumption at the purchase order level) |
4. Click 
to execute the report.
|
|
5. The list of Sales Orders represents all orders where the related PO has had a Goods Receipt posting in the timeframe specified. This list can then be copied and pasted into the transaction code VF01 to invoice the customer.
For orders where billing has already been
processed, a simple error message will be displayed in VF01.
6. Perform one of the following:
|
If |
Go To |
|
The list should be exported to Excel |
Step 7 |
|
No export is necessary |
BPP for VF01 as this activity is complete. |
|
|
7. Click the Export button 
.and
select Spreadsheet.
|
|
8. Click 
to move past this
message and the screen below will appear. Select Table.
|
|
9. Click to confirm your
selection.
|
|
10. Click to confirm Microsoft
Excel should be used.
This feature is called "SAP Excel in
Place". The standard Microsoft Excel format is used to display the document,
but the Excel session is within SAP! (note the worksheet title
"Worksheet in Basis (1)". This indicates that the file must be saved in order
to retain the details. Any sorting, filtering, etc complete on screen prior to
executing a "Save As" will be removed when the file is saved. Remember to
"Save As" first in order to avoid lost work!
|
|
11. Click 
to maximize the
spreadsheet.
Microsoft Excel - Worksheet in Basis (1)
|
|
12. Select File
Save Copy As....
|
|
13. Click 
or select the appropriate
file path.
14. As required, complete/review the following fields:
|
Field Name |
R/O/C |
Description |
|
File name: |
R |
The name given to the file that is imported to or exported from SAP. Example: MB51 Query ZFI05.xls |
15. Click 
and the system will save
the exported file to the specified directory. Open Excel and select the file
for further processing.
|
|
16. The list of Sales Orders represents all orders where the related PO has had a Goods Receipt posting in the timeframe specified. This list can then be copied and pasted into the transaction code VF01 to invoice the customer.
For orders where billing has already been
processed, a simple error message will be displayed in VF01.
17. Go to Step 32.
18. As required, complete/review the following fields:
|
|
19. Press the F9 key on your keyboard to trigger background execution of the program.
|
|
Specify LOCL in the Output Device
field.
20. Click to confirm the selection.
|
|
21. Click 
to trigger execution in
the background immediately.
22. Click 
to save the background
job criteria and execute the job.
|
|
At the bottom of the screen please note
that it will state that the background job was scheduled. In this case since
we selected 'Immediate', the message is saying that the job/query was started.
23. Click 
to go back to the SAP
Menu Screen.
|
|
24. From the main menu, type in transaction code SM37 and press enter.
This step allows you to search for system
jobs run under your username. Notice the system defaults your user ID in the
User Name field.
|
|
.|
|
Mark the checkbox next to the job name
before selecting the Spool button.
.Output Controller: List of Spool Requests
|
|
You need to click the ABAP List icon under
the 'Type' column to view the report.
Graphical display of spool request 10715 in system PR1
|
|
27. Perform one of the following:
|
If |
Go To |
|
The list should be exported to Excel |
Step 28 |
|
No export is necessary |
BPP for VF01 as this activity is complete. |
28. Select Spool Request Forward
Save to Local File...or enter Ctrl+Shift+F12.
|
|
29. Click 
to save in Excel, then
click .
Graphical display of spool request 10715 in system PR1
|
|
30. Choose the desired directory and file name.
Graphical display of spool request 10715 in system PR1
|
|
to save the file.32. This activity is now complete. Refer to the VF01 BPP and proceed to paste these order numbers into the VF01 screen to generate billing documents.
A report with the goods receipts posted within the date range specified.
Comments