SAP AG的生产计划与控制文档

3 下载量 148 浏览量 更新于2024-06-22 收藏 1.16MB DOC 举报
"Production Planning and Control.doc 是一个文档,可能属于 SAP AG,涉及生产计划与控制的主题。文档可能包含了关于构建模块配置的指南,并且提到了 SAP 的软件产品可能包含其他软件供应商的专有组件。此外,文档还提及了微软(Microsoft)的多个产品,如 Windows、Excel、Word 和 PowerPoint,以及 SQL Server,这些都是 Microsoft Corporation 的注册商标。另外,文档也提到了 IBM 的一系列产品和技术,如 DB2、OS/2、AIX、AS/400、iSeries、pSeries、xSeries、zSeries、z/OS 和相关商标,这些都是 IBM 在美国和其他国家的商标。Oracle 也被提及,它是 Oracle Corporation 的注册商标。" 生产计划与控制是企业管理中的关键环节,它涉及到如何有效地组织和调度企业的生产活动,以满足市场需求,同时优化资源利用,确保质量和成本目标的达成。在这个过程中,企业需要考虑以下几个核心知识点: 1. **需求预测**:通过对历史销售数据的分析,市场趋势的研究以及客户需求的了解,企业预测未来产品的需求量,这是生产计划的基础。 2. **产能规划**:根据预测的需求,企业评估其现有的生产能力,包括设备、人力、物料等资源,以确定是否需要增加或调整产能。 3. **主生产计划**:基于需求预测和可用产能,制定出详细的产品生产计划,明确何时、何地、生产多少产品。 4. **物料需求计划(MRP)**:在主生产计划的基础上,计算出各零部件和原材料的需求量及时间,以便于采购和库存管理。 5. **能力需求计划(CRP)**:分析生产计划对人力、设备等资源的需求,以确保在计划的时间内资源充足。 6. **作业排序和调度**:确定产品的生产顺序,合理安排生产线,减少等待时间和生产中断,提高生产效率。 7. **库存控制**:通过监控库存水平,确保材料的适时供应,防止过度库存和缺货情况的发生。 8. **质量管理**:在生产过程中实施质量检查和控制,确保产品符合预设的质量标准。 9. **绩效衡量**:通过各种指标(如生产率、交货准时率、废品率等)监控和评估生产系统的性能,持续改进。 10. **信息系统支持**:现代企业通常采用ERP(企业资源规划)系统,如 SAP 提到的,来整合这些流程,自动化数据处理,提供决策支持。 SAP AG 的软件产品在生产计划与控制领域扮演着重要角色,它们帮助企业实现上述各个环节的集成和优化,提升整体运营效率。文档中提到的“Building Block Configuration Guide”可能是指如何配置和定制 SAP 系统以适应特定企业的生产计划与控制需求。同时,文档还强调了知识产权的重要性,指出所有内容未经许可不得复制或传播。

请帮我看看这个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 浏览量

为什么下面的sql语句会输出重复的结果:SELECT tp.parent_production_orders AS parent_production_orders, tp.production_orders AS production_orders, tp.work_order AS work_order, tp.contract AS contract, tp.sbbh AS sbbh, tp.batch_num AS batch_num, tp.product_code AS product_code, tp.product_number AS product_number, tp.product_name AS product_name, to_char( middle.create_date, 'yyyy-mm-dd' ) AS issued_date, to_char( to_timestamp( tp.delivery_time / 1000 ), 'yyyy-mm-dd' ) AS delivery_time, middle.line_code AS work_area_code, middle.line_name AS work_area_name, tp.workorder_number AS workorder_number, tp.complete_number AS complete_number, tp.part_unit AS part_unit, middle.work_time_type AS work_time_type, middle.process_time AS process_time, CASE WHEN sc.totalSubmitHours IS NULL THEN 0 ELSE sc.totalSubmitHours END AS submit_work_hours, CASE WHEN middle.process_time > 0 AND sc.totalSubmitHours IS NOT NULL THEN round( ( sc.totalSubmitHours / middle.process_time ), 2 ) * 100 ELSE 0 END plan_achievement_rate, CASE WHEN sc.totalSubmitHours IS NULL THEN 0 ELSE round( CAST ( sc.totalSubmitHours AS NUMERIC ) / CAST ( 60 AS NUMERIC ), 1 ) END AS submit_work_hours_h, round( CAST ( middle.process_time AS NUMERIC ) / CAST ( 60 AS NUMERIC ), 1 ) AS process_time_h, pinfo.material_channel AS material_channel FROM hm_model_work_order_report_middle middle LEFT JOIN hm_model_trc_plan tp ON middle.work_order = tp.work_order LEFT JOIN ( SELECT oro.work_order AS orderNo, oro.work_area_code AS lineCode, SUM ( submit_work_hours ) AS totalSubmitHours, '自制' AS workHourType FROM hm_model_trc_order_report_operation_u orou LEFT JOIN hm_model_trc_order_report_operation oro ON orou.work_order_process_id = oro.ID WHERE orou.work_order_process_id IS NOT NULL AND oro.work_area_code IS NOT NULL GROUP BY oro.work_order, oro.work_area_code UNION all SELECT ohs.work_order_no AS orderNo, ohs.line_code AS lineCode, SUM ( receiving_hour ) AS totalSubmitHours, '外委' AS workHourType FROM hm_model_outsourcing_hour_statistics ohs GROUP BY ohs.work_order_no, ohs.line_code ) sc ON middle.work_order = sc.orderNo AND middle.line_code = sc.lineCode AND middle.work_time_type = sc.workHourType LEFT JOIN hm_model_part_info AS pinfo ON tp.product_number = pinfo.part_code WHERE middle.process_time > 0 AND tp.delivery_time IS NOT NULL AND tp.production_orders LIKE'FJ2023051100286' ORDER BY to_char( to_timestamp( tp.delivery_time / 1000 ), 'yyyy-mm-dd' ) DESC, tp.parent_production_orders DESC, tp.node_level ASC

172 浏览量