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 CDVERSION TO OCDVERSION

          CDNEXT_SEQ

          CDLAST_PAY

          RGDIR

          DIR2 TO %%_DIR2                                 

  FROM DATABASE PCL2(CU)

  ID CDKEY .


RGDIR table containing the that employee data for each month. using the employee number and sequential number .

LOOP AT RGDIR INTO WA_RGDIR .                              

    RXKEYPERNR = CDKEYPERNR.

    RXKEYSEQNO = WA_RGDIRSEQNR.

    IMPORT

      INVERSION TO OINVERSION                                    

      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 RXKEY

    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

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply