DATE\@"yyyy-MM-dd"2009-08-18Version1.0PAGE1聯(lián)芯科技ERP項(xiàng)目 DATE\@"M/d/yyyy"8/18/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編號ZLC_PP_005短描述周需求短缺報(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)先級MACROBUTTONCheckIt_RadiobuttonHigh/關(guān)鍵 MACROBUTTONUnCheckIt_RadiobuttonMid/推薦 MACROBUTTONCheckIt_RadiobuttonLow/可選用戶MACROBUTTONNextCell王董豹要求日期2009-08-預(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ù)時(shí)間姓名簡要的描述V1.02009-0王董豹V1.12009-08-17王董豹委外供應(yīng)商代碼變更委外庫-宏訊：MSLB-LIFNR=12000177委外庫-天通：MSLB-LIFNR=11000003V1.22009-08-18王董豹最終版

第II部分:詳細(xì)功能描述目的：顯示每周生產(chǎn)計(jì)劃缺料情況。功能描述:通過輸入每周生產(chǎn)計(jì)劃，計(jì)算得出每周缺料情況。運(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è)為中文)選擇屏幕：

物料代碼：FROM：XXXXXXXXTO：XXXXXXXX(1)委外采購訂單：FROM：XXXXXXXXTO：XXXXXXXX(2)委外采購申請：FROM：XXXXXXXXTO：XXXXXXXX(3)工廠：XXXXXXXX(4)MRP控制者：FROM：XXXXXXXXTO：XXXXXXXX(5)物料類型：FROM：XXXXXXXXTO：XXXXXXXX(6)庫存：XXXXXXXXPO：XXXXXXXXPR：XXXXXXXX：順序字段名稱字段技術(shù)名稱字段描述特殊需求1MATNRMARC-MATNR物料代碼2EBELNRESB-EBELN委外采購訂單3BANFNRESB-BANFN委外采購申請4WERKSRESB-WERKS工廠必選5DISPOMARC-DISPOMRP控制者區(qū)間查詢6MTARTMARA-MTART物料類型分割線庫存單選框，默認(rèn)選擇，強(qiáng)制選擇PO單選框，默認(rèn)選擇PR單選框，默認(rèn)選擇報(bào)表/表單的字段功能顧問（必填）列出報(bào)表或自定義打印程序上選擇屏幕上的字段顯示名稱(在屏幕或單據(jù)上的名稱)技術(shù)名稱（字段的來源信息，如果有默認(rèn)值或需要計(jì)算，也需要列出）描述（字段的業(yè)務(wù)含義，包括的內(nèi)容等，例：標(biāo)準(zhǔn)salesorder—所有類型為OR的訂單）特殊需求（如需要加入英文注釋）例：順序字段名稱字段技術(shù)名稱字段描述特殊需求1MATNRMARC-MATNR物料代碼2MAKTXMAKT-MAKTX物料名稱3WERKSRESB-WERKS工廠4MENGE采購申請數(shù)量5MENGE采購訂單數(shù)量6總需求計(jì)算結(jié)果7LABSTMARD-LABST原材料本地庫存MARD-LGORT=10108LBLABMSLB-LBLAB委外庫-宏訊MSLB-LIFNR=120001779LBLABMSLB-LBLAB委外庫-天通MSLB-LIFNR=1100000310LBLABMSLB-LBLAB委外庫-真索MSLB-LIFNR=1200035911LABSTMARD-LABST成品庫存MARD-LGORT=103012LABSTMARD-LABST待檢庫庫存MARD-LGORT=104913LABSTMARD-LABST樣品庫庫存MARD-LGORT=104614總庫存計(jì)算結(jié)果，總庫存=原材料本地庫存+委外庫-宏訊庫存+委外庫-天通庫存+委外庫-真索庫存+成品庫存+待檢庫庫存+樣品庫庫存15第1周（當(dāng)前周）計(jì)算結(jié)果16第2周計(jì)算結(jié)果17第3周計(jì)算結(jié)果18第4周計(jì)算結(jié)果19第5周計(jì)算結(jié)果20第6周計(jì)算結(jié)果21第7周計(jì)算結(jié)果22第8周計(jì)算結(jié)果DUMPS虛擬項(xiàng)目標(biāo)識格式/屏幕設(shè)計(jì)：必填報(bào)表和單據(jù)列出紙張附件名（必填）附上Excel/Word附件。(如附檔XXXXXXXX.XLS/或附表XXXX單)（必填）屏幕截圖邏輯關(guān)系：篩選字段：1，如果通過以下進(jìn)行篩選，可以通過resb找出下層物料清單，然后再相關(guān)計(jì)算。委外采購訂單委外采購申請2，如果以上不進(jìn)行篩選，可以通過Marc表，讀取相關(guān)的物料清單，然后在進(jìn)行相關(guān)計(jì)算報(bào)表邏輯：1，采購申請數(shù)量(已審批采購申請未下推訂單數(shù)量,是指該物料下達(dá)的采購申請，以及全部審核完畢的部分。)通過EBAN查找沒個(gè)物料所有的采購申請MARC-MATNR;EBAN-MATNRRESB-WERKS;EBAN-WERKS并排除：EBAN-LOEKZ=x;EBAN-STATUisb;EBAN-FRGKZ=Y不是排除，而是找到符合這個(gè)條件的記錄合計(jì)EBAN-MENGE的數(shù)量既是所求數(shù)量。2，采購訂單數(shù)量：（是指該物料已經(jīng)下達(dá)采購訂單，但還未交貨的部分。）通過EKPO查找該物料所有的采購訂單RESB-MATNR;EKPO-MATNRRESB-WERKS;EKPO-WERKS并排除：EKPO-LOEKZ=‘L’通過EKET計(jì)算出未交貨的數(shù)量：EKPO-EBELN;EKET-EBELNEKPO-EBELP;EKET-EBELP計(jì)算PO未交貨數(shù)量：SUM(EKET-MENGE-EKET-WEMNG)3,總需求某個(gè)物料需求是從RESB中讀取：.RESB-MATNR物料編碼RESB-WERKS工廠排除：RESB-XLOEK=X排除：RESB-KZEAR=X排除：RESB-BWART=’911需求數(shù)量=SUM(RESB-BDMNG-RESB-ENMNG)4委外庫-宏訊MARC-MATNR;MSLB-MATNRRESB-WERKS;MSLB–WERKSMSLB-LIFNR=10011103;庫存數(shù)量=SUM(MSLB-LBLAB)5,委外庫-天通MARC-MATNR;MSLB-MATNRRESB-WERKS;MSLB–WERKSMSLB-LIFNR=10011105;庫存數(shù)量=SUM(MSLB-LBLAB)6,委外庫-真索MARC-MATNR;MSLB-MATNRRESB-WERKS;MSLB–WERKSMSLB-LIFNR=12000359;庫存數(shù)量=SUM(MSLB-LBLAB)7.成品倉庫MARC-MATNR；MARD-MATNRRESB-WERKS;MARD-WERKS;MARD-LABST=1030庫存數(shù)量=SUM(MARD-LABST)8．待檢庫存MARC-MATNR；MARD-MATNRRESB-WERKS;MARD-WERKS;MARD-LABST=1049庫存數(shù)量=SUM(MARD-LABST)9．樣品庫存MARC-MATNR；MARD-MATNRRESB-WERKS;MARD-WERKS;MARD-LABST=1046庫存數(shù)量=SUM(MARD-LABST)10.總庫存計(jì)算總庫存=原材料本地庫存+委外庫-宏訊庫存+委外庫-天通庫存+委外庫-真索庫存+成品庫存+待檢庫庫存+樣品庫庫存11.周需求從當(dāng)前周開始計(jì)算（第一周），相繼列出后8周的需求情況。A：如果本周之前仍存在未完成的需求，則將該需求放在本周。B：選擇屏幕如果只選擇庫存，則每周的需求短缺量計(jì)算如下：第一周=庫存余額–本周的總需求；第二周=第一周余額-本周的總需求。C：選擇屏幕如果只選擇庫存，又選擇了PO，則每周的需求短缺量計(jì)算如下：第一周=庫存余額+本周PO數(shù)量–本周的總需求；第二周=第一周余額+本周PO數(shù)量-本周的總需求。D：選擇屏幕如果只選擇庫存，又選擇了PO，有選擇了PR，則每周