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

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

 2、主要是查询底表tfdir

主要代码部分

SELECTa~funcname,t~stext,a~pname,a~include,a~freedate,c~devclass,z~ITFNAMEO,AREA,ITFNAMEI,SXMSPSTYPE,IB_NS,OB_SYSTEM,IB_SYSTEM,TEXTINTO   TABLE @DATA(it_out)FROM tfdir AS aINNER JOIN enlfdir AS b ON b~funcname = a~funcnameINNER 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-languLEFT  JOIN ZIT002 as z ON z~funcname = a~funcnameWHERE a~funcname IN @s_funcAND a~pname    IN @s_pnamAND a~include  IN @s_inclAND a~freedate IN @s_dateAND c~devclass IN @s_devcAND t~stext    IN @s_stextAND b~area     IN @s_area.

效果