常用主数据表

DATA GT_Z0001 TYPE TABLE OF T001  WITH HEADER LINE.   "公司代码"
DATA GT_Z0002 TYPE TABLE OF T001W WITH HEADER LINE.   "工厂"
DATA GT_Z0003 TYPE TABLE OF T001L WITH HEADER LINE.   "库存地点"
DATA GT_Z0004 TYPE TABLE OF MAKT  WITH HEADER LINE.   "物料描述"
DATA GT_Z0005 TYPE TABLE OF LFA1  WITH HEADER LINE.   "供应商号"
DATA GT_Z0006 TYPE TABLE OF KNA1  WITH HEADER LINE.   "客户号"
DATA GT_Z0007 TYPE TABLE OF CSKT  WITH HEADER LINE.   "财务成本中心"
DATA GT_Z0008 TYPE TABLE OF CEPCT WITH HEADER LINE.   "财务利润中心"
DATA GT_Z0009 TYPE TABLE OF TVKBT WITH HEADER LINE.   "销售片区代码"
DATA GT_Z0010 TYPE TABLE OF T024E WITH HEADER LINE.   "采购组织代码"
DATA GT_Z0011 TYPE TABLE OF TVKOT WITH HEADER LINE.   "销售组织代码"
DATA GT_Z0012 TYPE TABLE OF TSPAT WITH HEADER LINE.   "产品组代码"
DATA GT_Z0013 TYPE TABLE OF T171T WITH HEADER LINE.   "销售大区代码"
DATA GT_Z0014 TYPE TABLE OF T003T WITH HEADER LINE.   "凭证类型"
DATA GT_Z0015 TYPE TABLE OF SKAT  WITH HEADER LINE.   "总账科目"
DATA GT_Z0016 TYPE TABLE OF CSKU  WITH HEADER LINE.   "成本要素"
DATA GT_Z0017 TYPE TABLE OF T134T WITH HEADER LINE.   "物料类型"
DATA GT_Z0018 TYPE TABLE OF T023T WITH HEADER LINE.   "物料组"
DATA GT_Z0019 TYPE TABLE OF T156T WITH HEADER LINE.   "移动类型"
DATA GT_Z0020 TYPE TABLE OF TVAKT WITH HEADER LINE.   "销售凭证类型"
DATA GT_Z0021 TYPE TABLE OF T053S WITH HEADER LINE.   "现金流原因代码"
DATA GT_Z0022 TYPE TABLE OF TCURT WITH HEADER LINE.   "货币代码"
DATA GT_Z0023 TYPE TABLE OF PA0001 WITH HEADER LINE.  "员工工号"
DATA GT_Z0024 TYPE TABLE OF M_WSOHA WITH HEADER LINE. "品类/分类模块代码"
DATA GT_Z0025 TYPE TABLE OF TMFGT WITH HEADER LINE.   "物料运输组(承运商)"
DATA GT_Z0026 TYPE TABLE OF ANKT  WITH HEADER LINE.   "固定资产分类"
DATA GT_Z0027 TYPE TABLE OF T148T WITH HEADER LINE.   "特殊库存标识"

获取数据

"company code."
SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0001 FROM T001 WHERE KTOPL = 'CACN'.
"plant."
SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0002 FROM T001W WHERE WERKS NE '0001'.
"storage location."
SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0003 FROM T001L WHERE WERKS NE '0001'. 
"material number description."
SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0004 FROM MAKT.
"vendor number."
SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0005 FROM LFA1. 
"customer number."
SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0006 FROM KNA1. 
"cost center."
SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0007 FROM CSKT WHERE KOKRS = 'CN00'. 
"profit center."
SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0008 FROM CEPCT WHERE KOKRS = 'CN00'.