11-13-2007 5:23 AM
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
11-13-2007 5:28 AM
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>
11-13-2007 5:24 AM
Hi,
If the condition type is inactive then KINAK will be not initial..
In your case KINAK = ' ' means condition is active
Thanks
Naren
11-13-2007 5:26 AM
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
11-13-2007 5:26 AM
field .....kinak = ' '.. space record can be fetch from db table.
11-13-2007 5:27 AM
hi guys,
can you explain further??whats that null value thing??
thanks very much.
gerld
11-13-2007 5:28 AM
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>
11-13-2007 5:29 AM
hi,
here the value in field kinak of table konv
is SPACE, it will select only that data.
Regards,
Sandeep Kaushik
11-13-2007 5:29 AM
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>