topic Re: data extract from maintenance view in Application Development and Automation Discussions

data extract from maintenance view

Former Member — Thu, 17 Dec 2009 05:48:27 GMT

Hi,

it is possible to extract data from maintenance table?

for ex, i want to check the combination of company code and plant in V__T001K_ASSIGN (SAP standard View).

i want to extract the plant code (WERKS) with the company code (BUKRS) as the extraction condition.

But i am not able to extract the data since it is a maintenance view and not the data base table.

can any body help?

Regards

Re: data extract from maintenance view

former_member194669 — Thu, 17 Dec 2009 05:58:00 GMT

You may need to use fm VIEW_GET_DATA. SAP doesn't allow SELECT query on maintenance view

a®

Re: data extract from maintenance view

Former Member — Thu, 17 Dec 2009 08:47:23 GMT

Try this out,

CALL FUNCTION 'VIEW_GET_DATA'

EXPORTING

view_name = 'V_TVTA_KFV'

TABLES

data = it_bus_area.

V_TVTA_KFV - View from which data is to be extractted

it_bus_area - internal table into which data will be extracted (DATA: it_bus_area TYPE TABLE OF V_TVTA_KFV,)

Hope this helps u.

Regards,

Abhijit

Re: data extract from maintenance view

Former Member — Thu, 17 Dec 2009 08:57:23 GMT

DATA: itab TYPE STANDARD TABLE OF V_T001K_ASSIGN.

CALL FUNCTION 'VIEW_GET_DATA'

EXPORTING

VIEW_NAME = 'V_T001K_ASSIGN'

TABLES

DATA = itab

Re: data extract from maintenance view

Former Member — Thu, 21 Oct 2010 10:34:38 GMT

good

Re: data extract from maintenance view

tkuebler1 — Mon, 19 Sep 2022 06:09:23 GMT

Thanks 4 you Info.

This showes me again how sick sap abap is...compleatly insane logik.

Re: data extract from maintenance view

thkolz — Mon, 19 Sep 2022 08:07:24 GMT

SM30 -> Display

More -> Table View -> Export (Spreadsheet)

Re: data extract from maintenance view

Former Member — Mon, 19 Sep 2022 13:07:38 GMT

I saw your posted comment. I recommend responding to newer questions. The author of the original question is no longer active in the community and won't receive your query. Feel free to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. With these tips you'll be able to prepare questions that draw responses from our members.

Thanks!