topic Re: Problem in Select Query in Application Development and Automation Discussions

Problem in Select Query

Former Member — Wed, 05 Aug 2009 13:15:41 GMT

Hi,

I am getting header details from table BKPF. and then i am getting item details from BSEG table based on the document no and fiscal year.

SELECT BELNR BSCHL HKONT BUKRS WRBTR

SGTXT FROM BSEG INTO TABLE I_BSEG

FOR ALL ENTRIES IN I_BKPF WHERE

BELNR EQ I_BKPF-BELNR AND

GJAHR EQ P_GJAHR.

this query is working fine for all document but in some document no while checking in table it have 10 items but while running this program its having only 7 items i am wondering about this thing please give some idea to fix this issue.

Thanks in Advance

Re: Problem in Select Query

Pawan_Kesari — Wed, 05 Aug 2009 13:18:54 GMT


> 
>     SELECT BELNR BSCHL HKONT BUKRS WRBTR
>            SGTXT FROM BSEG INTO TABLE I_BSEG
>            FOR ALL ENTRIES IN I_BKPF WHERE
>            BELNR EQ I_BKPF-BELNR AND
>            GJAHR EQ P_GJAHR.
>

You should include all key fields in query, in this particular case include fields

BUKRS

BELNR

GJAHR

BUZEI.

Edited by: Pawan Kesari on Aug 5, 2009 6:49 PM

Re: Problem in Select Query

Former Member — Wed, 05 Aug 2009 13:20:20 GMT

HI,

FOR ALL ENTRIES will remove duplicate records.

So just fetch the entire key fields from BSEG into your internal table.

Regards,

Ankur Parab

Re: Problem in Select Query

Former Member — Wed, 05 Aug 2009 13:20:43 GMT

Hi Hema,

While using FOR ALL ENTRIES statement if the values are same in the all fields it will delete the duplicate records from the database table itself.

Inorder to avoid this problem you have to add some unique fileds for example in BSEG table BUZEI field is act like a index field so

while selecting data from BSEG table add this field then it can select all the 10 records from the database table..

and also before getting data from the item table check the header table have data...

if i_bkpf[] is not initial.

Regards,

John Victor

Re: Problem in Select Query

Former Member — Wed, 05 Aug 2009 13:22:22 GMT

Hi,

It looks like other documents are having different fiscal year you check the Fiscal year in Bseg.

donu2019t use bseg table in our query because Its Custer table.

Reagrds

Re: Problem in Select Query

Former Member — Wed, 05 Aug 2009 13:22:54 GMT

Thanks John & all for your quick reply now its working fine thanks for your timely help.

Re: Problem in Select Query

Former Member — Wed, 05 Aug 2009 13:24:39 GMT

Hi,

try to use all primary keys fields while fetching from BSEG table..BUKRS,BELNR,GJAHR,BUZEI.

Because while you are using for all entries it will remove duplicates and actuals also, so for all entries will fail

Prabhudas