Skip to Content

Adding extra field in Datasource via append structure

Hi to all,

I have small doubt regaring adding extra field in standard datasource via append structure.

Example: We have a standard datasource which is already running in production and have new requirement to add extra field via append structure in datasource.

So we have added extra field via append structure and write code in BADI in DEV system.

Once we move the changes to production, does it will Corrupt the delta of related DSO in production which is taking data from this datasource.

As these extra field will be used as datafield of DSO , so i think it will not effect the existing delta load of DSO.

Please correct me if i am wrong. or any think apart from delta it will effect.

Regards

Pavneet Rana

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Aug 13, 2013 at 09:11 AM

    Hi Rana,

    Adding field will not effect of delta functionality.

    Even you no need to think delta of DSO. you always need think Delta of data source or info pack level only.

    Changes won't effect your existing data flow if added field will be irrelavant to delta field. but if you Need historical data for added field then reinit is mandatory.

    if you don't need historical data, then delta loads will fill data now onwards for added field.

    But yout extrat str will change and data souce replication will happens and your delta pointer may disturb. so you need to reinit your delta. there might be chance of missing records if no lock at ecc system.

    Missing delta records can pull thru repair full request with proper selections.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 13, 2013 at 11:51 AM

    Thanks to reply to all,

    What i have understod that.

    1. Wether Datasource is LO or not, RSA7 and SMQ1 should be empty, before datasource move to production with new fields.

    2. LO datsource i need to do re-init Delta of DSO, as delta pionter will get effected.

    3. for non LO datasource there no requirement of doing re-init Delta of DSO.

    am i right ?.

    Regards

    Pavneet Rana

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Shared link was more helpful on LO.

      Thanks for the info. but if we go with reinit, once all changes to prod, will be good practise.

      by chance, its corrupted, rather than finding later, if we reinit fist time itself, will be good idea.

      Two ways are possible, its depend on thread owner.

      Thanks

  • Posted on Aug 13, 2013 at 09:09 AM

    Yes your understanding is correct,it wont disturb the delta mechanism.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 13, 2013 at 09:13 AM

    Hi Pavneet,

    You need to make sure that all the queues including LBWQ and RSA7 are emptied before the transport containing the enhanced data siurce structure moves in.

    This is required because if the transport moved in and LBWQ contains still some entries related to oldd ata source structure then V3 jobs would failed. reason being old data is as per the old data source structure and also new structure exist now.

    In order to make sure LBWQ doesn't contain any record you need to get the user locked during that time.

    Also as suggested above you need to repair full after filling setup table for data for new fields.

    hope it helps.

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2013 at 09:45 AM

    Hi Pavneet,

    It won't affect Delta, nor anything in your flow, unless your datasource is a 2LIS one, I mean, from logistics.

    Advise if it's a 2LIS for explaining steps.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 10, 2013 at 07:08 AM

    Hi Rana,

    Please close the thread if your issue is solved and your queries have been answered

    Regards,
    AL

    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.