topic Re: select from a parameter table in Application Development and Automation Discussions

select from a parameter table

Former Member — Tue, 04 Nov 2014 14:18:48 GMT

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

Re: select from a parameter table

FredericGirod — Tue, 04 Nov 2014 14:26:05 GMT

Hi Peter,

did you have try to reinvente the TVARVc table ?

regards

Fred

Re: select from a parameter table

Former Member — Tue, 04 Nov 2014 14:36:23 GMT

Hi,

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

What is your suggestion

Peter

Re: select from a parameter table

FredericGirod — Tue, 04 Nov 2014 14:50:45 GMT

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

Fred

Re: select from a parameter table

Former Member — Tue, 04 Nov 2014 15:13:51 GMT

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

Re: select from a parameter table

FredericGirod — Wed, 05 Nov 2014 06:28:09 GMT

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