Move master data using ALE

[Former Member]

Hi Experts,

I am totally new to ALE. My requirement is to move master data from our production environment to our training environment using setup ALE

The master data are of :- Functional locations, work centers, equipment and bill of materials.

I am reading certain posts but dont know how to start.

Please suggest.

Thanks in advance.

Regards,

Priti.

[Former Member]

Hi,

To distribute the data between two systems is:

1)Create Logical systems(BD54)

2) Assign logical systems to clients(SCC4)

3) Create RFC destination (SM59)

4) Create Port(we21)

5) Create Partner profile(we20)

7) Distibuton model( BD64)

Please Check the below link, It shows a step by step approach to distribute data through Ale Idocs

https://www.sdn.sap.com/irj/scn/wiki?path=/display/abap/ale%252bidocs

http://help.sap.com/saphelp_nw04/helpdata/en/0b/2a666e507d11d18ee90000e8366fc2/frameset.htm

Regards,

Raj.

[Former Member]

Please can u tell me the Message type, Idoc type, Process code for these four : Functional locations, work centers, equipment and bill of materials.

And what the the tcode to execute them. Like for material master data we have BD10.

Also please tell me the tcode how to find out an idoc type. And then if i know the idoc type, how to find its corresponding message type and vice versa.

thanks in advance

Regards,

Priti.

[Former Member]

Use the transaction code WEDI for getting area menu of IDOC related Transaction Codes.

Regards

Vinod

[Former Member]

Can u tell me the Message type, Idoc type, Process code for these four : Functional locations, work centers, equipment and bill of materials.

I am not able to find it.

[Former Member]

Following are the idoc types

functional location : FUNC_LOC_CREATE01/ CHANGE01

work center : WORKC4

equipment : EQUIPMENT_CREATE01/CHANGE01

Bill of Material : BOMMAT01/02

Check the table EDIMSG (transaction code WE82) for IDOC type / Message type combination

Check the table TMSG1 (Transactioncode :WE41 - Outbound Process code) for Message type / Process code combination.

Regards

Vinod

[Former Member]

Hi Vinod,

Thanks a lot.

For workcenter i found message type as :

PPCC2RECWORKCENTER

and doc type as PPCC2RECWORKCENTER01

is it correct?

Aslso please tell me the tcode or program name i will need to use to transfer data.

Like for master data we have BD10.

Please suggest.

Thanks in adv.

[Former Member]

Yes, it is correct.

To find the transaction codes for ALE Data distribution follow the menu path in SAP Menu

SAP Menu -> Tools -> ALE -> Master Data Distribution
SAP Menu -> Tools -> ALE -> Distribution in Applications

Regards

Vinod

[Former Member]

thanks a lot Vinod.

I tried searching through the same path, found tcode for BOM but not for the remaining three. Nor could I find any related program for that.

So do i need to create a 'Z' program for that ?

If yes then how do i create it since a realy have no idea about it. Do u hav any sample program ?

Please do tell me ASAP.

Thanks in adv.

[Former Member]

If the standard program is not available, then you can create z program which uses the function module "MASTER_IDOC_DISTRIBUTE". Read function module documentation for further details.

Regards

Vinod

[Former Member]

Hi.

How to proceed with the Z program coding if we have the IDOC and SEGMENT information. How do i fill the S-Data structure.

In my case, I am creating a stand alone report for each : Func locn, Equipment, Work Center.

So then in the program, how do i fetch data?

Thanks in advance

[Former Member]

Refer to sample code. You have to fetch the data from corresponding tables and fill in the internal table.

data : control_dat like edidc.

data : int_edidd like edidd occurs 0 with header line,
       int_edidc like edidc occurs 0 with header line.

control_dat-mestyp = '<message type>'.
  control_dat-idoctp = '<idoc_type>'.
  control_dat-rcvprt = '<Port Type>'.
  control_dat-rcvprn = '<port_name>'.

loop at <final internal table> into <workarea>
int_edidd-segnam = '<segment name>'.
int_edidd-sdata = <work area>.
append int_edidd.
endloop.

call function 'MASTER_IDOC_DISTRIBUTE'
    exporting
      master_idoc_control                  = control_dat
    tables
      communication_idoc_control           = int_edidc
      master_idoc_data                     = int_edidd
   exceptions
     error_in_idoc_control                = 1
     error_writing_idoc_status            = 2
     error_in_idoc_data                   = 3
     sending_logical_system_unknown       = 4
     others                               = 5.

Regards

Vinod

[Former Member]

Thanks a lot Vinod.

But how to find the tables for them? ( for equipment, work center and Functional Location ) .

I know that i will need to write a select query. But dont know the table names.

Please tell me the corresponding tables for each of them.

Edited by: priti suryawanshi on Apr 23, 2010 11:30 AM

[Former Member]

Ask the functional consultant to get the table names. Alternatively you can check the table names in DD02L / DD02T tables

Regards

Vinod