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:)

Popular posts from this blog

One stage stop to know all about BW Extractors-Part1

COPA Extraction Step By Step in SAP BW

How does a datasource communicates "DELTA" with BW?