Skip to Content
Technical Articles
Author's profile photo Sébastien HERMANN

LISTCUBE replacement : a new way to display data

Hello,

ZLISTCUBE1.jpg

If you are tired of see this popup when trying to display a provider content, you have now a fresh solution : ZLISTCUBE

This program is designed to replace standard LISTCUBE and do almost all LISTCUBE does :

– Display content of any infoprovider, as well as listcube does

– Choose dynamically selection fields you want to use

ZLISTCUBE2.jpg
– Select dynamically which field you want to display
ZLISTCUBE3.jpg

– Filter on key figure value
– Save or Load selection variant
– Use ALV display variant

ZLISTCUBE4.jpg
– Export infoprovider content to file (local/server)
It could be batched and is a very easy solution to export data
from BW to another system
If you dont specify any excluded field, nav attribute will also
be kept in the file (but always empty) : file format used by import
– Load infocube directly from file (local/server)
Import file must have the same structure as complete export file
with nav attributes
You can use the filter field to define restriction displayed in
Infoprovider management window for the load

ZLISTCUBE5.jpg
– Extract huge amount of data by using serialization & server file
– If a complex query is not managed, you can switch to the standard
listcube directly from selection screen

ZLISTCUBE6.jpg

Instructions is given in the header of the program to replace standard listcube by this one, but you can use the program as a standalone specific if you prefer.

And there is a direct download link (remember that you will need SAPLINK to install) :

Download link : https://www.mediafire.com/folder/if3ljcnesme7y/ABAP

Feel free to comment here 🙂


My others blogpost :

Abstraction class to generate MSWORD with SAP using OLE

ZAL11 : a replacement for AL11

ZTOAD – Open SQL editor

Generate DOCX file in ABAP

ZAUTODOC : Automatic generation of technical BW documentation

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good Work!!

      When i try to download the code , i receive the message : ZLISTCUBE_nugg couldn't be download.

      Author's profile photo Sébastien HERMANN
      Sébastien HERMANN
      Blog Post Author

      Could you retry please ? it may be good now 🙂

      Author's profile photo Sébastien HERMANN
      Sébastien HERMANN
      Blog Post Author

      Update of the program to fix various minor bugs and little enhancements.

      Also fixed the link in first post.

      Author's profile photo Former Member
      Former Member

      Dear Sébastien,

       

      I tried this in an ECC6 Ehp7 IDES and it dumps because RSDRC_INFOPROV_READ does not exist in the system. However, it exists in an ECC6 Ehp6 IDES system. Do you know if this is already obsolete? There is another FM called RSDRI_INFOPROV_READ which is very similar. Can this be used instead?

       

      Cheers,

      Nathan

      Author's profile photo Sébastien HERMANN
      Sébastien HERMANN
      Blog Post Author

      Hello,

      You can't easilly use RSDRI* instead of RSDRC* FM. But, I found class
      SPAN {
      font-family: "Courier New";
      font-size: 10pt;
      color: #000000;
      background: #FFFFFF;
      }
      cl_rsdrc_infoprov  which seem to replace the FM RSDRC 🙂

      I will update the link during the day.

       

      But, to tell the truth, i do not use this program anymore. Why ? Because there is a standard program that fit far better to my dreams : transaction RSRT

      You can query any provider directly in RSRT by using this syntax in the "query" field : PROVIDER/!PROVIDER

       

      For example, you want to query 0IC_C03 cube ? type 0IC_C03/!0IC_C03

      You want to query masterdata 0MATERIAL ? type 0MATERIAL/!0MATERIAL

       

      Of course, you can also use third party tool like analysis for office, if allowed by your licence 😉

       

      Author's profile photo Sébastien HERMANN
      Sébastien HERMANN
      Blog Post Author

      New version released which fix the dump for FM RSDRC_INFOPROV_READ missing.