This website is not affiliated with, sponsored by, or approved by SAP AG.

FAQ: List Edit Reports

Logistics : PM and its sub-modules & SM

Moderators: Snowy, thx4allthefish, PJA

FAQ: List Edit Reports

Postby PJA » Mon Jun 19, 2006 6:37 am

FAQ: List Edit Reports

Please contribute:

Selection Variant

You can set-up many selection variants for most reports in R/3.

These selection variants can contain fixed data such as plant. They can also contain dynamic data such as today's date minus 30 days. You can make fields mandatory, or hide them, etc.

There is one nice function mainly applicable to the PM/CS modules in which the user can default their own settings each time they enter the report. This can be done as follows:

  • Enter your data in the relevant selection-screen. You can use dynamic selection fields to defaut dates
  • Page to the bottom of the screen and enter display variant name entered in step above
  • Save variant as U_XXXXXX where XXXXX is your user name
  • Re-run the transaction to test. You should find your defaults have been automatically assigned from variant U_XXXXXX
  • Your variant will be called every time, even if you log-off and back on again
The above does not stop you from manually selecting another variant once the selection-screen has been displayed.

One negative aspect of this functionality is that a company that uses the PM module extensively may have 1000s U_XXXXXX type of variants.

You can include this functionality in your own ABAP programs too. Have a look at SAP's ABAP code in program RIAUFK10 and routine VARIANT_START_F68.


Layout Variant

Layout variants are used to control which data columns are shown in the report display screen.

The data columns can be chosen while the list is being displayed by using menu option Settings > Display variant > Current. The pop-up which is presented displays the current fields which have already been selected (on the left of screen) and those which can be chosen (on the right). List order, totals / subtotals and filtering can also be defined in a display variant and saved for future use with the menu options under the "Edit" submenu.

Note that if one or more columns have been selected (by clicking on the column title) when these menu options are initiated, the system will assume that the user wishes to order, filter etc. on those columns, otherwise a selection will be presented.

Once the display variant has been set up it can be saved using menu option Settings > Display variants > Save as variant. Subsequently the display variant can be selected by using menu option Settings > Display variants > Get.

Alternatively each user can nominate one default display variant using menu option Settings > Display variant > Administration. Select the display variant required and execute menu option Edit > Set initial var or simply click in the Initial variant column. Note that sort criteria, filtering and totals are not taken into consideration when downloading (e.g. to spreadsheet).

Lastly you can add this layout variant to the selection variant defined in the above section. This enables you to link the selection-screen data and the report display data together.

To deactivate the ALV grid view, enter the following PID Q_ALV_GRID_INACTIVE in your user profile
Also try PID 0AV (Order list: List variant)

Downloading to MS Access

Before you can use MS Access you must first ensure that the following two RFCs have been created:

    PS_ACCESS_1 is used for downloading the table structure in MS Access format.
    PS_ACCESS_2 is used to populate the table created with PS_ACCESS_1.
These RFCs can be also used in the various PM/CS list edit reports to download data into MS Access. In the display screen you will find a menu option for Access. They can also used in the IBIP transaction.

For further details see OSS Note 583698: MS Access Interface

User-Exit for List Edit Reports

IWOC0004: Change single-level list editing PM/QM/SM ALV settings

You can use this customer exit to alter how single-level lists are displayed in Customer Service, Plant Maintenance and Quality Management. When doing this, you can change accordingly various parameters and tables that are transferred from the report in the ABAP List Viewer (ALV). For example, the following changes are possible:
  • Deactivate alternating white/gray display
  • Set print parameters (with/without cover sheet)
  • Change field attributes in the field catalog (hide fields, set automatic optimization of column widths, define fields as being mandatory)
  • Change field grouping for field selection
  • Enter a title for the list

BADI for List Edit Reports

IWOC_LIST_TUNING: Performance Tuning for Lists in PM/CS

You can use the Business Add-In to exchange the views used for elections in Plant Maintenance and Customer Service lists. To do this, you can use the methods CHANGE_VIEW to optimize the selection. In addition, you can exclude the main selection criterion from the selection, depending on the number of entries. The selected data records are then later checked according to these selection criteria.

Report Management

- Remove selection variant protection - report RSVARENT. Allows you to delete somebody elses variant .
- Delete all user layouts for a user - report BCALV_LAYOUT

Emailing List Edit Reports
Note: this will only work if your system is set-up for external emailing (see TCode SCOT)
  1. Create variant for the report you want to run
  2. S023: Create distribution list and add the email or SAP user name in distribution lists
  3. SM36: Define a simple job
  4. Specify Job start condition: Immediate checked and periodic job scheduled start No. start after
  5. Steps: ABAP program name and variant name
  6. Spool List Recipient: Define internal user or distribution list or external address.
  7. Save and release the background job.
Last edited by PJA on Fri Dec 29, 2006 8:45 am, edited 15 times in total.
PJA
 
Posts: 11383
Joined: Sun Jul 20, 2003 3:11 pm
Location: Deepest darkest Aberdeenshire

FAQ List Edit reports

Postby Brenton » Mon Jun 19, 2006 7:41 pm

PJA,

my suggestions below - feel free to amend / correct.

Display Variant

This is used to control what fields (columns) are included in the list edit display. The fields can be chosen while the list is being displayed by using menu option Settings > Display variant > Current. The pop-up which is presented displays the current fields which have already been selected (on the left of screen) and those which can be chosen (on the right). List order, totals / subtotals and filtering can also be defined in a display variant and saved for future use with the menu options under the "Edit" submenu. Note that if one or more columns have been selected (by clicking on the column title) when these menu options are initiated, the system will assume that the user wishes to order, filter etc. on those columns, otherwise a selection will be presented. Once the display variant has been set up it can be saved using menu option Settings > Display variants > Save as variant. Subsequently the display variant can be selected by using menu option Settings > Display variants > Get. Alternatively each user can nominate one default display variant using menu option Settings > Display variant > Administration. Select the display variant required and execute menu option Edit > Set initial var or simply click in the Initial variant column. Note that sort criteria, filtering and totals are not taken into consideration when downloading (e.g. to spreadsheet).

Selection variant

Need to expand current comments to indicate that many selection variants can be set up and the special case U_XXXXXX should be used when the user wants that selection variant as their default.

I would include a comment on status but this depends on what is being displayed (e.g. order will be different to notification etc) - maybe getting to detailed?

Regards,
Brenton
Brenton
 
Posts: 98
Joined: Mon Apr 10, 2006 6:53 pm
Location: Melbourne, Australia

Re: FAQ: List Edit Reports

Postby sbutterworth » Wed Jul 30, 2008 8:51 pm

Pete,
Great article. This may also be useful for the selection variant.
You can create a user variable that automatically defaults for the user, but you do not have to clutter up the variant selections with it. It is hidden using the "Only display in catalog" check box.
It will still be accessible in your transaction (because you know the identifier and it always defaults for you) but it is now only visible using SA38 for the program using the Variant Overview button.
It is not shown in the available variants for transactions or SA38 / SE38 using menu path: Go to > Variants or in SE38 using the "Variants" button.

An additional, often confusing feature is the dymamic date calculation function.
I have a document showing how to set this up, along with the 'making the variant invisible' settings but have not yet figured out how I can (or if I'm allowed to) upload a document, and I don't have enough posts to attach a URL using BBcode, but I think this might at least make the address visible, if not executable.

Dymamic date calculation

Of course, all of this is in 4.7. I think I recall it's unchanged in 5.0 ECC, but haven't got to 6.0 yet.
sbutterworth
 
Posts: 51
Joined: Wed Jul 16, 2008 5:01 pm
Location: USA


Return to Logistics PM

Who is online

Users browsing this forum: No registered users and 5 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.