Skip to Content
Author's profile photo Nanda Anantha

Identifying New Master Data Records

I have come across a typical situation and requirement to identify new records in(G/L Account master data) 🙁 . The actual business requirement was everyday we use to bring full load G/L master data into analysis system . After update, mapping department will download all data from G/L Account P table and going to cross check with any mapping done for each G/L account.

Here mapping department( due to business ethics I am not able to discuss what is mapping), needs to download and executing some manual steps and SQL statements they will come back with list of G/L’s which are not mapped.

,

Everyday they need to download huge amount of data records and compare with other system, this job will consume lot of time, hence they asked me what are the possibilities of identifying only new G/L records.

After doing some research I thought of create generic data source on SID table of G/L Account infoobject. 🙂

Everybody knows that in SID table SID value get generate only when new values come and update, taking this option created a generic datasource on SID table with delta numeric pointer on SID field.

Here are the few screenshots which I attached for reference and clear understanding of delta on SID field.

Created Generic Datasource on SID table of G/L Account infoobject.

/wp-content/uploads/2015/02/1_649986.png

Delta capability selected as numeric pointer on SID field since SID value get created when new G/L Account created , we can extract only new G/L Accounts.

/wp-content/uploads/2015/02/2_649987.png

Note: From 7.4 on-wards not required any generic delta because we have option to see records 0RECORDMODE values as we see in DSO.

In SPA BW on HANA 7.4 on wards we have 0RECODMODE included by default if you check below option.

/wp-content/uploads/2015/02/3_650021.png

Thanks for reading this Blog. I do welcome for any suggestions.

Regards,

Nanda

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Akanksha Verma
      Akanksha Verma

      Hi Nanda,

      Good way for delta load of master data.

      Thanks for sharing.

      Akanksha

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thank you Akanksha.

      Regards,

      Nanda

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Useful information!

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thanks Ganesh

      Author's profile photo Swapna Jain
      Swapna Jain

      Good Document.

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thanks Swapna

      Author's profile photo Francisco Rodríguez
      Francisco Rodríguez

      Nice, good idea to do deltas. Thanks for share Nanda!

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thank you Francisco.