美文网首页SAP 实用篇SAP 修行
How to find where settype DB tab

How to find where settype DB tab

作者: 华山令狐冲 | 来源:发表于2020-01-31 14:49 被阅读0次

We know settype table COMM_PRMAT is used to store attribute data modelled in product settype COMM_PR_MAT. In this table, there is one field FRG_GUID.
I would like to figure out how this field is used in ABAP code when this table is accessed.

How to find the ABAP code where this table is read with FRG_GUID in a most efficient way?
Approach1:
Write a utility method to read sales data via function module CRM_PRODUCT_SALES_READ_API:

Write a simple report to consume this method:

Use tcode SAT, click execute button:

Once done, expand trace data:

Click DB tables, all accessed database tables are listed in this tab. Choose "Position in the Hit List Tool" from context menu:

Double click statement:

Then it automatically navigates to the code position where this table is accessed.
Set a breakpoint:

Then confirm it in the runtime via debugging. Now we can also know the reason why this code place could not be found in where used list on table COMM_PRMAT : it is accessed dynamically via SELECT SINGLE * FROM (gc_set_table).

Approach2: run the report under ST05, and click button highlighted below, it can bring you to code where this table is accessed as well.

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


相关文章

网友评论

    本文标题:How to find where settype DB tab

    本文链接:https://www.haomeiwen.com/subject/ueugthtx.html