How to read data from clusters ( Time Management )

[Former Member]

Hi All,

How can we read data from cluster tables related to Time Management in different ways?

Can somebody help me please..

Thanks,

Sankar.

[Former Member]

Hi Sankar,

pliz refer the following link

http://help.sap.com/saphelp_erp2005/helpdata/en/fc/eb3bb7358411d1829f0000e829fbfe/frameset.htm

[Former Member]

Hi

Kindly check the following thread:

It has a sample code to read from & to store data in a cluster table

Hope you are looking for cluster tables in HR

Some useful HR tables:

HRP1000 - Infotype 1000 DB Table

HRP1001 - Infotype 1001 DB Table

HRP1028 - Infotype 1028 DB Table

Paxxxx - transparent tables for infotypes

PCL1 - HR Cluster 1

PCL2 - HR Cluster 2

PCL3 - HR Cluster 3

PCL4 - HR Cluster 4

PCL5 - HR/RP Cluster 5; HR Planning Usage

PERNR - Standard Selections for HR Master Data Reporting (Structure)

kindly check the following link for some useful HR tables:

http://www.atomhr.com/know_preview/SAP_HR_tables.htm

Hope this helps!

best regards,

Thangesh

[Former Member]

Ravi,

I guess you didnt get my question exactly. My question is to read the data from the clusters related to Time Management like B1 and B2 and the files PCL1 and PCL2 and the tables in those clusters like ZES, SALDO etc...

I heard that there are couple of ways to read the data from the clusters by using Macros and function modules..

If anybody knows about what are they and how to use those, can u please share.

Thanks in advance,

Sankar.

[Former Member]

Hi Sankar,

I think the easy way to read cluster B1 & B2 is using this Function: HR_TIME_RESULTS_GET

  DATA: T_ZL TYPE PC2BF OCCURS 0 WITH HEADER LINE.
  data: begin of tgetbuff occurs 0,
      x(10),
  end of tgetbuff.
     
  CALL FUNCTION 'HR_TIME_RESULTS_GET'
       EXPORTING
         GET_PERNR     = PERNR
         GET_PABRJ     = YEAR
         GET_PABRP     = MONTH
*         GET_CLTYP     = '1'
       TABLES
         GET_TBUFF     = TGETBUFF
         GET_ZL        = T_ZL
       EXCEPTIONS
         NO_PERIOD_SPECIFIED   = 1
         WRONG_CLUSTER_VERSION = 2
         NO_READ_AUTHORITY     = 3
         CLUSTER_ARCHIVED      = 4
         TECHNICAL_ERROR       = 5
         OTHERS                = 6.

Regards,