Community project: General purpose customizing table

[jrgkraus]

Use case

If there is a need for new customizing parameters in customer projects, we usually create tables, views, view clusters, access routines and so on. What if we used one single table for this? We would have an unique access module and could store as many parameters as we want using an access key.

Real-life experiences

I used this approach for many years in a mid-range implementation with about 3000 Users. It makes the developing more straightforward when it comes to use settings stored in the database. After 4 years, about 250 different parameter keys accumulated in our generic table. In case we have special requirements such as proper validation of values against domains or check tables, we continue using normal customizing features, but in case of simple setup parameters, the generic table is very helpful.

Features

• General customizing tables
• Possibility to set validity dates and user ids (for testing)
• Usage with our without change requests (customizing or non-customizing)
• Possibility to store structure-like parameters
• Possibility to store multi-value parameters 

Learn more on the github readme 

[BjörnS]

Hi @jrgkraus,

thank you for the project, we have been using a similar approach for years and are currently considering an ABAP Cloud redesign. I haven't searched the sources yet. Can the values ​​be maintained depending on permissions or can anyone maintain everything?

Greetings

Björn

[jrgkraus]

Hi @BjörnS,

no, actually there is no authority check implemented. In our case, the transaction-based check is sufficient.

[Jelena_Perfiljeva]

Thanks for sharing, @jrgkraus ! Neat idea. I've used (and created myself) similar setup many times. Usually it's not that evolved but I like the idea of expiration dates and user ID for testing.

I wish this was available 10+ years ago. 🙂

[Jelena_Perfiljeva]

@jrgkraus  Just returning to say thanks again and to let you know this post was featured in our recent newsletter story. Cheers! 🙂
https://boringenterprisenerds.substack.com/i/159298850/bffs-with-brf