How to retrieve data from maintainence table

[Former Member]

Hi all,

Can any body help me how to retrieve data from maintaince view V_T005 ASAP.

Thanks,

Sagar.

[Former Member]

Hi all,

Can any body help me how to retrieve data from maintaince view V_T005 ASAP.

Thanks,

Sagar.

[Former Member]

U cannot get data from a maintenance view ..(cannot write a

select on a view)

Instead write select on the table T005

[Former Member]

Hi

declare a Itab with required fields from below fields

Use join

T005

T005T

T002

T002T

T005X

with where condition

T005 LAND1 = T005T LAND1

T002 SPRAS = T005 SPRAS

T002 SPRAS = T002T SPRSL

T005 LAND1 = T005X LAND

Regards

Shiva

[Former Member]

Hi Shiva,

I didn't get u.

I need to fetch country name by giving land1.So can u tell me with example please.

is there any FM. Once i have used view_get_data. but the table in this FM data has no data type. So to declare a table similar to data is now impossible for me.Can u help me.

regards,

sagar

[Former Member]

Hi,

The country names are stored in T005T (you can find this out by looking at how V_T005 is defined).

You can use the 'Pattern' button in the ABAP editor to contruct the SELECT statement.

Regards,

Nick

[Former Member]

Hi,

You cannot retrieve the data from the maintenenace table/views.

For V_T005 data retrieval you can use the following tables:

T005 MANDT = T005T MANDT

T005 LAND1 = T005T LAND1

T002 SPRAS = T005 SPRAS

T002 SPRAS = T002T SPRSL

T005 MANDT = T005X MANDT

T005 LAND1 = T005X LAND

Thanks,

Sriram Ponna.