Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

issue at for all entries command

Former Member
0 Likes
1,221

Hi Experts,

I am working on FOR ALL ENTRIES command and my code is like...

DATA: v_belnr TYPE belnr_d.

SELECT-OPTIONS: s_belnr FOR v_belnr.

TYPES: BEGIN OF ty_bkpf,      " ACCOUNTING DOCUMENT HEADER

       bukrs TYPE bukrs,      " COMAPNY CODE

       belnr TYPE belnr_d,    " ACCOUNTING DOCUMENT HEADER

       xblnr TYPE xblnr1,     " REFERENCE DOCUMENT NUMBER

       budat TYPE budat,      " POSTING DATE OF DOCUMENT

       END OF ty_bkpf.

TYPES: BEGIN OF ty_bseg,      " ACCOUNTING DOCUMENT SEGMENT

       bukrs TYPE bukrs,      " COMPANY CODE

       belnr TYPE belnr_d,      " ACCOUNTING DOCUMENT HEADER

       buzei TYPE buzei,      " NUMBER OF LINE ITEM WITHIN ACCOUNTING DOCUMENT

       gsber TYPE gsber,      " BUSSINESS AREA

       wrbtr TYPE wrbtr,      " ACCOUNT IN DOCUMENT CURRENCY

       zuonr TYPE dzuonr,     " ASSIGMENT NUMBER

       kunnr TYPE kunnr,      " CUSTOMER NUMBER

       END OF ty_bseg.

TYPES: BEGIN OF ty_final,

       bukrs TYPE bukrs,      " COMAPNY CODE

       belnr TYPE belnr_D,      " ACCOUNTING DOCUMENT HEADER

       xblnr TYPE xblnr1,     " REFERENCE DOCUMENT NUMBER

       budat TYPE budat,      " POSTING DATE OF DOCUMENT

       buzei TYPE buzei,      " NUMBER OF LINE ITEM WITHIN ACCOUNTING DOCUMENT

       gsber TYPE gsber,      " BUSSINESS AREA

       wrbtr TYPE wrbtr,      " ACCOUNT IN DOCUMENT CURRENCY

       zuonr TYPE dzuonr,     " ASSIGMENT NUMBER

       kunnr TYPE kunnr,      " CUSTOMER NUMBER

       END OF ty_final.

DATA: it_bkpf TYPE TABLE OF ty_bkpf,

      it_bseg TYPE TABLE OF ty_bseg,

      it_final TYPE TABLE OF ty_final,

      wa_bkpf TYPE ty_bkpf,

      wa_bseg TYPE ty_bseg,

      wa_final TYPE ty_final.

SELECT bukrs belnr xblnr budat

       FROM bkpf

       INTO TABLE it_bkpf

       WHERE belnr IN s_belnr.

IF it_bkpf IS NOT INITIAL.

  SELECT BUKRS belnr buzei gsber wrbtr zuonr kunnr

         FROM bseg

         INTO TABLE it_bseg

         FOR ALL ENTRIES IN it_bkpf

         WHERE belnr = it_bkpf-belnr.

ENDIF.

So whenever I execute the code the it_bkpf is getting data as per selection but when the select query execute for bseg table it_bseg is not getting any value.

I checked it by debugging but unable to find out why the it_bseg is not getting dada.

Could you please check my code, where exactly i made mistake so data is not coming to it_bseg internal table.

Kind Regards,

Ajit Sarangi

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,182

Changed both query ...

INTO Table --> INTO corresponding field of  TABLE

Then give a try...

Changed both query ...

INTO Table --> INTO corresponding field of  TABLE

Then give a try...

8 REPLIES 8
Read only

Former Member
0 Likes
1,183

Changed both query ...

INTO Table --> INTO corresponding field of  TABLE

Then give a try...

Read only

0 Likes
1,182

Hi Chandra,

Thanks for replay but i want to use for all entries.Please guide me how to solve this issue by for all entries.

Kind Regards,

Ajit

Read only

0 Likes
1,182

Hi Chandra,

Thanks for replay but i want to use for all entries.Please guide me how to solve this issue by for all entries.

Kind Regards,

Ajit

Read only

0 Likes
1,182

Dear Ajit,

Please try to modify your query.

SELECT bukrs belnr xblnr budat

       FROM bkpf

      INTO corresponding field of  TABLE it_bkpf

       WHERE belnr IN s_belnr.

SELECT BUKRS belnr buzei gsber wrbtr zuonr kunnr

         FROM bseg

         INTO corresponding field of  TABLE it_bseg

         FOR ALL ENTRIES IN it_bkpf

         WHERE belnr = it_bkpf-belnr.

Read only

Former Member
0 Likes
1,182

Hi Ajit,

I tried your code and it is working fine.

Please check if bseg table has corresponding entries for the records in it_bkpf.

Read only

Former Member
0 Likes
1,182

Hi Ajit,

         code is working perfectly fine. just go to Bseg table and check wheater the give belnr exist in the Bseg table are not. With me the code is working fine.

ajit try to add company code, and fiscal year to your query as well.

IF it_bkpf IS NOT INITIAL.

   SELECT BUKRS belnr buzei gsber wrbtr zuonr kunnr

          FROM bseg

          INTO TABLE it_bseg

          FOR ALL ENTRIES IN it_bkpf

          WHERE belnr = it_bkpf-belnr

            and gjahr = it_bkpf-gjahr

            and bukrs = it_bkpf-bukrs.

ENDIF.

Regards,

Read only

Former Member
0 Likes
1,182

Ajit,

Check once whether the table BSEG is having records or not.

GO to SE11-->Table BSEG--->Execute--->Provide any BELNR values and choose execute.,If you get any records then your code should also works fine and you can get the records.

Thanks,

Uday.

Read only

Former Member
0 Likes
1,182

Hi All,

Thank you very very much to all for your guidance.

Finally I got my problem.

Regards,

Ajit