Tvarvc Table

[Former Member]

Hi Gurus,

I have a condition where I need to pull an information from TVARVC table, I have an entry in Tvarvc "N_days" where the no. of days are stored.

And now I need to pull that entry and need to store in a variable.

As of now I ahve written the following code:

select * into table it_tvarvc

from tvarvc

where name = 'N_days'.

thanks

Rajeev Gupta

[Former Member]

Hi Gurus,

I have a condition where I need to pull an information from TVARVC table, I have an entry in Tvarvc "N_days" where the no. of days are stored.

And now I need to pull that entry and need to store in a variable.

As of now I ahve written the following code:

select * into table it_tvarvc

from tvarvc

where name = 'N_days'.

thanks

Rajeev Gupta

[Former Member]

If there is only one record and if it is say a parameter TVARVC-TYPE = 'P', then all you have to do is this

DATA: v_value LIKE tvarvc-low.

SELECT SINGLE low FROM tvarvc INTO v_value WHERE name = 'N_DAYS' AND type = 'P' AND numb = '0000'.