ABAP-批导期初库存
*&---------------------------------------------------------------------*
*& Report ZMMR_031
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT zmmr_031.
*----------------------------------------------------------------------*
* INCLUDE *
*----------------------------------------------------------------------*
INCLUDE <list>.
INCLUDE <icon>.
*----------------------------------------------------------------------*
* CONSTANTS *
*----------------------------------------------------------------------*
CONSTANTS :
* 常量定义
BEGIN OF gc_con,
dow(4) TYPE c VALUE 'FC01', "下载按钮
objid TYPE wwwdatatab-objid VALUE 'ZMMR_031', "SAP WWW 网关对象名
END OF gc_con,
* EXCEL文件行和列
BEGIN OF gc_line,
begin_row TYPE i VALUE '4', "起始行
begin_col TYPE i VALUE '2', "起始单元格
end_row TYPE i VALUE '65535', "终了行
end_col TYPE i VALUE '18', "终了单元格
END OF gc_line.
*----------------------------------------------------------------------*
* TABLES *
*----------------------------------------------------------------------*
TABLES sscrfields.
*----------------------------------------------------------------------*
* TYPES *
*----------------------------------------------------------------------*
TYPES:
* 上传用
BEGIN OF ty_upload,
icon TYPE string, "状态
remark TYPE string, "消息
zeile TYPE i, "物料凭证中的项目
filed01 TYPE string, "项目01
filed02 TYPE string, "项目02
filed03 TYPE string, "项目03
filed04 TYPE string, "项目04
filed05 TYPE string, "项目05
filed06 TYPE string, "项目06
filed07 TYPE string, "项目07
filed08 TYPE string, "项目08
filed09 TYPE string, "项目09
filed10 TYPE string, "项目10
filed11 TYPE string, "项目11
filed12 TYPE string, "项目12
filed13 TYPE string, "项目13
filed14 TYPE string, "项目14
filed15 TYPE string, "项目15
filed16 TYPE string, "项目16
filed17 TYPE string, "项目17
END OF ty_upload,
* 出力用
BEGIN OF ty_alv,
zeile TYPE i, "物料凭证中的项目
budat TYPE mkpf-budat, "过帐日期
werks TYPE mseg-werks, "工厂
lgort TYPE mseg-lgort, "库位
matnr TYPE mseg-matnr, "物料编码
maktx TYPE makt-maktx, "物料描述
menge TYPE mseg-menge, "数量
meins TYPE mseg-meins, "计量单位
exbwr TYPE mseg-exbwr, "库存金额
bwart TYPE mseg-bwart, "移动类型
* sobkz TYPE mseg-sobkz, "特殊库存
* posid TYPE prps-posid, "WBS 元素
icon TYPE string, "状态
remark TYPE string, "消息
number TYPE i, "序号
END OF ty_alv.
*----------------------------------------------------------------------*
* DATA *
*----------------------------------------------------------------------*
* 全局内表定义
DATA: gt_upload TYPE STANDARD TABLE OF ty_upload, "上传
gt_alv TYPE STANDARD TABLE OF ty_alv, "出力
gt_alv2 TYPE STANDARD TABLE OF ty_alv, "出力
gt_fieldcat TYPE slis_t_fieldcat_alv, "ALV控制
gt_sort TYPE slis_t_sortinfo_alv, "ALV排序
* 全局构造定义
gs_fieldcat TYPE slis_fieldcat_alv,