Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

BUKRS Vs Exchange Rates (T001 ---> BUKRS-----Currency---->?)

Former Member
0 Kudos

Hi Experts,

Pls. let me, Where I hv to see to know that, a partcular BUKRS_1000 does hv/assigned so & so Exchange Rate Types - KURST?

Am trying to search in T001 -> BUKRS-Currency-->?

but, not get succeeded!

thanq.

1 ACCEPTED SOLUTION

former_member194669
Active Contributor
0 Kudos

Hi,

The following is a sample program i find in this forum


REPORT ZTEST01 .

TABLES: T001, TKA01, TKA02.
DATA: KURS LIKE TCURR-UKURS.

PARAMETERS: BUKRS LIKE T001-BUKRS.

SELECT SINGLE * FROM T001 WHERE BUKRS = BUKRS.

SELECT * FROM TKA02
WHERE BUKRS = BUKRS.
SELECT SINGLE * FROM TKA01 WHERE KOKRS = TKA02-KOKRS.

CALL FUNCTION 'READ_EXCHANGE_RATE'
EXPORTING
DATE = SY-DATUM
FOREIGN_CURRENCY = TKA01-WAERS
LOCAL_CURRENCY = T001-WAERS
TYPE_OF_RATE = 'M'
IMPORTING
EXCHANGE_RATE = KURS
* FOREIGN_FACTOR =
* LOCAL_FACTOR =
* VALID_FROM_DATE =
EXCEPTIONS
NO_RATE_FOUND = 1
NO_FACTORS_FOUND = 2
NO_SPREAD_FOUND = 3
OTHERS = 4.


ENDSELECT.
WRITE KURS.

aRs

8 REPLIES 8

former_member194669
Active Contributor
0 Kudos

Hi,

The following is a sample program i find in this forum


REPORT ZTEST01 .

TABLES: T001, TKA01, TKA02.
DATA: KURS LIKE TCURR-UKURS.

PARAMETERS: BUKRS LIKE T001-BUKRS.

SELECT SINGLE * FROM T001 WHERE BUKRS = BUKRS.

SELECT * FROM TKA02
WHERE BUKRS = BUKRS.
SELECT SINGLE * FROM TKA01 WHERE KOKRS = TKA02-KOKRS.

CALL FUNCTION 'READ_EXCHANGE_RATE'
EXPORTING
DATE = SY-DATUM
FOREIGN_CURRENCY = TKA01-WAERS
LOCAL_CURRENCY = T001-WAERS
TYPE_OF_RATE = 'M'
IMPORTING
EXCHANGE_RATE = KURS
* FOREIGN_FACTOR =
* LOCAL_FACTOR =
* VALID_FROM_DATE =
EXCEPTIONS
NO_RATE_FOUND = 1
NO_FACTORS_FOUND = 2
NO_SPREAD_FOUND = 3
OTHERS = 4.


ENDSELECT.
WRITE KURS.

aRs

0 Kudos

thanq,

sorry, i did not presented properly my requirement!

my requirement is,

I wanna to get all Exchange Rate types - KURST for a defined/assigned for a particular BUKRS_1000.

thanq.

0 Kudos

Hi,

Check for table T001A

aRs

0 Kudos

hi,

here no entries!

thanq.

0 Kudos

Hi,

Check OB08 transaction.

Exchange rate depends on 3 types.

1. Bank buying 2. Bank selling 3. Average rate.

Thanks,

Deepak.

0 Kudos

Hi,

Check for entries in Higher boxes. because i can able to find entries in my server

aRs

0 Kudos

thanq,

May I know that, Wht r Higher boxes? Do u mean, Config engine?

thanq.

0 Kudos

Hi,

I mean Production server or Unit testing servers

aRs