topic Re: abap error in Application Development and Automation Discussions

abap error

Former Member — Fri, 12 Feb 2010 04:36:39 GMT

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 0.00 MYR 99 424244

coding

1 EQA20800001052 | 10.00 |

2 EQA20800001052 | 0.00 |

Re: abap error

vinod_vemuru2 — Fri, 12 Feb 2010 04:40:11 GMT

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.

Re: abap error

Former Member — Fri, 12 Feb 2010 04:41:54 GMT

Hi,

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.

Re: abap error

former_member188827 — Fri, 12 Feb 2010 04:42:06 GMT

how many records does " ta_ywch1" hold?

Re: abap error

Former Member — Fri, 12 Feb 2010 04:46:36 GMT

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

Re: abap error

Former Member — Fri, 12 Feb 2010 05:57:51 GMT

hi instead of using for all entries

try using left outer join

u will get 3 entries

cheers

s.janagar