Query Modification in Quality Systems.

[former_member186356]

Hi Gurus,

I have very complex Query in Quality .. Production.

1) I have created one RKF directly in Quality with out techical name

2) I have created one formula directly in Quality with out techical name

3) Hidden some RKF in Query Properties in Quality Directly.

I know what changes i made . Next when i am transporting Do i face any issue.

Since it is very very complex Query, i do not want to take a chance.

1) shall i delete the RKF & Formula, unhide the RKF that i created in Quality

and recreate it in Dev and transport it to Quality then to Production.

2) Or Can i create the same RKF ,Formula , hide the RKF which is presently

hidden in Quality and transport it with out deleting the above in Quality.

What is the best way to make the next transport successful.

Advance thanks

Magge

[Former Member · Accepted solution]

hi Magge so where do you stand could you retrieve the transport request in Q ?

[former_member186356 · Accepted solution]

Thanks to Every one.Boujema Bouhazama Mti MKR. I will talk to basis. Thanks for all your valuable answers.

Points awarded.

thanks

Magge

[Former Member]

Why did you start to develop in qualification environment ? That is not a best practice.

Nevertheless why don't you transport from quality to dev and production that is not usual but possible ask you basis to help before you create the transport request and when transporting.

Boujema

[former_member186356]

HI ,

Thanks for reply.

I know it's not a best Practice. But There was no proper data in Dev to test . So that's why

i changed directly in Quality BWQ Environment.

I do not have that flexibility to transport back from BWQ to dev and Production. .

As per MKR, I can change the Query in Dev and transport it to Quality then Production.

That does not work .It will create duplicate elements.Checked with Arun 's blog.

Any other suggestions are welcome.

How about deleting those which are created in QUality and create them back in Dev and transport.

My concern is transport might fail. Any suggestions.

thanks

Magge

[Former Member]

was this query initially created in Q or was it first transported from dev and then modified in Q.

By the way no money no food.

Boujema

[former_member186356]

Thanks for replying. It was initally created in DEV, then transported to Q then Prod ,as usual.

When i am testing , i did not find proper data in dev, so changed Query in Q directly...

Now i wanted to keep all systems in Sync..

Any help Appreciated.

Magge

[Former Member]

so the alternative as you mentioned that no technical guid name was generated is to reproduce in dev what you have developed in Q.

Once you are done with the "manual copy" Delete what you have added in Q. Here the query should be in Sync with the one in Prod and in Dev (less the enrichments).

Transport your enriched query to Q when transporting select the option squeez orginal (in the third tab) when importing.

so it is your option 1 (from your first post) but you have first to delete them with the query designer and check in the abap side using rszdelete the objects (CKF and RKF) you created

Boujema

[former_member186356]

Hi Guru's,

I tried the first option. Deleted the RKF and formula in Q.Created them in BWD and trying to transport

it .Transport failed ... giving below errors.

R3TRELEM4J4DIT3GYQBGFOYUWLHXJ3VJ9 was repaired in this system

R3TRELEM4J4DITB5HOX5YBIB2FK9T5U91 was repaired in this system

R3TRELEM4J4DITIU0NIVGY1R89MM37SYT was repaired in this system

R3TRELEM4J4DITQIJM4KZKL7E3OYD9ROL was repaired in this system

R3TRELEM4J4DITY72KQAI74NJXRANBQED was repaired in this system

R3TRELEM4J4DIU5VLJC00TO3PRTMXDP45 was repaired in this system

R3TRELEM4J4DIUDK4HXPJG7JVLVZ7FNTX was repaired in this system

R3TRELEM4J4DIUL8NGJF22R01FYBHHMJP was repaired in this system

.--

---

-

---

Could any experts help....How to proceed

thanks

Magge

[Former Member]

hi

that means that someone maybe you created a transport request in Q and did not release the transport request. Therefore it does not allow import on these objects.

So release before the transport request containing these objects in Q and check in se03 if necessary.

I will not respond anymore if people do not play fair in the forum

When I say no money no food that means no points no respons.

Bye and good luck

Boujema

[former_member186356]

Hi Sorry,

I did not understand No money no food.Normally i will assign when it is done.

I thought if i assign , the thread will close.

Sorry about that.

I do not have any request to be released. I am the olny one working on it.

Cn you tell me how to proceed.

Thanks

Magge

[Former Member]

in Q go with transaction se03

find the option on the left "find transport request" execute

then on the following screen key in in the celles from left to right.

R3TR ELEM 4J4DIT3GYQBGFOYUWLHXJ3VJ9 for the first (as an example then you can go with the others)

tick released and not released at the bottom then execute.

You should find a transport request. If you find a request that is not release release it.

If you do not find a transport request that means that it may have been delete. So go in tx se01 on the right there is information about transport request you will find repairs.

Boujema

[former_member186445]

the message was repaired in this system just means that an objects was changed in the target system. so what you need to do is overwrite these changes. this is an option you can choose in stms (i believe you need to check the first four checkboxes.

anyway if you discuss this with the basis team they can help you to do this.

as a general remark..in the future when you want to change something in Q in order to test, make a copy of the original query and make the changes in the copy...then to do changes in D, and then you transport again from D to Q without any problem.

M.

[Former Member]

Its better to modify your query in DEV and transport to QA then to PRD.

1. Change the Query in DEV same as in QA.

2. Collect the query in transport request then transport to QA.