‎2006 Sep 20 3:11 PM
ho to all,
help me in this issue,
i want decimal format field(xdezp) from t005x with respect to comapny code but t005x is a pooled table .
i need the xdezp according to the comapny code how can i get it
thanks in advance.
kiran kumar
Message was edited by: kiran kumar
‎2006 Sep 20 3:28 PM
you can use USR01 table,to get the same for a particular USER Decimal notation.
field : USR01-DCPFM.(see F4 values for that field)
alternatively, go to the dataelement "XUDCPFM" and search of WHERE USED LIST. from here also you can find what tables are using this dataelement and from here you can get the required one.
Regards
Srikanth
Message was edited by: Srikanth Kidambi
Message was edited by: Srikanth Kidambi
‎2006 Sep 20 3:28 PM
you can use USR01 table,to get the same for a particular USER Decimal notation.
field : USR01-DCPFM.(see F4 values for that field)
alternatively, go to the dataelement "XUDCPFM" and search of WHERE USED LIST. from here also you can find what tables are using this dataelement and from here you can get the required one.
Regards
Srikanth
Message was edited by: Srikanth Kidambi
Message was edited by: Srikanth Kidambi
‎2006 Sep 20 3:29 PM
To use the particular setup...u just need to use the below.
SET COUNTRY 'GB'.
and in that case it would pickup the corresponding settings.
Sample code :
start-of-selection.
<b>set country 'GB'.</b>
IF p_file = 'X' and p_fname = space.
message E989(06) with 'Please select Filename with Path'.
EXIT.
endif.
Message was edited by: Anurag Bankley
‎2006 Sep 20 3:30 PM
I think you can still write selects on pooled table.
tables: t005x.
select single *
from t005x
where land1 = 'US'.
Regards,
Ravi
Message was edited by: Ravi Kanth Talagana
‎2006 Sep 20 3:50 PM
hi ravi,
not for single country for all countries i need a decimal notation. how can i get it
thanks in advance.
‎2006 Sep 20 3:32 PM
this table gives decimal notation according to country keys..
n u can select from the pool table like a transparent table....
for setting the decimal notation u can goto transaction OY01.