SAP的库龄分析表

 问题:SAP系统没有标准的库龄分析报表,这个报表出具如何处理?

         解决办法:

         1、可以通过批次管理,然后再财务进行FIFO评估,但是这个办法经测试发现实现比较麻烦。

         2、通过如下方法可以实现。

             MC46查找库存的呆货数量。

            通过query制作一个库存信息表(含价格)。

           在系统外通过EXCEL表的VLOOKUP功能即可以实现库龄分析。

           如果大家还有什么问题可以通过MSN或邮件和我联系。

方式二:ABAP开发 代码如下:

*----------------------------------------------------------------------*
* 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.

...

相关内容推荐