retriveing data from table cluster B2

Former Member — Thu, 12 Jun 2008 10:16:53 GMT

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

Re: retriveing data from table cluster B2

Former Member — Thu, 12 Jun 2008 15:44:43 GMT

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

topic retriveing data from table cluster B2 in Application Development and Automation Discussions

retriveing data from table cluster B2

Re: retriveing data from table cluster B2