我ABAP开发生涯中搜集的一些有意思的数据库表-阿里云开发者社区

开发者社区> jerrywangsap> 正文

我ABAP开发生涯中搜集的一些有意思的数据库表

简介: 我ABAP开发生涯中搜集的一些有意思的数据库表
+关注继续查看

Magic tables


CUS_IMGACH – IMG Activities

RFCATTRIB – Administration table for RFC destinations

SEOSUBCO – Class/interface subcomponent

TVIMF – User routines called from view maintenance

More to be added soon

Magic reports

RADPROTA – Display DDIC activation log

RSTABLESIZE – Determining Table Sizes

RSSDOCTB – export transparent table definition locally

4.A simple HTTP test tool RSICFCLTST01

More to be added soon

During my daily work I get to know the existence of some magic tables and reports which can enable me to achieve some work more efficiently and conveniently. Now I shared them with you.


Magic tables

(1) CUS_IMGACH – IMG Activities


Suppose I know the BAdI definition CRM_PRODIL_ADD_DATA and I would like to find the customizing path in SPRO where I can also manipulate it. Unfortunately the where used list in SE18 does not support to search BAdI definition by customizing activities.


image.png


Instead, I can query against IMG activity header table with field ATTRIBUTES = BAdI definition name, and I get the IMG activity description: BAdI: Maintenance of Additional Data in Product BOL.


image.png


Now go to SPRO, I can use keyword function there now:



image.png

And this is just what I am looking for:


image.png


(2) RFCATTRIB – Administration table for RFC destinations


I would like to search all RFC destinations created or modified by me, unfortunately the search attribute there does not support “created by” or “changed by”.


image.png


Such information is maintained in table RFCATTRIB,

as a result I write a simple report to search in that table.

Specify the user name:


image.png


And it will return all RFC destinations created or changed by that user.


image.png


(3) SEOSUBCO – Class/interface subcomponent


Suppose I only know there is one method which has a parameter named “it_ibintx_tab”. I would like to know which class/interface has such methods with this parameter defined in their signature.


Again the Repository information system for Method query does not support to query against method signature parameter name:


image.png


In this case simply query table SEOSUBCO with field SCONAME = IT_IBINTX_TAB, then we get result that the method CHANGE_BEFORE_UPDATE defined in interface IF_EX_IBASE_SAVE has defined this parameter in its signature.


image.png


(4) TVIMF – User routines called from view maintenance


Suppose I am a newbie for table maintenance generator, and I am now responsible to develop a validation logic defined in view event 01- Before saving the data in the database.


I would like to find a standard one done in system as example.

In this case query table TVIMF:


image.png


Then I plan to study the source code in subrountine CHECK_ACTV_ACCOUNT for reference.



image.png

In tcode SE54 I can find the function group for table CRMC_BUAG_ACTV is CRM_BUPA_BUAG_CD, and in that function group I can find the subroutine CHECK_ACTV_ACCOUNT.


image.png


Magic reports

(1) RADPROTA – Display DDIC activation log


For example, check all activation log with type Error:


image.png


Double click on a row in result list and detail reason for activation error is displayed:


image.png


(2) RSTABLESIZE – Determining Table Sizes

If you need to have a overview of the number of table entries for a series of tables, you don’t need to check them one by one in SE16 manually.


Instead, run this report:


image.png


Result is listed with number of lines and total memory consumption for each table:


image.png


(3) RSSDOCTB – export transparent table definition locally


Suppose I need to export the definition information for table COMM_PRODUCT:

image.png



The information is then displayed and could be saved locally via your preferred file format:


image.png


(4) A simple HTTP test tool RSICFCLTST01


In Fiori development I tend to use Chrome extension postman or SAP gateway client ( tcode /IWFND/GW_CLIENT ).And there is also a more lightweight HTTP test tool:

Execute the report, create a new session:


image.png


Select the created session, click Details tab,then execute send method.


image.png


After send method is successfully executed, choose Receive method from drop down list and execute it as well.


image.png


Once done, you can now see the response:


image.png


image.png

You can also directly execute some utility method in this client:


image.png

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
PO,VO,DAO,BO,POJO 之间的区别你懂吗?
value object:值对象。 通常用于业务层之间的数据传递,由new创建,由GC回收。
7 0
冬季实战营第一期:从零到一上手玩转云服务器 学习心得
目的:从什么都不会的小白变成会点点点就能搭建网站的大神。方法:跟随教程学习。结果:成功点点点搭建了网站并且打算薅一波礼品。
5 0
冬季实战营第一期学习报告
总结从零到一上手玩转云服务器的过程
3 0
ECS使用有感
我是一名即将步入社会的大学生,随着网络法等相关专业知识的学习愈发强烈。查询资料时,常常会浏览到制作精美的个人站,因此产生了建设自己个人站的设想,但是由于业余时间少之甚少,同时听闻购买域名与服务器的价格不菲,因此计划一直未能实现
3 0
Java 简介(Java 发展概述)|学习笔记
快速学习 Java 简介(Java 发展概述)
6 0
10S
冬季实战营第一期:从零到一上手玩转云服务器的学习报告
训练营日期:2022年1月17日 - 2022年1月23日,通过前五日从零学习云服务器,还能领取限量版盲盒等奖品
8 0
冬季实战营第一期:从零到一上手玩转云服务器学习报告
1月17-21日,我参加冬季实战营第一期:从零到一上手玩转云服务器学习,从创建一台ECS实例开始,学习了ECS云服务器新手上路、搭建LAMP环境(Linux、Apache、MySQL和PHP)、通过ECS服务器部署MySQL数据库等,掌握了ECS实例、部署应用等知识。
13 0
ECS服务器部署MySQL数据库学习笔记
通过冬季实战营第一期学习在ECS服务器部署MySQL数据库。
13 0
“冬季实战营第一期”之从零到一上手玩转云服务器——学习报告
动手实战、专家带练。由浅及深,逐渐提升动手实操能力。
25 0
+关注
2628
文章
0
问答
来源圈子
更多
+ 订阅
文章排行榜
最热
最新
相关电子书
更多
《2021云上架构与运维峰会演讲合集》
立即下载
《零基础CSS入门教程》
立即下载
《零基础HTML入门教程》
立即下载