How to read from PCL2, B2 Cluster based on the Last Updated date.

[Former Member]

Hi Experts,

How to get values Form B2 Cluster , time evaluation results, Based on the Last updated date. I hope FM HR_FORMS_TIM_GET_B2_RESULTS or macro RP-IMP-C2-B2 to used to get value from B2 Cluster . How i can retrive records from B2 cluster updation date is sy-datum. is it possible .

I don't have pernr value !

Thanks and regards

Renjith MP

[Former Member]

Question is Answered

[Former Member]

hi Renjith,

As mentioned in the earlier replies, u need a pernr to read the cluster table.

pernr and sequence number are the key to read the cluster.

But as in your case, where you want the B2 entries according to updation date---there is a workaround..

you can create a Zreport and do the following steps

1)select all the entries from PCL2 table with relid = B2 and AEDTM as sy-datum.

2)in the resulting entries, filter out the pernr i.e., the fieldSRTFD has both pernr and seqno.

get the first 8 digits of the SRTFD which is the pernr.you can eliminate the leading zeroes.

3)and then for these pernrs you can call the function module HR_FORMS_TIM_GET_B2_RESULTS or the macro...individually.

But on thing is for sure--u definitley need a pernr to read the cluster table entries or anything which reads a cluster table.

Try the above and let me know.it should wor..:)

[Former Member]

HI Renjith,

All the function modules are taking the input as pernr, without pernr it is not possible to get the value. Can you tell what is the requirement of the report?

BR/Manas

[Former Member]

Hi,

The file PCL2 contains the cluster B2, which is relevant for time evaluation. You can use report RPCLSTB2 (Display Time Evaluation Results (Cluster B2)) to view all the results of time evaluation, and the basic data and time data for each time evaluation period.

The file PCL1 contains the cluster B1, which is relevant for time evaluation. You can use report RPCLSTB1 (Display Recording Data (Cluster B1)) to obtain an overview of all the processed and unprocessed time events, generated and not yet corrected or confirmed messages from time evaluation, and important status fields

Regards,

Prasad