SAP R/3 or ECC DataSources for SAP BI 7.0

Financial Accounting: General Ledger:FI-GL (BKPF, BSEG Tables)
0FI_GL_1:General ledger: Transaction figures
0FI_GL_2:General ledger: Transaction figures - Cost of sales ledger
0FI_GL_4:General Ledger: Line Items with Delta Extraction
0FI_GL_6:General Ledger Sales Figures via Delta Extraction
0FI_GL_7:General Ledger Cost of Sales Ledger via Delta Extraction
0FI_GL_8:General Ledger: Statistical Key Figures
0FI_GL_10:General Ledger: Leading Ledger Balances
0FI_GL_14:General Ledger: Line Items of the Leading Ledger(New GL in ECC)

 0FI_TX_4: Taxes:General Ledger:Data for Tax on Sales/Purchases

 0ACAC_CALC:Manual Accruals: Calculated Accrual Values
0ACE_CALC_RESULT:Accrual Engine: Calculated Accrual Values

 Financial Accounting: Customers:FI-AR (BSIK, BSAK Tables)
0FI_AR_1:Customers: Transaction figures
0FI_AR_2:Customers: Item
0FI_AR_3:Customers: Line Items
0FI_AR_4:Customers: Line Items with Delta Extraction
0FI_AR_5:Customers: Payment History
0FI_AR_6:Customer Sales Figures via Delta Extraction
0FI_AR_7:Customer SGL Sales Figures via Delta Extraction
0FI_AR_8:Customer Credit Management. Central Data via Delta Extraction
0FI_AR_9:Customer Credit Management. Central Area Data via Delta Extraction
0FI_AR_10:Customer Payment Behavior via Delta Extraction

 Financial Accounting: Vendors:FI-AP (BSID, BSAD Tables)
0FI_AP_1:Vendors: Transaction figures
0FI_AP_2:Vendors: Item
0FI_AP_3:Vendors: Line Items
0FI_AP_4:Vendors: Line Items with Delta Extraction
0FI_AP_6:Vendor Sales Figures via Delta Extraction
0FI_AP_7:Vendor SGL Sales Figures using Delta Extraction

 Financial Accounting: Asset Accounting:FI-AA
0FI_AA_001:ANNUAL VALUES
0FI_AA_002:POSTED DEPRECIATION
0FI_AA_003:REVALUATION/YEAR
0FI_AA_004:INVESTMENT SUPPORT
0FI_AA_005:FI-AA: ACQUISITIONS
0FI_AA_006:TRANS. W/ VAL.ADJ.
0FI_AA_11:FI-AA: Transactions
0FI_AA_12:FI-AA: Posted Depreciation

 Master Data Financial Accounting in General:FI-IO
0GL_ACCOUNT_ATTR:Account Number
0GL_ACCOUNT_TEXT:Account Number
0ACCOUNT_0109_HIER:Account Number
0ACCT_TYPE_TEXT:Account Type
0BUS_AREA_TEXT:Business Area
0BUS_AREA_ATTR:Business Area
0CHRT_ACCTS_TEXT:Chart of Accounts
0CHRT_ACCTS_ATTR:Chart of Accounts
0COMPANY_TEXT:Company Code
0COMP_CODE_TEXT:Company Code
0COMP_CODE_ATTR:Company Code
0AC_DOC_TYP_TEXT:Document Type
etc..

 Master Data Financial Accounting: Asset Accounting:FI-AA-IO
0ASSET_CLAS_TEXT:Asset Class
0ASSET_ATTR:Asset Sub-number
0ASSET_TEXT:Asset Sub-number
0ASSET_ATTR_TEXT:Asset Sub-number with Description
0DEPRAREA_TEXT:Depreciation area real or derived
0ASSET_AFAB_ATTR:Depreciation Area Real or Derived
etc...

 Materials Management:MM-IM2LIS_03_BX:Stock Initialization for Inventory Management
2LIS_03_BF:Goods Movements From Inventory Management
2LIS_03_UM:Revaluations
etc..

 Materials Management:MM-PUR
2LIS_02_ACC:Purchasing Data (Account Level)
2LIS_02_HDR:Purchasing Data (Header Level)
2LIS_02_ITM:Purchasing Data (Item Level)
2LIS_02_SCL:Purchasing Data (Schedule Line Level)
2LIS_02_S011:Purchasing groups
etc...

 Materials Management Master Data:MM-IO
0DISMM_ATTR:MRP Type
0DISMM_TEXT:MRP Type
0MATL_GROUP_TEXT:Material Group
0MAT_VEND_ATTR:Material Number Compounded to vendor
0MATL_CAT_TEXT:Material Type
0WM_MVT_TYP_TEXT:Movement type for Warehouse Management
0PUR_GROUP_TEXT:Purchasing Group
0PURCH_ORG_TEXT:Purchasing Organization
0PUR_REASON_TEXT:Reason for Ordering
0VENDOR_ATTR:Vendor Number
0VENDOR_TEXT:Vendor Number
etc.....

 --------------------------------------------------------------------------------------------------------------------------
FI-GL 
Master data
0FIGL_IO

 FI-GL Line Item:
DSO
0FIGL_O02
Datasource/Infosource
 0FI_GL_4
--------------------------------------------------------------------------------------------------------------------------
FI-AP Transaction data

 0FIGL_IO

 DSO
0FIAP_O06

 Datasource/Infosource
0FI_AP_6
InfoCube
0FIAP_C02

Comments

anorange8 said…
Thanks a lot a lot for the info! really appreciate that:)
June 9, 2011 at 9:06 PM
Post a Comment

Popular posts from this blog

One stage stop to know all about BW Extractors-Part1

Image
Types of Extractors:               Application specific BW content extractors: Lo Extraction: Logistics refers to the process of getting a product or service to its desired location upon request which involves transportation, purchasing, warehousing etc. Main areas in logistics are: Sales and Distribution (SD) : application 11, 13, 08 (in LBWE T-code) Materials Management (MM) : application 03, 02 Logistics Execution (LE) : application 12 Quality Management : application 05 Plant Maintenance (PM) : application 04, 17 Customer Service (CS) : application 18 Project System (PS) : application 20 SAP Retail : application 40,43,44,45 How the data extraction happens? Extraction can be done using either Full update/delta update. Full load: Incase of logistic application, Full/Initiali
Read more

Generic Extraction via Function Module

How does the extraction API work in case you are extracting data using a self defined function module with generic delta? Sometimes, if your application or requirement makes it necessary, you have to create your own function module to extract the data from whatever sap system to bw. Therefore you normally make a copy of the standard fm 'RSAX_BIW_GET_DATA_SIMPLE'. To make this new function work for you, you have to realize the following. 1) The FM gets called by the extraction API for at least 2 times. First time is for initialization and from the 2nd time on it is for data extraction. 2) Right after the last data package (somehow you need to make sure that it is the last one) you have to raise the exception no_more_data. Example with lots of comments FUNCTION RSAX_BIW_GET_DATA_SIMPLE. *"-------------------------------------------------------------------------- *"*"Local interface: *" IMPORTING *" VALUE(I_REQUNR) TYPE SRSC_S_IF_SIMPLE-REQUN
Read more

COPA Extraction Step By Step in SAP BW

Image
COPA Extraction Step by Step: SAP R/3 or SAP ECC: 1. SAP R/3 or ECC goto T.Code KEB0 , In Function: Select Create  Control Parameters: Provide a New CO-PA DataSource Name:1_CO_PA%CL%ERK 2. Select your O perating C oncern, e.g.,IDES. 3. Select radio button Costing-based or Account-based as OC . 4.Select field names for partitioning.e.g. BUKRS (Company Code), Check 5.Click on Info Catalog (F7) 6. Select the Characteristics & Value fields & Keyfigures 7. Select the Package/Development Class for Workbench request 8. Edit your DataSource to select/Hide fields, Save. Datasource created successfully. 9. Extractor Checker or RSA3, extraction. SAP BW:   1. Replicate DataSource 2. Assign InfoSource 3. Transfer all the datasource elements to an InfoSource 4. Activate InfoSource 5. Create a InfoCube (Copy Str from InfoSource) 6. Create Dimension & Define and Assign it. 7. Check & Activate. 8. Create Transformation (Insert or Modify KF
Read more