topic find out data dictinary table. in Application Development and Automation Discussions

find out data dictinary table.

Former Member — Sat, 12 Jun 2010 08:13:44 GMT

hai experts,

in mm02 tcode views like mrp 04 block bom explosion/ requrements under one field is individual/coll (marc-sbdkz).

select this field press f4 value along value and with some text come .

i want this text on which table save it.

thanks in advance.

Edited by: Rob Burbank on Jun 13, 2010 4:14 PM

kesavadas_thekkillath — Sun, 13 Jun 2010 18:10:43 GMT

Hi,

I dont have a system right now.

Go to the domain of that field and check the value table name( the value table will have the texts).

If value table doesnt exist, then check the fixed values.

If fixed values exists, then use fm GET_DOMAIN_VALUES.

Former Member — Sun, 13 Jun 2010 20:15:18 GMT

Run transaction ST05 against F4. That will show you the table.

Rob

Former Member — Mon, 14 Jun 2010 04:04:03 GMT

Hi,

The F4 values are maintained as Fixed values in the domain SBDKZ.

The text maintained for the fixed values are stored in the table DD07T.

You can fetch these text by passing DOMNAME as SBDKZ and DDLANGUAGE as SY-LANGU from table DD07T.

As Keshav told : You can also use the FM GET_DOMAIN_VALUES for the same.

Regards

DKS

Former Member — Mon, 14 Jun 2010 05:00:20 GMT

solve my problem.

thanks for all.