Get all tables mapped to an OBJECTCLASS in CDHDR

[Noor534]

Dear all

I like to know a way to get all SAP ERP tables that get updated when an entry for a particular OBJECTCLASS is logged in CDHDR table. I see that there is an entry logged in CDHDR with OBJECTCLASS called "BELEG". I understood that this could mean several tables like BSEG, BKPF, BSID, BSAD have got documents updated within them.

I noticed that updates (Us) in SAP ERP are not getting logged in CDPOS table. So, I like to rely on CDHDR and get list of all tables that got updated for a particular UDATE & OBJECTCLASS. Using this, I will check if data is fresh in my target system (Databricks).

appreciate ideas/thoughts.

Br,

Noor.

[Michael39]

Hello Noor,

Are you using SLT? This question doesn't seem related to SLT. If you have more information on the SAP product you're using I can try to direct you to the correct location.

It seems like your question is better asked to BC-SRV-ASF-CHD (Change documents).

Best Regards,
Michael
SAP Support

[Noor534]

Hi Michael,

It is the combination of SLT & SAP DI together extract data from SAP ECC & publish data to Databricks. My goal is to check data freshness in Databricks. For that, I wanted to rely on CDHDR table  replicated into Databricks by SAP SLT & DI combo.

That's why I tagged all relevant products used in my environment.

I am unable to move to the SAP tag you mentioned ((I don't get in search results)).

Can you kindly do the needful please?

Br,

Noor.

[Michael39]

Hello Noor,

You mentioned "I like to know a way to get all SAP ERP tables that get updated when an entry for a particular OBJECTCLASS is logged in CDHDR table.", how to do this wouldn't be something that SLT or DI could provide information on, SLT and DI don't make the changes on the source data. 

I believe we will have to see if ERP can provide a response on this. 

Best Regards,
Michael
SAP Support