007第十篇 SAP ECC数据源合集

以下是SAP ECC中各主要数据源与描述 

方便各位开发顾问查询

BW SD MM FI 常用 数据源

BW SD MM FI 数据源

MM Data Sources Tables Purchasing

2LIS_02_SCLEKKO, EKBE,T001, T001W, EKET, EKPA.

2LIS_02_HDREKKO, EKBE,T001, EKPA.

2LIS_02_ITMEKKO, EKBE,T001, T001W, EKPO, TMCLVBW, T027C, ESSR, T147K, T147

2LIS_02_SCNEKET, EKES, EKPO.2LIS_02_CGR EKBE, EKES, EKPO.

2LIS_02_SGREKET, EKBE,KKPO

Inventory

2LIS_03_BX

stock tables,

MCHA, MARA, T001, T001W, CALCULATEDFROM MBEW, EBEW, QBEW.

2LIS_03_BFMSEG, MBEW,MKPF.

2LIS_03_UMBKPF, MBEW,QBEW, EBEW, BSEG.

MM Purchasing Datasources

ODS 0PUR_O012LIS_02_ITM,2LIS_02_SGR, 2LIS_02_CGR, 2LIS_02_SCN.

0PUR_O022LIS_02_HDR,

0PUR_O01

0PUR_DS032LIS_02_SCLand 2LIS_02_SGR.

CUBE 0PUR_C102LIS_02_SCLand 2LIS_02_SGR.

0PUR_C070PUR_C08

0PUR_C090PUR_O02,80PUR_O01, 2LIS_02_HDR 0SRV_C01 2LIS_02_S174

0PUR_C042LIS_02_S011,2LIS_02_SCL, 2LIS_02_ITM, 2LIS_02_HDR

0PUR_C012LIS_02_S012,2LIS_02_ITM, 2LIS_02_SCL

0PUR_C022LIS_02_S013

0PUR_C050MM_PUR_VE_01

0PUR_C060MM_PUR_VE_02

0PUR_C032LIS_02_S015

Inventory Management

CUBE 0IC_C03

2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM0IC_C02 2LIS_03_S195, 2LIS_03_S197 0IC_C01 2LIS_03_S196, 2LIS_03_S198

SD Data sources Tables

2LIS_11_VAKONVBUK, VBUP,VBAK, VBAP, VBKD, KOMV, T001.

2LIS_11_VAHDR VBAK, VBUK, T001

2LIS_11_VAITMVBAP, VBUP,VBAK, VBKD, VBAJP, T001, VBUK, PRPS.

2LIS_11_VASCLVBAP, VBUP,VBAK, VBEP, VBKD, T001, PRPS

2LIS_11_VASTHVBUK

2LIS_11_VASTIVBUP, VBUK

2LIS_11_V_ITMVBAP, VBAK,VBKD, VBUP, T001, PRPS, VBUK.

2LIS_11_V_SCLVBUP, VBEP,VBKD, VBAP, VBAK, T001, PRPS.

2LIS_11_V_SSLVBAP, VBEP,LIPS, WVBEP, VBUP

2LIS_13_VDKONVBUK, VBRP,KOMV, T001, VBRK.

FI DATASOURCES Tables Cost Center

Accounting

0CO_OM_CCA_1COSP,COSS

0CO_OM_CCA_2COSP, COSS

0CO_OM_CCA_3COSL, COKL.

0CO_OM_CCA_4COSR

0CO_OM_CCA_5COSB

0CO_OM_CCA_6COOMCO

0CO_OM_CCA_7BPJA, BPPE.

0CO_OM_CCA_8COST,TKA07,COOMCO, CSLA, COST, COKL.

0CO_OM_CCA_9COVP(COEP& COBK), COSP, COST, COEJ, COEP, T001.

0CO_OM_CCA_10COOI,COSP_VTYPE.

Product Cost Controlling

0CO_PC_PCP_01KEKO, TCKH3,TCKH8.

0CO_PC_PCP_02KEKO, TCKH3.

0CO_PC_PCP_03CKIS, T001K,TKA02, KEKO, MARA, MBEW.

0CO_PC_PCP_04CKIS, T001K,TKA02, KEKO, MBEW, MARA

0CO_PC_01AUFK, AFPO,COSS, COSP, COSB, COSL, COKEY, TKA09, TKV09

0CO_PC_02AUFK, AFPO,COSS, COSP, COSB, COSL, COKEY, TKA09, TKV09