ALV with IDA example
Dear community, I recently worked again with the SAP List Viewer with Integrated Data Access (ALV with IDA). Some time ago I made some first steps with it but then a lot of private issues came up. Simply real life 🙂
So what is it about? The main difference to the classic ALV ist the type of access to the data in our database. An ABAP Core Data Service View is used as the data source. Therefore no need for any special application logic for the selection and preparation of the data. All of this has to be done in the ABAP CDS. I think this is a nice possibility to learn ABAP CDS and at the same time to try out the output in the very familiar ALV environment.
I built my very simple demo scenario around units of measurement (database tables T006 and T006A). Units of measurement are an important thing through the whole SAP ERP system. It’s also interesting to see what units of measurements there are and how they are called in different languages.
I published my demo scenario on GitHub in this repository. So everyone has a small starting point and can do own research. As always access it with abapGit. I did the development on a SAP NetWeaver 7.52. With small adjustments, this should also work on a SAP NetWeaver 7.50.
Have fun with your first steps.
Best regards and stay healthy
P.S.: Not tired of reading blogs? Don’t miss this one by Jörgen Lindqvist.
Cloning on a new system, it dumps because ZC_VARIANTS_OVERVIEW (return type for GET_DATA) is unknown.
Let me know when it is fixed, it looks like a nice compact example, always good to have.
Yep, should be ZB_UOM. Thanks for your support. I will fix that this evening.
For everyone: Michael has already fixed it 🙂
Thanks for sharing, Michael!
I really like the concept (and we even included a very short example in ABAP Introduction book 🙂 ) but I never got a chance to use it in a "real" system. Just wondering, how is performance in this scenario compared to regular ALV?
Thanks for this, I want to ask if there is any tools that I can use to track bing serp for free?
Is it possible for the color of the key column to be the same as the other columns?