**How to copy Z-Table data from APO to ECC

[Former Member]

Hi Experts,

We want to copy the entire Z-Table data from APO to ECC.

Is there any way so that APO can PUSH or ECC can PULL the Z-Table data.

If the RFC to be used, is there any Function Module/BAPI/BADI which can support this requirement?

Plz share your thoughts on this scenario.

Thanks in advance for looking into this requirement.

Rgds

Jay

[former_member209769 · Accepted solution]

Hi Jay,

There is no standard functional way in which you can copy data from a Z table from APO to R/3. Is this a one time requirment, or regularly you would be doing this kind of copying activity?

If this is a one time activity, you could have following options:

1) If its possible for you to import transport requests (TRs) from APO to R/3, then you can create a TR containing table data in APO, and import this in R/3. This could also help in the future if you need to copy data through TRs.

2) Extract the data from APO to an excel file. Create the table in R/3 with maintenance view, and you can copy-paste the data in R/3 table or import it from excel using simple Function Modules (if volume if really huge).

If you would need to do this activity on a frequent basic, read further. I am not very sure if some SAP standard FM or BAPI already exists to read data from remote database table. May be possible that it exists, but will need to dig for it.

Ask your ABAP team if they are already using some RFC enabled FM in R/3 to read data from a remote table. In that case, they could use the same FM to extract data from APO.

Otherwise also, it would be quite simple for ABAP team to create an RFC enabled FM in R/3, pass the table name (and any other selection criteria as required), and get back the contents of the table from APO to R/3. This could then be populated in a table or used in some other way.

Hope this helps.

Thanks - Pawan

[Former Member · Accepted solution]

Thanks Pawan,

We will be doing this activity (Z-Table data extraction from APO to ECC) daily. Hence, we have to use standard FM or BAPI for the same.

Do you have any idea if this is possible through Standard FM/BAPI? What if there is no standard FM/BAPI for this case? Is it possible then also to extract the Z-Table data from APO to ECC?

Apart, is it possible to extract the Key Figure value from APO & then store those in ECC side Z-Table? If yes, is there any FM/BAPI used for this case?

Thanks for looking into this issue & providing your valuable inputs..

Rgds/

Jay

[Former Member · Accepted solution]

Hi,

Please use FM RFC_READ_TABLE to copy data from APO to R/3.

You can either execute this manually or

you can have a utility program using this FM to pull data periodically from APO to R/3.

Regards,

Ashok

[former_member209769 · Accepted solution]

Hi Jay,

There you go. Ashok already gave the name of the RFC FM that you could use to get data from remote tables.

Key Figures (KFs) in APO are not stored in a database table, rather they are stored in datacache. You could use BAPI_PBSRVAPS_GETDETAIL2 to get the details of the KFs, if really required.

I would not recommend sending the data from APO to R/3 as that will lead to data unneccessarily being stored (redundantly) on R/3 side. Ideal way would be to send relevant transaction data from R/3 to APO, and if someone wants to compare data, do that in APO or otherwise create a BW report for comparison.

Thanks - Pawan