Skip to Content
author's profile photo Former Member
Former Member

Problem in datasource 0MAT_PLANT

Hi Gurus,

My requirement is to extract "standard cost changes" into BW master data 0MAT_PLANT which is feeded by SAP standard delivered datasource 0mat_plant_attr which doesn't have this field so I have enhanced datasource with this field but changes to standard cost for a given material/plant is extracted to BW when there is a change to other delta-enabled fields in 0mat_plant_attr datasource but my requirement was to trigger standard cost delta changes to BW without changes to attributes so I have gone for generic extractor through View by ALE Delta enabled i.e. the generic datasource(Uses flexible update infosource) thru View will extract only deltas into BW if we need to go for any new records or full upload we have to load them thru standard datasource(Direct update infosource) but now my doubt is as I load huge amount of data daily:

1)There will be any issues like performance wise or anyother when i load millions of records thru this view.

2)Is the data from the standard datasource and generic datasource are consistent as one is direct update and other is flexible.

Would anyone please explain in detail about this. I appreciate it in advance and I gaurantee of award points.

Thanks and Regards

Kishore.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 25, 2006 at 05:24 AM

    1. Peformance - Business content ( Function Module based ) extractors are always better than eneric ones - and a view holding millions of records will be lesser in performance compared to a business content datasource

    2. There is a possibility of inconsistency since the deltas for both data sources are based on different logic - if you do a full update , then it shouldnot be a problem - provided that the business content extractor also extracts from the same tables and no extra logic is involved..

    Arun

    Assign points if useful

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2006 at 01:23 AM

    Hi Arun,

    Thanks a lot for your valuable information and would you please explain me what are the steps I need to follow if i am going for Delta extractions rather than Full and also Regarding loading large volumes of Data and data consistency does it works fine or I need to take any precautions. Please let me know.

    Thanks and Regards

    Kishore

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.