reading clusters

[Former Member]

i am using payroll clusters.

how can i read ' wpbp ' cluster.

what macreo shud i use?

[Former Member]

HI,

Cluster tables combine the data from several tables with identical (or almost identical) keys into one physical record on the database.

Data is written to a database in compressed form.

Retrieval of data is very fast if the primary key is known.

Cluster tables are defined in the data dictionary as transparent tables.

Special language elements EXPORT TO DATABASE, IMPORT TO DATABASE and DELETE FROM DATABASE are used to process data in the cluster tables.

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

Regards

Sudheer

[former_member214288]

Hi Nidhi,

Cluster Table in which WPBP is stored is PCL2. You can use the following statement to import data. Note that we cannot fetch data from Cluster tables using Select Statements. Data can be fetched only using Import Statement.

IMPORT B2-VERSION TO OB2-VERSION
       WPBP
FROM DATABASE PCL2(B2)
ID B2-KEY.

Report RPCLSTB2 fetches data from WPBP Cluster. You can refer to this program.

Do Reward points if helpfull and close this question as answered.

Regards,

Ram

[Former Member]

hi

good

WPBP

Table WPBP contains data on the employee’s work center and basic pay.

Try with macro RP-EXP-C2-B2

thanks

mrutyun^

[Former Member]

Hi,

You can read the payroll cluster with the logical database PNP. Take a look at Report EXAMPLE_PNP_GET_PAYROLL and it's documentation. It's self-explanatory.

Regards