topic Re: Clarification on a SQL Query in Application Development and Automation Discussions

Clarification on a SQL Query

Former Member — Wed, 27 Feb 2008 07:03:21 GMT

Hi Gurus,

Can anybody explain me the below query. what does it actually do.

SELECT SINGLE INCPO INTO TVLK-INCPO

FROM TVLK

WHERE LFART = 'EL'.

thanks,

Ram.

Re: Clarification on a SQL Query

Former Member — Wed, 27 Feb 2008 07:07:40 GMT

Hi Ram,

The following query is fetching INCPO(Field) into TVLK-INCPO ( internal table field) from table TVLK where LFART = 'EL'.

Regards

Sourabh

Re: Clarification on a SQL Query

Former Member — Wed, 27 Feb 2008 07:10:00 GMT

Hi saurabh,

here, is TVLK intenal table or database table.

Re: Clarification on a SQL Query

Former Member — Wed, 27 Feb 2008 07:10:13 GMT

SELECT SINGLE INCPO INTO TVLK-INCPO

FROM TVLK

WHERE LFART = 'EL'.

this will select single record of INCPO from TVLK table by checking the condition LFART = 'EL'.

Re: Clarification on a SQL Query

Former Member — Wed, 27 Feb 2008 07:11:23 GMT

hi,

this 'single' will fetch one record depending upon the where condition

it is updating the incpo field with the value where LFART = 'EL'

regards,

pavan t.

Re: Clarification on a SQL Query

Former Member — Wed, 27 Feb 2008 07:14:39 GMT

Ram,

SELECT SINGLE INCPO INTO TVLK-INCPO

FROM TVLK

WHERE LFART = 'EL'.

When you declare the TAbles statement it will allocate some memory(work area) to that table

TABLES :TVLK--database table.

selecting the data based on condition and putting into work area of table TVLK.

Re: Clarification on a SQL Query

Former Member — Wed, 27 Feb 2008 09:04:05 GMT

Hi Ram,

If you define a statement TABLES followed by TVLK ..

It will create a WorkArea with the Structure of TVLK.

If this is your SELECT query..

SELECT SINGLE INCPO INTO TVLK-INCPO

FROM TVLK

WHERE LFART = 'EL'.

It will Fetch INCPO Value from the database table TVLK Where LFART equals to EL.

Regards.

Prabhu.

Re: Clarification on a SQL Query

Former Member — Wed, 27 Feb 2008 09:16:02 GMT

Hi,

SELECT SINGLE INCPO INTO TVLK-INCPO

FROM TVLK

WHERE LFART = 'EL'.

In the above query , INCPO value which is related to LFART = 'EL', will be replaced in the internal table field TVLK_INCPO.

REgards,

kavitha