topic Re: method for finding the table&field from a structure in Application Development and Automation Discussions

method for finding the table&field from a structure

Former Member — Tue, 29 Aug 2006 13:51:07 GMT

Hi,

How can we get the table name and the fields from a structure.

for eg:

vbstt-gbsta_bez is a field in a structure

vbstt is the structure and gbsta_bez is a filed in the structure.

Need to know the method for finding the table&field from a structure

Re: method for finding the table&field from a structure

RichHeilman — Tue, 29 Aug 2006 13:58:13 GMT

Well, this is sometimes not an easy task. You can start by doing a SQL trace using ST05. You can then see all of the tables that are hit in a tranactions. Yes, this will be cumbersome. Next, you can try debugging the program, to find how the structure is filled at runtime.

You can also do a where used on the structure, and maybe it is used in a function module somewhere.

Regards

Rich HEilman

Re: method for finding the table&field from a structure

RichHeilman — Tue, 29 Aug 2006 14:00:47 GMT

I found the following FM which use the structure. Maybe you can use these to get your data.

RV_DOCUMENT_HEAD_STATUS_TEXTS

RV_DOCUMENT_POS_STATUS_TEXTS

Regards,

Rich Heilman

Re: method for finding the table&field from a structure

Former Member — Tue, 29 Aug 2006 14:03:45 GMT

select from DD03L where tabname = VBSTT

Check SE11->VBSTT

View Entries and enter in field tabname VBSTT

-> you'll see the fields.