聯(lián)芯科技ERP項(xiàng)目-技術(shù)文檔-MM-027-采購申請執(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)目開發(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編號LC_SPEC_MM_027短描述采購申請執(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)先級MACROBUTTONCheckIt_RadiobuttonHigh/關(guān)鍵 MACROBUTTONUnCheckIt_RadiobuttonMid/推薦 MACROBUTTONCheckIt_RadiobuttonLow/可選用戶MACROBUTTONNextCell（必填）（關(guān)鍵用戶崗位/領(lǐng)導(dǎo)）要求日期20090607預(yù)計(jì)開發(fā)天數(shù)（由功能顧問與開發(fā)顧問評估）必填_____天是否有標(biāo)準(zhǔn)功能MACROBUTTONCheckIt_RadiobuttonYes MACROBUTTONUnCheckIt_RadiobuttonNo標(biāo)準(zhǔn)功能未采用的原因:MACROBUTTONCheckIt_RadiobuttonPerformanceMACROBUTTONCheckIt_RadiobuttonComplexityMACROBUTTONCheckIt_RadiobuttonOtherse參考的標(biāo)準(zhǔn)功能文檔變更歷史版本號文檔維護(hù)時(shí)間姓名簡要的描述V1.02009何春紅初始文檔創(chuàng)建V1.12009-8-19何春紅增加權(quán)限對象及權(quán)限控制點(diǎn)。V1.22009-8-20何春紅增加選擇屏幕日期的取值字段

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

第III部分:技術(shù)說明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è)子過程，主要通過連接EBAN\EKKO\EKPO這三個(gè)透明表得到相應(yīng)的數(shù)據(jù)代碼如下：從EBAN里取出相應(yīng)的數(shù)據(jù)：

SELECT

banfn

"采購申請?zhí)?/p>

frgdt

"采購申請批準(zhǔn)日期

ernam

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

matnr

"物料號

"maktx

"物料描述

txz01

"短文本

menge

AS

menge1

"采購申請數(shù)量

ekgrp

"采購組

ebeln

"采購訂單編號

ebelp

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

bsmng

AS

menge2

"采購訂單數(shù)量

"c~bedat

"采購訂單日期

"

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

=

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

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è)采購訂單的情況，以采購申請單進(jìn)行累加：

LOOP

AT

gt_out

INTO

gs_out.

gs_all

=

gs_out.

AT

END

OF

matnr.

SUM.

gs_all-menge2

=

gs_out-meng