PP-RPT-005--生產(chǎn)報(bào)工統(tǒng)計(jì)報(bào)表-FS

1、精選優(yōu)質(zhì)文檔傾情為你奉上精選優(yōu)質(zhì)文檔傾情為你奉上專心專注專業(yè)專心專注專業(yè)精選優(yōu)質(zhì)文檔傾情為你奉上專心專注專業(yè) 報(bào)表設(shè)計(jì)規(guī)格PP_RPT_005 -生產(chǎn)報(bào)工統(tǒng)計(jì)報(bào)表SunSUNTECH SAP Project pPROJECT 版本:VersionRelease Date and TimeBy Remarks1.02006-04-04Bill WangDraft簽名:Reviewed & Approved by Business Dept/Business Process Owner:NameTitleSignatureDate Business Dept/Business Process Ow

2、ner顧嘯林Manager盧守義Manager謝泰宏Manager陸峻峰Engineer章鴻EngineerSunSAP Project熊海波Project Manager肖捷Project ManagerLoytong,ChiaProject Manager王利忠Consultant生產(chǎn)報(bào)工統(tǒng)計(jì)報(bào)表輸入畫面:生產(chǎn)線基本信息序字段說(shuō)明選擇類型字段名稱參考字段名稱資料類型長(zhǎng)度初值必要輸入檢核條件單一區(qū)間復(fù)選框選擇圓點(diǎn)是否物料號(hào)AFPO-MATNR生產(chǎn)工單號(hào)AFKO-AUFNR工廠AFRU-WERKS報(bào)工日期MARA-MTARTMRP 控制者AFKO-DISPO報(bào)表格式工廠生產(chǎn)線物料號(hào)碼物料描述生

3、產(chǎn)訂單號(hào)順序號(hào)順序描述工序號(hào)工序描述工作中心 工序數(shù)量報(bào)工日期 報(bào)工的良品工序總報(bào)工良品用戶ID 報(bào)工的廢品工序總報(bào)工廢品 盈欠數(shù)量單位 機(jī)器折舊 直接人工其它制費(fèi) 功率(W)銷售訂單號(hào)行項(xiàng)目數(shù)量四. 字段描述 Field DescriptionField Name資料類型長(zhǎng)度排序跳頁(yè)鍵值 Calculation備注升序降序加總小計(jì)分組AFRU-AUFNR,生產(chǎn)工單號(hào)AFRU-APLFL,順序號(hào)AFRU-VORNR,工序號(hào)AFRU-WERKS,工廠AFRU-ERSDA,確認(rèn)日期AFRU-LMNGA,確認(rèn)數(shù)量AFRU-ERNAM,確認(rèn)人AFRU-XMNGA,確認(rèn)的廢品AFRU-MEINH,計(jì)量單

4、位AFRU-ISM02,機(jī)器折舊(H)AFRU-ISM03,直接人工(H)AFRU-ISM04,直接動(dòng)力(KWH)AFRU-ISM05,模具費(fèi)用(PC)AFRU-ISM06,其它制費(fèi)-DT(H)AFRU-AUFPL,訂單中工序的工藝路線號(hào)AFRU-APLZL,訂單的通用計(jì)數(shù)器AFKO-PLNBEZ,物料號(hào)AFKO-RSHTY,CIM 資源的對(duì)象類型AFKO-RSHID,資源的對(duì)象 IDAFKO-ARSPS,工單項(xiàng)目編號(hào)AFPO-KDAUF,銷售訂單號(hào)AFPO-KDPOS,銷售訂單行項(xiàng)目號(hào)AFPO-KDEIN,行項(xiàng)目數(shù)量AFVC-LTXA1,工序描述AFVV-MGVRG,工序數(shù)量五. 程序邏輯盈

5、欠數(shù)量 = 工序計(jì)劃完成數(shù)量 - (工序?qū)嶋H已確認(rèn)良品總數(shù)量+工序?qū)嶋H已確認(rèn)廢品總數(shù)量)需要有每日每個(gè)工序確認(rèn)良品數(shù)量，廢品數(shù)量的小計(jì) 參考代碼* ZPPR004* PROGRAM NAME : 生產(chǎn)日?qǐng)?bào)表及生產(chǎn)排工盈欠日?qǐng)?bào)表 * APPLICATION NAME : PP * SUBSYSTEM : PP * AUTHOR : J * TRANSACTION : ZPPR004 * PROGRAM TYPE : Report * SAP RELEASE : 4.7C *PROGRAM DESCRIPTION : 生產(chǎn)日?qǐng)?bào)表及生產(chǎn)排工盈欠日?qǐng)?bào)表 * REVISION LOG * LOG# DA

6、TE AUTHOR DESCRIPTION * * 0000 03/04/2005 James Yang 生產(chǎn)日?qǐng)?bào)表及生產(chǎn)排工盈欠日?qǐng)?bào)表 *REPORT ZPPR004 NO STANDARD PAGE HEADING MESSAGE-ID ZWL LINE-COUNT 90 LINE-SIZE 355.*&*& TABLES:*&*TABLES:AFRU,AFKO,AFPO,AFVC,AFVV,MAKT.*&*& PROGRAM VARIABLES*&*DATA:*&* data declaration*&*DATA:BEGIN OF ITAB OCCURS 0, AUFNR LIKE AF

7、RU-AUFNR, 生產(chǎn)工單號(hào) APLFL LIKE AFRU-APLFL, 順序號(hào) VORNR LIKE AFRU-VORNR, 工序號(hào) WERKS LIKE AFRU-WERKS, 工廠 ERSDA LIKE AFRU-ERSDA, 確認(rèn)日期 LMNGA LIKE AFRU-LMNGA, 確認(rèn)數(shù)量 ERNAM LIKE AFRU-ERNAM, 確認(rèn)人 XMNGA LIKE AFRU-XMNGA, 確認(rèn)的廢品 MEINH LIKE AFRU-MEINH, 計(jì)量單位 ISM02 LIKE AFRU-ISM02, 機(jī)器折舊(H) ISM03 LIKE AFRU-ISM03, 直接人工(H) IS

8、M04 LIKE AFRU-ISM04, 直接動(dòng)力(KWH) ISM05 LIKE AFRU-ISM05, 模具費(fèi)用(PC) ISM06 LIKE AFRU-ISM06, 其它制費(fèi)-DT(H) AUFPL LIKE AFRU-AUFPL, 訂單中工序的工藝路線號(hào) APLZL LIKE AFRU-APLZL, 訂單的通用計(jì)數(shù)器 PLNBEZ LIKE AFKO-PLNBEZ, 物料號(hào) RSHTY LIKE AFKO-RSHTY, CIM 資源的對(duì)象類型 RSHID LIKE AFKO-RSHID, 資源的對(duì)象 ID ARSPS LIKE AFKO-ARSPS, 工單項(xiàng)目編號(hào) KDAUF LIKE

9、 AFPO-KDAUF, 銷售訂單號(hào) KDPOS LIKE AFPO-KDPOS, 銷售訂單行項(xiàng)目號(hào) KDEIN LIKE AFPO-KDEIN, 行項(xiàng)目數(shù)量 LTXA1 LIKE AFVC-LTXA1, 工序描述 MGVRG LIKE AFVV-MGVRG, 工序數(shù)量 LMNGA1 LIKE AFVV-LMNGA, 工序總確認(rèn)數(shù)量 XMNGA1 LIKE AFVV-XMNGA, 工序總確認(rèn)廢品 YQSL LIKE AFVV-MGVRG, 盈欠數(shù)量 ARBPL LIKE CRHD-ARBPL, 工作中心 MAKTX LIKE MAKT-MAKTX, 物料描述* STOKZ LIKE AFRU-

10、STOKZ, add 3.18.2005 被沖銷憑證的標(biāo)識(shí) STZHL LIKE AFRU-STZHL, 沖銷 END OF ITAB.*&*& SELECT-OPTIONS*&*SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.* PARAMETERS:SELECT-OPTIONS:S_PLNBEZ FOR AFKO-PLNBEZ, S_AUFNR FOR AFRU-AUFNR, S_WERKS FOR AFRU-WERKS, S_ERSDA FOR AFRU-ERSDA OBLIGATORY, S_DISPO FOR

11、AFKO-DISPO.SELECTION-SCREEN END OF BLOCK B1.* INITIALIZATION*INITIALIZATION.* PERFORM INITIALIZATION.* top-of*TOP-OF.* PERFORM WRITE_TITLE.* PERFORM WRITE_PAGE.* End-of*END-OF.*START-OF-SELECTION*START-OF-SELECTION. PERFORM MAIN.*&*& Form MAIN*&* text* - p1 text* p1 text* p1 text* p1 text* p1 text*

12、p1 text* - p2 text*FORM WRITE_DATA_ALV . DATA:LIN TYPE I. DESCRIBE TABLE ITAB LINES LIN. IF LIN = 0. MESSAGE S000. EXIT. ENDIF. TYPE-POOLS: SLIS,KKBLO. DATA: ET_FIELDCAT TYPE KKBLO_T_FIELDCAT. DATA: CS_KKBLO_LAYOUT TYPE KKBLO_LAYOUT. DATA: FIELDCAT TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE, FIELDCAT

13、_LN LIKE LINE OF FIELDCAT, SORTCAT TYPE SLIS_T_SORTINFO_ALV WITH HEADER LINE, SORTCAT_LN LIKE LINE OF SORTCAT, EVENTCAT TYPE SLIS_T_EVENT, EVENTCAT_LN LIKE LINE OF EVENTCAT. DATA: GT_LIST_TOP_OF_PAGE TYPE SLIS_T_LISTHEADER. DATA: GC_FORMNAME_TOP_OF_PAGE TYPE SLIS_FORMNAME VALUE ALV_TOP_OF_PAGE. DATA

14、 : PS_LAYOUT TYPE SLIS_LAYOUT_ALV. DATA: NN TYPE I, TITLE TYPE LVC_TITLE, LEN TYPE I. DEFINE HOUT1. NN = NN + 1. FIELDCAT-TABNAME = ITAB. FIELDCAT-FIELDNAME = &1. FIELDCAT-SELTEXT_M = &2. FIELDCAT-COL_POS = NN. FIELDCAT-OUTPUTLEN = &3. FIELDCAT-DATATYPE = &4.* FIELDCAT-DO_SUM = &5. FIELDCAT-LZERO =

15、X. APPEND FIELDCAT. CLEAR FIELDCAT. END-OF-DEFINITION. MOVE 生產(chǎn)日?qǐng)?bào)表及生產(chǎn)排工盈欠日?qǐng)?bào)表 TO TITLE. PS_LAYOUT-ZEBRA = X. 顏色交替 PS_LAYOUT-COLWIDTH_OPTIMIZE = X. 寬度自動(dòng)調(diào)整 HOUT1 WERKS 工廠 4 CHAR . HOUT1 PLNBEZ 物料號(hào)碼 18 CHAR . HOUT1 MAKTX 物料描述 40 CHAR . HOUT1 AUFNR 生產(chǎn)工單號(hào) 12 CHAR . HOUT1 KDAUF 銷售訂單號(hào) 10 CHAR . HOUT1 KDPOS 行

16、項(xiàng)目 6 CHAR . HOUT1 KDEIN 數(shù)量 4 CHAR . HOUT1 APLFL 順序號(hào) 6 CHAR . HOUT1 VORNR 工序號(hào) 6 CHAR . HOUT1 LTXA1 工序描述 40 CHAR . HOUT1 ARBPL 工作中心 8 CHAR . HOUT1 MGVRG 工序數(shù)量 13 QUAN . HOUT1 ERSDA 確認(rèn)日期 8 DATS . HOUT1 LMNGA 確認(rèn)的良品 13 QUAN . HOUT1 LMNGA1 工序總確認(rèn)良品 13 QUAN . HOUT1 ERNAM 確認(rèn)人 12 CHAR . HOUT1 XMNGA 確認(rèn)的廢品 13 QUAN . HOUT1 XMNGA1 工序總確認(rèn)廢品 13 QUAN . HOUT1 YQSL 盈欠數(shù)量 13 QUAN . HOUT1 MEINH 單位 4 CHAR . HOUT1 ISM02 機(jī)器折舊(H) 13 QUAN . HOUT1 ISM03 直接人工(H) 13 QUAN . HOUT1 ISM04 直接動(dòng)力(KWH) 13 QUAN . HOUT1 ISM05 模具費(fèi)用(PC) 13 QUAN . HOUT1 ISM06 其它制費(fèi)-DT(H) 13 QU