Move datasource to another application component in BW4HANA

[Loed]

Hi guys,

Just wanted to check how to move a CDS view datasource from NODESNOTCONNECTED to another application component? Upon creation, all of our CDS view datasources were automatically created in NODESNOTCONNECTED application component since we are not allowed to choose one below.

How can I also create a custom APPLICATION COMPONENT?

Thanks a lot!

Loed

[Dominik_Graus · Accepted solution]

Hi Loed,

You can maintain application components and assign DataSources to application components in transaction RSA6 in the source system.

Regards,
Dominik

[Loed · Accepted solution]

Hi Dominik,

Sorry? Is this in S4 side or B4 side? I checked both of them but I can't find the CDS view datasources I have created in RSA6.

Thanks.

Loed

[Dominik_Graus · Accepted solution]

Hi Loed,

Sorry, I missed that your question was specifically for DataSources based on CDS views. For such DataSources, the application component is inherited from the ABAP package on which the CDS view was created. Note that the application component hierarchy for ABAP packages is different from the application component hierarchy for SAPI DataSources.

Regards,
Dominik

[Loed · Accepted solution]

Hi Dominik,

Are you referring to these packages? Because the CDS views were created in one of these packages. But still the datasources are showing in NODESNOTCONNECTED in BW4. How can I replicate these packages in BW4?

Thanks.

Loed

[Dominik_Graus · Accepted solution]

Hi Loed,

Yes, I am referring to the ABAP development packages that the CDS view belongs to. When you open the ABAP development package, e.g. ZTEST in your screenshot, you can see the application component that is assigned to this package. See Application Component Hierarchy in SAP Help.

As an alternative, you can open the CDS source system, unset the Remote Tree flag, and activate the source system. You can then use the generic BW application component hierarchy to group your CDS DataSources. See Creating and Moving Application Components in a Generic Hierarchy in SAP Help.

Regards,
Dominik

[Loed · Accepted solution]

Thanks a lot Dominik! I was able to assign the CDS datasource to other application component.

Couple of questions though:

1. How can I see the list of application components that are present in the S4 system? Upon clicking the BROWSE button it doesn't show me any options. I only tried BW or SD or any other SAP module. 😄

2. How can I create a customized application component?

I checked the 2nd link you have posted but it only shows how to create a custom application component for FLAT FILES source system. What if I wanted to create a custom application component for CDS VIEW DATASOURCE?

I tried to right the CDS VIEW source system but there is no option to create a new application component.

I even tried to create a custom application component in RSA6 of S4 server but ZTEST was not recognized when assigning it to one of the abap packages.

Thanks a lot!

Loed

[Dominik_Graus · Accepted solution]

Hi Loed,

Once you unchecked the Remote Tree option, you can create application components as documented in the SAP Help link I shared earlier. This is not only valid for flat file source systems but for all source systems that do not (or cannot) use a remote tree.

In case you cannot see the option to create application components or to move DataSources after unchecking the Remote Tree option and activating the source system, it may help to close and restart BW Modeling Tools.

Regards,
Dominik

[Loed · Accepted solution]

Oh okay, so that's the only way where we can create a custom one. So by not unchecking it, there is no other option than to re-use the standard application components.

Thanks a lot for the help Dominik!

Loed