SELECT
EKPO~EBELN
EKPO~EBELP
EKKO~BEDAT
EKPO~AFNAM
EKPO~MENGE
EKPO~MEINS
EKET~EINDT
EKPO~MATNR
EKKO~LIFNR
EKPO~BUKRS
EKPO~WERKS
EKPO~LGORT
INTO CORRESPONDING FIELDS OF TABLE I_PO
UP TO 30 ROWS
FROM EKPO
INNER JOIN EKKO
ON EKPO~EBELN = EKKO~EBELN
INNER JOIN EKET
ON EKPO~EBELN = EKET~EBELN
AND EKPO~EBELP = EKET~EBELP
WHERE EKPO~WERKS IN S_WERKS
AND EKKO~LIFNR IN S_LIFNR
AND EKKO~EBELN IN S_EBELN
AND EKKO~BEDAT IN S_BEDAT
AND EKPO~LOEKZ = ''.
结构是这么定义的
TYPES : BEGIN OF T_PO ,
EBELN TYPE EKPO-EBELN, "采购凭证号
EBELP TYPE EKPO-EBELP, "采购凭证的项目编号
MENGE TYPE EKPO-MENGE, "采购订单数量
MEINS TYPE EKPO-MEINS, "采购订单的计量单位
BEDAT TYPE EKKO-BEDAT, "采购凭证日期
EINDT TYPE EKET-EINDT, "项目的交货日期
MATNR TYPE EKPO-MATNR, "物料号
MAKTX TYPE MAKT-MAKTX, "物料描述
LIFNR TYPE EKKO-LIFNR, "供应商代码
NAME1 TYPE LFA1-NAME1,"供应商名称
EKORG TYPE EKKO-EKORG, "采购组织
EKGRP TYPE EKKO-EKGRP, "采购组
BUKRS TYPE EKPO-BUKRS, "公司代码
WERKS TYPE EKPO-WERKS, "工厂
LGORT TYPE EKPO-LGORT, "库存地点
AFNAM TYPE EKPO-AFNAM, "需求者/请求者姓名
END OF T_PO.
操蛋网上提供的一些什么垃圾信息