Skip to Content
author's profile photo Former Member
Former Member

abap error

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 |

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2010 at 04: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 12, 2010 at 04: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 12, 2010 at 04:42 AM

    how many records does " ta_ywch1" hold?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2010 at 04: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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.