topic Re: select statment in Application Development and Automation Discussions

select statment

Former Member — Thu, 29 Jun 2006 10:26:00 GMT

hi friends,

i dont understand this statement pls help me.

1. Do look up in COAS to obtain "internal order"(COAS-AUFNR) and Internal Order Text(COAS-KText) using this conditions.

Ordertype(COAS-AUART)='x'

Release Status(coas-phas1)='x'

completion status(coas-phas2)<>'x'

cloasing status (coas-phas3)<>'x'

Delettion status(coas-loekz)<>'x'

what is 'x' there.

chandu

Re: select statment

Former Member — Thu, 29 Jun 2006 10:27:54 GMT

Hi here the 'x' is the value in the table for all these fields

example

deletion status <> 'x' means that the deletion indicator has not been set for that record.

the value of deletion status in the record should not be equal to 'X'.

Re: select statment

Former Member — Thu, 29 Jun 2006 10:30:01 GMT

In this they are fetching only the active records. For example LOEKZ is a deletion indiactor. If u delete any records in Master data, physically they are not deleting. i. e they assign the 'X' to LOEKZ field. but logically it is deleted . These records are not available in the Table. If you want to see the deleted records they are using these fields.

Hope it will be helpful

Re: select statment

Former Member — Thu, 29 Jun 2006 10:30:13 GMT

hi,

pls send select stament for this.

chandu

Re: select statment

Former Member — Thu, 29 Jun 2006 10:30:21 GMT

Internal Order will have different status. If a field = 'x' then it is maintained. Your functional consultant will be able to explain you about Internal Order status.

Thanks & Regards,

Govind.

Re: select statment

madan_ullasa — Thu, 29 Jun 2006 10:31:26 GMT

Ordertype(COAS-AUART)='x'

Release Status(coas-phas1)='x'

completion status(coas-phas2)<>'x'

cloasing status (coas-phas3)<>'x'

Delettion status(coas-loekz)<>'x'

Probably implies :

from table coas, field auart has value equal to 'X'.

similiarly for other things in the bracket.

'<>' implies 'not equal'.

hope this helps.

regards,

Madan..

Re: select statment

Former Member — Thu, 29 Jun 2006 10:32:24 GMT

Hi,

In ABAP we usually put 'X' as a flag. This signifies whether a certain condition is true or not. For example if deletion flag is 'X' then it says this record is marked for deletion.

And make sure when you write the query it should be capital 'X' not 'x'

Regards,

sumit.

Re: select statment

Former Member — Thu, 29 Jun 2006 10:33:50 GMT

I do not understand what do you want actually. Do you want the select clause to be written.

select aufnr ktext

into (coas-aufnr, coas-ktext)

from coas

where auart = 'X'

and phas1 = 'X'

and phas2 <>'X'

and phas3 <> 'X'

and loekz <> 'X'.

'X' means here 'YES'.

Regards,

Subhasish

Re: select statment

Former Member — Thu, 29 Jun 2006 10:35:55 GMT

select aufnr

ktext

from coas

into table t_tab

where auart = <some value> "I don't think it is 'X'

and phas1 = 'X' "Phase "Order released"

AND PHAS2 <> 'X' "Phase "order NOT completed"

AND PHAS3 <> 'X' "Phase "order closed"

AND LOEKZ <> 'X'. "Deletion flag NOT SET

rEGARDS,

rAVI

Re: select statment

Former Member — Thu, 29 Jun 2006 10:35:56 GMT

check this out

TYPEs : begin of ty_coas,

auart type AUFART

ktext type AUFTEXT,

end of ty_coas.

DATA: i_coas type standard table of ty_coas.

select aufnr

ktext

from coas

into table i_coas

where auart eq 'X' and

phas1 eq 'X' and

phas2 ne 'X' and

phas3 ne 'X' and

loekz ne 'X' .

Re: select statment

Former Member — Thu, 29 Jun 2006 10:36:41 GMT

DATA I_COAS like standard table of COAS.

SELECT * FROM COAS into I_COAS

Where AUART = ‘X’

AND PHASE1 = ‘X’

AND PHASE2 <> ‘X’

AND PHASE3 <> ‘X’

AND LOELZ <> ‘X’.

Re: select statment

Former Member — Thu, 29 Jun 2006 12:52:06 GMT

Hi Chandru,

use this-

select aufnr

ktext

into corresponding fields of table itab

from coas

where auart = 'X'

and phas1 = 'X'

and phas2 <> 'X'

and phas3 <> 'X'

and loekz <> 'X'.

X means its active.

Hope this helps!!!

Seema.

Re: select statment

Former Member — Thu, 29 Jun 2006 14:00:28 GMT

I don't know about the select statement, but I'd go back to the person that gave you the specs and ask what is meant by "Ordertype(COAS-AUART)='x'". Order type is a four character field. Unless your organization has created this order type, it may mean something else.

Rob