topic Using select statements in Application Development and Automation Discussions

Using select statements

Former Member — Wed, 06 Feb 2008 07:15:36 GMT

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 — Wed, 06 Feb 2008 07:20:04 GMT

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 — Wed, 06 Feb 2008 07:22:26 GMT

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