Description of ATNAM field in CABN table

[Former Member]

Hello experts,

How can I know the description of ATNAM field in CABN table? I havent tried this,

Example:

If the value of ATNAM is 'IH_VC_FOD_M', how can I know that this is "Roll outside diameter"

Thanks and Regards,

Chris

[Former Member · Accepted solution]

Hi Chris,

you can use transaction CT04 to look up the description of the characteristic.

Regards,

Andreas

[RichHeilman · Accepted solution]

Check the sample code.

report zrich_0001.

data: begin of xcab,
      atnam  type cabn-atnam,
      atinn  type cabn-atinn,
      atbez  type cabnt-atbez,
      end of xcab.

parameters: p_atnam type cabn-atnam.


select single cabn~atnam cabn~atinn cabnt~atbez
       into corresponding fields of xcab
          from cabn
             inner join cabnt
                on cabn~atinn = cabnt~atinn
                    where cabn~atnam = p_atnam
                      and cabnt~spras = sy-langu.




write:/ xcab-atnam, xcab-atbez.

Regards,

Rich Heilman

[ferry_lianto]

Hi Chris,

You can use FM <b>CTM1_CHARACTERISTIC_HAS_TEXT</b> to get characteristic description.

DATA: WA_ATINN TYPE CABN-ATINN,
      WA_ATBEZ TYPE CABNT-ATBEZ.
                                                                        
MOVE 'IH_VC_FOD_M' TO WA_ATINN.
                                                         
CALL FUNCTION 'CTM1_CHARACTERISTIC_HAS_TEXT'
  EXPORTING
    ATINN           = WA_ATINN
    LANGU           = SY-LANGU
    KEY_DATE        = SY-DATUM
  IMPORTING
    ATBEZ           = WA_ATBEZ
 EXCEPTIONS
    NO_ATINN        = 1
    NO_LANGU        = 2
    NOT_FOUND       = 3
    NO_TEXT         = 4
    OTHERS          = 5.
                                                                        
IF SY-SUBRC = 0.
  WRITE: / WA_ATBEZ.
ENDIF.

Hope this will help.

Regards,

Ferry Lianto

[Former Member]

thanks guys, I really appreciate your help

[Lakshmant1]

Hi Christopher,

Check CABNT table.

Thanks

Lakshman