Retraction of data from BPC 11 to S4

[Former Member]

I have a requirement to retract planned data from BPC 11 to S4 hana. These planned data have to be moved from BPC to WBS planned data. Would like to know what is the process to retract data.

Should the data from BPC be pushed to BW datasource and then from the datasource can we directly update in S4, using standard BAPI's or should we create a separate staging table in S/4 to store the data and then call a BAPI to read data from S4 staging table.

[Former Member]

There is an API available to update ACDOCP from BPC11.

That may be the preferred solution to update S4.

[former_member687971]

Can you please suggest which API should be used ?

[jfigueiredo]

Hi,

not sure if that is the best practice, but I did use a BADI retraction to update the data from BPC and store it into a custom Z table in BW. Then the table is used as an export datasource into S4.

Regards,

José F.

[former_member601686]

Hi Jose,

How would you use this export datasource to update a table into S4 (eg ACDOCP)? Isn't there other way via a function module or something like that?

Alternatively , you can use a dataflow from BPC 11.1 (can be automated via process chain) generating a CSV file using OpenHub(bundled with BW/4HANA licenses) and use the S/4 standard Fiori app, "Import Financial Plan Data" to get the data to the relevant table. But that would involve a last manual step.

[damovand]

Hello,

I recommend posting the part for S/4HANA in SAP answers for S/4HANAas they have expertise in that area. Basically, as you may have expected, there are two parts to this task how you can get BPC data out of BPC and then how to store that data in S4HANA tables. I think the second part will determine which BW artefacts, e.g. DSO or ADSO, you should use in between BPC and S4HANA. I think this part can best be answered by S4HANA or BW4HANA experts.

Best Regards,

Leila L.

[damovand]

Hello,

Retracting data from BPC to ECC is common practice. I am not sure S4HANA since BW artefacts are retrieving live data via HANA views. I can tell you about ECC, hopefully that is helpful.

If you were working with ECC then the method would depend on BPC mode, standard vs. embedded. BPC standard provides a BPC data manager package (DMP) for retraction from BPC to a BW data source and from there to tables in ECC. I am assuming that the same type of process exists for S4HANA, but I am not sure.

Hopefully, this information helps even though it is for ECC.

Regards,

Leila Lappin

[Former Member]

Thanks for your reply. With reference to your statement "from BW data source to tables in ECC", I require more clarity. In my case, I want to use the data from BW data source to update standard transaction data in S4. Example, update the planned values for WBS in s4 using BW data source data. Can I use a BAPI, to read data from BW to S/4 or should I store the data from BW data source to a custom table in S4 and then use a BAPI to update transactional data in S4 using this custom table. What is the best practice in this case.

Regards,

Thomas