ABAP-批导采购订单
*&---------------------------------------------------------------------*
*& Report ZMMR_034
*&---------------------------------------------------------------------*
*& Responsibility
*&---------------------------------------------------------------------*
*& Program Name : 采购订单批量导入
*& Date written : 2018.04.07
*& Author's name : Li Jun
*& Last update : 2018.04.11
*& Program title : 采购订单批量导入
*& Project Name : 安全集团
*& Version : Ver.1.0
*&---------------------------------------------------------------------*
*& Description : (Incl. Related Function Area and System)
*&---------------------------------------------------------------------*
*& Change History
*&---------------------------------------------------------------------*
*& Date | Programmer | Corr. # | Description
*&
*&
*&---------------------------------------------------------------------*
REPORT zmmr_034.
*----------------------------------------------------------------------*
* INCLUDE *
*----------------------------------------------------------------------*
INCLUDE <list>.
INCLUDE <icon>.
*----------------------------------------------------------------------*
* CONSTANTS *
*----------------------------------------------------------------------*
CONSTANTS :
* 常量定义
BEGIN OF gc_con,
dow(4) TYPE c VALUE 'FC01', "下载按钮
objid TYPE wwwdatatab-objid VALUE 'ZMMR_034', "SAP WWW 网关对象名
waers TYPE ekko-waers VALUE 'CNY', "货币码
END OF gc_con,
* EXCEL文件行和列
BEGIN OF gc_line,
begin_row TYPE i VALUE '5', "起始行
begin_col TYPE i VALUE '2', "起始单元格
end_row TYPE i VALUE '65535', "终了行
end_col TYPE i VALUE '45', "终了单元格
END OF gc_line,
* 科目分配类别
BEGIN OF gc_knttp,
p TYPE eban-knttp VALUE 'P', "项目
s TYPE eban-knttp VALUE 'S', "展会类
a TYPE eban-knttp VALUE 'A', "资产
k TYPE eban-knttp VALUE 'K', "成本中
END OF gc_knttp.
*----------------------------------------------------------------------*
* TABLES *
*----------------------------------------------------------------------*
TABLES sscrfields.
*----------------------------------------------------------------------*
* TYPES *
*----------------------------------------------------------------------*
TYPES: BEGIN OF ty_upload,
icon TYPE string, "状态
remark TYPE string, "消息
number TYPE i, "序号
bedat TYPE string, "凭证日期
bsart TYPE string, "采购订单类型
lifnr TYPE string, "供应商编码
waers TYPE string, "货币
bukrs TYPE string, "公司代码
ekorg TYPE string, "采购组织
ekgrp TYPE string, "采购组
zterm TYPE string, "付款条件
ebeln TYPE string, "采购订单号
ebelp TYPE string, "采购订单行项目
werks TYPE string, "工厂
knttp TYPE string, "科目分配类别
matnr TYPE string, "物料编码
txz01 TYPE string, "物料描述
matkl TYPE string, "物料组
menge TYPE string, "采购数量
meins TYPE string, "订单单位
netwr TYPE string, "净价
peinh TYPE string, " 价格单位
bprme TYPE string, " 订单价格单位(采购)
mwskz TYPE string, "税码
eindt TYPE string, "交货日期
lgort TYPE string, " 库存地点
uebtk TYPE string, " 标识:允许未限制的过量交货
retpo TYPE string, " 退货标识
kostl TYPE string, "成本中心
anln1 TYPE string, "固定资产编号
sakto TYPE string, "总账科目
zcgpp TYPE string, " 采购品牌
kschl1 TYPE string, " 条件类型1
kbetr1 TYPE string, " 条件金额1
kpein1 TYPE string,