Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

retriveing data from table cluster B2

Former Member
0 Likes
638

Hi Experts,

EXIT_SAPLHRLV_005 is used to change the results of quota generation - To change only the generated results calculated by time evaluation. The entire generation result from table QTACC (Absence Quota Generation) in cluster B2 .

I want to retrieving data from table QTACC. which is stored in table cluster B2. in PCL2 cluster table.

how we can retrieve data from that table QTACC.

Regards

Santhosh

1 REPLY 1
Read only

Former Member
0 Likes
467

Define QTACC with the following data statement in your program:

  • type for QTACC -

DATA: qtacc LIKE pc2bj OCCURS 0 WITH HEADER LINE.

DATA: time_results TYPE STANDARD TABLE OF ptm_time_results.

Then use the following function module

CALL FUNCTION 'HR_TIME_RESULTS_IN_INTERVAL'

EXPORTING

int_pernr = pernr-pernr

int_begda = pn-begda

int_endda = pn-endda

TABLES

int_time_results = time_results

EXCEPTIONS

no_period_specified = 1

wrong_cluster_version = 2

no_read_authority = 3

cluster_archived = 4

technical_error = 5.

CASE sy-subrc.

WHEN 0.

CLEAR: qtacc[].

CLEAR: qtacc.

LOOP AT time_results INTO time_results_wa.

APPEND LINES OF time_results_wa-qtacc TO qtacc.

ENDLOOP.

ENDCASE.

After that Loop through QTACC