topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Sat, 20 Jul 2013 05:58:15 GMT

i have region (region-adrc) as op in my report,which shows op as 13 for Maharashtra but i need to show Maharashtra instead of 13, what should i do?

Re: Report

Former Member — Mon, 22 Jul 2013 09:25:47 GMT

You need to read table T005S using the region.

Select BEZEI

from T005S

where LAND1 = 'IN'

and bland = '13'.

T005S-BEZEI = 'Maharashtra'.

Re: Report

Former Member — Mon, 22 Jul 2013 09:30:15 GMT

To find out the description of a code is usually straightforward. Check the table in SE11 - in this case ADRC. Go to the "Entry help/check'" tab. Find the field you wish to find the description for - in this case "REGION". Look at the search help or check table attached to that field - in this case the check table is T005S.

Re: Report

Former Member — Mon, 22 Jul 2013 09:34:14 GMT

Hi,

ADRC will not give you the description for the region.

What you could do is you could fetch the BEZEI field from the t0005s table where you can get the description.

if you still don't want to write a query then use

if adrc-bland = '13'.

description = 'MAHARASTRA'.

endif.

in the loop you make for final output.

Thanks,

Dinesh.

Re: Report

Former Member — Mon, 22 Jul 2013 09:47:07 GMT

Hi,

as all said you have to get the description from t005u table.

select * from t005u INTO TABLE it_t005u
FOR ALL ENTRIES IN it_tab
where spras = 'EN' and land1 = 'IN'and bland = it_tab-region_number.

READ TABLE it_t005u into wa_t005u WITH key spras = 'EN' land1 = 'IN' bland = region_number.

Re: Report

former_member491621 — Mon, 22 Jul 2013 09:54:02 GMT

Hi Pratik,

Just a small correction to what Kevin suggested.

You can get the value from table T005U. Table T005S does not contain the field BEZEI.

Hope this helps

Re: Report

Former Member — Mon, 22 Jul 2013 10:29:32 GMT

Hi,

Read Table T005U.

Select BEZEI

from T005U

where LAND1 = 'IN'

and bland = '13'.

T005U-BEZEI = 'Maharashtra'.

Regards,

Ravi Pratap Singh

Re: Report

former_member209120 — Mon, 22 Jul 2013 10:46:27 GMT

Hi Pratik Ranadive,

Try like this

Select BEZEI

from T005S

into table it_T005S

for all entries in it_adrc

where LAND1 = 'IN'

and BLAND = it_adrc-REGION.

Re: Report

Former Member — Mon, 22 Jul 2013 11:05:07 GMT

Hi Pratik ,

Goto below code.

data: var1 type BEZEI20.

Select BEZEI from T005U into var1

where SPRAS = SY-LANGU

AND LAND1 = 'IN' " COUNTRY CODE

AND BLAND = '13' . " REGION CODE.

Regards

Alok

Re: Report

Former Member — Tue, 23 Jul 2013 06:22:58 GMT

Thanks Aniket,

This helped... i wanted that correct table name which u suggested.

Re: Report

venkateswaran_k — Tue, 23 Jul 2013 06:34:52 GMT

Dear Pratik

Is this issue resolved?

Regards

Venkat

Re: Report

Former Member — Tue, 23 Jul 2013 06:37:44 GMT

Hi,

can you show your source code ?

Re: Report

Former Member — Tue, 23 Jul 2013 06:55:13 GMT

Dear Venkat,

Yes the issue is resolved completely.

Thanks all for the help.