Skip to Content
Technical Articles

Obsolete BW DataSources are not released for ODP-SAP replication – what to do?

This is a technical Blog Post for SAP BW and SAP BW/4HANA consultants. As part of your project you want to take advantage of the ODP-SAP replication API to extract data e.g. from a SAP ERP or SAP S/4HANA on Premise system using BW DataSources.

You have worked through the different sources of information and applied the required SAP Notes (152188, 193142, 2232584). Now you are in the situation that a DataSource currently used in your systems is considered as obsolete by SAP and therefore not officially released for ODP-SAP replication.

Find below a list of BW DataSources that are considered as obsolete. If available, the DataSources that can be used instead are mentioned in column ‘Replacement / Alternative”.

Obsolete Replacement / Alternative SAP Note / Comment
0ASSET_ATTR 0ASSET_ATTR_TEXT
0ASSET_TEXT 0ASSET_ATTR_TEXT
0BBP_TD_CONF_1 0SRM_TD_CF 614940
0BBP_TD_INV_1 0SRM_TD_IV 614940
0BBP_TD_PO_1 0SRM_TD_PO 614940
0BP_RELATIONS_46BC_ATTR 0BP_RELATIONS_ATTR 614940
0BP_RELATIONS_470_ATTR 0BP_RELATIONS_ATTR 614940
0BP_UNAME_46C_ATTR 0BP_UNAME_ORGUNIT_ATTR 614940
0COM_PRODUCT_STATUS_ATTR n.a. 673053
0COM_PRODUCT_TEXT n.a. 673053
0CRM_PRFI_ATTR 0CRM_PR_FIN01_ATTR 805262
0CRM_PRFISL_ATTR 0CRM_PR_FIN02_ATTR, 0CRM_PR_FIN03_ATTR 805262
0CRM_PROD_ATTR 0CRM_PRODUCT_ATTR, 0PRODUCT_ATTR 1157513
0CRM_PRODSL_ATTR 0CRM_PR_SALESA_ATTR, 0CRM_PR_SALESG_ATTR, 0CRM_PR_RESIDVL_ATTR 805262
0PROD_CATEG_2_ATTR 0PROD_CATEG_R3_MAP_ATTR 614940, 771530
0FI_AA_001 Replaced by 0FI_AA_11/12 obsolete DS only supported FULL mode
0FI_AA_002 Replaced by 0FI_AA_11/12 obsolete DS only supported FULL mode
0FI_AA_003 Replaced by 0FI_AA_11/12 obsolete DS only supported FULL mode
0FI_AA_004 Replaced by 0FI_AA_11/12 obsolete DS only supported FULL mode
0FI_AA_005 Replaced by 0FI_AA_11/12 obsolete DS only supported FULL mode
0FI_AA_006 Replaced by 0FI_AA_11/12 obsolete DS only supported FULL mode
0FI_AP_1 0FI_AP_4 obsolete DS only supported FULL mode
0FI_AP_3 0FI_AP_4 obsolete DS only supported FULL mode
0FI_AR_1 0FI_AR_4 obsolete DS only supported FULL mode
0FI_AR_3 0FI_AR_4 obsolete DS only supported FULL mode
0FI_GL_1 0FI_GL_6 obsolete DS only supported FULL mode
0FI_GL_2 0FI_GL_7 obsolete DS only supported FULL mode
0FI_FM_1 0PU_IS_PS_11 735646
0FI_FM_2 0PU_IS_PS_2 735646
0FI_FM_31 0PU_IS_PS_31 735646
0FI_FM_32 0PU_IS_PS_32 735646
0FI_FM_33 0PU_IS_PS_33 735646
0FUND_ATTR 0FUND_PU_ATTR 735646
0CMMT_ITEM_FMCI_HIER 0CMMT_ITEM_FMCI_PU_HIER 735646
0CMMT_ITEM_ATTR 0CMMT_ITEM_PU_ATTR 735646
0CMMT_ITEM_TEXT 0CMMT_ITEM_PU_TEXT 735646
0BUD_VERSN_TEXT 0BUD_VERSN_PU_TEXT 735646
0FM_TRANSAC_TEXT 0FM_TRANSAC_PU_TEXT 735646
0FM_VTYPE_TEXT 0FM_VTYPE_PU_TEXT 735646
0FUNDS_CTR_FMFC_HIER 0FUNDS_CTR_FMFC_PU_HIER 735646
0FUND_ATTR 0FUND_PU_ATTR 735646
0RES_CLOSED_TEXT 0RES_CLOSED_PU_TEXT 735646
0RES_DEL_TEXT 0RES_DEL_PU_TEXT 735646
0FUND_TYPE_TEXT 0FUND_TYPE_PU_TEXT 735646
0HR_PY_3 0HR_PY_1 or 0HR_PY_1_CE 2059886
0JOB_ATTR 0EC_CJOB_ATTR
0EMPLOYEE_2_ATTR 0EMPLOYEE_ATTR DS only for Direct Access
0ME_MED_FAM_ATTR 0ME_MATERIAL_ATTR 699306
0ME_MED_ISS_ATTR 0ME_MATERIAL_ATTR 699306
0ME_MED_PROD_ATTR 0ME_MATERIAL_ATTR 699306
0MM_IM_BF 2LIS_03_BF DS only for Direct Access,1714455
0MM_IM_BX 2LIS_03_BX DS only for Direct Access, 1714455
0MM_IM_DS n.a. DS only for Direct Access
0MM_IM_STOCK 2LIS_03_BX DS only for Direct Access, 1714455
0MM_IM_UM 2LIS_03_UM DS only for Direct Access, 1714455
0MM_PUR_CNF_MAA n.a. DS only for Direct Access, 2181511
0MM_PUR_DATA n.a. DS only for Direct Access, 2181511
0MM_PUR_MAA n.a. DS only for Direct Access, 2181511
0MM_PUR_PO_CGR 2LIS_02_CGR DS only for Direct Access, 2181511
0MM_PUR_PO_HDR 2LIS_02_HDR DS only for Direct Access, 2181511
0MM_PUR_PO_HIST_MAA 2LIS_02_ACC DS only for Direct Access, 2181511
0MM_PUR_PO_ITM 2LIS_02_ITM DS only for Direct Access, 2181511
0MM_PUR_PO_SCL 2LIS_02_SCL DS only for Direct Access, 2181511
0MM_PUR_PO_SCN 2LIS_02_SCN DS only for Direct Access, 2181511
0MM_PUR_PO_SGR 2LIS_02_SGR DS only for Direct Access, 2181511
0MM_PUR_PURCH_DATA n.a. DS only for Direct Access, 2181511
0MM_PUR_PURCH_GROUPS n.a. DS only for Direct Access, 2181511
0MM_PUR_SRV 2LIS_02_SRV DS only for Direct Access, 2181511
0MM_PUR_SRV_LEVEL n.a. DS only for Direct Access, 2181511
0SCM_TM_TCCRIC n.a. 1540769
0UC_INDSECT_TEXT 0UC_IND_SEC_TEXT
0UC_ISU_02 – 0UC_ISU_11 n.a. 363253
0UC_ISU_12 0UCCONTRACT_ATTR_2 2270505
0UC_ISU_13 0UCINSTALLAH_ATTR_2 2270505
0UC_ISU_14 0UC_ISU_32 2270505
0UC_ISU_15 0UC_DEVINST_ATTR 2270505
0UC_ISU_16 0UC_SALES_STATS_02 or 0UC_SALES_STATS_03 2270505
0UC_ISU_17 0UC_SALES_STATS_02 or 0UC_SALES_STATS_03 2270505
0UC_ISU_18 0UC_DEVICE_ATTR and 0UC_DEVICER_ATTR 2270505
0UC_ISU_19 0UC_DEVICE_ATTR 2270505
0UC_ISU_20 0UC_DEVICE_ATTR 2270505
0UC_ISU_22 0BPARTNER_ATTR 2270505
0UC_ISU_23 0UC_ACCNTBP_ATTR_2 2270505
0UC_ISU_24 0UCCONTRACT_ATTR_2 and 0UCCONTRACTH_ATTR_2 2270505
0UC_ISU_25 0UCINSTALLAH_ATTR_2 or 0UCINSTALLA_ATTR_2 2270505
0UC_ISU_26 0UC_CONNOBJ_ATTR_2 2270505
0UC_ISU_27 0UCPREMISE_ATTR_2 2270505
0UC_ISU_28 0UC_DEVLOC_ATTR 2270505
0UC_ISU_30 0UC_DEVICE_ATTR and 0UC_DEVICER_ATTR 2270505
0UC_ISU_31 0UC_INSTFACTS 2270505
0UC_ACCNTBP_ATTR 0UC_ACCNTBP_ATTR_2 2270505
0UC_CONNOBJ_ATTR 0UC_CONNOBJ_ATTR_2 2270505
0UC_INDSECT_TEXT n.a. 2270505
0UC_TRANSPORT_TEST n.a. 2270505
0UCCONTRACT_ATTR 0UCCONTRACT_ATTR_2 2270505
0UCCONTRACTH_ATTR 0UCCONTRACTH_ATTR_2 2270505
0UCINSTALLA_ATTR 0UCINSTALLA_ATTR_2 2270505
0UCINSTALLAH_ATTR 0UCINSTALLAH_ATTR_2 2270505
0UCPREMISE_ATTR 0UCPREMISE_ATTR_2 2270505
0UC_ISU_CONSUMPT_02 (Sales Statistics shall be applied) 2270505
0UC_ISU_CONSUMPTION (Sales Statistics shall be applied) 2270505
0UC_SALES_SIMU_02 0UC_SALES_SIMU_01, 0UC_SALES_SIMU_03 2270505
0UC_SALES_STATS_01 0UC_SALES_STATS_02, 0UC_SALES_STATS_03 2270505
0UC_INDSECT_TEXT 0UC_IND_SEC_TEXT
0RE_11 n.a. RE solution was replaced by RE-FX with new DataSources
0RE_16 n.a. RE solution was replaced by RE-FX with new DataSources
0RE_2 n.a. RE solution was replaced by RE-FX with new DataSources
0RE_4 n.a. RE solution was replaced by RE-FX with new DataSources
0RE_5 n.a. RE solution was replaced by RE-FX with new DataSources
0RE_6 n.a. RE solution was replaced by RE-FX with new DataSources
0RE_7 n.a. RE solution was replaced by RE-FX with new DataSources
0RE_8 n.a. RE solution was replaced by RE-FX with new DataSources
0RE_9 n.a. RE solution was replaced by RE-FX with new DataSources
0RECN_ATTR n.a. RE solution was replaced by RE-FX with new DataSources
0RENTAGRMNT_ATTR n.a. RE solution was replaced by RE-FX with new DataSources
0RENTAGRMNT_TEXT n.a. RE solution was replaced by RE-FX with new DataSources
0RENTUNIT_ADR_ATTR n.a. RE solution was replaced by RE-FX with new DataSources
0RENTUNIT_ATTR n.a. RE solution was replaced by RE-FX with new DataSources
0RENTUNIT_TEXT n.a. RE solution was replaced by RE-FX with new DataSources
0REOBJ_ATTR n.a. RE solution was replaced by RE-FX with new DataSources
0REOBJ_TEXT n.a. RE solution was replaced by RE-FX with new DataSources
/PM0/PM_ABDAPREMTAX_ATTR n.a.

Disclaimer: The list – which does not claim to be exhaustive – gives an indication which data sources can be considered as a replacement. It is still necessary to further check if the replacement / alternative mentioned suits your specific business requirements.

What can I do, if a suitable replacement for an obsolete DataSource cannot be found?

Technically, it is always possible to expose a standard SAP DataSource for the ODP-SAP replication by maintaining a corresponding entry in table ROOSATTR in the relevant source system with OLTPSOURCE = <Technical Name of DataSource> and EXPOSE_EXTERNAL = ‘X’.

On this way you could also enable ODP extraction for obsolete SAP standard DataSources.

Just take into considerations when doing so:

  • SAP does not recommend to use obsolete DataSources.
  • After you enabled data sources for ODP extraction by your own for a standard DataSource which is not officially released via SAP Note 2232584, potential issues when using this particular DataSource in the ODP context will not be supported by SAP.
  • Therefore you will need to test the extraction of the DataSource via the ODP framework throughly and the usage is on your own risk.

Hope this blog post could help you.

 

Related blog post:

Conversion SAP BW 7.x to SAP BW/4HANA – How to handle missing SAP Exit-Variables

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