Hi SAP Community,
Use Case:
- We need to load data based on export data sources (infocube) from one source BW (sBW) to a target BW (tBW)
- We implemented an ODP BW source system connection, which is working fine
- By default, a DTP created based on any ODP data source gets the setting "Data Extraction: Directly from source system. PSA not used" as well as the setting "Extraction Mode: Delta" (see as well attached screenshot)
Problem Statement:
- We are not allowed to load any data in delta and directly from source system without PSA from sBW to tBW, because this will harm the ETL process in the source system sBW (tcode ODQMON)
- In tBW, we have to build a lot of DTPs based on ODP export data sources and we must avoid any developer is using the default settings from DTP which results in delta loading directly from the source system
- We checked the ODP data source settings, but we are not able to change them in our sBW (see other screenshot)
Question(s):
- Is there any (automated/technical) way to prevent the developer in tBW to create DTPs with the default settings "delta" + " directly from source system" ?
- As an alternative, we have in mind to implement a monitoring on table(s) RS* like RSBKDTP and/or RSBKREQUEST to identify at least ex post any DTP (requests) which are using the default settings "delta" + " directly from source system", but in best case we prefer any option to prevent this in the first place.
Many thanks in advance and best regards,
Sebastian

