(未转)采购订单采购申请报表.doc

(未转)采购订单采购申请报表 * REPORT ZTMM_RP0001 * Report Name: 未转采购订单的采购申请 * Report Description: MM-16 未转采购订单的采购申请 * T-Code: ZMM001 *---------------------------------------------------------------------* * Created By: TTC Created On: 2012-08-01 * Updated By: TTC Updated On: 2012-08-01 *---------------------------------------------------------------------* REPORT ztmm_rp001. *J_3ABDBS J_3ADBBA MRP状态 MTS表示是无销售单的采购申请 MTO表示是有销售单的采购申请 TABLES:eban,ebkn,vbak,vbap,kna1,mara,vbep,cawnt,j_3apgtx,eket,j_3abssi,ekpo,eina,j_3adbba. DATA: g_banfn TYPE char10. DATA: g_bnfpo TYPE num5. DATA: i_row TYPE i. DATA: BEGIN OF w_output OCCURS 0 ,werks LIKE eban-werks 工厂 ,banfn LIKE j_3abssi-j_3absnr 采购申请(12) ,bnfpo LIKE j_3abssi-j_3ahbsp 采购申请项目(6) ,frgkz LIKE eban-frgkz 审批状态 ,badat LIKE eban-badat PR创建日期 ,vbeln LIKE j_3abssi-j_3auanr 销售订单 ,vbelp LIKE j_3abssi-j_3aupos 销售订单项目 ,matnr LIKE eban-matnr 物料号 ,txz01 LIKE eban-txz01 物料描述 ,cpwlh LIKE vbap-matnr 成品物料号 ,kunnr LIKE vbak-kunnr 客户编号 ,name1 LIKE kna1-name1 客户名称 ,matkl LIKE mara-matkl 物料组 ,mtart LIKE mara-mtart 物料类型 ,ekgrp LIKE eban-ekgrp 采购组 ,ebakz LIKE eban-ebakz 结算标识 ,meins LIKE ekpo-meins 订单单位 ,loekz LIKE eban-loekz 删除标识 ,j_3apgnr LIKE eban-j_3apgnr 网格编号 ,END OF w_output. DATA:w_output_header LIKE w_output OCCURS 0 WITH HEADER LINE . DATA: BEGIN OF w_j_3abssi OCCURS 0 ,werks LIKE j_3abssi-werks 工厂 ,j_3auanr LIKE j_3abssi-j_3auanr销售订单 ,j_3aupos LIKE j_3abssi-j_3aupos销售订单项目 ,j_3absnr LIKE eban-banfn 采购申请 ,j_3ahbsp LIKE eban-bnfpo 采购申请项目 ,matnr LIKE j_3abssi-matnr 物料号码 ,j_3asize LIKE j_3abssi-j_3asize网格值 ,menge LIKE j_3abssi-menge 采购申请数量 ,j_3atmpm LIKE j_3abssi-j_3atmpm未清数量 ,frgkz LIKE eban-frgkz 审批标识 ,txz01 LIKE