揚(yáng)農(nóng)化工（瑞祥）SAP項(xiàng)目-MM-采購發(fā)票查詢報(bào)表開發(fā)說明書-V1.1-20180328

開發(fā)規(guī)格書第12頁，共12頁揚(yáng)農(nóng)化工SAP項(xiàng)目-開發(fā)規(guī)格書1需求模塊■MM MACROBUTTONCheckIt_CheckBox￡P(guān)P MACROBUTTONCheckIt_CheckBox￡SD MACROBUTTONCheckIt_CheckBox￡FIMACROBUTTONCheckIt_CheckBox￡CO MACROBUTTONCheckIt_CheckBox￡P(guān)SMACROBUTTONCheckIt_CheckBox￡其它Spec編號(hào)MM018短描述采購發(fā)票查詢報(bào)表類型報(bào)表MACROBUTTONCheckIt_Radiobutton報(bào)表MACROBUTTONCheckIt_RadiobuttonABAPProgramMACROBUTTONCheckIt_RadiobuttonInformationSystemMACROBUTTONCheckIt_RadiobuttonReportPrinterMACROBUTTONCheckIt_RadiobuttonReportWriterMACROBUTTONCheckIt_RadiobuttonSAPQueryMACROBUTTONCheckIt_RadiobuttonBWreportMACROBUTTONCheckIt_RadiobuttonCrystalReportsMACROBUTTONCheckIt_RadiobuttonOthers_____________________________________________________MACROBUTTONUnCheckIt_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í)MACROBUTTONUnCheckIt_RadiobuttonHigh/關(guān)鍵 MACROBUTTONCheckIt_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/2/2許兆柱新增1.12018/3/28張錦濤補(bǔ)充開發(fā)技術(shù)說明

2詳細(xì)功能描述2.1選擇屏幕輸入?yún)?shù)：物料：FROMXXXXXXXXXXXXXXXXXXTOXXXXXXXXXXXXXXXXXX(1)供應(yīng)商：FROMXXXXXXXXXXTOXXXXXXXXXX(2)采購訂單：FROMXXXXXXXXXXTOXXXXXXXXXX(3)發(fā)票號(hào)：FROMXXXXXXXXXXTOXXXXXXXXXX(4)用戶名稱：FROMXXXXXXXXXXXXTOXXXXXXXXXXXX(5)工廠：XXXX選擇日期：FROMXXXX/XX/XXTOXXXX/XX/XX(7)未完成付款申請(qǐng)清單：X全部：順序字段名稱字段技術(shù)名稱字段描述特殊需求1MATNRRSEG-MATNR物料2LIFNRRBKP-LIFNR供應(yīng)商3EBELPRSEG-EBELP采購訂單4BELNRRBKP-BELNR發(fā)票號(hào)5USNAMRBKP-USNAM用戶名稱6WERKSRSEG-WERKS工廠必輸7BLDATRBKP-BLDAT選擇日期8WFCFY未完成付款申請(qǐng)清單DEFAULT‘X’9QBFY全部2.2報(bào)表/表單/功能的字段ALV輸出字段順序字段字段技術(shù)名稱字段描述類型長度說明1BELNRRBKP-BELNR發(fā)票號(hào)CHAR102LIFNRRBKP-LINFR供應(yīng)商CHAR103NAME1LFA1-NAME1供應(yīng)商名稱CHAR354BLDATRBKP-BLDAT憑證日期DATS85BUDATRBKP-BUDAT過賬日期DATS86WAERSRBKP-WAERS貨幣CUKY57KURSFRBKP-KURSF匯率DEC9,58RMWWRRBKP-RMWWR總金額CURR13,29BEZNKRBKP-BEZNK計(jì)劃外費(fèi)用CURR13,29WMWST1RBKP-WMWST1稅金CURR13,210ZTERMRBKP-ZTERM付款條件CHAR411TEXT1T052U-TEXT1付款條件描述CHAR5012ZBD1TRBKP-ZBD1T天數(shù)DEC313XRECHRBKP-XRECH發(fā)票標(biāo)記CHAR1RBSTATRBKP-RBSTAT發(fā)票憑證狀態(tài)CHAR1RBSTDEC發(fā)票狀態(tài)描述CHAR3014ZFBDTRBKP-ZFBDT基準(zhǔn)日期DATS815ZDQDTRBKP-ZFBDT到期日期DATS8RBKP-ZFBDT+RBKP-ZBD1T16YTBJE已提報(bào)付款金額CURR13,2依據(jù)RBKP-BELNR關(guān)聯(lián)表：ZTFI003（其中ZTFI003-ZDEL=‘’）獲取SUM(ZTFI003-ZSFJE)17FKSTU付款狀態(tài)CHAR4依據(jù)RBKP-BELNR關(guān)聯(lián)表：ZTFI003（其中ZTFI003-ZDEL=‘’）獲取SUM(ZTFI003-ZSFJE)；1.若抓取不到數(shù)據(jù)，則FKSTU=‘未提報(bào)付款’2.RBKP-RMWWR>SUM(ZTFI003-ZSFJE)，則FKSTU=‘部分提報(bào)付款’3.RBKP-RMWWR=SUM(ZTFI003-ZSFJE)，則FKSTU=‘已全部提報(bào)付款’19SGTXTRBKP-SGTXT文本CHAR5020BUZEIRSEG-BUZEI行項(xiàng)目NUMC621MATNRRSEG-MATNR物料CHAR1822MAKTXMAKT-MAKTX描述CHAR40MAKT~SPARAS=SY-LANGUANDMAKT-MATNR=RSEG-MATNR23EBELNRSEG-EBELN采購訂單號(hào)CHAR1024EBELPRSEG-EBELP訂單行項(xiàng)目NUMC5LFBNRRSEG-LFBNR參考憑證號(hào)CHAR10LFPOSRSEG-LFPOS參考憑證行項(xiàng)目NUMC425MENGERSEG-MENGE數(shù)量QUAN13,326BSTMERSEG-BSTME單位UNIT327WRBTERSEG-WRBTE未稅金額CURR13,228MWSKZRSEG-MWSKZ稅碼CHAR229IVTAX稅率CHAR5依據(jù)RSEG-MWSKZ關(guān)聯(lián)表：A003、KONP，關(guān)聯(lián)條件：A003-MWSKZ=EKPO-MWSKZANDA003-KAPPL=‘TX’ANDA003-KSCHL=‘MWVS’ANDA003-ALAND=‘CN’ANDA003-KNUMH=KONP-KNUMH，獲?。篕BETR、KONWA；IVTAX=(KBTER/1000)KONWA30SLBTERSEG-WRBTE稅金額CURR13,2RSEG-WRBTE*IVTAX2.3邏輯關(guān)系：選擇屏幕“物料”、“供應(yīng)商”、“采購訂單”、“發(fā)票號(hào)”設(shè)置搜索幫助。權(quán)限對(duì)象：M_RECH_WRK檢查選擇屏幕“工廠”是否有權(quán)限，若無權(quán)限，提示“您無權(quán)查看工廠：XXXX相關(guān)數(shù)據(jù)”選擇屏幕“工廠”可手工輸入，也可通過搜索幫助來選擇輸入；需關(guān)聯(lián)表：T001W檢查手工輸入存在否，若不存在提示“工廠：XXXX不存在，請(qǐng)檢查?！边x擇屏幕“選擇日期”對(duì)應(yīng)“結(jié)束日期”需大于“開始日期”，否則提示“結(jié)束日期：XXXXXXXX不能小于開始日期”。依據(jù)選擇屏幕條件關(guān)聯(lián)表：RBKP、RSEG，條件：RBKP-TCODE=‘MIR7’獲取以上數(shù)據(jù)存放在內(nèi)表：ITAB中。若選擇屏幕“采購訂單”沒有輸入數(shù)據(jù)，則依據(jù)選擇屏幕條件關(guān)聯(lián)表：RBKP、RBMA，條件：RBKP-TCODE=‘MIR7’獲取以上數(shù)據(jù)存放在內(nèi)表：ITAB中；無需抓取RBMA-MENGE輸出。依據(jù)ITAB-BELNR關(guān)聯(lián)表：RBKP，條件：RBKP-STBLG=ITAB-BELNR，若可以抓取數(shù)據(jù)則從內(nèi)表：ITAB中排除對(duì)應(yīng)ITAB-BELNR所在數(shù)據(jù)。若選擇屏幕WFCFY=‘X’則輸出FKSTU=‘未提報(bào)付款’和FKSTU=‘部分提報(bào)付款’清單。ALV輸出。3技術(shù)說明ProgramnameZMMR3016TransactioncodeZMMR3016AuthorizationObjectM_RECH_WRKFormFormnameN/AOutputtypeN/AFormroutineN/A3.1程序邏輯：選擇屏幕：程序邏輯：（1）根據(jù)選擇屏幕輸入的工廠，進(jìn)行權(quán)限檢查

AUTHORITY-CHECK

OBJECT

'M_RECH_WRK'

ID

'ACTVT'

FIELD

'03'

ID

'WERKS'

FIELD

p_werks.（2）根據(jù)選擇屏幕條件關(guān)聯(lián)表RBKP和RSEG獲取TCODE等于MIR7的數(shù)據(jù)，如果選擇屏幕沒有輸入采購訂單號(hào)，則增加關(guān)聯(lián)表RBKP和RBMA獲取TCODE等于MIR7的數(shù)據(jù)如果以上沒有取到數(shù)據(jù)，則提示用戶消息并返回選擇屏幕（3）所取得的發(fā)票號(hào)若存在沖銷發(fā)票RBKP-STBLG,則刪除（沖銷和被沖銷的發(fā)票皆刪除）

SELECT

stblg

INTO

TABLE

lt_belnr

FROM

rbkp

FOR

ALL

ENTRIES

IN

gt_rsepo

WHERE

stblg

=

gt_rsepo-belnr.（4）根據(jù)所取得的發(fā)票數(shù)據(jù)信息，關(guān)聯(lián)相關(guān)表取描述信息MAKT-MAKTX(物料描述)，T052U-TEXT1(付款條件描述),LFA1-NAME1(供應(yīng)商名稱)（5）根據(jù)發(fā)票號(hào)和年度，關(guān)聯(lián)表ZTFI003取付款申請(qǐng)單信息，根據(jù)發(fā)票號(hào)合計(jì)付款申請(qǐng)金額和實(shí)付金額（6）關(guān)聯(lián)表A003和KONP取稅率，并用發(fā)票RSEG-WRBTR乘以稅率取得稅金額

SELECT

a003~mwskz

konp~kbetr

INTO

TABLE

gt_trate

FROM

a003

INNER

JOIN

k