cancel
Showing results for 
Search instead for 
Did you mean: 

Pricing issue

Former Member
0 Kudos

Hi friends

my problem is

For a scheduling agreements there are n number of deliveries.

suppose 1 delivery is made in Jan-2004 price is 100/1

2 feb-2005 200/1

3 april-2005 150/1

Now my requirement is to find the price of the item in a delivery when delivery was created.

i.e. in which tables can i find these price changes for a SA and also check for their validity dates..

We do not maintain pricingin delivery documents

Another problem is How to convert the currency i.e like

from INR to USD keeping in mind the exchange rate at the time of conversion

Thank you very much for ur help in advace

this is very urgent

please help me

regards

sree

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI,

I can give solution to the last problem

CALL FUNCTION 'CONVERT_AMOUNT_TO_CURRENCY' EXPORTING

date = sy-datum

foreign_currency = 'INR'

foreign_amount = '2000.00'

local_currency = 'USD'

IMPORTING

local_amount = amount

Try this out.

Hope this helps.

Thanks & Regards,

Judith.

Former Member
0 Kudos

Hi

this is whant Iam getting

Import parameters Value

DATE 2005/05/02

FOREIGN_CURRENCY INR

FOREIGN_AMOUNT 2000

LOCAL_CURRENCY USD

Export parameters Value

LOCAL_AMOUNT

Tables Value

T_C_ERRORS 0 Entries

Result: 0 Entries

Can you please correct me where iam going wrong

regards

sree

Answers (2)

Answers (2)

christian_wohlfahrt
Active Contributor
0 Kudos

Hi Sree,

(in addition to Brad's comments)

you wrote: We do not maintain pricing in delivery documents -> you have only (relevant) pricing in purchase orders / sales orders (depending on the original document) and in an invoice.

If you should do something in between, it's a hint for a redesign of the process. I know, customers very often require price information at other places, but try to re-direct the focus to the correct places of (customer) price determination: sales order or invoice (which uses very often conditions of the sales order -> only one price determination left).

Regards,

Christian

Former Member
0 Kudos

Hi Sree,

What price are you after?

- material cost price?

- price rate (eg $5.00 per 1kg)?

- total price ex tax?

- total price inc tax?

Do you do pricing in your scheduling agreements?

Why do you need the price at the delivery? Maybe there is another way to achieve what you want.

I would forget about looking for the pricing master data records in the tables, its much too complicated. You need to use a pricing procedure to determine the price.

Please get back with some answers.

Cheers,

Brad