issue at for all entries command

[Former Member]

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

[Former Member]

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

[Former Member]

Changed both query ...

INTO Table --> INTO corresponding field of  TABLE

Then give a try...

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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,

[Former Member]

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.

[Former Member]

Hi All,

Thank you very very much to all for your guidance.

Finally I got my problem.

Regards,

Ajit