12-03-2008 9:14 AM
Dear All,
DD03L contains table-field data, DD03T - as I know - is for field description. If I use SE16 + DD03T and give table MARC as selection parameter, SAP tells me:
No table entries found for specified key
Message no. MO429
In which tabel I can find the name of the fields? How can I extract those pieces of information via a query? (I cannot write ABAP code).
Please help...
Thanks,
Csaba
12-03-2008 9:32 AM
you can also try table DD03M
in fact the problem is here, that there is a data element behind each table-field, and the data element has the text (not the table-field). The data elements are stored in table DD04L, the texts of the elements in DD04T.
DD03L-ROLLNAME will be the data element behind the table-field, you have to check that one in DD04L and DD04T tables
12-03-2008 9:20 AM
12-03-2008 9:28 AM
HI,
The Function Module DDIF_FIELDINFO_GET
retrieves all the field along with descritpion.
You can chk it out this FM.
Regards,
K.Tharani.
12-03-2008 9:32 AM
you can also try table DD03M
in fact the problem is here, that there is a data element behind each table-field, and the data element has the text (not the table-field). The data elements are stored in table DD04L, the texts of the elements in DD04T.
DD03L-ROLLNAME will be the data element behind the table-field, you have to check that one in DD04L and DD04T tables
12-03-2008 9:37 AM
I think DD03T only contains descriptions for table fields that do not reference a data element.
Thomas
P.S. somebody edited his post, so mine is a dupe now
12-03-2008 10:29 AM
>
> P.S. somebody edited his post, so mine is a dupe now
that was me of course, sorry, but the statement you provided was missing from my reply, so your post still holds valuable information
12-03-2008 10:50 AM
Dear All,
Thaks for your answers!
Vivek,
I wouldn't like to use ABAP code but I assume what you wrote is correct.
Tharani,
I don't know how to use function modules...my poor knowledge...
Ok, in the meanwhile my colleague told me, it is an ABAP program (that cannot be run in itself) and I can refere to (and use) in my ABAP programs...
Thanks,
Csaba
Edited by: Csaba Szommer on Dec 3, 2008 11:56 AM
12-03-2008 9:38 AM
12-03-2008 10:02 AM
There should be better way to handle this, but if joining DD03L & DD03T doesn,t resolve issue
You can loop at structure in your program.
sflighttype ?= cl_abap_typedescr=>describe_by_name('SFLIGHT').
comp_tab = sflighttype->get_components( ).
LOOP AT comp_tab ASSIGNING <wa_comp>.
CASE <wa_comp>-name.
WHEN 'CARRID' OR 'CONNID' OR 'FLDATE' OR 'PRICE' OR 'CURRENCY'.
APPEND <wa_comp> TO new_comp_tab.
ENDCASE.
ENDLOOP.
I have copied this code for referance from following link.