Scribd
Upload
1K views2 pages

BW SD MM FI Data Sources Overview

The document lists SAP data sources tables used for business warehouse (BW) extraction from SAP modules including sales and distribution (SD), materials management (MM), and financial accounting (FI). It provides details of the data sources and tables used for key BW objects including operational data stores (ODS) and cubes related to purchasing, inventory management, sales, and cost center accounting in FI and product cost controlling.

Uploaded by

manikantaramisetty
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1K views2 pages

BW SD MM FI Data Sources Overview

The document lists SAP data sources tables used for business warehouse (BW) extraction from SAP modules including sales and distribution (SD), materials management (MM), and financial accounting (FI). It provides details of the data sources and tables used for key BW objects including operational data stores (ODS) and cubes related to purchasing, inventory management, sales, and cost center accounting in FI and product cost controlling.

Uploaded by

manikantaramisetty
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

SAP Community Netw ork

Log In Register About Us How to Contribute


Welcome Guest

SDN Community BPX Community BusinessObjects University Alliances SAP EcoHub


Home Forums Wiki Blogs Articles eLearning Downloads Code Exchange Career Center Events InnoCentive Idea Place

My Home > Business Intelligence > … Data Extraction > BW SD MM FI DATASOURCES Brow se Search

BW SD MM FI DATASOURCES Tools
Added by Krish, last edited by Arun Varadarajan on Jul 28, 2009 (view change)
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.

converted by W eb2PDFConvert.com
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

Child Pages (1) Hide Child Pages | View in Hierarchy


BW SD MM FI Data Sources

Contact Us Site Index Marketing Opportunities Legal Terms Privacy Impressum


Powered by SAP NetWeaver

converted by W eb2PDFConvert.com

You might also like