?問題：SAP系統(tǒng)沒有標(biāo)準(zhǔn)的庫齡分析報表，這個報表出具如何處理？

??????? ?解決辦法：

?????????1、可以通過批次管理，然后再財務(wù)進行FIFO評估，但是這個辦法經(jīng)測試發(fā)現(xiàn)實現(xiàn)比較麻煩。

???????? 2、通過如下方法可以實現(xiàn)。

???????????? MC46查找?guī)齑娴拇糌洈?shù)量。

??????????? 通過query制作一個庫存信息表（含價格）。

?????????? 在系統(tǒng)外通過EXCEL表的VLOOKUP功能即可以實現(xiàn)庫齡分析。

????????? ?如果大家還有什么問題可以通過MSN或郵件和我聯(lián)系。

方式二：ABAP開發(fā) 代碼如下：

*----------------------------------------------------------------------*
* Program?? : MM Stock Aging Report??????????????????????????????????? *
* Program ID: Z_RPMMIM_STOCK_AGING???????????????????????????????????? *
* Spec By?? : Winnie Tan?????????????????????????????????????????????? *
* Done by?? : Choon Seng (NCSNCS)????????????????????????????????????? *
* Date????? : 20 May 2002????????????????????????????????????????????? *
* Changed By:????????????????????????????????????????????????????????? *
* Last Upd? :????????????????????????????????????????????????????????? *
*----------------------------------------------------------------------*

*----------------------------------------------------------------------*
* Date????? : 3 July 2002????????????????????????????????????????????? *
* Changed By:? Chen Su??????????????????????????????????????????????????????? *
* Purpose? :?? modify aging logical???????????????????????????????????????????????????? *
*----------------------------------------------------------------------*

INCLUDE <LINE>.
* Tables used in the program
TABLES: LQUA,
??????? MBEW,
??????? MARA,
??????? MAKT,
??????? T001,
??????? T001K,
??????? T001W,
??????? T134T,
??????? MARD,
??????? MKPF,
??????? MSEG.

* Constants used in the program.
*CONSTANTS: const_yes(3) TYPE c VALUE "YES".

* Data variables used in the program.
DATA: SEL1 LIKE LQUA-WERKS,????? "PLANT
????? SEL2 LIKE MARA-MTART,????? "MATERIAL TYPE
????? SEL3 LIKE MARA-MATKL,????? "MATERIAL GROUP
????? SEL4 LIKE MARA-MATNR,????? "MATERIAL NO.
????? SERNO(4) TYPE C,
????? PLANT LIKE LQUA-WERKS,
????? MTYPE LIKE MARA-MTART,
????? MATNO LIKE MARA-MATNR,
????? COMPANY LIKE T001-BUTXT,
????? FDATE(10) TYPE C,
????? MTYPET LIKE T134T-MTBEZ,
????? PLANTT LIKE T001W-NAME1,
????? TMESSAGE(40) TYPE C,
????? ERR_DESC(60) TYPE C,
????? LINENO LIKE SY-LINNO,
????? PAGENO LIKE SY-PAGNO,
????? RIND TYPE C.

* Internal tables used in the program.
DATA: BEGIN OF T_RPTMAIN OCCURS 0,
???????? DURATION TYPE I,
???????? BAND TYPE C,
???????? STKVALUE LIKE MBEW-STPRS,
???????? ERR_CODE(2) TYPE C,
???????? MTART LIKE MARA-MTART,
???????? MATKL LIKE MARA-MATKL,
???????? MAKTG LIKE MAKT-MAKTG,
???????? VPRSV LIKE MBEW-VPRSV,
???????? PEINH LIKE MBEW-PEINH,
???????? VERPR LIKE MBEW-VERPR,
???????? STPRS LIKE MBEW-STPRS,
???????? BWART LIKE MSEG-BWART.
???????? INCLUDE STRUCTURE LQUA.
DATA: END OF T_RPTMAIN.

DATA: BEGIN OF T_MAKT OCCURS 0.
???????? INCLUDE STRUCTURE MAKT.

．．．

總結(jié)

以上是生活随笔為你收集整理的SAP的库龄分析表的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。