how to fetch values from Table DDSHPVAL50 based on sy-uname

[Former Member]

Hi all,

Any idea how to fetch values from Table DDSHPVAL50 based on sy-uname.

This table is used to store values for personal value list.

[Former Member]

Hi Saurav,

Use this link.

I hope this will help you.

Regards,

Vijay

[Former Member]

what is the problem?

data : gt_DDSHPVAL50 type standard table of DDSHPVAL50.

select * from DDSHPVAL50 into gt_DDSHPVAL50 where username = sy-uname.

[Former Member]

Hi,

Will not a simple select query work..

data:
  t_tab type table of DDSHPVAL50,
  fs like line of t_tab.

  select *
  from DDSHPVAL50
  into table t_tab
  up to 10 rows
  where username eq sy-uname.
  if sy-subrc eq 0.
  loop at t_tab into fs.
    write:/ fs-username.
  endloop.
  endif.

Regards,

Deeba

[Former Member]

hi,

there is one field record of char255. it has values for all the columns in a different format.

I was thinking if there was some standard FM / perform which would fetch the values of this Record into an internal table.

[Former Member]

what is the problem again?

after getting the value into internal table, you can see the value of that char255 field i.e RECORD some thing like :

"FIELD:_CTEXT000020₀₀₀₁₂₀C~000000"

[Former Member]

how to interpret this value ?

Sometimes for one row to be inserted in DDSHPVAL50 , two rows are created in the table by standard perform

How would i know which two rows corresponds to one row of internal table ?

[Former Member]

Solved using Standard perform:

PERFORM personal_values_select IN PROGRAM saplsdsd

TABLES t_record

USING p_shlp_descr .