topic Re: ALE tables in Application Development and Automation Discussions

ALE tables

vinothkumar_g — Mon, 04 Dec 2006 14:39:30 GMT

Hi all,

I need to get the data record tables and segement information tables.

Suppose i have the idoc number . In which table Idoc will be stored and all the segment details like material number, unit, price etc.

Kindly mention what are the possible tables in transferring of data thru ale

tables like EDiDD, EDiDC, EDIDs etc.

Regards,

vinoth

Re: ALE tables

Former Member — Mon, 04 Dec 2006 14:40:54 GMT

Goto SE11 transaction.

Give the table name as EDI* and press F4.

Regards,

ravi

Re: ALE tables

Former Member — Mon, 04 Dec 2006 14:42:12 GMT

Hi,

If you know the message type look at the DB table: EDP13, u get the IDoc Type.

Regards,

Goutham.1

Re: ALE tables

Former Member — Mon, 04 Dec 2006 14:43:38 GMT

Control Record - EDIDC

Status Record - EDIDS

Data Record - EDID4.

However, you need to know the segment name to get the data from there

Declare variables of the type of the segment structure

EDID4 will have the segment name and the field called SDATA.

So, depending on the segment name you need dump the data of SDATA field into appropriate structure

When 'E1EDKA1'

wa_structure = sdata.

Now, wa_structure will have all the data of the segment E1EDKA1.

You should do these at the loop of the data records for a given IDOC number.

LOOP AT EDID4.

CASE EDID4-SEGNAM.

 WHEN 'E1EDK1'.
   WA_E1EDK1 =  EDID4-SDATA.

ENDCASE.

ENDLOOP.

regards,

Ravi

Note - Please mark all the helpful answers

Re: ALE tables

Former Member — Mon, 04 Dec 2006 14:45:27 GMT

hi,

edid4 is the table for IDoc Data Records.

try edi* and f4 in se11 for more tables

EDID4 is the table that stores the Data of the IDOC, it will have all the segements data.

if you want the control record then look in EDIDC table.

if you want the status record then it is EDIDS table.

Regards,

Kumar

Re: ALE tables

Former Member — Mon, 04 Dec 2006 14:46:52 GMT

Hello,

EDIDS - status table for IDoc

EDIDC - Control table

EDIDD - Data from this structure can be retrieved via following method (for inbound idoc).

suppose the IDoc data is stored in internal table IDoc_data.

then you can get data from segment like this :

loop at idoc_data.

case IDoc_data-segnam.

when 'E1EDK01'.

*****Following lines transfers data from structure to individual fields of segment.

move idoc_data-sdata to e1edk01.

***use data from e1edk01 structure to further completing transaction.

endcase.

endloop.

Re: ALE tables

Former Member — Mon, 04 Dec 2006 14:51:21 GMT

Hi Vinoth,

You can use FM IDOC_READ_COMPLETELY to get IDoc control, status and segments. Just need to pass the IDoc number as input parameter.

Hope this will help.

Regards,

Ferry Lianto

Please reward points if helpful.

Re: ALE tables

vinothkumar_g — Tue, 05 Dec 2006 03:11:00 GMT

Hi all,

Thanks for your valuable information.

Once the transaction BD10 is executed, i need to display the idoc number as information message.

is it possible to get the idoc number directly, instead of viewing it in we02 tcode.

Regards,

vinoth.