Maintanence View

[Former Member]

Hi all,

maintanence view v_tvkgr

req s to use in dis view in my program to get sales group description

im nt aware of using dis view in se38.

can any 1 help?

thanks in advance

sashti.p

[Former Member]

Hi all,

maintanence view v_tvkgr

req s to use in dis view in my program to get sales group description

im nt aware of using dis view in se38.

can any 1 help?

thanks in advance

sashti.p

[Former Member]

hi ,

y u want to use maitainance view to get data ,

use simple select query on DB table to fetch what u want.

[Former Member]

Hi,

You can't use Maintenance view in SELECT statement in your program.

Instead i would suggest to use the tables TVKGR & TVGRT in combination to get the sales group description.

tables: tvgrt.

parameters: p_vkgrp type tvgrt-vkgrp.

select single bezei into tvgrt-bezei from tvgrt
where spras = sy-langu and
          vkgrp = p_vkgrp.
if sy-subrc = 0.
  write:/ p_vkgrp, tvgrt-bezei.
endif.

Please note TVKGR is the master table for sales group and TVGRT is the text table for TVKGR, ie TVGRT contains the description of the sales group in different languages.

Hope this helps.

Thanks,

Balaji

[Former Member]

Hi,

We cannot use maintenance view for select queries.

Only Database views and projection views can be used with select queries.

Reward points if helpful.

Thanks and Regards.