‎2006 Oct 05 2:24 PM
Hi All
Kindly give me solution for my requairment.
i am explaining my requairment.
inbound idoc orders03 meesage type ordchg.
this inbound idoc is for to change the sales order.
the data comes to segments and it will update the sales order related tables here i have nothing to do.
first i will give the field names of segments
E1EDK02 BELNR PO Number
E1EDP01 POSEX Line Item Number
E1EDP01 MENGE Item Quantity
E1EDP20 EDATU Delivery Date
E1EDP19 QUALF Identification for customer
E1EDP19 IDTNR Material Number
these fields will automatically change the sales order.
when changing the sales order i need to do two stpes
1)here the item Quantity is from purshase order.
but they donot want to chage the sales order with this qunatity.they want to upate the quantity which is in the sales order for that purchase order number and item.
for that firsti need to get the sales order number and item from table VBFA based on the purchase order number and item.
2)Based on the salesorder number and item i need to get QUANTITY (WMENG)from table VBEP.
and to pass this wmeng to appropriate internal table which actually change the sales order.that is in function module (exit_saplvedb_001).
Please kindly response to this topic.
I have very less time to complete this task.
Kindly help me .
Please give sample coding for this .
Thanks in Advance.
Thanks&Regards.
Ramu.
‎2006 Oct 05 2:34 PM
Do something like this:
CASE segment-segnam.
when 'E1EDP01'.
select *
from vbfa
where vbelv = e1edk01-BELNR
and posnv = e1edp01-posex
*vbfa-vbeln will be your so and
vbfa-POSNN will be your item
SELECT SINGLE *
FROM VBEP
WHERE VBELN = VBFA-VBELN
AND POSNR = VBFA-POSNN.
endcase.
Regards,
ravi
‎2006 Oct 05 2:45 PM
Hi,
vbelv is the so and posnv is the item.
after getting the record from vbep how to pass the wmeng to the internal table.
Thakns&Regards.
Ramu.