Report

[Former Member]

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?

[Former Member]

You need to read table T005S using the region.

Select BEZEI

from T005S

where LAND1 = 'IN'

and bland = '13'.

T005S-BEZEI = 'Maharashtra'.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[former_member491621]

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

[Former Member]

Thanks Aniket,

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

[Former Member]

Hi,

Read Table T005U.

Select BEZEI

from T005U

where LAND1 = 'IN'

and bland = '13'.

T005U-BEZEI = 'Maharashtra'.

Regards,

Ravi Pratap Singh

[former_member209120]

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.

[Former Member]

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

[venkateswaran_k]

Dear Pratik

Is this issue resolved? 

Regards

Venkat

[Former Member]

Dear Venkat,

Yes the issue is resolved completely.

Thanks all for the help.

[Former Member]

Hi,

     can you show your source code ?