Online Tutorials & Training Materials | STechies.com
Register Login

How to Retrieve the short description of a Fieldname using only the Fieldname

|| || 4

How to Retrieve the short description of a Fieldname using only the Fieldname
Stechies

Good Day everyone,

I would like to know if there is a way, a function perhaps or anthing to retrieve the short description of a fieldname using only the fieldname itself w/o particularly knowing the table name where that fieldname came. Fieldname(s) came from table CDPOS.

FIELDNAME: ABTR
TABLE NAME: ?
SHORT TEXT: ?

Thank a lot everyone!
Your kind response is a big help for an abap newbie like me. =]


Comments

  • Shalesh Singh Visen
    04 Jul 2011 5:34 am
    I don't think so, I think the text is dependent on the data element so only having the field name is not enough, unless the field name matched the data element's name (which happens quite a lot).
    You can use table DD04T, where ROLLNAME is the data element name and DDLANGUAGE is the language of the text you want.
  • Shalesh Singh Visen
    04 Jul 2011 5:35 am
    I agree to what you have said, not all fieldnames have the same name with their corresponding data element.
    I've used to checked those tables, including the DD03L(Table Fields) and DD03T(DD: Texts for fields (language dependent)).
    I am searching for a function where i can pass as parameters all the fieldnames that will came from CDPOS then display the
    corresponding short text of the fieldnames. Its main reason is I do need it as a column for my ZRPT_CMR_CHANGE_LOG report.
    I need to know what fieldnames was edited/updated on the customer master data based on the given date range.


    As of now, no function available because some of the functions that I searched, the TABLENAME is a required parameter.
    I am doing it manualy. On se11, I am placing the fieldnames on the Data Element field then clicked the button Where-Used-List.
    From there sir, I was able to see where that fieldname came from what table and its description. For those fieldnames that are not
    the same with their DataElement, Iam surfing the internet to know from what table it came from and then check that table then get its
    short text/description.
    Those fieldnames that I was able to convert from non-technical term, I am adding it to my custom table ZCMR_LOGS. Its structure is:
    MANDT Fieldname Description.
  • Shalesh Singh Visen
    04 Jul 2011 5:35 am
    To get Texts from DataElement:
    1º Get Description of FIELDNAME using the class CL_RECA_DDIC_DTEL method GET_TEXT.
    Now you have SHORT, MEDIUM and LARGE descriptions.

    Get texts from table with fieldname:
    1º Select TABNAME from table TCDOB where OBJECT = CDPOS-OBJECTCLAS.
    Now you have all tables related with respective object.

    2º Function SCTM_GET_TAB_FROM_DATA_ELEMENT get ALL tables related with especific DataElement.
    3º With TABNAME found in TCDOB exclude entries in TABLELIST(Return of Function).
    4º Now for each table you can get with the class CL_RECA_DDIC_DTEL method GET_TEXT_BY_FIELDNAME your descriptions.
    This suggestion may I help you?
  • Shalesh Singh Visen
    04 Jul 2011 5:35 am
    If you are trying to present the changes then you should probably check out these functions:
    CHANGEDOCUMENT_READ_HEADERS
    CHANGEDOCUMENT_READ_POSITIONS
    The second one seems to get you a description of the field on the field FTEXT of EDITPOS.

    That being said, CDPOS already has both table and field name, so you can use the tables you just said: DD03L and DD03T..