topic Re: APPEND in Application Development and Automation Discussions

APPEND

Former Member — Mon, 17 Mar 2008 09:45:09 GMT

Hi all

If u see below there are two SELECT statements.In the first statement am selecting RECORD1 and in the second SELECT statement i want to select RECORD2.But whats happening is RECORD 1 is getting selected TWICE and in the output am getting as

RECORD1

RECORD2.

I tried using INTO table it_bseg in the second statment but am not getting it.Am also using DELETE ADJACENT.....But am getting the same out put.Please help.

With regards

Vijay

SELECT

belnr gjahr buzei bschl koart shkzg wrbtr

sgtxt saknr hkont kunnr lifnr prctr FROM bseg

INTO TABLE it_bseg FOR ALL ENTRIES IN it_bkpf

WHERE bukrs EQ p_bukrs AND belnr EQ it_bkpf-belnr AND

gjahr EQ p_gjahr AND umskz NE 'F' .

if not it_bseg[] is initial.

SELECT

belnr gjahr buzei bschl koart shkzg wrbtr sgtxt saknr hkont kunnr lifnr prctr FROM bseg

APPENDING table it_bseg

FOR ALL ENTRIES IN it_bseg WHERE bukrs EQ p_bukrs AND belnr EQ it_bseg-belnr AND gjahr EQ p_gjahr

AND umskz NE 'F' AND bschl IN r_bschl.

DELETE ADJACENT DUPLICATES FROM it_bseg comparing bschl belnr prctr.

endif.

Re: APPEND

Former Member — Mon, 17 Mar 2008 09:48:23 GMT

Hi krishna,

Just delete adjacent duplicates in it_bkpf befiore using for all entries and also in it_bseg before using.

Regards,

Madhu..!!

Re: APPEND

Former Member — Mon, 17 Mar 2008 09:49:31 GMT

Hi,

Try appending it separately after the two select statements.

Regards,

Ramya

Re: APPEND

Former Member — Mon, 17 Mar 2008 09:50:43 GMT

HI RAMYA..

Can u tell me exactly where to?

Re: APPEND

Former Member — Mon, 17 Mar 2008 09:51:01 GMT

hi madhu can u explain me exactly where to?

Re: APPEND

Former Member — Mon, 17 Mar 2008 09:52:40 GMT

hi ,

in your code use this..

after first select statement

sort the itab by field1.

delete adjacent duplicates from itab comparing the field1 .

regards,

venkat.

Re: APPEND

Former Member — Mon, 17 Mar 2008 09:52:57 GMT

Before DELETE ADJACENT DUPLICATES you must SORT this table with relevant fields.

Re: APPEND

Former Member — Mon, 17 Mar 2008 09:53:46 GMT

The record is selected twice because conditions in the second SELECT are almost equal to the conditions in the first SELECT. You only added the

AND bschl IN r_bschl

Also you are selecting using the FOR ALL ENTRIES and the condition for this is

AND belnr EQ it_bseg-belnr

which is selected in the first SELECT

AND belnr EQ it_bkpf-belnr

Maybe you want to change the FOR ALL ENTRIES condition to some other field, perhaps the Reversal document number.

Rgds

Mat

Re: APPEND

Former Member — Mon, 17 Mar 2008 09:55:12 GMT

Hi,

First sort the internal table it_bkpf based on the primary keys & then delete the adjacent duplicates from it. Next after the 1st select statement sort the internal table it_bseg & then delete the duplicate entries.

This may help you.

Regards,

Sayee

Re: APPEND

Former Member — Mon, 17 Mar 2008 09:56:08 GMT

Hi,

I think there may two differnt combination of RECORD1 may exist thats y its coming like that first of all check the internal table wether both the records having same values in all fields... if not then check for the condition....

check the internal table first by debugging..

Thanks.

Arunprasad.P

Reward if usefull.

Re: APPEND

Former Member — Mon, 17 Mar 2008 10:02:57 GMT

Hi Vijay,

I have a question here

Why are you doing 2 selects for the same table ?

anyway .......

Try something Like this ..

SELECT

belnr gjahr buzei bschl koart shkzg wrbtr

sgtxt saknr hkont kunnr lifnr prctr FROM bseg

INTO TABLE it_bseg FOR ALL ENTRIES IN it_bkpf

WHERE bukrs EQ p_bukrs AND belnr EQ it_bkpf-belnr AND

gjahr EQ p_gjahr AND umskz NE 'F' .

if not it_bseg[] is initial.

SELECT

belnr gjahr buzei bschl koart shkzg wrbtr sgtxt saknr hkont kunnr lifnr prctr FROM bseg

APPENDING table it_bseg

FOR ALL ENTRIES IN it_bseg WHERE bukrs EQ p_bukrs AND belnr EQ it_bseg-belnr AND gjahr EQ p_gjahr

AND umskz NE 'F' AND bschl IN r_bschl.

SORT it_bseg BY bschl belnr prctr.

DELETE ADJACENT DUPLICATES FROM it_bseg comparing bschl belnr prctr.

endif.

Reward if useful

Cheers

Kripa Rangachari.