SAP SD PA教程:SCM605 73课程详解

需积分: 16 12 下载量 16 浏览量 更新于2024-07-27 1 收藏 7.75MB PDF 举报
本资源为SAP SD(SAP Supply Chain Management)的PA(Process Automation)教程,适用于mySAP供应链管理系统的学习者。课程名为"SCM605",针对的是第73版,强调了5天的专业培训,旨在提升用户在实际工作中对SAP系统的理解和应用能力。 课程内容涵盖了SAP教材,这些教材在学习过程中是核心参考材料,工作时同样具备实用性。版权方面,该教程版权属于SAP AG,所有权利受到保护。未经SAP AG的明确许可,不得复制或传播文档的任何部分,也不得进行出租、转让或出售。任何更改需得到官方通知。 值得注意的是,SAP SD教程中可能涉及到了多个知名软件公司如Microsoft、IBM、Oracle、Informix等的商标,如Windows、Excel、DB2、Oracle等,这些都是各公司的注册商标。此外,还有其他技术标准和产品的商标,如Citrix、HTML、JAVA、JAVASCRIPT等,体现了课程内容的全面性和专业性。 该教程还可能涉及到SAP的一些标志性产品和服务,如R/2、RIVA、R/3、SAP Business Workflow、WebFlow等,这些都是SAP在供应链管理领域的关键组成部分,有助于提升用户的业务流程管理和优化技能。 学员手册作为教学辅助工具,提供详细的操作指南和理论实践相结合的学习路径。课程设计注重实用性和针对性,确保学员能够掌握并应用于实际工作场景。整体而言,这是一份深入且权威的SAP SD培训材料,对于希望在供应链管理领域深化理解或提升技能的专业人士具有很高的价值。

请帮我看看这个sql语句是否正确,并改正:select a.ebeln, a.ebelp, a.art, a.kdauf, a.zbw, a.size1, a.txz01, a.menge, b.quantity, (a.menge - b.quantity) as OWE_MATERIAL, ( select sum(THIS_PLAN_QTY) as HAVE_PLAN , a.ebeln , a.ebelp , a.kdauf from SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c , SCM_PROCESS_PURCHASE_ORDER_D a group by c.order_no , c.order_seq , c.sales_order , a.ebeln , a.ebelp , a.kdauf having c.order_no = a.ebeln And c.order_seq = a.ebelp And c.sales_order = a.kdauf ) , ( select a.menge - t.HAVE_PLAN as OWN_PLAY from (select sum(THIS_PLAN_QTY) as HAVE_PLAN , c.order_no , c.order_seq , c.sales_order from SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c , SCM_PROCESS_PURCHASE_ORDER_D a group by c.order_no , c.order_seq , c.sales_order , a.ebeln , a.ebelp , a.kdauf having c.order_no = a.ebeln And c.order_seq = a.ebelp And c.sales_order = a.kdauf ) t , SCM_PROCESS_PURCHASE_ORDER_D a where a.ebeln = t.order_no and a.ebelp = t.order_seq and a.menge = t.sales_order ) , d.scan_qty, (d.quantity - d.scan_qty) as OWN_PRODUCE, e.scan_qty, (e.quantity - e.scan_qty) as OWE_SHIP from SCM_PROCESS_PURCHASE_ORDER_D a left join MMS_INOUT_BILL_M b On a.ebeln = b.purchase_order_number And a.ebelp = b.purchase_order_seq And a.kdauf = b.sales_order left join SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c on a.ebeln = c.order_no And a.ebelp = c.order_seq And a.kdauf = c.sales_order left join SCM_PROCESS_OUTPUT d on a.ebeln = d.order_no And a.ebelp = d.order_seq And a.kdauf = d.sales_order left join SCM_OUTSOURCE_SHIP e on a.ebeln = e.qr_code and a.ebelp = e.order_no and a.kdauf = e.order_seq where a.art = 'IE7181' Order by a.ebeln desc, a.ebelp;

157 浏览量