Best Practice for Master Data Loads in DS

[Former Member]

Hi Gurus,

We are implementing all financials (AR,AP,GL,CS,PA,PS,SA) and manufacturing ( PP,PM,FA,IA) rapid marts. What is the best practice to load the master data into target?

Appreicate  your input.

Thanks for your help.

Regards,

Vk

[ahalya_inturi]

Hi Vk,

some of the practices as below will help you in development of BODS job

• Get Legacy data to stage data base tables
• Implement transformation part  as per requirements (different DF's for data generation, transformation, validation, merge, format, lookups)
• Filter the data as per requirements before getting into source stage table
• Maintain separate data flows  with respective of their subject so it will be helpful to reuse
• Create audit points on each data flow and insert them to audit tables
• Keep fields in the required structure w.r.t data types and sequence before call any RFC/BAPI functions
• Check for duplicated data . if any, select distinct option
• If getting any errors from return status ,  reprocess them again
• Raise manual exceptions with proper description, if there are any errors in return from SAP sys
• Print Statistics points for records count (Audit points ) at the end of each job run
• Implement Reconciliation report before job ends
• Temp table should always check "Delete data from table before loading"
• Permanent table with require selection on "Delete data from table before loading"
  

Thanks

Ahalya

[Former Member]

Hi Ahalya,

Thanks for your response. I was actually looking for the order of loading the SAP modules master data into the EDW.

Appreciate your  response.

Thanks,
Vk

[ahalya_inturi]

Hi

we following the order of loading as below

BM,MM,MC,PM,CM & AR

[Former Member]

Hi,

on SAP Note 1658647 you will see a link to the  step by step guide, in there is a link to the Intergated Data Model document - please have a look at this document,

regards,

Adrian

[Former Member]

Thank you Ahalya.  Thats helps.

[Former Member]

This Note 1658647  discusses more of Rapid Mart installation procedures.

Thank you.