topic Re: ABAP CDS table with complex AMDP coding in Application Development and Automation Discussions

ABAP CDS table with complex AMDP coding

Former Member — Tue, 05 Dec 2017 04:26:56 GMT

Hi Expert,

I am trying to create an ABAP CDS table, but I need to do some row-level processing in AMDP implementation, but I don't know how to return the result table variable in this AMDP implementation. the AMDP code as below:

as above, the final result table variable is VAR_OUT, I want to return this table variable, is it possible? how to code this return statement in AMDP procedure?

Many Thanks,

Re: ABAP CDS table with complex AMDP coding

iftah_peretz — Tue, 05 Dec 2017 06:12:05 GMT

Hey,

Can this help?

Re: ABAP CDS table with complex AMDP coding

Former Member — Tue, 05 Dec 2017 06:15:06 GMT

Hi!

It need to be specified in the AMDP method definition. This can be implicitly for instance from your CDS table function or explicitly in the method definition in the AMDP class. Then use the RETURN statement in the AMDP or popupate the defined export parameter.

Check this out: https://blogs.sap.com/2015/10/21/abap-news-for-release-750-cds-table-functions-implemented-by-amdp/

Re: ABAP CDS table with complex AMDP coding

iftah_peretz — Tue, 05 Dec 2017 07:36:55 GMT

You know you gave the same link I gave?

Re: ABAP CDS table with complex AMDP coding

iftah_peretz — Tue, 05 Dec 2017 07:45:16 GMT

Also, refer to this (pages 7-9 of the PDF).

Re: ABAP CDS table with complex AMDP coding

retired_member — Tue, 05 Dec 2017 07:46:04 GMT

The return value of a CDS table function implemented in AMDP has the

"type of a standard table is created with an empty table key named result with a structured row type. The components of the row type are determined by the elements of the CDS table function. Their names are used and the ABAP types are derived from their Dictionary types. The row type corresponds to the structured data type, which the CDS table function represents with respect to ABAP."

With other words, inside the procedure it has a tabular type that you can fill in the implementation. What exactly is your problem?

Re: ABAP CDS table with complex AMDP coding

Former Member — Tue, 05 Dec 2017 07:53:30 GMT

I did not even know there was another reply. I see you beat me with 3 min posting your answer. 🙂

Well, then it must be a good link, right?

Re: ABAP CDS table with complex AMDP coding

iftah_peretz — Tue, 05 Dec 2017 08:03:43 GMT

:). It is so good that even the writer of that linked blog answered the question.

Re: ABAP CDS table with complex AMDP coding

Former Member — Tue, 05 Dec 2017 17:59:21 GMT

Thanks all for quick respond.

after adjusting the code, finally I put return statement into the code below:

and there is no error for the AMDP procedure any more:

but when I try to preview the data for the ABAP CDS table, I get following error:

can you pleas help how to fix the issue?

I try to debug the code, but I can't put break-point into the code with following error:

am I wrong with some concepts or operations?

finally after run OPEN sql for this ABAP CDS table, I get following error message:

but compare the data type for the fields of the ABAP CDS table with array types below in the code, I don't find any different, is the error message pointing to other meaning?

Re: ABAP CDS table with complex AMDP coding

retired_member — Tue, 05 Dec 2017 18:01:48 GMT

What happens if you SELECT with Open SQL.

Re: ABAP CDS table with complex AMDP coding

Former Member — Tue, 05 Dec 2017 20:00:52 GMT

Thanks Horst, if I understand correctly, I fill the data into corresponding field in AMDP procedure, but still have the issue, which some data type inconsistent between table definition and AMDP code.

Re: ABAP CDS table with complex AMDP coding

retired_member — Wed, 06 Dec 2017 06:43:02 GMT

"still have the issue, which some data type inconsistent between table definition and AMDP code."

Check the mapping tables.

Re: ABAP CDS table with complex AMDP coding

kalakalauday — Sun, 01 Apr 2018 15:22:11 GMT

hi horst keller,

I have seen many of ur blogs and I am following of it.Sir I have started using AMDP but only with select statements with joins.I wanted know what all functions does amdp support which are supported in ABAP.Please give me a reference regarding the same.

thanks

Regard's

uday

Re: ABAP CDS table with complex AMDP coding

retired_member — Sun, 01 Apr 2018 16:40:28 GMT

AMDP isn't implemented in ABAP but in Hana's SQLScript.

ABAP just manages the procedures, creation, lifetime etc.

You must read the SQLScript reference.

For simple queries you don't need AMDP at all.