Skip to Content
0
Aug 14, 2023 at 09:39 AM

Clarification on ROOSOURCE table in SAP BW system

282 Views Last edit Aug 14, 2023 at 11:30 AM 3 rev

Hi Team,

Table ROOSOURCE in SAP ECC system contains all the Datasource details present in ECC system. What about the table ROOSOURCE present in SAP BW system? I could see only few ECC Datasources present in this table in BW system when compared to the same table in ECC system. For example, Datasource 0FC_RET which is present in both A & D version in ROOSOURCE table SAP ECC system is not present in ROOSOURCE table in SAP BW system, though the Datasource is replicated into BW system already and also used in Dataflows. But Datasource 0AUD_AUDIT is present in ROOSOURCE table in both SAP ECC & BW systems. Why is this so? I compared the Datasources 0FC_RET and 0AUD_AUDIT but don't find any differences in their properties but still 0FC_RET is not showing up in ROOSOURCE in BW system.Though a basic question, could someone help in letting me know on this please? Any help on this is highly appreciated.

Thanks,

Aravindhan