SAP SCM 81培训材料:Billing课程介绍与版权声明

需积分: 50 2 下载量 38 浏览量 更新于2024-07-16 收藏 10.78MB PDF 举报
SCM615 EN Col81 FV Part A4.pdf 是一份由SAP提供的培训材料,它专注于SAP Supply Chain Management (SCM) 的课程内容。该文档适用于2天的学习课程,课程版本为81,材料编号为50087120。这份资料旨在帮助学习者提升在SCM领域的专业技能,并可在工作中作为参考。 课程内容涵盖了SAP SCM的核心模块,如计费(Billing),这可能包括对SAP系统中的费用计算、发票处理和支付管理的深入理解。学习者可以期待通过这次培训,掌握如何有效地运用SAP解决方案来优化供应链流程,提高效率和降低成本。 培训中心和教育网站提供了详细的课程大纲、讲师名单以及参与手册,确保了教学的专业性和连贯性。版权信息表明,所有内容受2007年SAP AG的版权保护,未经许可,禁止任何形式的复制或传播,且SAP保留随时更新信息的权利。 值得注意的是,文档中提到的一些软件产品是由SAP AG及其分销商提供的,它们包含了其他软件供应商的专有组件。例如,提到了微软的Windows、Excel、Word、PowerPoint和Oracle的注册商标,以及IBM的DB2、AIX等产品,这些都是行业内的知名技术和平台。此外,文档还提及了Informix和UNIX等技术的商标。 课程参与者应遵守版权法规,尊重知识产权,并意识到在学习过程中可能会接触到不同厂商的专有技术。这份材料是SAP SCM专业认证培训的重要参考资料,对于希望在SCM领域发展或深化业务流程管理技能的人来说,是一份不可多得的学习资源。

请帮我看看这个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;

166 浏览量