select statment

[Former Member]

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

[Former Member]

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'.

[Former Member]

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

[Former Member]

hi,

pls send select stament for this.

chandu

[Former Member]

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.

[madan_ullasa]

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..

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

hi

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' .

[Former Member]

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’.

[Former Member]

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.

[Former Member]

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