External View: No data preview

[leandrovani]

Hi Experts.

I just created an External View following the steps on link:

The problem is that when I choose "Open Data Preview" on the External View context menu, no rows are retrieved.

The SAP HANA View I am exposing via External View is a SAP standard calculation view called "sap.glo.tmflocbr.ctr.NF_IMPOSTO_CALCULO".

When I choose "Data Preview", the calculation view returns 5 rows:

Below is the External View:

I can see the the External View on SE11. The problem is that no rows are retrieved using ADT on Eclipse neither using ABAP program.

Is there anything done wrong? Is there any security issues I am not taking into account?

Thanks in advance!

Leandro

[vairma]

Hi Leandro,

By referring to your attached screen shot, i looks like the data you have in HANA E66 for client 800.However, you have created ABAP  project  NWH with client 001.

I believe that is reason why, you are able to see any data, because external view is a DDIC representation in ABAP for the underlying HANA view, when you call the same external view from ABAP, it will fetch records for the client which you logged in.

Hope this helps.

Best Regards,

Vaibhav

[leandrovani]

Hi Vaibhav, thanks for your quick respose!

You are right, it was a MANDT issue. I created another Calc.View without MANDT field and it worked.

But now I have another question: In this case, when I replicate data from ECC (MANDT = 800) to a NetWeaver system (MANDT=001) using SLT, what is the best way to do the MANDT mapping?

I mean, the original system have a MANDT, but when I replicate the data, my SAP HANA system have another MANDT and i did not find a way to map the original MANDT to the target one.

Thanks again,

Leandro

[vairma]

Hi Leandro,

In my opinion, you can configure MANDT field value during replication configuration.

Pls have a look at this video.

https://www.youtube.com/watch?v=sqfsGkQ2TzQ

Hope this helps.

Best Regards,

Vaibhav

[leandrovani]

Thank you again!

Best regards,

Leandro

[Former Member]

Hi Leandro,

The details you mentioned here is SAP CTR specific and you don't need to map mandant as the nature of CTR is support multi mandant information.

Also the external view you are creating may already exist on TDF system (not on source ECC). Run this query to see a list of external views on the system:

SELECT * FROM SYNONYMS WHERE SCHEMA_NAME = 'SAPNWH';

Regards, Fernando Da Rós

[leandrovani]

Hi Da Ros!

Indeed, the External Views already exists, I've tried to found these E.V. a time ago, but now with your tip to select SYNONYMS table, now I understood the naming relation between the Calc.View and the External View, thanks a lot.

Even TDF is made to support several MANDT, I still have the problem of "no values found" after the SELECT, that's because my ECC system have MANDT = '800' and the HANA system where the External View resides have MANDT = '001'.

For instance, the TDF Cal. View called sap.glo.tmflocbr.ctr/NF_DOCUMENTO have the equivalent External View /TMF/V_NF_DOC. Using SAP HANA Studio, the first one return me rows, with MANDT column showing the '800' value. The External View /TMF/V_NF_DOC, using SE11 on show me 0 rows, thats because SAP states that MANDT = '001' behind the scenes, that's why I think that shoud be a MANDT mapping or another way to state that ECC MANDT 800 now is 001 on NetWeaver...

Do you see what I mean?

Thanks a lot!

Leandro Vani

(vulgo PP, que trabalhou contigo na Petrobrás)

[Former Member]

Hi Leandro,

Hmmm I understood your point. For SE16 you can't access such data specially as the TDF client have no obligation to follow the ECC replicated client.

You only have the option with a custom program that access external view with client specified clause on select.

Best regards, Fernando Da Rós

(For sure, I remind you and started to laugh a lot just for that)