聯(lián)芯科技ERP項(xiàng)目-技術(shù)文檔-PP-010-委外生產(chǎn)任務(wù)情況報(bào)表-20090908

DATE\@"yyyy-MM-dd"2009-09-22Version1.0PAGE1聯(lián)芯科技ERP項(xiàng)目 DATE\@"M/d/yyyy"9/22/2009Version1.0 聯(lián)芯科技ERP項(xiàng)目開發(fā)規(guī)格書第I部分:需求模塊MACROBUTTONCheckIt_CheckBox￡MM ■PP MACROBUTTONCheckIt_CheckBox￡SD MACROBUTTONCheckIt_CheckBox￡FI MACROBUTTONCheckIt_CheckBox￡CO MACROBUTTONCheckIt_CheckBox￡IP/FMMACROBUTTONCheckIt_CheckBox￡其它Spec編號(hào)ZLC_PP_013短描述委外生產(chǎn)任務(wù)情況報(bào)表類型MACROBUTTONUnCheckIt_Radiobutton報(bào)表●ABAPProgramMACROBUTTONCheckIt_RadiobuttonInformationSystemMACROBUTTONCheckIt_RadiobuttonReportPrinter MACROBUTTONCheckIt_RadiobuttonReportWriterMACROBUTTONCheckIt_RadiobuttonSAPQueryMACROBUTTONCheckIt_RadiobuttonBWreportMACROBUTTONCheckIt_RadiobuttonCrystalReportsMACROBUTTONCheckIt_RadiobuttonOthersMACROBUTTONCheckIt_Radiobutton表單MACROBUTTONCheckIt_Radiobutton流程增強(qiáng)MACROBUTTONCheckIt_RadiobuttonUserExitMACROBUTTONCheckIt_RadiobuttonBADIMACROBUTTONCheckIt_RadiobuttonDialogProgram MACROBUTTONCheckIt_RadiobuttonOtherseMACROBUTTONCheckIt_Radiobutton接口MACROBUTTONCheckIt_RadiobuttonBAPIMACROBUTTONCheckIt_RadiobuttonIDOCMACROBUTTONCheckIt_RadiobuttonALEMACROBUTTONCheckIt_RadiobuttonOthersendMACROBUTTONCheckIt_Radiobutton數(shù)據(jù)轉(zhuǎn)移需求優(yōu)先級(jí)MACROBUTTONCheckIt_RadiobuttonHigh/關(guān)鍵 MACROBUTTONUnCheckIt_RadiobuttonMid/推薦 MACROBUTTONCheckIt_RadiobuttonLow/可選用戶MACROBUTTONNextCell王董豹要求日期集成測(cè)試時(shí)使用預(yù)計(jì)開發(fā)天數(shù)_4__天是否有標(biāo)準(zhǔn)功能MACROBUTTONCheckIt_RadiobuttonYes MACROBUTTONUnCheckIt_RadiobuttonNo標(biāo)準(zhǔn)功能未采用的原因:MACROBUTTONCheckIt_RadiobuttonPerformanceMACROBUTTONCheckIt_RadiobuttonComplexityMACROBUTTONCheckIt_RadiobuttonOtherse參考的標(biāo)準(zhǔn)功能文檔變更歷史版本號(hào)文檔維護(hù)時(shí)間姓名簡(jiǎn)要的描述V1.02009-0朱輝明V1.12009-07-02王董豹將數(shù)量改為計(jì)劃數(shù)量，增加在產(chǎn)數(shù)量、成品率字段20090908徐世兵增加技術(shù)說明文檔

第II部分:詳細(xì)功能描述目的：跟蹤檢查委外生產(chǎn)任務(wù)的執(zhí)行情況功能描述:查詢系統(tǒng)內(nèi)的委外生產(chǎn)任務(wù)的計(jì)劃情況以及實(shí)際執(zhí)行情況。計(jì)劃數(shù)量、BOM版本、軟件版本、實(shí)際入庫的數(shù)量與實(shí)際入庫的日期。運(yùn)行頻率MACROBUTTONUnCheckIt_Radiobutton任何時(shí)間MACROBUTTONCheckIt_Radiobutton每天MACROBUTTONCheckIt_Radiobutton每周MACROBUTTONCheckIt_Radiobutton兩周MACROBUTTONCheckIt_Radiobutton每月MACROBUTTONCheckIt_Radiobutton每年MACROBUTTONCheckIt_Radiobutton其它：運(yùn)行方式MACROBUTTONUnCheckIt_Radiobutton手工MACROBUTTONCheckIt_Radiobutton自動(dòng)MACROBUTTONCheckIt_Radiobutton批處理MACROBUTTONCheckIt_Radiobutton在線處理輸出方式MACROBUTTONCheckIt_Radiobutton屏幕輸出MACROBUTTONCheckIt_Radiobutton打印MACROBUTTONUnCheckIt_Radiobutton文件輸出MACROBUTTONCheckIt_Radiobutton其它：打印機(jī)類型(如無特殊需求，預(yù)設(shè)為激光打印機(jī))紙張大小(如無特殊需求，預(yù)設(shè)為A4橫印)語言(如無特殊需求，預(yù)設(shè)為中文)選擇屏幕： 工廠：FromXXXXXXTOXXXXXX(1)產(chǎn)品編號(hào)：FromXXXXXXTOXXXXXX（2）MRP控制者：FromXXXXXXTOXXXXXX（2）委外PR單號(hào)：FromXXXXXXTOXXXXXX(3)委外PO單號(hào)：FromXXXXXXTOXXXXXX(4)PO建立日期：FromXXXXXXTOXXXXXX(5)計(jì)劃交貨日期：FromXXXXXXTOXXXXXX(6)實(shí)際交貨日期：FromXXXXXXTOXXXXXX(6)采購(gòu)申請(qǐng)類型：可選：順序字段名稱字段技術(shù)名稱字段描述特殊需求1工廠EKPO-WERKS工廠2產(chǎn)品編號(hào)EKPO-MATNR3MRP控制者M(jìn)ARC-DISPO4委外PR單號(hào)EKPO-BANFN委外采購(gòu)申請(qǐng)單號(hào)5委外PO

單號(hào)EKPO-EBELN委外采購(gòu)單號(hào)6PO建立日期EKKO-AEDAT7計(jì)劃交貨日期EKET-EINDT8實(shí)際交貨日期MKPF-BUDAT9BSARTEBAN-BSART采購(gòu)申請(qǐng)類型報(bào)表/表單的字段功能顧問（必填）列出報(bào)表或自定義打印程序上選擇屏幕上的字段顯示名稱(在屏幕或單據(jù)上的名稱)技術(shù)名稱（字段的來源信息，如果有默認(rèn)值或需要計(jì)算，也需要列出）描述（字段的業(yè)務(wù)含義，包括的內(nèi)容等，例：標(biāo)準(zhǔn)salesorder—所有類型為OR的訂單）特殊需求（如需要加入英文注釋）例：順序字段名稱字段技術(shù)名稱字段描述特殊需求1IDID序號(hào)序號(hào)從1累加2WERKSEKPO-WERKS工廠編碼根據(jù)查詢的單據(jù)選取工廠3EBELNEKPO-EBELN委外PO單號(hào)4EBELPEKPO-EBELP項(xiàng)目編號(hào)5MATNREKPO-MATNR產(chǎn)品編號(hào)6MAKTXMAKT-MAKTX產(chǎn)品名稱7DISPOMARC-DISPOMRP控制者8PLIFZMARC-PLIFZ計(jì)劃交貨時(shí)間9PO建立日期10LIFNREKKO-LIFNR委外加工商11NAME1LFA1-NAME1供應(yīng)商名稱12BANFNEKPO-BANFN委外采購(gòu)申請(qǐng)單號(hào)13BSARTEBAN-BSART采購(gòu)申請(qǐng)類型14MENGEEKET-MENGE計(jì)劃數(shù)量已計(jì)劃數(shù)量15BADATEKET-EINDT計(jì)劃交貨日期16在產(chǎn)數(shù)量在產(chǎn)數(shù)量=EKET-MENGE-EKET-WEMNG-MSEC-MENGE17VERIDEKET-VERIDBOM版本統(tǒng)計(jì)字段18軟件版本讀取采購(gòu)訂單文本信息中的軟件版本19WEMNGEKET-WEMNG交貨數(shù)量合計(jì)每單的（EKET-WEMNG）合計(jì)20成品率21MENGEMSEC-MENGE質(zhì)檢數(shù)量合計(jì)每單的全部103收貨合計(jì)-每單的（EKET-WEMNG）合計(jì)22MBLNRMSEG-MBLNR交貨單號(hào)23BUDATMKPF-BUDAT交貨日期過賬日期24MENGEMSEC-MENGE交貨數(shù)量移動(dòng)類型為：105，10625MENGEMSEC-MENGE凍結(jié)數(shù)量移動(dòng)類型為：103，10426LGORTMSEG-LGORT交貨倉庫27BWARTMSEG-BWART移動(dòng)類型25BANFNEKPO-BANFN采購(gòu)申請(qǐng)單號(hào)格式/屏幕設(shè)計(jì)：必填報(bào)表和單據(jù)列出紙張附件名（必填）附上Excel/Word附件。(如附檔XXXXXXXX.XLS/或附表XXXX單)（必填）屏幕截圖樣張：列出業(yè)務(wù)單據(jù)編號(hào)附上樣張的WORD/EXCEL文件其它內(nèi)容：對(duì)報(bào)表/單據(jù)的其它功能進(jìn)行描述*注：刪除上面不適用的行和注釋行.

第III部分:技術(shù)說明ProgramnameZ_PP_EXEC_EXEC_SCHEDULETransactioncodeZPP010AuthorizationObjectFormFormnameN/AOutputtypeN/AFormroutineN/A程序邏輯：要求：ＡＬＶ輸出，能夠?qū)氲紼XCEL。邏輯關(guān)系：1，可以輸入多個(gè)采購(gòu)申請(qǐng)編號(hào)2，可以輸入多個(gè)采購(gòu)訂單編號(hào)EKET關(guān)聯(lián)EKPOEKET-EBELN;EKET-EBELPEKPO-EBELN;EKPO-EBELPEKKO關(guān)聯(lián)EKPOEKPO-EBELN;EKKO-EBELNMSEG關(guān)聯(lián)EKPOMSEG-EBELN;MSEG-EBELPEKPO-EBELN;EKPO-EBELPMSEG關(guān)聯(lián)MKPFMSEG-MBLNR;MKPF-MBLNR委外采購(gòu)訂單：必須符合EKPO-PSTYP=3并排除EKPO-LOEKZ=XEKKO關(guān)聯(lián)LFA1EKKO-LIFNR與LFA1-LIFNR備注信息：一張訂單可以存在多個(gè)交貨日期與交貨數(shù)量，一張訂單可以存在多個(gè)交貨單號(hào)。必須把所有的交貨明細(xì)列出。交貨計(jì)劃與交貨單號(hào)不是一一對(duì)應(yīng)關(guān)系。在產(chǎn)數(shù)量：在產(chǎn)數(shù)量=EKET-MENGE-EKET-WEMNG-MSEC-MENGE；成品率：成品率=100*（取MSEG-BWART=105，106，且MSEG-LGORT=1030，1020的∑MSEC-MENGE）/（EKET-WEMNG（交貨數(shù)量合計(jì)）+MSEC-MENGE（質(zhì)檢數(shù)量合計(jì)））取數(shù)PERFORMGET_DATA.1.1從EKKO，EKPO取采購(gòu)訂單的主要信息1.2從EKBE讀取采購(gòu)訂單歷史相關(guān)信息SELECTBELNRASMBLNR"交貨憑證號(hào)BWART"移動(dòng)類型BUDAT"憑證日期WESBSASMENGE"數(shù)量EBELN"采購(gòu)單號(hào)EBELP"采購(gòu)行項(xiàng)目號(hào)GJAHR"憑證年度BUZEI"憑證項(xiàng)目號(hào)INTOCORRESPONDINGFIELDSOFTABLELT_EKBEFROMEKBEFORALLENTRIESINGT_OUTWHEREEBELN=GT_OUT-EBELNANDEBELP=GT_OUT-EBELPANDBWARTIN('103','104','105','106').1.3按訂單號(hào)和行項(xiàng)目號(hào)進(jìn)行交貨歷史的匯總，計(jì)算出已交貨數(shù)量SORTLT_EKBEBYEBELNEBELP.LOOPATLT_EKBEINTOLS_EKBE.IFLS_EKBE-BWART='105'.LS_EKBE-MENGE=ABS(LS_EKBE-MENGE).ELSEIFLS_EKBE-BWART='106'ORLS_EKBE-BWART='122'.LS_EKBE-MENGE=ABS(LS_EKBE-MENGE)*-1.ENDIF.IFLS_EKBE-BWART='105'ORLS_EKBE-BWART='106'ORLS_EKBE-BWART='122'.G_SUM=G_SUM+LS_EKBE-MENGE.ENDIF.ATENDOFEBELP.READTABLELT_EKBEINTOLS_EKBEINDEXSY-TABIX.LS_105-EBELN=LS_EKBE-EBELN.LS_105-EBELP=LS_EKBE-EBELP.LS_105-SUMMENGE=G_SUM.APPENDLS_105TOLT_105.CLEAR:G_SUM,LS_105.ENDAT.CLEAR:LS_EKBE.ENDLOOP.讀取交貨計(jì)劃行信息SELECTEBELN "采購(gòu)單號(hào)EBELP "采購(gòu)行項(xiàng)目號(hào)EINDTASBADAT "計(jì)劃交貨日期VERID "BOM版本ETENR"交貨計(jì)劃行計(jì)數(shù)器INTOTABLELT_EKETFROMEKETFORALLENTRIESINGT_OUTWHEREEBELN=GT_OUT-EBELNANDEBELP=GT_OUT-EBELPANDEKET~EINDTINS_EINDT.1.5進(jìn)行數(shù)據(jù)處理，合并計(jì)算相關(guān)數(shù)據(jù)LOOPATGT_OUTINTOGS_OUT.*取交貨數(shù)量合計(jì)SELECTSUM(WEMNG)SUM(MENGE)INTO(GS_OUT-WEMNG,GS_OUT-SUMMENGE)FROMEKETWHEREEBELN=GS_OUT-EBELNANDEBELP=GS_OUT-EBELP.*取103/104合計(jì)CLEAR:GT_SUM103,GT_SUM104.SELECTSUM(WESBS)INTOGT_SUM103FROMEKBEWHEREEBELN=GS_OUT-EBELNANDEBELP=GS_OUT-EBELPANDBWART='103'.SELECTSUM(WESBS)INTOGT_SUM104FROMEKBEWHEREEBELN=GS_OUT-EBELNANDEBELP=GS_OUT-EBELPANDBWART='104'.*每單的全部103/104收貨合計(jì)-每單的（EKET-WEMNG）合計(jì)GS_OUT-C_MENGE=ABS(GT_SUM103)-ABS(GT_SUM104)-GS_OUT-WEMNG."質(zhì)檢數(shù)量合計(jì)*計(jì)算在產(chǎn)數(shù)量(在產(chǎn)數(shù)量=EKET-MENGE-EKET-WEMNG-MSEC-MENGE)GS_OUT-ZZAICHAN=GS_OUT-SUMMENGE-GS_OUT-WEMNG-GS_OUT-C_MENGE.*取版本號(hào)CLEAR:L_TEXT.CONCATENATEGS_OUT-EBELNGS_OUT-EBELPINTOL_TEXT.CALLFUNCTION'READ_TEXT'EXPORTINGCLIENT=SY-MANDTID='F91'"采購(gòu)申請(qǐng)的長(zhǎng)文本軟件版本ID號(hào)（見表TTXID)LANGUAGE='1'"語言NAME=L_TEXT"采購(gòu)申請(qǐng)?zhí)?采購(gòu)申請(qǐng)行項(xiàng)目號(hào)OBJECT='EKPO'"采購(gòu)申請(qǐng)的應(yīng)用程序?qū)ο?見表TTXID)TABLESLINES=LT_TLINE"輸出的長(zhǎng)文本表EXCEPTIONSID=1LANGUAGE=2NAME=3NOT_FOUND=4OBJECT=5REFERENCE_CHECK=6WRONG_ACCESS_TO_ARCHIVE=7OTHERS=8.LOOPATLT_TLINE.CONCATENATELT_TLINE-TDLINEGS_OUT-VERTEXTINTOGS_OUT-VERTEXT.ENDLOOP.1.6進(jìn)行輸出內(nèi)表處理，按交貨計(jì)劃、和交貨歷史進(jìn)行比較，以同一訂單號(hào)行項(xiàng)目號(hào)二者條數(shù)多的為基數(shù)進(jìn)行輸出1.7整理后的輸出內(nèi)表進(jìn)行相關(guān)計(jì)算處理輸出表整理LOOPATGT_OUT2INTOGS_OUT2.IFGS_OUT2-BWART='122'."122移動(dòng)類型用做計(jì)算成品率不做輸出DELETEGT_OUT2.CONTINUE.ENDIF.*輸出序號(hào)處理L_ID=L_ID+1.GS_OUT2-ID=L_ID.*成品率計(jì)算READTABLELT_105INTOLS_105WITHKEYEBELN=GS_OUT2-EBELNEBELP=GS_OUT2-EBELP.IFSY-SUBRC=0ANDGS_OUT2-WEMNG<>0."成品率=100*（∑105/106）/（交貨數(shù)量合計(jì)）GS_OUT2-ZCPL=(100*LS_105-SUMMENGE)/GS_OUT2-WEMNG.ENDIF.*數(shù)量去小數(shù)點(diǎn)GS_OUT2-MENGE105I=GS_OUT2-MENGE105.GS_OUT2-MENGE103I=GS_OUT2-MENGE103.GS_OUT2-E_MENGEI=GS_OUT2-E_MENGE."已計(jì)劃數(shù)量GS_OUT2-WEMNGI=GS_OUT2-WEMNG."交貨數(shù)量合計(jì)GS_OUT2