select problem again

[Former Member]

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

[Former Member]

Hi,

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

In your case KINAK = ' ' means condition is active

Thanks

Naren

[meikandan_krishnan2]

Hi,

The condition <b>kinak = ' '</b> refers to the null value.

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

Regards

Meikandan

[Former Member]

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

[Former Member]

hi guys,

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

thanks very much.

gerld

[Former Member]

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.

<b>Pls Reward points if usefull.</b>

[Former Member]

hi,

here the value in field kinak of table konv

is SPACE, it will select only that data.

Regards,

Sandeep Kaushik

[Former Member]

HI

<b>KINAK</b> 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.

<b>REward if useful</b>