Where used list for IDOC's and Segments

[Former Member]

Hello,

I have a requirement where I need to change the database table's field length, example I have a database table ZMARA in which I need to change field ZMATNR from CHAR18 to CHAR30.

Now I want to see Where Used List such that it displays all the objects impacted by ZMARA-ZMATNR. I am able to achieve part of the requirement other than IDOC's, Segments etc. Mainly Interface Related.

Is there any way to get the IDOC's, Segments name that may impact because of changes to ZMARA-ZMATNR.

[Former Member]

Hi,

Check EDP13 for Message Type and Partner Relation and EDISEGMENT for Segment name.

Otherwise goto SE80 and enter package SED and Check Databse table names.

Regards,

[Former Member]

hello,

There should some standard way to get it. But here is a simple query that oyu can write and found out. Get all the segments from EDISEGMENT and then query the table "DD03L" with these in the TABNAME and FIELDNAME as your fieldname (ZMATNR). You will get the list of segments that have your field.

Also there is a FM IDOC_COMPLETE_SEGMENT_READ to read segment field.

Also check tables EDISDEF, EDISEG

best regards,

swanand

[Former Member]

Many Thanks Swanand and Salil for replying. I resolved the issue myself by debugging the standard functionality.

Use FM 'SEGMENT_WHERE_USED_LIST' to achieve the same. This FM will return all the basic and extension IDOC's using segment type. Also achieve segment types from table 'EDSAPPL' by passing field name ZMATNR.

Hope I explained.