Skip to Content
avatar image
Former Member

HANA Transport Mechanism

Hi All,

I'm new to SAP HANA and was wondering how the transport mechanism works for Views Created in HANA Studio.

I was just reading a Document which talked about CTS+  ( I'm SAP ABAP Developer - I know CTS )- But I Read CTS+ is used for Non ABAP Objects -Can Some Explain what are Non ABAP Objects .

Also as per the document - First I have to create the Views In Packages which are attached to Delivery Unit - Then Download the Delivery Unit to your local PC and then go to STMS and Create a Transport and then attach the Delivery Unit File from Your Local PC and then Release the transport...

Its almost similar to what i do for SAP ABAP objects but the it asks me instantly when i edit or create a new program - I don't have to download and then attach to transport. Do we have any similar mechanism in SAP HANA or its just the downlaod attach mechanism

Also what about the tables that i created in HANA Studio and i believe the tables are not attached to Delivery Unit - How do you move your tables from DEV to QA to PRD


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 07, 2013 at 05:54 PM

    Any Suggestions

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Thomas Jung

      HI Tom

         Thanks for responding. May be I should have phrased the question better. I have created SQL scripts under a project in the development perspective which I have linked to a package which is linked to a DU. When I import this DU in the QA system, is this project automatically created in the QA system and can I expect to see the SQL script files under this project in the QA system ?

         Also when the DU is imported, will the system just activate the SQL script files or will it run them as well.



  • avatar image
    Former Member
    Apr 04, 2014 at 07:00 AM

    Hi Everyone,

    So glad to find this discussion. Now that we have developed our 'Content', we are on SP06 and would need help to know for any additional features/methods for control and traceability that we may have for a robust transport strategy (apart from CTS+).

    A similar discussion -

    @Ravindra Channe I have exactly the same gap for control which you raised. In BW, when we transport a particular object from Dev to QA, the next time you try to edit that object, it prompts for a request. This is a Control measure which is essential. Do we have this in HANA yet?

    Another thought that runs to my mind is HANA being a part ad-hoc analysis kind of an enviornment,

    if I do not allow any changes in my Production HANA environment, is it logical to go back to Dev do the changes and then transport it through multiple system landscape until I can experience the change? The change I am talking of here is as small as having one more field in my Analytic View and analyzing the information for business support.

    Let me know your thoughts please.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi PB,

      follow these steps if you can not fire a query on Sys_repo table:

      1. Go to Change Manager

      2. Select the correct server details from drop down

      3. Select the user id who activated the object from the drop down. Alternatively you can also select blank user id(the first in the list). By default your own user id will be selected.

      4. Select Status as Open and select Search or Go button

      5. At the bottom of the screen it will list down all the open change ids. Expand the button beside each change id One by one.

      6. Once you expand a change id, you will see objects and contributors. Expand object and see if your object is present. If not then go to the next change id and do the same.

      this is a tidious way to check but helpful way if you can not query sys_repo.

  • avatar image
    Former Member
    Feb 18, 2015 at 05:51 PM

    Thanks Tarun. In our system developers doesn't have access on _SYS_REPO schema. I am looking for some UI as part of change manager or System window where developers can check the Change_id for any object.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello P B,

      Unless you have SELECT  ON schema _SYS_REPO inside object privileges for your user , you cannot see repository related details.

      Change Manager view or _SYS_REPO.CHANGE_ENTRIES  gives you objects created under a change id , in order to see the subsequent changes made by different user under a change id , you can do select on table SYS_REPO.CHANGE_CONTRIBUTORS.