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

Overwriting a field already present in the DSO

Hi experts!

We want to create a DSO with a few characteristics (no key figures).

Before each new reload with new data (we are going to use Delta), we want to overwrite the value of the of the fields.

Can we set up in the start routine that if one field is "a value", then overwrite all the records with that value to "another value", disappearing the previous one?

After setting that value of that field as "another value", we will do the normal delta load...

If not possible,can we use a external ABAP program?

DSO after the first load

Field 1 Field 2 Field 3 Field 4 Field that we need to overwrite

Record 1 XX YY ZZ UU WW

Dong the second load:

Before new data reach the DSO

Field 1 Field 2 Field 3 Field 4 Field that we need to overwrite

Record 1 XX YY ZZ UU "TT" --> (we want to change this value from WW to TT) before all tarsformations of new data)

Record 2 XY YY zz UU WW --> We dont want to do anything with the value of this field within its first laod.

Thanks for your time!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 15, 2012 at 10:10 AM

    Hi,

    Make the first four fields as keyfields in DSO and the one which you need to overwrite as datafield.

    BY doing so it will behave as you need.Please understand that based on unique combination of keyfields new record will be added or else it will be overwritten.

    So in your case if all the keyfields remain same then the data will get overwritten everytime.

    Hope that helps.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ganesh,

      This DSO is going to be filled with reversal records only...so, i dont think that we will ever have a reversal of a reversal.

      It is just to change overwrite the "Change mode" field of the records present in the DSO before the new data reach it.

      As we just need data with record mode = R, no further modification of those records for the set up as key fields will ever get the DSO..

      Thanks!

  • Posted on Dec 15, 2012 at 09:15 AM

    Hi Die,

    DSO nature is Over write functionality. Cube is Additive.

    If the all characters are same and key fig will be different, while in second load it will loads with + and -values of tht key fig.

    regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Raman Korrapati

      Hi KR,

      Once one record get this DSO, we dont expect that a reversal reached it ever (as it is going to be filled only with records with Record mode = R)

      So, we dont expect that the following Deltas change its value...the idea is to select in the start routine all the records with Record Mode = R, and overwrite to "X"...or any other value.

      This process is done, let the new records of day be loaded...and if record mode = R, keep the "R" value...just till next delta load...that we would set up the record as "X"...

      Of course, the Record mode will be data field.

      thanks again!

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.