select from a parameter table

[Former Member]

Hi,

I have created a parameter table (small).

it contains these fields:

Objectid          Objectname     Action          Parm1

WD_FORM     Payroll              Include       Payroll text

WD_FORM     ovk                   Include        Agreements

WD_FORM     pens                  Include      Pension

Now, I want to read these 3 records in a select that now looks like this:

select *

     into corresponding fields of table it_cat

     from ( theic_category as c

     inner join threic_cateq_t as p on p~category = c~category )

     where c~category ---> here is the doubt. I want to include all 3 records from the above table.

How to do that ? Any indeas ?

Peter

[FredericGirod]

Hi Peter,

did you have try to reinvente the TVARVc table ?

regards

Fred

[Former Member]

Hi,

I need the table to be maintained as a kind of parameter table by useradm....

What is your suggestion

Peter

[FredericGirod]

Do you know TVARVC ?  go in SM30, table=TVARVC, press the maintain button

Fred

[Former Member]

The only hesitation I might have is that a lot of people write code to maintain TVARVC in the background.  It increases the chance of your data being altered.  Doesn't stop me from using it.  Just a thought.

Neal

[FredericGirod]

I'm agree with you Neal, for me the TVARVC must be managed centraly in a big SAP System, and not by team. And for old system, you could find a lot of variable not anymore used ..

regards

Fred