topic Re: Cluster table in Application Development and Automation Discussions

Cluster table

Former Member — Mon, 25 Sep 2006 06:42:46 GMT

Hi all,

What are the Payroll cluster databases (PCLn).And how to read the Payroll cluster database

Help on this.

Regards

parul

Re: Cluster table

Former Member — Mon, 25 Sep 2006 06:45:05 GMT

Re: Cluster table

Former Member — Mon, 25 Sep 2006 06:46:37 GMT

Hi parul,

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.

regards,

amit m.

Re: Cluster table

Former Member — Mon, 25 Sep 2006 06:55:25 GMT

Hi,

Just cek this <a href="http://planetsap.com/HR_ABAP_payroll.htm">link.</a> It will help you.

Regards,

Re: Cluster table

Former Member — Mon, 25 Sep 2006 07:11:10 GMT

good

go through these links

http://fuller.mit.edu/hr/cluster_tables.html

thanks

mrutyun^

Re: Cluster table

anversha_s — Mon, 25 Sep 2006 07:18:55 GMT

hi parul,

chk this .

Cluster Table:

Cluster tables are logical tables that must be assigned to a table cluster when they are defined.

Cluster tables can be used to strore control data.

They can also be used to store temporary data or texts, such as documentation.

A clustered cannot be read from outside SAP because certain data are clustered and pooled in one field.

rgds

anver

pls mark helpful answers