Saturday, January 1, 2011

SAP R/3 or ECC DataSources for SAP BI 7.0

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_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
0ACAC_CALC:Manual Accruals: Calculated Accrual Values
0FI_TX_4:Taxes: Line Items by Means of Delta Extraction
0ACE_CALC_RESULT:Accrual Engine: Calculated Accrual Values

Financial Accounting: Customers:FI-AR (BSID, BSAD 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 Managemt. Central Data via Delta Extraction
0FI_AR_9:Customer Credit Managmt. Cntrl Area Data via Delta Extractn
0FI_AR_10:Customer Payment Behavior via Delta Extraction

Financial Accounting: Vendors:FI-AP (BSID, BSAK 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 Extrcation
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 Depreciations

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:Businees 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 Subnumber
0ASSET_TEXT:Asset Subnumber
0ASSET_ATTR_TEXT:Asset Subnumber 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.....

1 comment: