• 使用SAP Analysis Path Framework (APF)展示CDS view数据


    Analysis Path Framework (APF) is a framework which provides reuse components that allow you to build and enhance interactive analytical Web applications. Recently during my self study, I find out that an OData service exposed by CDS view could easily be consumed by APF.

    Here below is detailed step.

    For prerequisites to use APF, you can find it in SAP help.
    In my case, I have the following PFCG role assigned:

    And this role has the following role menu assigned:

    Step1. Create a simple header and item CDS view, and a consumption view to expose as OData service.
    Below source code is for item view:

    @AbapCatalog.sqlViewName: 'zorITem'
    @AbapCatalog.compiler.compareFilter: true
    @AccessControl.authorizationCheck: #CHECK
    @EndUserText.label: 'order item detail'
    define view Z_I_Order_Item as select from zorder_item {
      key zorder_item.parent_id,
      key zorder_item.item_id,
      zorder_item.item_text
    }
    

    Below source code for header view:

    @AbapCatalog.sqlViewName: 'zorheader'
    @AbapCatalog.compiler.compareFilter: true
    @AccessControl.authorizationCheck: #CHECK
    @EndUserText.label: 'header view'
    define view Z_I_Order_Header as select from zorder_header
    association [0..*] to Z_I_Order_Item as _Item
    on $projection.object_id = _Item.parent_id
    {
      key zorder_header.object_id,
      zorder_header.description,
      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Item
    }
    

    The corresponding database in ABAP for these two CDS views are listed below:


    The source code of CDS view:

    @AbapCatalog.sqlViewName: 'zjorderview'
    @AbapCatalog.compiler.compareFilter: true
    @AccessControl.authorizationCheck: #CHECK
    @EndUserText.label: 'Jerry order consumption view'
    @OData.publish: true
    define view Z_C_Order as select from Z_I_Order_Header {
      key Z_I_Order_Header.object_id,
      Z_I_Order_Header.description,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      Z_I_Order_Header._Item
    }
    

    Since I use the annotation OData.publish:true, so a corresponding OData service Z_C_Order_CDS is generated automatically.
    Register it via tcode /IWFND/MAINT_SERVICE. Once done, ensure the metadata access could successfully be done.

    Step2. Expose the created OData service via APF
    Click tile APF Configuration Modeler,

    Create a new Application:

    Use the default semantic object:

    Create a new configuration which acts as a container for sub settings such as Filters and Categories:

    In Smart Filter, choose the OData service and entity type created from previous step.

    And a new category:


    Select this new category and create a new step:

    In the step creation page, just select all the two properties exposed by CDS view Z_C_Order, that is:

    Create a new Representation based on this step:

    Here for representation type, I just choose the most simple one: Table. Choose property from drop down list for table display.

    Once done, click execute button, you will see the following screen:


    Then choose the table representation:

    Then the table is displayed as expected:

    Its content matches with the data in the corresponding database table.

    要获取更多Jerry的原创文章,请关注公众号"汪子熙":

  • 相关阅读:
    怎么产生一个随机数
    C# 算速表达式
    Wpf OpenFileDialog
    完美世界自动更新程序
    只容许程序运行1个实例
    WPF 同一个程序 只允许 同时运行一个
    13 引用WINAPI
    winform窗体跟随窗体
    C#如何检测一个字符串是不是合法的URL
    WPF 下载网络文件 带进度条
  • 原文地址:https://www.cnblogs.com/sap-jerry/p/13540517.html
Copyright © 2020-2023  润新知