1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 |
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_Z0014 TYPE TABLE OF CEPCT WITH HEADER LINE. "财务利润中心 DATA GT_Z0008 TYPE TABLE OF TVKBT WITH HEADER LINE. "销售片区代码 DATA GT_Z0009 TYPE TABLE OF T024E WITH HEADER LINE. "采购组织代码 DATA GT_Z0010 TYPE TABLE OF TVKOT WITH HEADER LINE. "销售组织代码 DATA GT_Z0011 TYPE TABLE OF TSPAT WITH HEADER LINE. "产品组代码 DATA GT_Z0012 TYPE TABLE OF T171T WITH HEADER LINE. "销售大区代码 DATA GT_Z0016 TYPE TABLE OF T003T WITH HEADER LINE. "凭证类型 DATA GT_Z0017 TYPE TABLE OF SKAT WITH HEADER LINE. "总账科目 DATA GT_Z0018 TYPE TABLE OF CSKU WITH HEADER LINE. "成本要素 DATA GT_Z0019 TYPE TABLE OF T134T WITH HEADER LINE. "物料类型 DATA GT_Z0020 TYPE TABLE OF T023T WITH HEADER LINE. "物料组 DATA GT_Z0021 TYPE TABLE OF T156T WITH HEADER LINE. "移动类型 DATA GT_Z0022 TYPE TABLE OF TVAKT WITH HEADER LINE. "销售凭证类型 DATA GT_Z0023 TYPE TABLE OF T053S WITH HEADER LINE. "现金流原因代码 DATA GT_Z0024 TYPE TABLE OF TCURT WITH HEADER LINE. "货币代码 DATA GT_Z0025 TYPE TABLE OF PA0001 WITH HEADER LINE. "员工工号 DATA GT_Z0026 TYPE TABLE OF M_WSOHA WITH HEADER LINE. "品类/分类模块代码 DATA GT_Z0027 TYPE TABLE OF TMFGT WITH HEADER LINE. "物料运输组(承运商) DATA GT_Z0028 TYPE TABLE OF ANKT WITH HEADER LINE. "固定资产分类 DATA GT_Z0030 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. 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_Z0014 FROM CEPCT WHERE KOKRS = 'CN00'. "bank account. useless skip! "sales office. SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0008 FROM TVKBT. "purchase org. SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0009 FROM T024E WHERE EKORG NE '0001'. "sales org. SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0010 FROM TVKOT WHERE VKORG NE '0001'. "product division. SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0011 FROM TSPAT. "销售大区(BZIRK) SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0012 FROM T171T. "凭证类型 SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0016 FROM T003T. "gl account. SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0017 FROM SKAT WHERE KTOPL = 'CACN'. "cost element. SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0018 FROM CSKU WHERE KTOPL = 'CACN'. "物料类型 SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0019 FROM T134T. "物料组. SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0020 FROM T023T. "MvT. SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0021 FROM T156T. "sales document type. SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0022 FROM TVAKT. "现金流原因代码 SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0023 FROM T053R WHERE BUKRS NOT IN ('0001','RECO','REOB','RERF','TH01'). "货币代码 SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0024 FROM TCURT. "员工工号 SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0025 FROM PA0001. "品类/分类模块代码 SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0026 FROM M_WSOHA. "物料运输组(承运商) SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0027 FROM TMFGT. "固定资产分类 SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0028 FROM ANKT. DELETE GT_Z0028 WHERE ANLKL+0(1) NE 'Z'. "特殊库存标识 SELECT * INTO CORRESPONDING FIELDS OF TABLE GT_Z0030 FROM T148T. |
本文作者: GavinDong
版权属于: GavinDong博客
文章链接: https://gavindong.com/1609.html
如果使用过程中遇到问题,可 **点击此处** 交流沟通。
版权所有,转载时必须以链接形式注明作者和原始出处及本声明。
评论列表(1条)
*字段名 描述 ajax备选类型(authid) 卡类型类型描述(authdesc)
*bukrs 公司代码 z0001 公司代码
*werks 工厂 z0002 工厂
*lgort 库存地点 z0003 库存地点
*matnr 物料号 z0004 物料号
*lifnr 供应商号 z0005 供应商号
*kunnr 客户号 z0006 客户号
*kostl 财务成本中心 z0007 财务成本中心
*prctr 财务利润中心 z0014 财务利润中心
*BANKL 银行账号 z0015 银行账号
*vkbur 销售片区代码 z0008 销售片区代码
*ekorg 采购组织代码 z0009 采购组织代码
*vkorg 销售组织代码 z0010 销售组织代码
*spart 产品组代码 z0011 产品组代码
*bzirk 销售大区代码 z0012 销售大区代码
*blart 凭证类型 z0016 凭证类型
*saknr 总账科目 z0017 总账科目
*kstar 成本要素 z0018 成本要素
*mtart 物料类型 z0019 物料类型
*matkl 物料组 z0020 物料组
*bwart 移动类型 z0021 移动类型
*auart 销售凭证类型 z0022 销售凭证类型
*rstgr 现金流原因代码 z0023 现金流原因代码
*waers 货币代码 z0024 货币代码
*pernr 员工工号 z0025 员工工号
*skopf 品类/分类模块代码 z0026 品类/分类模块代码
*mfrgr 物料运输组(承运商)
*anlkl 固定资产资产分类