关于SAP APO的ClientCopy
环境:S4 HANA 1709
目标:从生产环境复制client业务数据到测试系统,从而使测试系统拥有生产环境的业务数据。
Environment: S4 HANA 1709
Goal: Copy client business data from the production environment to the test system so that the test system owns the business data of the production environment.
2022年2月春节前,我们开始了上述目的的client copy, 很不顺利,每次client copy 把9万张表数据拷贝完成后,无法启动“后处理”模式,导致APO模块中的数据没有加载到LiveCache中去。
Before the Spring Festival in February 2022, we started client copy for the above purpose, but it was not successful. After copying 90,000 table data from client copy each time, the "post-processing" mode could not be started, resulting in the data in APO module not being loaded into LiveCache.
表现上看,/SAPAPO/SEQ1 中看不到生产订单。从春节前到节后,我们一共尝试了差不多10次拷贝,均告失败。我们也发了incident给SAP,每次白天我们提交情况,SAP德国的顾问晚上回复(时差),问题从服务转到BASIS转到APO开发部门,但均得不到有效的解决。这个问题一直困扰了我们3周时间,这期间测试环境不能做功能的测试,要知道开发和测试系统虽然没有生产环境的安全等级高,但其实也是SAP一套系统中不可损失的部分,如果缺失,生产的更新和变更也会缺失,可以算为一个不大不小的事故了。
Performance-wise, there is no production order in /SAPAPO/SEQ1. We tried about 10 copies before and after the Spring Festival, but failed. We also sent incident to SAP. Every time we submitted the information during the day, SAP's Consultant in Germany replied at night (time difference), and the problem was transferred from service to BASIS to APO development department, but no effective solution was found. This problem has plagued us three weeks, during which the testing environment can't do function test, want to know the development and test system although do not have the security level of production is high, but it is also the SAP is the loss of part of a system, if the lack of updates and changes will also be missing, can be regarded as a small accident.
祸不单行,因为时间拖了很久,超出了NBU数据库备份的备份周期,我们无法将测试系统回退到问题发生前。
这个问题,也是我遇到的一个新问题了,说起client copy,我的经验其实比较丰富(网上一半的说明都是转载我在2001年项目的client copy说明,“重庆”),APO的LiveCache是个很小众的东西,我们都没有做过类似的事情,去年宝能项目环境一致,但也只是拷贝了配置数据,没有涉及到LC的业务数据这块。不过这次我的血压正常,因为我有降压药,还因为我不是BASIS,我只是ABAP......
It never rains but it rains. Because of the time delay, beyond the NBU database backup cycle, we were unable to roll back the test system to the time before the problem occurred.
This problem is also a new one I have encountered. Speaking of client copy, I have rich experience in fact (half of the descriptions on the Internet are reprinted from the client copy description of my project in 2001, "Chongqing"). APO LiveCache is a very popular thing, and we have never done similar things. Last year, baoneng project had the same environment, but only copied the configuration data, without involving the business data of LC. But this time my blood pressure was normal because I had blood pressure medication and because I wasn't BASIS, I was just ABAP......
问题的解决:
我们一直在纠结用SCC7、8、9拷贝全部的client数据,流程不完整就试图让拷贝流程完整,但其实拷贝分为2个阶段,一个是1709版本9万张表数据的拷贝,一个是完成后的4000个表的数据后处理。SCC程序拷贝总会停在第二个阶段:
我们把情况告诉了业务顾问黄丽君老师,她说我们自己建生产订单试试呢!果然,我们自己建的生产订单是正常在LiveCache中使用的,这个样子,其实测试环境已经可以正常使用除生产订单外的全部业务数据(因为9万张表已经拷贝完成了),然后再自己创建一些生产订单出来,我们就达成了包含APO模块的ClientCopy的目的。
Problem solving:
We have been struggling to copy all client data with SCC7, 8 and 9. If the process is not complete, we will try to make the copy process complete. However, in fact, the copy is divided into two stages, one is the copy of the data of 90,000 tables in version 1709, and the other is the post-processing of the data of 4,000 tables after completion. SCC program copy always stops at the second stage:
We told our business consultant, Miss Huang Lijun, and she said let's try to build our own production order! Sure enough, the production order we created was normally used in LiveCache. In fact, the test environment can normally use all the business data except the production order (because 90,000 tables have been copied), and then create some production orders by ourselves. We have achieved our goal of including the ClientCopy of the APO module.
-------2022.4.8--这周我们彻底解决了SAP APO client copy的问题-----------
关于成功完成APO clientcopy的总结如下:
1、用SCC7,8,9来按常规方式拷贝CLIENT,拷贝中 S4 hana 1709 版本会自己排除到7张表,不用去纠结这/SAPAPO/ORDKEY这7张表,这是系统功能自动排除的。
2、常规9万张表拷贝完成后,需要后处理程序/SAPAPO/OM_CLNT_COPY_UPLOAD把S4中的数据导入LC中,如果程序停在这里,需要使用/SAPAPO/OM17修正基础数据后再执行程序。
3、上面两步做完,可能APO PPC报工相关的表中任然没有数据,还需要检查事件的后台作业是否启动,因为APO的报工是走的事件功能,详细说明见SAP ABAP APO PPDS 计划(生产)订单报工事件_james-lx的博客-CSDN博客
————————————————
版权声明:本文为CSDN博主「刘欣的博客」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/ot512csdn/article/details/123607608