topic Re: Table Field Short Descriptions in Application Development and Automation Discussions

Table Field Short Descriptions

Former Member — Tue, 13 Nov 2007 21:42:54 GMT

If you go into the Repository Information System (SE83), then drill down to ABAP Dictionary->Fields->Table Fields, you are allowed to enter a table name to display its fields and short descriptions. I need to know what table the short descriptions are stored. I assumed it was DD03T, but I'm not able to locate most of my field descriptions for the MM module. Can anyone help?

Thanks!

Re: Table Field Short Descriptions

naimesh_patel — Tue, 13 Nov 2007 21:45:03 GMT

Check out DD03M.

Regards,

Naimesh Patel

Re: Table Field Short Descriptions

Former Member — Tue, 13 Nov 2007 21:53:03 GMT

That is for generating a table for view. I don't think that's what I'm looking for. I saw a post asking this question, and someone replied to use DD04T. I am able to find a field name, but I'm not able to associate it to a specific table. The example I'm using to locate the field short descriptions is table EKPO, field BUKRS.

Thanks

Re: Table Field Short Descriptions

naimesh_patel — Tue, 13 Nov 2007 21:58:16 GMT

Yes that's right.. but this view contains all you want.

Like:

E.g.,

REPORT ZTEST_NP.

data: l_ddtext like dd03m-ddtext.

select single DDTEXT

into l_DDTEXT

from DD03M

where TABNAME = 'EKPO'

and FIELDNAME = 'BUKRS'

and DDLANGUAGE = sy-langu.

Regards,

Naimesh Patel

Re: Table Field Short Descriptions

Former Member — Tue, 13 Nov 2007 22:15:17 GMT

I don't have the ability to run an ABAP script, so is the short description in the field SCRTEXT_S ?

Thanks

Re: Table Field Short Descriptions

Former Member — Tue, 13 Nov 2007 22:24:05 GMT

You can see data in SE16 if you look at DD03M Database view :

Enter tab name

Use language field

Text fields are

SCRTEXT_S - Short

SCRTEXT_M - Medium

SCRTEXT_L - long ( Use this one)

Thanks

Seshu

Re: Table Field Short Descriptions

Former Member — Tue, 13 Nov 2007 22:25:29 GMT

Thanks for the information!

Re: Table Field Short Descriptions

Former Member — Wed, 05 Dec 2007 16:57:47 GMT

Sheshu... The DD03M seems to be missing some positional data even though its viewable in SAP TCode ZSE16R.

Check this out as an example:

Look at table CSKS fields by using ZSE16R, then go to the choose fields option in the Settings>List Format menus. Then compare that to the data that is in DD03M.

Examples of missing fields form DD03M for table CSKS:

MANDT

PKZKP

VERAK

WAERS

Can you tell me why this data isn't present in the DD03M table?

Thanks

Re: Table Field Short Descriptions

Former Member — Wed, 05 Dec 2007 17:27:41 GMT

Nevermind Sheshu... I found out that our SAP is limiting us to 2Gb of streaming data which explains why some of the data is missing.

Thanks anyway!