How to fetch check number details

[Former Member]

Hi ,

My requirement is to fetch the check number from payr table using CHECT field .

but relation ship i taken from bseg table.

i am giving query as follows

select single chect from payr into a_chect where vblnr = bseg-belnr.

above query is not giving solution.

is there any other relation ship for getting check number.

[Former Member]

Hi ,

My requirement is to fetch the check number from payr table using CHECT field .

but relation ship i taken from bseg table.

i am giving query as follows

select single chect from payr into a_chect where vblnr = bseg-belnr.

above query is not giving solution.

is there any other relation ship for getting check number.

i written subroutine program for calling into form .

form check_get tables in_tab structure itcsy

out_tab structure itcsy.

tables: payr.

data: a_chect type payr-chect,

b_belnr type bseg-belnr.

read table in_tab INDEX 1. "with key NAME = 'BSIK-BELNR'.

check sy-subrc = 0.

b_belnr = in_tab-value.

break-point.

select single CHECT from PAYR into A_CHECT where vblnr = b_belnr.

if sy-subrc = 0.

read table out_tab index 1. "with key 'CHECT'.

check sy-subrc = 0.

out_tab-value = a_chect.

modify out_tab index 1.

endif.

endform.