SAP BW学习方法总结

SAP培训：http://www.51sap.cn

目录

目录 .................................................................................................................................................. 1

1. 在源系统中设置BW传输参数。Frequency 一般设置为5-10............................ 3 2. LO LIS的区别 ......................................................................................................... 5 3. LBWE中维护默认的LO数据源 ........................................................................... 6 4. Direct delta / Queued delta / Unserialized V3 update ............................................... 8 5. 主数据DELTA ......................................................................................................... 9 6. Delta Management中的一些定义 ........................................................................... 9 7. 几种更新模式(Update Mode) .................................................................................. 9 8. Delta type ................................................................................................................ 10 9. Update Mode: Repeat .............................................................................................. 10 10. DataSource在R/3和BW中的表 ..................................................................... 11 11. Return Table ........................................................................................................ 11 12. 从CSV文件上传中文 ....................................................................................... 12 13. RSA7 Delta Update 和 Delta Repetition ........................................................... 12 14. Query 跳转时显示如下消息 ............................................................................. 14 15. Query中交通灯仅在合计行显示 ...................................................................... 18 16. 在不同层次的合计行用不同的颜色显示 ......................................................... 19 17. BW中的SD凭证流 .......................................................................................... 23 18. 如何减少维度表的大小 ..................................................................................... 24 19. 删除PSA数据 ................................................................................................... 24 20. RSRV检查 .......................................................................................................... 26 21. 在MultiProvider中，要连接的特性必须是一样的？而不能是参考？......... 26 22. 在SD凭证流Infoset中，如何解决KPI重复计算的问题？ ........................ 26 23. LO中的PP数据源，生产订单需要设置： .................................................... 27 24. LBWQ的数据无法进入RSA7 ......................................................................... 28 25. CELL ................................................................................................................... 29 26. 几个ODS同时激活，需要设置RSODSO_SETTINGS，和RZ10的参数文件. 33 27. 设置RSODSO_SETTINGS，和RZ10的参数文件后仍然不能激活ODS数据，用SM50查看BW处理进程，并保证GBD空闲进程至少三个。................... 35 28. 在query里显示当期日期，可以创建一个公式变量，用客户退出。 .......... 35 29. 无法在formula中使用keyfigure的result ....................................................... 36 30. 对采购收货，会产生2条delta。已收货数量等字段会被更新 .................... 37 31. 对发票出具会计凭证时，能够产生delta ........................................................ 37 32. Exception TYPELOAD_NEW_VERSION ........................................................ 37 33. 为BI CONTENT数据源添加key figure字段时，一般数量、金额字段取反，

SAP培训：http://www.51sap.cn 单价字段不取反。 ......................................................................................................... 37 34. 在角色里隐藏文件夹按钮：设置S_RS_FOLD为X ...................................... 37 35. Update rule激活时报错，Empty or invalid formula......................................... 38 36. Workbook里几个query用到相同的输入条件 ................................................ 38 37. 开发机的query传输到生产机之后，可以在RSA1的传输连接里点“BEX请求”。之后修改query将不在报错 .............................................................................. 38 38. 对导航属性设置权限 ......................................................................................... 38 39. 执行Infopackage用户的权限 ........................................................................... 39 40. 打上“小写字母”，激活有主数据的信息对象时，去掉alpha. .................. 39 41. 系统自动生成的信息包：自建ODS更新到新的ODS时，要复制源数据（以8开头） .......................................................................................................................... 40 42. 修改系统自带提取结构后，提取数据时出错问题处理 ................................. 42 43. 设备运转率报表连接到R/3系统事务代码： ................................................. 45 44. 合并资产负债表，损益表 0ECCS_C01该模型在R/3中4.6版本以后都要求手工生成该数据源3EC_CS_1A ................................................................................... 46 45. 1CL_OEQU001数据源不能取出数据，前台新增特性设置： ...................... 46

SAP培训：http://www.51sap.cn

1. 在源系统中设置BW传输参数。Frequency 一般设置为5-10.

SAP培训：http://www.51sap.cn

SAP培训：http://www.51sap.cn 2. LO LIS的区别

https://www.sdn.sap.com/irj/sdn/thread?messageID=290544#290544

LIS is old technique through which we can load the lo data. Here we use typical delta and full up-loading techniques to get data from an logistics application, it uses V1 and V2 update, it means that it was a synchronous or asynchronous update from the application documents to LIS structures at the time when the application document was posted.

LO Cockpit is new technique i think from bw 3.0 ( i am not sure) which uses V3 which is an update that you can schedule, so it does not update at the time when you process the application documents, but it will be posted at a later stage.

Another big difference between LO and LIS is that,

You have separate datasources for header level, item level and schedule line level available in LO, you can choose at which level you want to extract your data and switch off others, which results in reduced data.

we do not have this flexibility with LIS structures.

LO EXTRACTOR的好处：

__The new LO extractor has the following advantages when compared with the process of extracting data using transfer structures and information structures:

__Improved performance and reduced volumes of data __Simple handling

__Standardized solution for all Logistics applications __No use of LIS functions

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库SAP BW学习方法总结在线全文阅读。