Using select statements

[Former Member]

Hi,

I have a doubt in two things using select statements.

1. In sales report generation, do not select orders with del block or billing block ( LIFSK & FAKSK = 'x'.)

2. How to always group by document type and print total of net value.

Thanks,

Stalin.

[Former Member]

Hi Stalin.

1. In select query you have to neglect (in where condition).

del block LIFSK <> 'X'

billing block FAKSK <> 'X'

2. Use group by clause in select query.

Jayant Sahu

[Former Member]

ANSWERS

1. In sales report generation, do not select orders with del block or billing block ( LIFSK & FAKSK = 'x'.)

2. How to always group by document type and print total of net value.

u can write query as........

SELECT F1 F2 F3

FROM TABLE

into ITAB

WHERE LIFSK = 'X AND

FAKSK = 'X'

GROUP BY DOC_TYPE

Reward if useful

Narendra