topic issue at for all entries command in Application Development and Automation Discussions

issue at for all entries command

Former Member — Sun, 10 Nov 2013 11:40:51 GMT

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

Re: issue at for all entries command

Former Member — Sun, 10 Nov 2013 11:58:23 GMT

Changed both query ...

INTO Table --> INTO corresponding field of TABLE

Then give a try...

Re: issue at for all entries command

Former Member — Sun, 10 Nov 2013 12:21:31 GMT

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

Re: issue at for all entries command

Former Member — Sun, 10 Nov 2013 12:21:33 GMT

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

Re: issue at for all entries command

Former Member — Sun, 10 Nov 2013 12:29:37 GMT

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.

Re: issue at for all entries command

Former Member — Sun, 10 Nov 2013 12:37:09 GMT

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.

Re: issue at for all entries command

Former Member — Sun, 10 Nov 2013 12:52:22 GMT

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,

Re: issue at for all entries command

Former Member — Sun, 10 Nov 2013 17:48:07 GMT

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.

Re: issue at for all entries command

Former Member — Sun, 10 Nov 2013 18:25:46 GMT

Hi All,

Thank you very very much to all for your guidance.

Finally I got my problem.

Regards,

Ajit