Skip to Content
0

Total Net Order Value stored data

Feb 13 at 03:31 AM

33

avatar image
Former Member

Hi All,

Can anybody please let me know in what table are the values stored from the transaction CL20N. The field is "Total Net Order Value" from CL20N. I get the data on it but its on float data using AUSP table. How can i get the exact data that is encoded to "Total Net Order Value".

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

shivakkumar Geetha venkatesan Feb 13 at 08:30 AM
-1

Hi CJ Reyes,

Please find the details.

System reads the value EKPO-NETWR (Net order value in PO currency)

for the value CEKKO-GNETW (Total net order value), and system will not

read the condition table KONV to read the condition price.

For using the effective price you need to use the user-exit EXIT_SAPLEBND_002.

Use the field CEKKO-USRN1 to receive the EKPO-EFFWR value.

Hope it helps..

Regards.

G.V.Shivakkumar

Share
10 |10000 characters needed characters left characters exceeded
Ankur Chauhan Feb 13 at 04:54 AM
-1

Hi CJ Reyes,

What is exactly you are trying to do, as per my understanding you are trying to mapped the release strategy, for Purchase Order or other Purchasing Documents, if you are trying it for Purchase order, you can use "Total Net Order Value" from the Table CEKKO and the field name is GNETW.

Please do let me know in case you are doing something else!!

Thanks,

Ankur Chauhan

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Ankur Chauhan,

Thank you for your answer, I'm trying to extract data from the table that stored "Total Net Order Value", how ever direct read for CEKKO is not possible any other way to extract the data of it. Data from AUSP is a float data.

Thanks

CJ Reyes

0

Try with EKKO!!

0

What you see in CL20N is not from EKKO table, it is from the classification, it has the values specified for the characteristics. You can't use at all CL20N to see values from a purchase order, hence EKKO can't be the right answer to the question "..let me know in what table are the values stored from the transaction CL20N."

0
Jürgen L
Feb 13 at 06:37 AM
0

CEKKO has the value from the purchase order during runtime of a purchase order. This value from CEKKO has nothing to do with a AUSP value, except that SAP is comparing CEKKO and AUSP field in its release procedure.

If you want a clear readable value then you have to use a function module to convert it. There is no other table that stores this value in enduser readable way.

Use this search term in Google and you will find plenty discussions with suggestions: how to read float fields site:sap.com

Share
10 |10000 characters needed characters left characters exceeded