Re: [sap-log-sd] Condition rate in KONV table
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by R. Neal Wilhite (Senior Project Manager) on May 13 at 3:11 PM |  Mark as helpful |
Just make sure I was accurate enough. I'm not that experienced in SD/FICO, so I could have badly worded my answer even though there was good intent.
Neal
-----Original Message-----
From: hovering_yogi via sap-log-sd <sap-log-sd@Groups.ITtoolbox.com>
To: R. Neal Wilhite <wilhiten@aol.com>
Sent: Thu, May 13, 2010 9:46 am
Subject: Re: [sap-log-sd] Condition rate in KONV table
Posted by hovering_yogi (Independent SAP SD Consultant currently at Sony)
on May 13 at 9:56 AM
Mark as helpful
Very comprehensive Neal - definitely better than my "for good reason"! -
thanks for taking the time to elaborate as sure it will help others who have
come across similar confusion.
On 13 May 2010 14:33, R. Neal Wilhite via sap-log-sd <
sap-log-sd@groups.ittoolbox.com> wrote:
> Posted by R. Neal Wilhite(Senior Project Manager)
> on May 13 at 9:36 AM
> In this case, SAP intends you to use their methods for accessing it.
> You'll notice that it is always stored with a currency key. That key has
> fields that describe how it is to be read. In every portion of SAP they read
> in with currency key as a parameter.
>
> Why:
> Different currencies have different numbers of decimal places. USD has 2
> others have 3 or 1 or none (there may be others...). They however must all
> be stored in the same field. How do you manage that? You could put it all in
> a 3 decimal place field, but what if you do a calculation on it. Say tax is
> 6.5%. cost is $1.02. Therefore gross is $1.0863. The system realizes this is
> not representable, so it shows it as 1.086. But in USD there is no such
> thing as 0.006.
> SAP has chosen to shift them all to the same number of decimal places so
> that manipulations can all be done on the fly with 0 overhead. Only when
> they are displayed does the un-shifting need to be done.
>
> HTH,
>
> Neal
>
> In case you didn't catch it, this is just a translation of what Stephen
> said. (Or just because it bugs you, doesn't make it an insect...)
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: hovering_yogi via sap-log-sd <sap-log-sd@Groups.ITtoolbox.com>
> To: R. Neal Wilhite <wilhiten@aol.com>
> Sent: Thu, May 13, 2010 2:36 am
> Subject: Re: [sap-log-sd] Condition rate in KONV table
>
>
>
>
>
>
>
>
> Posted by hovering_yogi (Independent SAP SD Consultant currently at Sony)
> on May 13 at 2:34 AM
> Mark as helpful
>
>
> I dont think its fair to say its a bug... it is entirely fair to say to be
> careful and make sure you divide the value by the required factor. Just
> because you expect it to be stored in the database in a certain way doesn't
>
> mean it has to be sometimes for very good reasons.
>
> On 13 May 2010 04:30, Harsimran Gill via sap-log-sd <
> sap-log-sd@groups.ittoolbox.com> wrote:
>
> > Posted by SAP_Inventions
> > on May 12 at 11:34 PM
> > This is a Bug, It multiples the rate by 10 and saves in KONV. This is
> > worse for ZR00 maintained in Eu$, the value stored in KONV is multiplied
> by
> > 1000 by itself. If you are picking these values be careful and divide by
> the
> > factor before using these values.
> >
> > -----Original Message-----
> > Dear members,
> > I have sales order with the following condition types
> >
> > ZPR0 Price 16.00 USD
> > Gross Value 16.00 USD
> > Discount Amount 0.00 USD
> > Rebate Basis 16.00 USD
> > ZST4 Repack Chge w/ Tax 0.00 USD
> > ZST5 Special Chge w/ Tax 0.00 USD
> > Net Value for Item 16.00 USD
> > BO01 Mat/Group Rebate 1.00- %
> > Net Value 2 15.84 USD
> > Net Value 3 15.84 USD
> >
> > Now, my first query is --> when I look into the table KONV-KBETR, the
> > condition rate is showing (10.00-) Why is it so? Should'nt it show
> (1.0-%)?
> >
> > My second query is how can I pull up the 'Netvalue 2' i.e., 15.84 USD
> into
> > my report? Which table is it getting stored?
> >
> > Thanks and Regards,
> > SAPQUEST342
__.____._ Neal
-----Original Message-----
From: hovering_yogi via sap-log-sd <sap-log-sd@Groups.ITtoolbox.com>
To: R. Neal Wilhite <wilhiten@aol.com>
Sent: Thu, May 13, 2010 9:46 am
Subject: Re: [sap-log-sd] Condition rate in KONV table
Posted by hovering_yogi (Independent SAP SD Consultant currently at Sony)
on May 13 at 9:56 AM
Mark as helpful
Very comprehensive Neal - definitely better than my "for good reason"! -
thanks for taking the time to elaborate as sure it will help others who have
come across similar confusion.
On 13 May 2010 14:33, R. Neal Wilhite via sap-log-sd <
sap-log-sd@groups.ittoolbox.com> wrote:
> Posted by R. Neal Wilhite(Senior Project Manager)
> on May 13 at 9:36 AM
> In this case, SAP intends you to use their methods for accessing it.
> You'll notice that it is always stored with a currency key. That key has
> fields that describe how it is to be read. In every portion of SAP they read
> in with currency key as a parameter.
>
> Why:
> Different currencies have different numbers of decimal places. USD has 2
> others have 3 or 1 or none (there may be others...). They however must all
> be stored in the same field. How do you manage that? You could put it all in
> a 3 decimal place field, but what if you do a calculation on it. Say tax is
> 6.5%. cost is $1.02. Therefore gross is $1.0863. The system realizes this is
> not representable, so it shows it as 1.086. But in USD there is no such
> thing as 0.006.
> SAP has chosen to shift them all to the same number of decimal places so
> that manipulations can all be done on the fly with 0 overhead. Only when
> they are displayed does the un-shifting need to be done.
>
> HTH,
>
> Neal
>
> In case you didn't catch it, this is just a translation of what Stephen
> said. (Or just because it bugs you, doesn't make it an insect...)
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: hovering_yogi via sap-log-sd <sap-log-sd@Groups.ITtoolbox.com>
> To: R. Neal Wilhite <wilhiten@aol.com>
> Sent: Thu, May 13, 2010 2:36 am
> Subject: Re: [sap-log-sd] Condition rate in KONV table
>
>
>
>
>
>
>
>
> Posted by hovering_yogi (Independent SAP SD Consultant currently at Sony)
> on May 13 at 2:34 AM
> Mark as helpful
>
>
> I dont think its fair to say its a bug... it is entirely fair to say to be
> careful and make sure you divide the value by the required factor. Just
> because you expect it to be stored in the database in a certain way doesn't
>
> mean it has to be sometimes for very good reasons.
>
> On 13 May 2010 04:30, Harsimran Gill via sap-log-sd <
> sap-log-sd@groups.ittoolbox.com> wrote:
>
> > Posted by SAP_Inventions
> > on May 12 at 11:34 PM
> > This is a Bug, It multiples the rate by 10 and saves in KONV. This is
> > worse for ZR00 maintained in Eu$, the value stored in KONV is multiplied
> by
> > 1000 by itself. If you are picking these values be careful and divide by
> the
> > factor before using these values.
> >
> > -----Original Message-----
> > Dear members,
> > I have sales order with the following condition types
> >
> > ZPR0 Price 16.00 USD
> > Gross Value 16.00 USD
> > Discount Amount 0.00 USD
> > Rebate Basis 16.00 USD
> > ZST4 Repack Chge w/ Tax 0.00 USD
> > ZST5 Special Chge w/ Tax 0.00 USD
> > Net Value for Item 16.00 USD
> > BO01 Mat/Group Rebate 1.00- %
> > Net Value 2 15.84 USD
> > Net Value 3 15.84 USD
> >
> > Now, my first query is --> when I look into the table KONV-KBETR, the
> > condition rate is showing (10.00-) Why is it so? Should'nt it show
> (1.0-%)?
> >
> > My second query is how can I pull up the 'Netvalue 2' i.e., 15.84 USD
> into
> > my report? Which table is it getting stored?
> >
> > Thanks and Regards,
> > SAPQUEST342
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
R. Neal WilhiteSAP Logistics Sales and Distribution Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
In the Spotlight
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere. Use the New iPhone App
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
