Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

ALE tables

vinothkumar_g
Product and Topic Expert
Product and Topic Expert
0 Likes
2,128

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,386

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

7 REPLIES 7
Read only

Former Member
0 Likes
1,386

Goto SE11 transaction.

Give the table name as EDI* and press F4.

Regards,

ravi

Read only

Former Member
0 Likes
1,386

Hi,

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

Regards,

Goutham.1

Read only

Former Member
0 Likes
1,387

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

Read only

Former Member
0 Likes
1,386

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

Read only

Former Member
0 Likes
1,386

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.

Read only

Former Member
0 Likes
1,386

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.

Read only

vinothkumar_g
Product and Topic Expert
Product and Topic Expert
0 Likes
1,386

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.