topic Re: How to create a range into table in Application Development and Automation Discussions

How to create a range into table

Former Member — Tue, 22 Jun 2021 14:27:38 GMT

Hi everybody,

I want to create a table with a range field type (i.e : /IWBEP/T_COD_SELECT_OPTIONS) for maintaining in SM30 tcode...

Is it possible?

Thanks for your Help,

Stéphane

Re: How to create a range into table

joltdx — Wed, 23 Jun 2021 03:25:33 GMT

Yes, it's possible. You can create such a table.

What specifically is it that's not working for you?

Re: How to create a range into table

FredericGirod — Wed, 23 Jun 2021 06:32:57 GMT

You could also include the structure of the TVARV / TVARVC table

Re: How to create a range into table

Gourab_Dey — Wed, 23 Jun 2021 14:03:23 GMT

Dear Stephane,

What is your requirement exactly? It seems like you want to store some values in the table with similar to select-option. There is a standard table already available "TVARVC". You can go to SM30 and give the table name TVARV. You can click on the "Selection Options".

You can go to change mode(by clicking on pencil button), then you can create button. Then lclick on the multiple-selection button and a selection-option pop-up will come. You can use that to store value. Also you can write a select-query to the table TVARVC to find out the values

Let me know if you are looking for the same or elaborate your exact requirement.

Cheers!

Gourab

Re: How to create a range into table

Former Member — Thu, 24 Jun 2021 13:09:20 GMT

Hi,

Thank you for your returns.

I need to qualify item with some criteria. For example, the program for the machine is different according to PRODUCT, COLOR, HEIGHT...

I would to create a table, accessible in SM30, to maintain the paramtere like in IMG_01.

I do it easely in an abap program :

I want to create the same table in SE11...

Frederic : In SE11, i can't put structure TVARV...

Gourab : I know i can do it in TVARVC, but i think it will be to difficult for user to maintain it...

Re: How to create a range into table

FredericGirod — Thu, 24 Jun 2021 13:15:21 GMT

And what about BRF+ ?

Re: How to create a range into table

joltdx — Thu, 24 Jun 2021 14:10:51 GMT

Yes, BRF+ is a good candidate in this case.

I have done something similar in the past, which might work here too if there is only I/EQ rows in the ranges. I simply made a table like a matrix of valid options, like so:

PARAM     | VALEUR  | PRODUIT  | MODELE  | COULEUR  | etc...
Programme | Pgm1    | PROD_A   | AXISC   | ROUGE    |
Programme | Pgm1    | PROD_A   | AXISD   | BLEUE    |
Programme | Pgm1    | PROD_B   | AXISD   | VERTE    |
Programme | Pgm2    | PROD_C   | AXISC   | VERTE    |

It's kind of similar to a BRF+ approach, and it's working but it's a bit messy to enter in SM30, like there has to be a unique key for each line and there will need be a single line for each and every valid combination of all the fields... With BRF+ you get an awesome Excel export/import and good overview, (and it will handle the key, and provide simulations among other things)

Re: How to create a range into table

Nikhil_Rao_ABAP — Fri, 25 Jun 2021 00:49:32 GMT

Hello Stephane,

I also liked gdey.sapabap's suggestion to use TVARVC( since SAP does much of the heavy lifting to provide screens for select-option maintenance).

If you are open to using 3 tables instead of 1, you might want to explore using view clusters. The hierarchy of the views would then be:

Program IDs -> Criteria IDs(per program ID) --> Select-options( per criteria ID)

There is plenty of information on creating View Clusters and maintaining them....

Regards,

Nikhil Rao