Extractor-Enhancement in Transaction SMOD - new Delta-Init?

[andreas_lcher]

Hello,

i have a question concerning the logic for filling the fields of an extract-structure. I have a standard-datasource (Source-System: SAP R/3) and i have a field which is not filled right now. The delta-logic to the bw system ist already running since a while. When i change the logic of the corresponding function-module for filling the empty field is it necessary to make a new delta-initialisation?

I don't want to change the records which have already been loaded into the bw-system i just want to make sure that the modification of the function-module does not destroy the intact delta-logic.

Kind regards,

Andreas

[RamanKorrapati · Accepted solution]

Hi Andreas,

Standard data source logic was not changeable/not acceptable also. No need to touch the standard extractor.

if standard data source logic was not filling for that field, then you do the enhancement.

Yyou can do enhancement by adding z field to extract structure and maintain logic at CMOD, RSAP00001, EXIT-SAPLRSAP_001, INCLUDE ZXRSAU01.

at RSA6, select your data source unhide added field and hide the old field which was part of your data source. test at RSA3.

if looks fine then replciate into bw side, do the mapping at transformations. actiavte and do others steps.

Thanks

[andreas_lcher · Accepted solution]

Hi,

sorry maybe i wrote it not clear. i already did an enhancement where i added new fields to the standard data source. I also filled the field via a logic in an exit (transaction SMOD). I transported the enhancement into the productive system, replicated the datasource, made an new initialization and so on. Because of some problems of the transport order my enhancement in the exit (transaction SMOD) was not in the production system right now what means that the enhanced field is still empty. Now i want to transport the enhancement of the exit. My question is if it is necessary to set a new delta-init because of the transport of the exit?

Kind regards,

Andreas

[RamanKorrapati · Accepted solution]

hi,

For this added field, if you need historical data then delete and reload is mandatory.

If your don't need historical data for added field then do the reinit(mandatory) without data transfer. Now onwards your added field will be filled with data.

Thanks

[former_member186445 · Accepted solution]

you can do the transport without the reinitialization. You only need to make sure all your queues are empty. If this is not the case, the next delta will dump and you still need to do an init.

M.

[ranganath_korata · Accepted solution]

Hi,

I second Tibollo. Delta Init is not required. And I'm not here for points . Also, i wonder why some developers replicate datasources in QA and PRD when a transport is all that is required. I cannot think of an advantage for this extra step.

Thanks,

Ranga

[former_member186445 · Accepted solution]

agree. As long as the structure of the DS does not change, a replicate is not necessary. And by the way,  you can transport a replication.

M.

[anilkumar_kalkivai]

Hi,

Without loading the data the newly added field will be empty. If you run the delta, you can only see the new request data in the newly added field.

So, it is better to delete the request and run the full load after the enhancement.

Regards,

Anil.

[former_member186445]

I always wonder how many persons actually read the question. I get the impression a lot of people instead read the answers and then re-formulate them just hoping for some points....

The person states more than once he couldn't care less about the history for the added fields. He only wants to know if his delta will still work after the import of the transport requests. Maybe he can't do an init because it takes 3 days, or because he can't get any downtime, or whatever the reason can be....

I don't want to change the records which have already been loaded into the bw-system i just want to make sure that the modification of the function-module does not destroy the intact delta-logic.

[andreas_lcher]

Thank you. Indeed i can't do a delta-init because there is no possibility for a downtime. It is not neccessary to get the field filled for the historical data. I just want to make sure that i can import the transport which includes the exit-extension without destroying my intact delta-logic.

Kind regards,

Andreas

[former_member182470]

Did you see my reply? It will not disturb your existing data.

[former_member182470]

It is advisable to re-initialze your datasource after the enhancement. You can just do init without transfer. So that your old data will be undisturbed.

Your delta will always depends on the delta specific field. If the data changes as per that field in source, then delta will be triggered to BW.