topic Read data from Cluster Table(B2) in Application Development and Automation Discussions

Read data from Cluster Table(B2)

former_member184739 — Thu, 16 May 2013 07:10:48 GMT

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.

Re: Read data from Cluster Table(B2)

sandeep_katoch — Thu, 16 May 2013 07:56:39 GMT

Hi Prabaharan,

check this link

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

Regards,

Sandeep Katoch

Re: Read data from Cluster Table(B2)

former_member184739 — Thu, 16 May 2013 08:21:11 GMT

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

Re: Read data from Cluster Table(B2)

sandeep_katoch — Thu, 16 May 2013 08:56:34 GMT

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

Re: Read data from Cluster Table(B2)

former_member184739 — Thu, 16 May 2013 11:33:28 GMT

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

Re: Read data from Cluster Table(B2)

former_member184739 — Thu, 16 May 2013 12:06:11 GMT

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

Re: Read data from Cluster Table(B2)

Former Member — Thu, 16 May 2013 14:47:24 GMT

Hi ,

Try this FM:

HR_TIME_RESULTS_GET

HR_TIME_RESULTS_IN_INTERVAL

Regards,

Boris