Skip to Content
avatar image
Former Member

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

@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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Please help me out from this issue its very urgent

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2017 at 03:58 PM

    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...

    Add comment
    10|10000 characters needed characters exceeded