SAP BW中SD MM FI 常用 数据源

SAP BW中SD MM FI 常用 数据源

本文转自：http://zhan.renren.com/menfanyu?checked=true

 

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

 

2LIS_02_SCN EKET, EKES, EKPO. 2LIS_02_CGR EKBE, EKES, EKPO.

 

2LIS_02_SGR EKET, EKBE, KKPO

 

Inventory

 

2LIS_03_BX

 

stock tables,

 

MCHA, MARA, T001, T001W, CALCULATED FROM MBEW, EBEW, QBEW.

 

2LIS_03_BF MSEG, MBEW, MKPF.

 

2LIS_03_UM BKPF, MBEW, QBEW, EBEW, BSEG.

 

MM Purchasing Datasources

 

ODS 0PUR_O01 2LIS_02_ITM, 2LIS_02_SGR, 2LIS_02_CGR, 2LIS_02_SCN.

 

0PUR_O02 2LIS_02_HDR,

 

0PUR_O01

 

0PUR_DS03 2LIS_02_SCL and 2LIS_02_SGR.

 

CUBE 0PUR_C10 2LIS_02_SCL and 2LIS_02_SGR.

 

0PUR_C07 0PUR_C08

 

0PUR_C09 0PUR_O02, 80PUR_O01, 2LIS_02_HDR 0SRV_C01 2LIS_02_S174

 

0PUR_C04 2LIS_02_S011, 2LIS_02_SCL, 2LIS_02_ITM, 2LIS_02_HDR

 

0PUR_C01 2LIS_02_S012, 2LIS_02_ITM, 2LIS_02_SCL

 

0PUR_C02 2LIS_02_S013

 

0PUR_C05 0MM_PUR_VE_01

 

0PUR_C06 0MM_PUR_VE_02

 

0PUR_C03 2LIS_02_S015

 

Inventory Management

 

CUBE 0IC_C03

 

2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM 0IC_C02 2LIS_03_S195, 2LIS_03_S197 0IC_C01 2LIS_03_S196, 2LIS_03_S198

 

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.

 

FI DATASOURCES Tables Cost Center Accounting

 

0CO_OM_CCA_1 COSP,COSS

 

0CO_OM_CCA_2 COSP, COSS

 

0CO_OM_CCA_3 COSL, COKL.

 

0CO_OM_CCA_4 COSR

 

0CO_OM_CCA_5 COSB

 

0CO_OM_CCA_6 COOMCO

 

0CO_OM_CCA_7 BPJA, BPPE.

 

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

 

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

 

0CO_OM_CCA_10 COOI, COSP_VTYPE.

 

Product Cost Controlling

 

0CO_PC_PCP_01 KEKO, TCKH3, TCKH8.

 

0CO_PC_PCP_02 KEKO, TCKH3.

 

0CO_PC_PCP_03 CKIS, T001K, TKA02, KEKO, MARA, MBEW.

 

0CO_PC_PCP_04 CKIS, T001K, TKA02, KEKO, MBEW, MARA

 

0CO_PC_01 AUFK, AFPO, COSS, COSP, COSB, COSL, COKEY, TKA09, TKV09

 

0CO_PC_02 AUFK, AFPO, COSS, COSP, COSB, COSL, COKEY, TKA09, TKV09