https://community.sap.com/t5/application-development-and-automation-discussions/tvarvc-table/m-p/2651852#M611322 <HTML><HEAD></HEAD><BODY><P>If there is only one record and if it is say a parameter TVARVC-TYPE = 'P', then all you have to do is this</P><P></P><P>DATA: v_value LIKE tvarvc-low.</P><P></P><P>SELECT SINGLE low FROM tvarvc INTO v_value WHERE name = 'N_DAYS' AND type = 'P' AND numb = '0000'.</P></BODY></HTML> Tue, 21 Aug 2007 15:58:25 GMT Former Member 2007-08-21T15:58:25Z https://community.sap.com/t5/application-development-and-automation-discussions/tvarvc-table/m-p/2651851#M611321 <HTML><HEAD></HEAD><BODY><P>Hi Gurus,</P><P></P><P>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.</P><P></P><P>And now I need to pull that entry and need to store in a variable.</P><P></P><P>As of now I ahve written the following code:</P><P></P><P> select * into table it_tvarvc</P><P> from tvarvc</P><P> where name = 'N_days'.</P><P></P><P>thanks</P><P>Rajeev Gupta</P></BODY></HTML> Tue, 21 Aug 2007 15:49:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tvarvc-table/m-p/2651851#M611321 Former Member 2007-08-21T15:49:39Z https://community.sap.com/t5/application-development-and-automation-discussions/tvarvc-table/m-p/2651852#M611322 <HTML><HEAD></HEAD><BODY><P>If there is only one record and if it is say a parameter TVARVC-TYPE = 'P', then all you have to do is this</P><P></P><P>DATA: v_value LIKE tvarvc-low.</P><P></P><P>SELECT SINGLE low FROM tvarvc INTO v_value WHERE name = 'N_DAYS' AND type = 'P' AND numb = '0000'.</P></BODY></HTML> Tue, 21 Aug 2007 15:58:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tvarvc-table/m-p/2651852#M611322 Former Member 2007-08-21T15:58:25Z