Here will take datsource 2LIS_03_BF as a sample ,we copy it to ZRLIS_03_BF.
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.
Enter T-CODE : RSA2 to check datasource. In this condition, the delta is not supported.
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.
The copied datasource will share the same setup table with its original one.
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’.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22464099/viewspace-734163/,如需转载,请注明出处,否则将追究法律责任。