How to copy R/3 Standard Datasource

 Here will take datsource 2LIS_03_BF as a sample ,we copy it to ZRLIS_03_BF.

1.     Create a generic datasource

Enter T-CODE : RSO2 to create a generic datasource  with extraction by FM. The Function Module and Extract.Struct. are the same as the standard datasource 2LIS_03_BF.

2.     Check generic datasource

Enter T-CODE : RSA2 to check datasource. In this condition, the delta is not supported.

3.     Convert to delta-supported datasource

        Here are three important tables, the following program is used to copy the corresponding   attributes to ZRLIS_03_BF.

Table	Description
ROOSOURCE	Table Header for SAP BW OLTP Sources (Relevant From 2.0)
ROOSOURCET	Texts for an OLTP Source
ROOSFIELD	DataSource Fields

 

REPORT  ZBW_COPY_DATASOURCES                    .

TABLES: roosource,

        roosourcet,

        roosfield.

 

CONSTANTS:  c_objvers_active   LIKE roosource-objvers

                                              VALUE 'A'.

 

PARAMETERS: s_datsrc LIKE rsiodynp4-oltpsource OBLIGATORY.

PARAMETERS: t_datsrc LIKE roosource-oltpsource OBLIGATORY.

 

*...Copy ROOSOURCE

SELECT SINGLE * FROM roosource

                WHERE ltpsource = s_datsrc

                  AND objvers    = c_objvers_active.

IF sy-subrc = 0.

  MOVE t_datsrc  TO roosource-oltpsource.

  Modify roosource.

ELSE.

  WRITE: / 'DataSource 0FI_GL_4 is not active.'.

  WRITE: / 'Please use transaction RSA5 to activate.'.

  EXIT.

ENDIF.

 

*...Copy ROOSOURCET

SELECT * FROM roosourcet

              WHERE langu      = sy-langu

                AND ltpsource = s_datsrc

                AND objvers    = c_objvers_active.

  MOVE t_datsrc TO roosourcet-oltpsource.

  Modify roosourcet.

ENDSELECT.

 

*...Copy ROOSFIELD

SELECT * FROM roosfield

              WHERE ltpsource = s_datsrc

                AND objvers    = c_objvers_active.

  MOVE t_datsrc TO roosfield-oltpsource.

  Modify roosfield.

ENDSELECT.

 

After Running the program, and you can check datasource again.

When you go back to generic data RSO2, it shows like this.

4.     Check Setup table

The copied datasource will share the same setup table with its original one.

 

5.     Check Delta Queue

Do an initial in BW on this datasource.  Enter RSA7, you can see the 2RLIS_03_BF. Do some GR or GI change, and extracted changed data to delta queue, unfortunately only the standard datasouce 2LIS_03_BF has delta data. So with respect to the logistic data extraction, I don’t think it is available for future project implementation. According to the experience, the financial data extraction makes sense as it’s ‘push’.