cancel
Showing results for 
Search instead for 
Did you mean: 

How to restrict S4 DB User to replicate a specific client data into DW

prasanna_korada2
Explorer
0 Kudos

Hi,

We are using DB connection(SDI) to replicate S4 tables into DWC but our S4 has multiple clients data, we don't want to load all clients into DWC. Is there any way to restrict to specific data client?

Thanks

Prasanna Korada

cardoso
Advisor
Advisor

Hello,

In case you are using remote tables, you could use filters to achieve that:
https://help.sap.com/docs/SAP_DATA_WAREHOUSE_CLOUD/c8a54ee704e94e15926551293243fd1d/bd1ece5c9f78444c...

BR.
Ismael

Accepted Solutions (0)

Answers (3)

Answers (3)

prasanna_korada2
Explorer
0 Kudos

Hi Ismael,

We can use DWC remote table filter but the problem is when we move this objects from Dev to QA/Prod, we have to manually change these filters based corresponding S4 Data client#. This is not a best practice to modify objects in QA/Prod DWC systems.

Thanks

Prasanna Korada

DebjitSingha
Active Contributor
0 Kudos

For remote table this seems to be limitation. You need to add fiters in respective systems.

Sven_Knöpfler
Active Participant
0 Kudos

You could use the DWC CLI tool to create a script that adds this filter automatically to every remote table: https://www.npmjs.com/package/@sap/dwc-cli#help-documentation

prasanna_korada2
Explorer
0 Kudos

Hi Debjit,

We can restrict client at ABAP connection but not at DB connection.

We are using DB connect to do Table replications into DWC from S4.

Thanks

Prasanna Korada

DebjitSingha
Active Contributor
0 Kudos

Hello prasanna.korada2,

When you are creating connection to S4 it lets you choose Client itself.

https://blogs.sap.com/2020/05/26/connecting-from-sap-data-warehouse-cloud-to-s-4hana-onpremise-cloud...

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

-Debjit