函数和程序及接口查询接口

1、首先新建一个接口自定义登记表

 2、主要是查询底表tfdir

主要代码部分

SELECT
    a~funcname,
    t~stext,
    a~pname,
    a~include,
    a~freedate,
    c~devclass,
    z~ITFNAMEO,
    AREA,
    ITFNAMEI,
    SXMSPSTYPE,
    IB_NS,
    OB_SYSTEM,
    IB_SYSTEM,
    TEXT
  INTO   TABLE @DATA(it_out)
  FROM tfdir AS a
  INNER JOIN enlfdir AS b ON b~funcname = a~funcname
  INNER JOIN tadir AS c ON c~obj_name = b~area AND c~pgmid = 'R3TR' AND c~object = 'FUGR'
  INNER JOIN tftit AS t ON t~funcname = a~funcname AND spras = @sy-langu
  LEFT  JOIN ZIT002 as z ON z~funcname = a~funcname

  WHERE a~funcname IN @s_func
    AND a~pname    IN @s_pnam
    AND a~include  IN @s_incl
    AND a~freedate IN @s_date
    AND c~devclass IN @s_devc
    AND t~stext    IN @s_stext
    AND b~area     IN @s_area.

效果