Fetch the cluster data from PCL2
Regarding this issue i saw many posts in SCN , but i didn’t got exact data what i require.
That is the reason i’m creating the this document .
PCL2 is containing the cluster data (in field CLUSTD) that data if we requires means we have to import the data by using database importing.
this situation will occur mainly , if we delete the data from tables that time data won’t store into table directly it will contain in data base directly with the form of cluster , this time we can’t get the data.
we can achieve like this situation by using the below code.
first we have to take the data by passing the key as CU- Cluster Directory and employee number into cd-key .
IMPORT CD–VERSION TO OCD–VERSION
DIR2 TO %%_DIR2
FROM DATABASE PCL2(CU)
ID CD–KEY .
RGDIR table containing the that employee data for each month. using the employee number and sequential number .
LOOP AT RGDIR INTO WA_RGDIR .
RX–KEY–PERNR = CD–KEY–PERNR.
RX–KEY–SEQNO = WA_RGDIR–SEQNR.
IN–VERSION TO OIN–VERSION
FROM DATABASE PCL2(IN) ID RX–KEY
IGNORING STRUCTURE BOUNDARIES.
we will get the all the tables data like RT data and Section 80 , Section 88.
Mainly we will use this one for Sections data.