Read data from Cluster Table(B2)

[former_member184739]

I am currently involved in HR Programming. Now i am searching for reading data from Cluster Tables(Cluster Table:B2).
Is there any standard Function Module available for this or if anyone provide a sample code snippet for this would
be greatfull.Your help is appreciated.

Thanks
Prabaharan.

[sandeep_katoch]

Hi Prabaharan,

check this link

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3c46358411d1829f0000e829fbfe/content.htm

Regards,

Sandeep Katoch

[former_member184739]

Hi Sandeep ,

I tried as suggested by you using below but no luck.

Cluster Table :B2-ABWKONTI : Absence Quotas

IMPORT ITAB TO JTAB FROM DATABASE INDX(HK) ID 'ABWKONTI'.

Please suggest.

Thanks

Prabaharan

[sandeep_katoch]

Hi ,

check sy-subrc.

I doubt you are giving wrong values in key

Also try to specify the client also in import statement.

Alternatively try this FM

RP_CATT_LSTB2

You can find the documentation for this FM in below link

http://www.se80.co.uk/sapfms/r/rp_c/rp_catt_lstb2.htm

Regards,

Sandeep katoch

[former_member184739]

Sandeep,

Thanks for your valuable help. FM you have suggested can be used for pulling cluster data's.

  Again i have a doubt to ask . I have read in SAP Help portal and also from SCN that

  1.Cluster tables are defined in the data dictionary as transparent tables(http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm)

  2.You can access them using SELECT statements(http://scn.sap.com/thread/100902).

But Cluster Tables below are not defined in SE11.

   1.ABWKONTI – Absence Quotas
   2.QTACC – Absence Quota Generation – for adjustments

   3.ZES – Time Balances for each day – for accruals and usage

Please suggest.

Thanks

Prabaharan

[former_member184739]

Sandeep,

On Executing FM "RP_CATT_LSTB2" didnt fetch any results and i searched for related FM's to read  from Cluster B2 and i found an FM "HR_FORMS_TIM_GET_B2_RESULTS" which fetched me results as shown below.

We need to pass PERNR ,BEGDA and ENDDA to above FM .But in my report i have only "Key Date" in selection scree. I am in search of getting Perid Dates based on Key date.If you can throw some lights it will more helpfull.

Thanks

prabaharan

[Former Member]

Hi ,

Try this FM:

HR_TIME_RESULTS_GET

HR_TIME_RESULTS_IN_INTERVAL

Regards,

Boris