data retrival from cluster table using BUFFER???????????

Former Member — Thu, 15 Jun 2006 11:51:53 GMT

Hi,

i would like to retreive payroll results from it's allocated cluster tables using buffer.

i donot know how to use BUFFER concept and it's statments.

could anyone guide me in this topic?

thanks

theresita.j

Re: data retrival from cluster table using BUFFER???????????

Former Member — Thu, 15 Jun 2006 11:53:33 GMT

Hi theresita,

i would like to retreive payroll results from it's allocated cluster tables .

1. U want the remuneration (monthly salary )

2. U won't get it DIRECTLY from any table.

(Its stored in cluster format)

3. Use this logic and FM.

DATA: myseqnr LIKE hrpy_rgdir-seqnr.

DATA : mypy TYPE payin_result.

DATA : myrt LIKE TABLE OF pc207 WITH HEADER LINE.

SELECT SINGLE seqnr FROM hrpy_rgdir

INTO myseqnr

WHERE pernr = mypernr

AND fpper = '200409'

AND srtza = 'A'.

IF sy-subrc = 0.

CALL FUNCTION 'PYXX_READ_PAYROLL_RESULT'

EXPORTING

clusterid = 'IN'

employeenumber = mypernr

sequencenumber = myseqnr

CHANGING

payroll_result = mypy

EXCEPTIONS

illegal_isocode_or_clusterid = 1

error_generating_import = 2

import_mismatch_error = 3

subpool_dir_full = 4

no_read_authority = 5

no_record_found = 6

versions_do_not_match = 7

error_reading_archive = 8

error_reading_relid = 9

OTHERS = 10.

myrt[] = mypy-inter-rt.

READ TABLE myrt WITH KEY lgart = '1899'.

4. the internal table myrt

will contain what u require.

*-------

I dont think there is any buffering concept

involved in cluster table.

regards,

amit m.

topic Re: data retrival from cluster table using BUFFER??????????? in Application Development and Automation Discussions

data retrival from cluster table using BUFFER???????????

Re: data retrival from cluster table using BUFFER???????????