data extract from maintenance view

[Former Member]

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

[Former Member]

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!

[former_member194669]

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

a®

[Former Member]

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

[Former Member]

DATA: itab TYPE STANDARD TABLE OF V_T001K_ASSIGN.

CALL FUNCTION 'VIEW_GET_DATA'

EXPORTING

VIEW_NAME = 'V_T001K_ASSIGN'

TABLES

DATA = itab

.

[Former Member]

good

[tkuebler1]

Thanks 4 you Info.

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

[thkolz]

SM30 -> Display

More -> Table View -> Export (Spreadsheet)

[Former Member]

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!