topic Re: select problem again in Application Development and Automation Discussions

select problem again

Former Member — Tue, 13 Nov 2007 05:23:47 GMT

hi guys,

i have another question, whats the use of this field .....kinak = ' '......in the below sample code??what does this refer to??

select kschl sakn1 kwert from konv into table con

for all entries in doc

where knumv = doc-knumv

and kinak = ' '

and kschl in ('ZU01','R100','ZC25','ZDTR','ZDTL','ZDTP','ZDDA','ZRET','ZD06','ZDMI','ZDNP','ZDNE','ZDTD',

'ZC20','ZC01','ZC02','ZC03','ZC04','ZC05','ZC06','ZC07','ZC10','ZC14','ZC18','ZM09','ZC19',

'ZC27').

thanks in advance,

gerald

Re: select problem again

Former Member — Tue, 13 Nov 2007 05:24:36 GMT

Hi,

If the condition type is inactive then KINAK will be not initial..

In your case KINAK = ' ' means condition is active

Thanks

Naren

Re: select problem again

meikandan_krishnan2 — Tue, 13 Nov 2007 05:26:08 GMT

Hi,

The condition kinak = ' ' refers to the null value.

ie Select the records based on the condition where KINAK value is null.

Regards

Meikandan

Re: select problem again

Former Member — Tue, 13 Nov 2007 05:26:32 GMT

field .....kinak = ' '.. space record can be fetch from db table.

Re: select problem again

Former Member — Tue, 13 Nov 2007 05:27:54 GMT

hi guys,

can you explain further??whats that null value thing??

thanks very much.

gerld

Re: select problem again

Former Member — Tue, 13 Nov 2007 05:28:48 GMT

Hi,

Select statement you have provide will do the following

selects the required fields where your kunmv = doc-kunmv and it also check for

kinak = ' ' and kschl as you have provided

It will fetcvh a record where in it satisfy all the 3 conditions

if any one of the condition fail it doesnt bring the record

If you have written the conditions using OR statement it will fetch record if any one condition is satisfied.

Pls Reward points if usefull.

Re: select problem again

Former Member — Tue, 13 Nov 2007 05:29:22 GMT

hi,

here the value in field kinak of table konv

is SPACE, it will select only that data.

Regards,

Sandeep Kaushik

Re: select problem again

Former Member — Tue, 13 Nov 2007 05:29:29 GMT

KINAK Condition is inactive

Definition

Indicates if the condition is active.

Procedure

If you want to deactivate the condition, mark the field. During pricing, the system ignores conditions that are valid but not active.

REward if useful