揚(yáng)農(nóng)化工（瑞祥）SAP項(xiàng)目-FI-采購(gòu)合同執(zhí)行情況明細(xì)表開發(fā)說明書-V3.0-20180424

開發(fā)規(guī)格書第7頁(yè)，共7頁(yè)揚(yáng)農(nóng)化工SAP項(xiàng)目-開發(fā)規(guī)格書1需求模塊MACROBUTTONCheckIt_CheckBox￡MM MACROBUTTONCheckIt_CheckBox￡P(guān)P MACROBUTTONCheckIt_CheckBox￡SD ■FIMACROBUTTONCheckIt_CheckBox￡CO MACROBUTTONCheckIt_CheckBox￡P(guān)SMACROBUTTONCheckIt_CheckBox￡其它Spec編號(hào)FI009短描述瑞祥采購(gòu)合同執(zhí)行情況明細(xì)表類型報(bào)表MACROBUTTONUnCheckIt_Radiobutton報(bào)表MACROBUTTONCheckIt_RadiobuttonABAPProgramMACROBUTTONCheckIt_RadiobuttonInformationSystemMACROBUTTONCheckIt_RadiobuttonReportPrinterMACROBUTTONCheckIt_RadiobuttonReportWriterMACROBUTTONCheckIt_RadiobuttonSAPQueryMACROBUTTONCheckIt_RadiobuttonBWreportMACROBUTTONCheckIt_RadiobuttonCrystalReportsMACROBUTTONCheckIt_RadiobuttonOthers_____________________________________________________MACROBUTTONCheckIt_Radiobutton表單MACROBUTTONCheckIt_Radiobutton流程增強(qiáng)MACROBUTTONCheckIt_RadiobuttonUserExitMACROBUTTONCheckIt_RadiobuttonBADIMACROBUTTONCheckIt_RadiobuttonDialogProgramMACROBUTTONCheckIt_RadiobuttonOthers__________________________________MACROBUTTONCheckIt_Radiobutton接口MACROBUTTONCheckIt_RadiobuttonBAPIMACROBUTTONCheckIt_RadiobuttonIDOCMACROBUTTONCheckIt_RadiobuttonALEMACROBUTTONCheckIt_RadiobuttonOthers__________________________MACROBUTTONCheckIt_Radiobutton數(shù)據(jù)轉(zhuǎn)移需求優(yōu)先級(jí)MACROBUTTONCheckIt_RadiobuttonHigh/關(guān)鍵 MACROBUTTONUnCheckIt_RadiobuttonMACROBUTTONCheckIt_RadiobuttonMid/推薦 MACROBUTTONCheckIt_RadiobuttonLow/可選預(yù)計(jì)開發(fā)天數(shù)（由功能顧問與開發(fā)顧問評(píng)估）必填_______天是否有標(biāo)準(zhǔn)功能MACROBUTTONCheckIt_RadiobuttonYes MACROBUTTONUnCheckIt_RadiobuttonNo標(biāo)準(zhǔn)功能未采用的原因:MACROBUTTONCheckIt_RadiobuttonPerformanceMACROBUTTONCheckIt_RadiobuttonComplexityMACROBUTTONCheckIt_RadiobuttonOtherse參考的標(biāo)準(zhǔn)功能表單開發(fā)：列出參考的標(biāo)準(zhǔn)的Form的技術(shù)名稱報(bào)表開發(fā)：列出參考的標(biāo)準(zhǔn)報(bào)表文檔變更歷史版本號(hào)文檔維護(hù)時(shí)間姓名簡(jiǎn)要的描述1.02018/1/25楊鋒新增1.12018/4/23許兆柱修改，增加查詢條件及輸出字段

2詳細(xì)功能描述2.1選擇屏幕：公司代碼：XXXX采購(gòu)組織：FROM：XXXX/XX/XXTO：XXXX/XX/XX訂單類型：FROM：XXXX/XX/XXTO：XXXX/XX/XX供應(yīng)商：FROM：XXXX/XX/XXTO：XXXX/XX/XX采購(gòu)訂單號(hào)：FROM：XXXX/XX/XXTO：XXXX/XX/XX船號(hào)信息：FROM:XXXXXXXXXXXXTOXXXXXXXXXXXX采購(gòu)組：FROM:XXXTO:XXX可手工輸入，也通過搜索幫助來選擇輸入（僅顯示Y開頭采購(gòu)組），需關(guān)聯(lián)表：T024輸出EKGRP、EKNAM；手工輸入需檢查存在否，若不存在提示“采購(gòu)組：XXX不存在，請(qǐng)檢查?！睂徟鸂顟B(tài)：FROM：XTOX可手工輸入，也通過搜索幫助來選擇輸入，需關(guān)聯(lián)表：T16FE輸出FRGKE、FRGET,T16FE-SPRAS=SY-LANGU；手工輸入需檢查存在否，若不存在提示“審批狀態(tài)：X不存在，請(qǐng)檢查?！庇唵稳掌冢篎ROM：XXXX/XX/XXTO：XXXX/XX/XX創(chuàng)建人：XXXX未清訂單明細(xì)：X獲取EKPO-ELIKZ=‘’清單全部順序字段名稱字段技術(shù)名稱字段描述特殊需求1公司代碼EKKO-BUKRS公司代碼必輸2項(xiàng)目編碼PROJ-PSPID項(xiàng)目編碼項(xiàng)目編碼查詢公司代碼非必輸3WBS編碼PRPS-PSPIDWBS編碼WBS編碼查詢公司代碼非必輸4供應(yīng)商編號(hào)EKKO-LIFNR供應(yīng)商編號(hào)5采購(gòu)訂單號(hào)EKKO-EBELN采購(gòu)訂單號(hào)船號(hào)信息EKKO-VERKF船號(hào)信息采購(gòu)組EKKO-EKGRP采購(gòu)組審批狀態(tài)EKKO-FRGKE審批狀態(tài)6訂單類型EKKO-BSART訂單類型7訂單日期EKKO-BEDAT訂單日期8采購(gòu)組織EKKO-EKORG采購(gòu)組織9創(chuàng)建人EKKO-ERNAM創(chuàng)建人2.2報(bào)表/表單/功能的字段順序字段字段技術(shù)名稱字段描述類型長(zhǎng)度說明BUKRSEKKO-BUKRS公司代碼CHAR4LIFNREKKO-LIFNR供應(yīng)商編號(hào)CHAR10NAME1LFA1-NAME1供應(yīng)商名稱CHAR35BSARTEKKO-BSART訂單類型CHAR4BATXTT161T-BATXT訂單類型名稱CHAR20EKORGEKKO-EKORG采購(gòu)組織CHAR4EKOTXT024E-EKOTX采購(gòu)組織名稱CHAR20VERKFEKKO-VERKF船號(hào)信息CHAR30EKGRPEKKO-EKGRP采購(gòu)組CHAR3FRGZUEKKO-FRGZU審批狀態(tài)CHAR4IFEKKO-FRGKE<>‘’初始狀態(tài)；X提交OA審批XX審批完成ELSEEKKO-FRGZUENDIFFRGKEEKKO-FRGKE批準(zhǔn)標(biāo)識(shí)CHAR1創(chuàng)建人EKKO-ERNAM創(chuàng)建人CHAR12NAME_TEXTADRP-NAME_TEXT創(chuàng)建人名稱CHAR80EBELNEKKO-EBELN采購(gòu)訂單號(hào)CHAR10BSTNKEKKO-BSTNK合同號(hào)CHAR20ZRTWR訂單含稅總價(jià)CURR13,2匯總EKPO-BRTWREXPWR訂單費(fèi)用總金額CURR13,2匯總EKPO-EFFWR–匯總EKPO-NETWRZFFWR訂單總價(jià)（含費(fèi)用）CURR13,2匯總EKPO-EFFWRWAERSEKKO-WAERSCUKY5EBELPEKPO-EBELP行項(xiàng)目NUMC5MATNREKPO-MATNR物料號(hào)CHAR18服務(wù):ESLL-SRVPOSMAKTXMAKT-MAKTX物料描述CHAR40服務(wù)描述:ASMD-ASKTXSGTXTRESB-SGTXT設(shè)備位號(hào)CHAR50MATKLEKPO-MATKL物料組CHAR9WGBEZT023T-WGBEZ物料組描述CHAR20TXZ01EKPO-TXZ01短文本CHAR40ANLN1EKPO-ANLN1資產(chǎn)號(hào)CHAR12TXT50ANLA-TXT50資產(chǎn)描述CHAR50WERKSEKPO-WERKS工廠CHAR4MENGEEKPO-MENGE訂單數(shù)量CHAR13MEINSEKPO-MEINS訂單單位UNIT3KBETR/KPEINKONV-KBETR、KONV-KPEIN行項(xiàng)目單價(jià)（含稅）CURR13,6EKKO-KNUMV、EKPO-EBELP關(guān)聯(lián)表：KONV，關(guān)聯(lián)條件：KONV-KNUMV=EKKO-KNUMVANDKONV-KPOSN=EKPO-EBELPANDKONV-KSCHLIN(‘PBXX’、‘PB00’)ANDKONV-KBETR>‘0’NETWREKPO-NETWR行項(xiàng)目未稅金額CHAR13，2BRTWREKPO-BRTWR行項(xiàng)目含稅金額CHAR13，2EXTWR行項(xiàng)目費(fèi)用總金額CURR13,2EKPO-EFFWR–EKPO-NETWREFFWREKPO-EFFWR行項(xiàng)目總價(jià)（含費(fèi)用）CURR13,2MENGEMSEG-MENGE收貨數(shù)量CHAR13MENGEEKBE-MENGE發(fā)票數(shù)量CHAR13WRBTREKBE-WRBTR發(fā)票金額CHAR13MWSKZEKBE-MWSKZ稅碼CHAR2稅率*‰SHKZGMSEG-SHKZG收貨借/貸標(biāo)識(shí)CHAR1S-借，H-貸SHKZGEKBE--SHKZG發(fā)票借/貸標(biāo)識(shí)CHAR1S-借，H-貸BELNREKBE-BELNR采購(gòu)發(fā)票號(hào)CHAR13刪除此字段PS_PSP_PNREKKN-PS_PSP_PNRWBS編號(hào)CHAR8POST1PRPS-POST1WBS描述CHAR40ZSQJEZSQJE付款申請(qǐng)金額CHAR10相同PO匯總ZSFJEZTFI003-ZSFJE已付金額CHAR10相同PO匯總ZFKMCT042Z-TEXT1付款方式CHAR30FKBLFKBL付款比例DEC5BANFNEKPO-BANFN采購(gòu)申請(qǐng)CHAR10BNFPOEKPO-BNFPO采購(gòu)申請(qǐng)行項(xiàng)目NUMC5MENEGEBAN-MENGE采購(gòu)申請(qǐng)數(shù)量QUAN13,3MEINSEBAN-MEINS采購(gòu)申請(qǐng)單位UNIT3RSNUMRSDBS-RSNUM預(yù)留NUMC10RSPOSRSDBS-RSPOS預(yù)留行項(xiàng)目NUMC42.4邏輯關(guān)系：在獲取采購(gòu)訂單信息時(shí)，要排除已標(biāo)記刪除行項(xiàng)目，即EKPO-LOEKZ<>‘L’根據(jù)屏幕的項(xiàng)目編碼=PRPS-PRHI，取PRPS-PSPNR，PRPS-PSPNR=EKKN-PS_PSP_PNR，根據(jù)屏幕輸入WBS=EKKN-PS_PSP_PNR,取EKKN-EBELN,EKKN-EBELPEKKO-EBELN=EKPO-EBELN=EKKN-EBELN,EKPO-EBELN=EKBE－EBELN=EKKN-EBELN,EKPO-EBELP=EKBE－EBELP=EKKN-EBELPADRP-NAME_TEXT:創(chuàng)建人名稱,條件EKKO-ERNAM=USR21-BNAME,取USR21-PERSNUMBER,USR21-PERSNUMBER=ADRP-PERSNUMBER,取ADRP-NAME_TEXTESLL-SRVPOS:服務(wù)條目編碼,條件：EKPO-EBELN=ESLH-EBELN，EKPO-EBELP=ESLH-EBELP，MAX（ESLH-PACKNO），ESLH-PACKNO=ESLL-PACKNO，取ESLL-SRVPOSASMD-ASKTX:服務(wù)短文本,條件：ASMD-ASNUM=ESLL-SRVPOSRSDBS-RSNUM:預(yù)留,條件:EKPO-EBELN=RSDBS-EBELN,EKPO-EBELP=RSDBS-EBELP,RSDBS-RSPOS:預(yù)留行項(xiàng)目,條件同預(yù)留邏輯MARA-MATKL（物料組）：MARA-MATNR=MSEG-MATNR，取MARA-MATKLT023T-WGBEZ（物料組描述）：T023T-MATKL=MARA-MATK，取T023T-WGBEZFKBL:付款比例條件:SUM(ZTFI003-ZSFJE)/SUM(EKPO-NETWR),按照單個(gè)訂單行項(xiàng)目金額匯總.根據(jù)MSEG-EBELN對(duì)應(yīng)的MSEG-MBLNR，取各行項(xiàng)目的EKPO-NETWR*MSEG-MENGE/EKPO-MENGE值，按(MSEG-SHKZG=S)-(MSEG-SHKZG=