Skip to Content
avatar image
Former Member

How to fetch check number details

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 10, 2007 at 05:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded