SAP BW数据源和ECC TABLE 关系.doc

该部分的数据表包含了五个方面:
采购相关的数据;库存相关数据;销售相关数据;财务会计相关数据;成本核算相关数据。
1. MM Data Sources Tables Purchasing
2LIS_02_SCL: EKKO, EKBE, T001, T001W, EKET, EKPA
2LIS_02_HDR: EKKO, EKBE, T001, EKPA
2LIS_02_ITM: EKKO, EKBE, T001, T001W, EKPO, TMCLVBW, T027C, ESSR, T147K, T147
: EKET, EKES, EKPO
2LIS_02_CGR: EKBE, EKES, EKPO
2LIS_02_SGR: EKET, EKBE, KKPO
2. Stock Tables
2LIS_03_BF: MSEG, MBEW, MKPF
2LIS_03_UM: BKPF, MBEW, QBEW, EBEW, BSEG
MCHA, MARA, T001, T001W, CALCULATED FROM MBEW, EBEW, QBEW
3. SD Data sources Tables
2LIS_11_VAKON: VBUK, VBUP, VBAK, VBAP, VBKD, KOMV, T001
2LIS_11_VAHDR: VBAK, VBUK, T001
2LIS_11_VAITM: VBAP, VBUP, VBAK, VBKD, VBAJP, T001, VBUK, PRPS
2LIS_11_VASCL: VBAP, VBUP, VBAK, VBEP, VBKD, T001, PRPS
2LIS_11_VASTH: VBUK
2LIS_11_VASTI: VBUP, VBUK
2LIS_11_V_ITM: VBAP, VBAK, VBKD, VBUP, T001, PRPS, VBUK.
2LIS_11_V_SCL: VBUP, VBEP, VBKD, VBAP, VBAK, T001, PRPS.
2LIS_11_V_SSL: VBAP, VBEP, LIPS, WVBEP, VBUP
2LIS_13_VDKON: VBUK, VBRP, KOMV, T001, VBRK.
4. FI DATASOURCES Tables Cost Center Accounting
A_1 COSP,COSS
A_2 COSP, COSS
A_3 COSL, COKL
A_4 COSR
A_5 COSB
A_