Help View Read

[Former Member]

How I can access a Help View in ABAP? I need the data from the Help View "H_T007A" but i can't read or select this view.

Message: "H_T007A" is not a table or database-view.

[RichHeilman · Accepted solution]

That view is over two tables, T007A and T007S. You can't do a SELECT against this view and you can't do a inner join against these two tables because one of them is a pooled table. I think this may be your only solution.

report zrich_0004
       no standard page heading.

data: itab type table of h_t007a with header line.

select * into corresponding fields of table itab
         from t007a.
loop at itab.
  select single TEXT1 into itab-TEXT1
          from t007s
               where spras = sy-langu
                 and kalsm = itab-kalsm
                 and mwskz = itab-mwskz.
  modify itab.

endloop.


check sy-subrc  = 0.

Regards,

Rich Heilman

[Former Member · Accepted solution]

i have found this solution, too.

but i need this for my degree dissertation and it's look not very professionally, because of database travel an so on.

there are not another solution to read the existent help-view directly?

[RichHeilman · Accepted solution]

You can not read the help-view directly. The system will not allow it.

How about this......only two database hits.

report zrich_0004
       no standard page heading.

data: it007a type table of t007a with header line.
data: it007s type table of t007s with header line.
data: itab type table of h_t007a with header line.

select * into corresponding fields of table it007a
         from t007a.
select * into corresponding fields of table it007s
         from t007s.


loop at it007a.

  move-corresponding it007a to itab.
  read table it007s with key
                       spras = sy-langu
                       kalsm = itab-kalsm
                       mwskz = itab-mwskz.
  move it007s-text1 to itab-text1.
  append itab.

endloop.


check sy-subrc  = 0.

Regards,

Rich Heilman

[Former Member · Accepted solution]

looks better. thx

[Former Member]

Hi Tom,

You can join the tables T007A and T007S to get the required results.

Regards,

Vin

[Former Member]

this doesn't work.

for pool-tables, cluster-tables a join is not allowed: "T007S"