開發規格書第5頁，共9頁揚農化工SAP項目-開發規格書1需求模塊MACROBUTTONCheckIt_CheckBox￡MM MACROBUTTONCheckIt_CheckBox￡PP MACROBUTTONCheckIt_CheckBox￡SD ■FIMACROBUTTONCheckIt_CheckBox￡CO MACROBUTTONCheckIt_CheckBox￡PSMACROBUTTONCheckIt_CheckBox￡其它Spec編號FI009短描述瑞祥采購合同執行情況明細表類型報表MACROBUTTONUnCheckIt_Radiobutton報表MACROBUTTONCheckIt_RadiobuttonABAPProgramMACROBUTTONCheckIt_RadiobuttonInformationSystemMACROBUTTONCheckIt_RadiobuttonReportPrinterMACROBUTTONCheckIt_RadiobuttonReportWriterMACROBUTTONCheckIt_RadiobuttonSAPQueryMACROBUTTONCheckIt_RadiobuttonBWreportMACROBUTTONCheckIt_RadiobuttonCrystalReportsMACROBUTTONCheckIt_RadiobuttonOthers_____________________________________________________MACROBUTTONCheckIt_Radiobutton表單MACROBUTTONCheckIt_Radiobutton流程增強MACROBUTTONCheckIt_RadiobuttonUserExitMACROBUTTONCheckIt_RadiobuttonBADIMACROBUTTONCheckIt_RadiobuttonDialogProgramMACROBUTTONCheckIt_RadiobuttonOthers__________________________________MACROBUTTONCheckIt_Radiobutton接口MACROBUTTONCheckIt_RadiobuttonBAPIMACROBUTTONCheckIt_RadiobuttonIDOCMACROBUTTONCheckIt_RadiobuttonALEMACROBUTTONCheckIt_RadiobuttonOthers__________________________MACROBUTTONCheckIt_Radiobutton數據轉移需求優先級MACROBUTTONCheckIt_RadiobuttonHigh/關鍵 MACROBUTTONUnCheckIt_RadiobuttonMACROBUTTONCheckIt_RadiobuttonMid/推薦 MACROBUTTONCheckIt_RadiobuttonLow/可選預計開發天數（由功能顧問與開發顧問評估）必填_______天是否有標準功能MACROBUTTONCheckIt_RadiobuttonYes MACROBUTTONUnCheckIt_RadiobuttonNo標準功能未采用的原因:MACROBUTTONCheckIt_RadiobuttonPerformanceMACROBUTTONCheckIt_RadiobuttonComplexityMACROBUTTONCheckIt_RadiobuttonOtherse參考的標準功能表單開發：列出參考的標準的Form的技術名稱報表開發：列出參考的標準報表文檔變更歷史版本號文檔維護時間姓名簡要的描述1.02018/1/25楊鋒新增2.02018/3/29張錦濤補充開發技術說明

2詳細功能描述2.1選擇屏幕：公司代碼：XXXX采購組織：FROM：XXXX/XX/XXTO：XXXX/XX/XX訂單類型：FROM：XXXX/XX/XXTO：XXXX/XX/XX供應商：FROM：XXXX/XX/XXTO：XXXX/XX/XX采購訂單號：FROM：XXXX/XX/XXTO：XXXX/XX/XX訂單日期：FROM：XXXX/XX/XXTO：XXXX/XX/XX創建人：XXXX順序字段名稱字段技術名稱字段描述特殊需求1公司代碼EKKO-BUKRS公司代碼必輸2項目編碼PROJ-PSPID項目編碼項目編碼查詢公司代碼非必輸3WBS編碼PRPS-PSPIDWBS編碼WBS編碼查詢公司代碼非必輸4供應商編號EKKO-LIFNR供應商編號5采購訂單號EKKO-EBELN采購訂單號6訂單類型EKKO-BSART訂單類型7訂單日期EKKO-BEDAT訂單日期8采購組織EKKO-EKORG采購組織9創建人EKKO-ERNAM創建人2.2報表/表單/功能的字段順序字段字段技術名稱字段描述類型長度說明BUKRSEKKO-BUKRS公司代碼CHAR4LIFNREKKO-LIFNR供應商編號CHAR10NAME1LFA1-NAME1供應商名稱CHAR35BSARTEKKO-BSART訂單類型CHAR4BATXTT161T-BATXT訂單類型名稱CHAR20EKORGEKKO-EKORG采購組織CHAR4EKOTXT024E-EKOTX采購組織名稱CHAR20創建人EKKO-ERNAM創建人CHAR12NAME_TEXTADRP-NAME_TEXT創建人名稱CHAR80EBELNEKKO-EBELN采購訂單號CHAR10BSTNKEKKO-BSTNK合同號CHAR20MATNREKPO-MATNR物料號CHAR18服務:ESLL-SRVPOSMAKTXMAKT-MAKTX物料描述CHAR40服務描述:ASMD-ASKTXSGTXTRESB-SGTXT設備位號CHAR50MATKLEKPO-MATKL物料組CHAR9WGBEZT023T-WGBEZ物料組描述CHAR20TXZ01EKPO-TXZ01短文本CHAR40ANLN1EKPO-ANLN1資產號CHAR12TXT50ANLA-TXT50資產描述CHAR50WERKSEKPO-WERKS工廠CHAR4MENGEEKPO-MENGE訂單數量CHAR13NETWREKPO-NETWR訂單金額CHAR13BRTWREKPO-BRTWR訂單含稅金額CHAR13MENGEMSEG-MENGE收貨數量CHAR13MENGEEKBE-MENGE發票數量CHAR13WRBTREKBE-WRBTR發票金額CHAR13MWSKZEKBE-MWSKZ稅碼CHAR2稅率*‰SHKZGMSEG-SHKZG收貨借/貸標識CHAR1S-借，H-貸SHKZGEKBE--SHKZG發票借/貸標識CHAR1S-借，H-貸BELNREKBE-BELNR采購發票號CHAR13PS_PSP_PNREKKN-PS_PSP_PNRWBS編號CHAR8POST1PRPS-POST1WBS描述CHAR40ZSQJEZSQJE付款申請金額CHAR10相同PO匯總ZSFJEZTFI003-ZSFJE已付金額CHAR10相同PO匯總ZFKMCT042Z-TEXT1付款方式CHAR30FKBLFKBL付款比例DEC5BANFNEKPO-BANFN采購申請CHAR10BNFPOEKPO-BNFPO采購申請行項目NUMC5RSNUMRSDBS-RSNUM預留NUMC10RSPOSRSDBS-RSPOS預留行項目NUMC42.4邏輯關系：根據屏幕的碼=PRPS-PRHI，取PRPS-PSPNR，PRPS-PSPNR=EKKN-PS_PSP_PNR，根據屏幕輸入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:創建人名稱,條件EKKO-ERNAM=USR21-BNAME,取USR21-PERSNUMBER,USR21-PERSNUMBER=ADRP-PERSNUMBER,取ADRP-NAME_TEXTESLL-SRVPOS:服務條目編碼,條件：EKPO-EBELN=ESLH-EBELN，EKPO-EBELP=ESLH-EBELP，MAX（ESLH-PACKNO），ESLH-PACKNO=ESLL-PACKNO，取ESLL-SRVPOSASMD-ASKTX:服務短文本,條件：ASMD-ASNUM=ESLL-SRVPOSRSDBS-RSNUM:預留,條件:EKPO-EBELN=RSDBS-EBELN,EKPO-EBELP=RSDBS-EBELP,RSDBS-RSPOS:預留行項目,條件同預留邏輯MARA-MATKL（物料組）：MARA-MATNR=MSEG-MATNR，取MARA-MATKLT023T-WGBEZ（物料組描述）：T023T-MATKL=MARA-MATK，取T023T-WGBEZFKBL:付款比例條件:SUM(ZTFI003-ZSFJE)/SUM(EKPO-NETWR),按照單個訂單行項目金額匯總.根據MSEG-EBELN、EBELP對應的MSEG-MBLNR，取到各采購訂單行項目的MSEG-MENGE，按(MSEG-SHKZG=S)-(MSEG-SHKZG=H)匯總，得到收貨數量根據MSEG-EBELN、EBELP對應的MSEG-MBLNR，取各采購訂單行項目的EKPO-NETWR*MSEG-MENGE/EKPO-MENGE值，按(MSEG-SHKZG=S)-(MSEG-SHKZG=H)匯總，得到收貨金額根據EKBE-EBELN、EBELP對應的EKBE-BELNR，取到各采購訂單行項目EKBE-MENGE，按(EKBE-SHKZG=S)-(EKBE-SHKZG=H)匯總，得到發票數量根據EKBE-EBELN、EBELP對應的EKBE-BELNR，取各采購訂單行項目的EKBE-WRBTR*（1+EKBE-MWSKZ對應的KONP-KBETR值*‰，按(EKBE-SHKZG=S)-(EKBE-SHKZG=H)匯總，得到發票金額。（根據A003-MWSKZ找到對應的KNUMH，根據KONP-KNUM找到KBETR的值，并乘以‰得到稅率）3技術說明ProgramnameZFIR1008TransactioncodeZFIR1008AuthorizationObjectFormFormnameN/AOutputtypeN/AFormroutineN/A3.1程序邏輯：根據選擇屏幕輸入條件，關聯表EKKO,EKPO,EKKN取得相關采購訂單信息，如果選擇屏