topic Re: External view with currency/quantity fields in Application Development and Automation Discussions

External view with currency/quantity fields

arundec — Thu, 15 Aug 2013 12:39:21 GMT

Hello ABAP for HANA experts,

I am trying to create an external view in ABAP Development Tools for a SAP HANA view, and have reached the stage where I see the mapping for each field between the HANA type and the ABAP Dictionary type.

Some of the fields in my view represent currency amounts and their associated currency keys, and so I have manually changed the proposed Dictionary type to CURR for the amount field, and CUKY for the currency key.

Now of course, when creating currency amount fields in SE11, we would be asked to provide a reference table and field for the currency key which describes it.

Well, when I try to activate my external view in ADT, I get the expected error:

'Specify reference table and reference field'.

The problem is, I cannot see anywhere where I can maintain this setting in ADT - and since external views cannot be maintained in SE11, I am unable to activate my view.

Any ideas?

Christine

Re: External view with currency/quantity fields

Former Member — Fri, 16 Aug 2013 01:07:23 GMT

Hi,

Typically in ABAP, While we are creating currency fields in ddic we have to give the reference and field in the tab of currency key tab. Like this check is there any tab for currency then refer one standard table and field of currency key.

Hope this will solve your problem.

Regards,

John.

Re: External view with currency/quantity fields

arundec — Fri, 16 Aug 2013 06:43:50 GMT

Yes John, but as I said, this would be easy if we were in SE11, but this is in ABAP Development Tools, and there is no tab for the reference table and reference field.....

Re: External view with currency/quantity fields

Former Member — Mon, 19 Aug 2013 09:52:32 GMT

Hi Chris,

I asked my friends, who have got the chance to work on ABAP on HANA. Once i get the solution i will update you. For your future reference go through the below links,

http://help.sap.com/hana/html/_csql_data_types.html#sql_data_types_datetime_format_additional

http://wiki.sdn.sap.com/wiki/display/inmemory/SAP+HANA+commonly+used+SQL

Regards,

John.

Re: External view with currency/quantity fields

yeushengteo — Tue, 20 Aug 2013 11:44:48 GMT

Hi Christine.

I think is a missing feature in ADT now. May needs to report back to product team.

For now maybe you have to use DEC first.

Regards.