08-13-2007 9:24 AM
Hi,
Is there any way to get the inbound idoc number which created the sales order in the system.
I have the sales order no. form that i want know the inbound idoc number which created this sales order.
I am looking for any FM or Tables.
Thanks,
Patil
08-13-2007 9:37 AM
Go to WE19 and look which segment type has the sales order number in it. Keep the name of the segment as this is the dictionary structure that you will move the records from the next step into.
Read EDID4 by filtering out according to EDIDC etc. Overlay the record from this table into the segment structure mentioned above and this when you get the sales order number in that field you will have the IDOC number from the initial read.
Wayne
08-13-2007 9:27 AM
08-13-2007 9:30 AM
Hi
check in edidd table
reward points to all helpful answers
kiran.M
08-13-2007 9:32 AM
Hi,
use select query as follows.
select single * from edid4
where sdata cp <b>'SALES ORDER NUMBER'</b>.
from the field DOCNUM, you will get the inbound IDOC number.
reward points if helpful.
08-13-2007 9:37 AM
Go to WE19 and look which segment type has the sales order number in it. Keep the name of the segment as this is the dictionary structure that you will move the records from the next step into.
Read EDID4 by filtering out according to EDIDC etc. Overlay the record from this table into the segment structure mentioned above and this when you get the sales order number in that field you will have the IDOC number from the initial read.
Wayne
08-13-2007 9:46 AM
hi
good
go thruogh this link
[Removed by the moderator.]
thanks
mrutyun^
08-13-2007 9:47 AM
Hi..
Table EDID4 stores the Data records of an IDOC.
You can search for SDATA field to get the Sales doc no.
Try this Sample code
report ztest1.
tablEs edid4.
data : it_data type table of edid4 with header line.
PARAMETERS : P_MATNR TYPE MARA-MATNR DEFAULT '100-100'.
DATA : V_pattern type string.
CONCATENATE '%' P_MATNR '%' INTO V_PATTERN.
SELECT * FROM EDID4 into table it_data
WHERE
segnam = 'E1EDK01' "To check the Segment name
and SDATA LIKE V_PATTERN
.
LOOP AT IT_DATA.
WRITE: IT_dATA-DOCNUM.
ENDLOOP.
<b>Reward if Helpful</b>