欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

SAP ABAP数据库表字段checktable的实现原理 ABAPC4CCloudCDS viewSAP成都研究院 

程序员文章站 2022-06-15 19:22:14
...

For project reasons I need to find all tables whose fields have used a given table say COMM_PRODUCT as check table.

 

SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院 

 

The only information I know is that such kind of table metadata is stored in table with name prefix DD*. Unfortunately there are huge number of table starting with DD:

 

SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院 

 

How to efficiently find the exact one by yourself?

(1) Make the check table field selected, and press F1:

 

SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院 

 

In popup dialog, click this icon to display technical information:

 

SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院 

 

Unfortunately, the found DD03P_D is a structure, so it is not possible to view it via tcode SE16. Nevertheless let’s write down the field name CHECKTABLE.

 

SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院 

 

(2) Go to SE80 -> Repository information system, double check ABAP Dictionary -> Fields -> Table fields, type field name as CHECKTABLE and search

 

SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院 

 

The DD08L seems to be the table I am looking for.

 

SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院 

 

Double confirm in SE16:

 

SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院 

 

Confirmed

 

 

SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院 SAP ABAP数据库表字段checktable的实现原理
            
    
    
        ABAPC4CCloudCDS viewSAP成都研究院