常用主数据表
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'.