Extracting Purchase doucument Item condition value (Urgent)
Currently, I am extracting purchase order item level data using 2lis_02_itm DS in which the extract structure is modified with fields which are fetching data from Condition Type (KSCHL), Condition Value (KWERT), etc., field at run time for which code is written in CMOD.
Now, user requirement is some what like this: they maintain KWERT for one of the condition type after a week/a month or 2 months (not fixed) of PO creation date.
Problem: In current extraction the data is comming for all the values changed or records added at item level (like material number, quantity, value, net value, etc.) but its not extracting the change in Condition Value (KWERT).
<b>Please explain why?</b>
Also, I tried to create a view based on the tables EKKO, EKPO and KONV but since KONV is pool table it's not allowing to create one.
Tried to create function module by changing standard function module RSAX_BIW_GET_DATA_SIMPLE_1 and passing an custom extract structure created with only few (required) fields. The problem with this one is that in OPEN CURSOR ..... area when I am trying to write select statement which contains INTO clause, its giving error while checking where as query is working when tested as a report output.
<b>Also, pls. let me know weather any provision is available on extraction of Condition data for each item in a PO is available in SAP's standard DS or BC. The one like they have condition level DS for application area SD.</b>
for any further details pls. let me know.
Thank You in advance.
Points will be awarded to satisfying answer.