Load Cost Center Master Data in SAC w/service API_COSTCENTER_SRV

[sap_cohort]

Hi, I am looking to load Cost Center Master Data in SAC from API_COSTCENTER_SRV. When I create a SAC Import I need to filter on validity dates because Cost Center is time-dependent. Usually for time-dependent data (like in BW) you would just filter by providing the current date.

How would I filter the validity dates using current date in an SAC Import to get the correct valid cost center records?

There are no variables in SAC that would allow me to use the current date.

Thanks for any help!

[sap_cohort]

So this would require adding validity dates to the Public Cost Center Dimension correct? Thanks!

[DebjitSingha]

yes.
Other wise you can add an additional attribute to the master an derive "9999" in that column. Next step would to filter out this value while use master data (model or story).

Hope this helps.

Thanks,

Debjit

[former_member6443 · Accepted solution]

Hi Kenneth,

You can use the Free Hand Query Option when you create the Data Source using something like this API_COSTCENTER_SRV/?$filter=ValidityEndDate eq 9999-12-31 ( untested ) you should be able to get the latest Cost Centers

Good luck

Afshin