聯(lián)芯科技ERP項(xiàng)目-技術(shù)文檔-MM-027-采購(gòu)申請(qǐng)執(zhí)行狀況清單-V1.2-20090820

DATE\@"yyyy-MM-dd"2009-10-29Version1.0PAGE1聯(lián)芯科技ERP項(xiàng)目 DATE\@"M/d/yyyy"10/29/2009Version1.0 聯(lián)芯科技ERP項(xiàng)目開(kāi)發(fā)規(guī)格書第I部分:需求模塊■MM MACROBUTTONCheckIt_CheckBox￡P(guān)P MACROBUTTONCheckIt_CheckBox￡SD MACROBUTTONCheckIt_CheckBox￡FI MACROBUTTONCheckIt_CheckBox￡CO MACROBUTTONCheckIt_CheckBox￡IP/FMMACROBUTTONCheckIt_CheckBox￡其它Spec編號(hào)LC_SPEC_MM_027短描述采購(gòu)申請(qǐng)執(zhí)行狀況報(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（必填）（關(guān)鍵用戶崗位/領(lǐng)導(dǎo)）要求日期20090607預(yù)計(jì)開(kāi)發(fā)天數(shù)（由功能顧問(wèn)與開(kāi)發(fā)顧問(wèn)評(píng)估）必填_____天是否有標(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何春紅初始文檔創(chuàng)建V1.12009-8-19何春紅增加權(quán)限對(duì)象及權(quán)限控制點(diǎn)。V1.22009-8-20何春紅增加選擇屏幕日期的取值字段

第II部分:詳細(xì)功能描述目的：顯示某一段時(shí)間內(nèi)采購(gòu)申請(qǐng)執(zhí)行狀況，如是否已轉(zhuǎn)采購(gòu)訂單及轉(zhuǎn)采購(gòu)訂單的數(shù)量等。功能描述:顯示某一定時(shí)間范圍內(nèi)采購(gòu)申請(qǐng)轉(zhuǎn)采購(gòu)定單的狀況運(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ī)類型(如無(wú)特殊需求，預(yù)設(shè)為激光打印機(jī))紙張大小(如無(wú)特殊需求，預(yù)設(shè)為A4橫印)語(yǔ)言(如無(wú)特殊需求，預(yù)設(shè)為中文)選擇屏幕： 日期：FROM：XXXX/XX/XXTO：XXXX/XX/XX(1)采購(gòu)申請(qǐng)審批狀態(tài)：（2）采購(gòu)申請(qǐng)執(zhí)行狀況：X(3)采購(gòu)組：FROM：XXXTO：XXX（4）采購(gòu)申請(qǐng)編號(hào)：FROM：XXXXXXXXTO：XXXXXXXX(5)物料號(hào)：FROM：XXXXXXXXXXXXTO：XXXXXXXXXXXX（6）工廠：FROM：XXXTO：XXX(7)物料組：FROM：XXXTOXXX(8)項(xiàng)目類別：X(9)：順序字段名稱字段技術(shù)名稱字段描述特殊需求1日期EBAN-FRGDT起始時(shí)間2采購(gòu)申請(qǐng)審批狀態(tài)EBAN-FRGKZ3采購(gòu)申請(qǐng)執(zhí)行狀況基于同一采購(gòu)申請(qǐng)的申請(qǐng)單號(hào)及行項(xiàng)目EBAN-BANFN+EBAN-BNFPO，取采購(gòu)申請(qǐng)數(shù)量EBAN-MENGE與采購(gòu)訂單數(shù)量EBAN-BSMNG的差值，即EBAN-MENGE-EBAN-BSMNG，當(dāng)差值等于零或等于負(fù)數(shù)時(shí)，顯示‘已關(guān)閉’；當(dāng)差值大于零時(shí)，顯示‘未關(guān)閉’。4采購(gòu)組EBAN-EKGRP5采購(gòu)申請(qǐng)編號(hào)EBAN-BANFN6物料號(hào)EBAN-MATNR7工廠EBAN-WERKS8物料組EBAN-MATKL9項(xiàng)目類別EBAN-PSTYP采購(gòu)憑證中的項(xiàng)目類別報(bào)表/表單的字段順序字段名稱字段技術(shù)名稱字段描述特殊需求1采購(gòu)申請(qǐng)編號(hào)EBAN-BANFN2采購(gòu)申請(qǐng)批準(zhǔn)日期EBAN-FRGDT采購(gòu)申請(qǐng)批準(zhǔn)日期3采購(gòu)申請(qǐng)創(chuàng)建者EBAN-ERNAM創(chuàng)建對(duì)象的人員名稱4物料號(hào)EBAN-MATNR5短文本EBAN-TXZ016采購(gòu)申請(qǐng)數(shù)量EBAN-MENGE7采購(gòu)組EBAN-EKGRP8采購(gòu)訂單編號(hào)EKPO-EBELN通過(guò)采購(gòu)訂單編號(hào)+行項(xiàng)目EKPO-EBELN+EKPO-EBELP對(duì)應(yīng)采購(gòu)申請(qǐng)?zhí)?行項(xiàng)目EKPO-BANFN+EKPO-BNFPO，如能對(duì)應(yīng)上，則取采購(gòu)訂單編號(hào)EKKO-EBELN；如對(duì)應(yīng)不上，則取空值。9項(xiàng)目號(hào)EBAN-EBELP采購(gòu)訂單行項(xiàng)目號(hào)10采購(gòu)訂單數(shù)量EBAN-BSMNG對(duì)應(yīng)于采購(gòu)申請(qǐng)的訂貨數(shù)量11采購(gòu)訂單日期EBAN-BEDAT12供應(yīng)商EKKO-LIFNR13采購(gòu)申請(qǐng)未清數(shù)量未轉(zhuǎn)采購(gòu)訂單的數(shù)量同一采購(gòu)申請(qǐng)下達(dá)采購(gòu)訂單數(shù)量的合計(jì)–采購(gòu)申請(qǐng)數(shù)量14工廠EBAN-WERKS格式/屏幕設(shè)計(jì)：ALV格式邏輯關(guān)系：1、排除采購(gòu)申請(qǐng)（EBAN-LOEKZ）與采購(gòu)訂單（EKPO-LOEKZ）已刪除的行項(xiàng)目。2、基于同一采購(gòu)申請(qǐng)的申請(qǐng)單號(hào)及行項(xiàng)目EBAN-BANFN+EBAN-BNFPO，取采購(gòu)申請(qǐng)數(shù)量EBAN-MENGE與采購(gòu)訂單數(shù)量EBAN-BSMNG的差值，即EBAN-MENGE-EBAN-BSMNG，當(dāng)差值等于零或等于負(fù)數(shù)時(shí)，顯示‘已關(guān)閉’；當(dāng)差值大于零時(shí)，顯示‘未關(guān)閉’。3、采購(gòu)訂單編號(hào)：通過(guò)采購(gòu)訂單編號(hào)+行項(xiàng)目EKKO-EBELN+EKKO-EBELP對(duì)應(yīng)采購(gòu)申請(qǐng)?zhí)?行項(xiàng)目EKPO-BANFN+EKPO-BNFPO，如能對(duì)應(yīng)上，則取采購(gòu)訂單編號(hào)EKKO-EBELN；如對(duì)應(yīng)不上，則取空值。4、采購(gòu)申請(qǐng)未清數(shù)量：同一采購(gòu)申請(qǐng)下達(dá)采購(gòu)訂單數(shù)量的合計(jì)–采購(gòu)申請(qǐng)數(shù)量。5、EBAN與EKPO通過(guò)采購(gòu)申請(qǐng)編號(hào)+行項(xiàng)目關(guān)聯(lián)EBAN-BANFN+EKPO-BNFPO。6、EKKO與EKPO通過(guò)采購(gòu)訂單編號(hào)EKKO-EBELN關(guān)聯(lián)。7、權(quán)限控制點(diǎn)為采購(gòu)申請(qǐng)中的采購(gòu)組，權(quán)限對(duì)象為M_BANF_EKG。樣張：其它內(nèi)容：

第III部分:技術(shù)說(shuō)明ProgramnameZ_MM_EXEC_PURCHASE_EXETransactioncodeZMM027AuthorizationObjectM_BANF_EKGFormFormnameN/AOutputtypeN/AFormroutineN/A程序邏輯：選擇屏幕，選擇相應(yīng)的條件，在ALV顯示相應(yīng)的數(shù)據(jù)。**

*

START-OF-SELECTION

*

**

START-OF-SELECTION.

PERFORM

frm_get_data."得到數(shù)據(jù)

PERFORM

frm_add_fieldcat.

"增加fieldcat

PERFORM

frm_display_alv.

"顯示ALV程序當(dāng)最主要的邏輯就是FRM_GET_DATA這個(gè)子過(guò)程，主要通過(guò)連接EBAN\EKKO\EKPO這三個(gè)透明表得到相應(yīng)的數(shù)據(jù)代碼如下：從EBAN里取出相應(yīng)的數(shù)據(jù)：

SELECT

banfn

"采購(gòu)申請(qǐng)?zhí)?/p>

frgdt

"采購(gòu)申請(qǐng)批準(zhǔn)日期

ernam

"創(chuàng)建對(duì)象人員名稱

matnr

"物料號(hào)

"maktx

"物料描述

txz01

"短文本

menge

AS

menge1

"采購(gòu)申請(qǐng)數(shù)量

ekgrp

"采購(gòu)組

ebeln

"采購(gòu)訂單編號(hào)

ebelp

"采購(gòu)訂單行項(xiàng)目

bsmng

AS

menge2

"采購(gòu)訂單數(shù)量

"c~bedat

"采購(gòu)訂單日期

"

c~lifnr

"供應(yīng)商

*

werks

"工廠

*

loekz

"刪除標(biāo)記

FROM

eban

"AS

a

LEFT

OUTER

JOIN

ekpo

AS

b

ON

b~banfn

=

a~banfn

AND

b~bnfpo

=

a~bnfpo

"INNER

JOIN

ekko

AS

c

ON

c~ebeln

=

b~ebeln

INTO

CORRESPONDING

FIELDS

OF

TABLE

gt_out

WHERE

frgkz

IN

s_date

AND

frgkz

IN

s_frgkz

AND

ekgrp

IN

s_ekgrp

AND

banfn

IN

s_banfn

AND

matnr

IN

s_matnr

AND

werks

IN

s_werks

AND

matkl

IN

s_matkl

AND

pstyp

IN

s_pstyp

AND

loekz

=

''."and

b~LOEKZ

=

''.增加采購(gòu)訂單信息，并刪除采購(gòu)訂單為空的記錄：代碼如下：

SELECT

a~ebeln

a~bedat

a~lifnr

b~werks

b~loekz

FROM

ekko

AS

a

INNER

JOIN

ekpo

AS

b

ON

b~ebeln

=

a~ebeln

INTO

TABLE

gt_ekko

FOR

ALL

ENTRIES

IN

gt_out

WHERE

a~ebeln

=

gt_out-ebeln

AND

b~ebelp

=

gt_out-ebelp.

LOOP

AT

gt_out

INTO

gs_out

.

READ

TABLE

gt_ekko

INTO

gs_ekko

WITH

KEY

ebeln

=

gs_out-ebeln.

IF

sy-subrc

=

0.

gs_out-bedat

=

gs_ekko-bedat.

gs_out-lifnr

=

gs_ekko-lifnr.

gs_out-werks

=

gs_ekko-werks.

gs_out-loekz

=

gs_ekko-loekz.

IF

gs_out-loekz

<>

''.

DELETE

gt_out.

ELSE.

MODIFY

gt_out

FROM

gs_out.

ENDIF.

ENDIF.

ENDLOOP.在255行，處理多個(gè)采購(gòu)申請(qǐng)單處理多個(gè)采購(gòu)訂單的情況，以采購(gòu)申請(qǐng)單進(jìn)行累加：

LOOP

AT

gt_out

INTO

gs_out.

gs_all

=

gs_out.

AT

END

OF

matnr.

SUM.

gs_all-menge2

=

gs_out-meng