主数据
-
SAP常用主数据及描述取数
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112DATA 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. -
彻底删除SAP利润中心主数据
0KE1 delete transactions0KE2 delete Master data(没有业务数据时才能用) KE54是打删除标记!