Dear All,
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
CD-NEXT_SEQ
CD-LAST_PAY
RGDIR
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.
IMPORT
IN-VERSION TO OIN-VERSION
VERSC
WPBP
ABC
RT
CRT
BT
C0
C1
V0
VCP
ALP
DFT
GRT
LS
STATUS
ARRRS
DDNTK
ACCR
BENTAB
AB
FUND
AVERAGE
MODIF
RT_GP
CODIST
LIFL
LIDI
EPF
SAN
GRY
ESI
S80
S88
PET
IOS
HRA
CCO
PTX
EXM
HFS
S89
LWF
GEM
RIC
RIP
TAN
FROM DATABASE PCL2(IN) ID RX-KEY
IGNORING STRUCTURE BOUNDARIES.
endloop.
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.
Regards,
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 |