2LIS_02_SCL - need Doc Currency Amount (WRBTR) from EKBE table
Problem: We are using the 2LIS_02_SCL to get our purchasing order data. The problem is that instead of sending over the Doc Value Amounts found in the EKBE table, SAP is doing a calculation based on the the local currency. They are then using the Exchange rate from the PO Header. Our users are complaining, because they expect it to match up with what is in the purchase order history.
I was planning to create a new amount field and and in my transfer rules write ABAP code to take the following fields from 2LIS_02_SCL:
BW:CValLC(BWGEO), Local cur.(HWAER), Posting Date, Currency(WAERS)
Use this Date to go back to TCURR to get the correct exchange rate that is used and do my calculation to doc currency (basically replicating the data as viewed in PO History).
I ran into an issue however. The Currency (WAERS) field is being filled with the value from EKKO. I have a below example where in EKBE, the PO was invoiced in a currency other than the DOC Currency.
Data in R/3 from EKBE (History per PO)
Amount in Local Currency(DMBTR): 250,01
Local Currency (HSWAE): USD
Amount in Doc Currency(WRBTR): 250,01
Doc Currency (WAERS): USD
Data in R/3 from EKKO (Purchase Order Header)
In this scenario, I am unable to populate the correct value (as seen in purchase order history).
I dont see of a way that I can get around this. Does anyone have any ideas?