Skip to Content
0

How to fetch from this view inside from an AMDP Method.

May 12, 2017 at 05:21 PM

90

avatar image
Former Member

@AbapCatalog.sqlViewName: 'zso_cust' @AbapCatalog.compiler.compareFilter: true @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'Sales order fetch' define view ZSALES_ORDER_1 with parameters p_kunnr : kunnr as select from vbak as sales_head inner join vbap as sales_item on sales_head.vbeln = sales_item.vbeln { sales_head.vbeln, sales_head.vbtyp, sales_head.vkorg, sales_item.posnr, sales_item.matnr, @Semantics.amount.currencyCode: 'sales_item.WAERK' sales_item.netpr, @Semantics.currencyCode: true sales_item.waerk } where sales_head.kunnr = $parameters.p_kunnr

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member May 12, 2017 at 05:37 PM
0

Please help me out from this issue its very urgent

Share
10 |10000 characters needed characters left characters exceeded
Sean Zhang
May 27, 2017 at 03:58 PM
0

Hi Mona,

you could use the sqlviewname: zso_cust in the AMDP.

it's something like the following:

select ...

from zso_cust(:parameter1, :parameter 2...)

where...

Share
10 |10000 characters needed characters left characters exceeded