02-12-2010 4:36 AM
hi all ,
i'm now stuck with my coding...
dunno which part and why?
i do this coding
SELECT cdwclm amlabr INTO TABLE ta_labor FROM ywcl
FOR ALL ENTRIES IN ta_ywch1
WHERE cdwclm = ta_ywch1-cdwclm.
when i debug, its only capture 2 records.
but when i do a sqvi..its display 3 record which is correct. why ya?
SQVI :
EQA20800001052 10.00 MYR 10 424244
EQA20800001052 10.00 MYR 10 424244
EQA20800001052 0.00 MYR 99 424244
coding
1 EQA20800001052 | 10.00 |
2 EQA20800001052 | 0.00 |
02-12-2010 4:41 AM
Hi,
EQA20800001052 10.00 MYR 10 424244
EQA20800001052 10.00 MYR 10 424244
it is considering this entry as 1 record removing duplicate.. In for all entries extend the key in the where condition and check .
br,
Vijay.
02-12-2010 4:40 AM
Hi,
Select all the key fields of your table.
FOR ALL ENTRIES automatically deletes the duplicates based on the selected field list.
IF NOT ta_ywch1[] IS INITIAL. "Mandatory check is also missing
SELECT cdwclm amlabr INTO TABLE ta_labor FROM ywcl
FOR ALL ENTRIES IN ta_ywch1
WHERE cdwclm = ta_ywch1-cdwclm.
ENDIF.
Thanks,
Vinod.
02-12-2010 4:41 AM
Hi,
EQA20800001052 10.00 MYR 10 424244
EQA20800001052 10.00 MYR 10 424244
it is considering this entry as 1 record removing duplicate.. In for all entries extend the key in the where condition and check .
br,
Vijay.
02-12-2010 4:42 AM
02-12-2010 4:46 AM
hi,
In sqvi above two entry are same ........... in coding output depends upon the data in ta_ywch1...may be same data is available 2 times in internal table but finally internal table doesn't contains duplicate entry....because of For All Entry..
regards
Gaurav
02-12-2010 5:57 AM
hi instead of using for all entries
try using left outer join
u will get 3 entries
cheers
s.janagar