Financial Management & Controlling (SAP HANA-Optimized)
Financial Accounting: Accounts Receivable (SAP HANA-Optimized)
Prerequisites
Defining Schema Mapping
Replicating SAP ERP Tables to SAP HANA
Assigning SQL Privileges for SAP_ECC Schema
Assigning SQL Privileges for BW System Schema
Activating BW Content and Generating SAP HANA Data Models
Activating SAP HANA Information Models
Queries
FI-AR: Reconciliation (Real Time) - /IMO/FIAR_M01_Q0001
FI-AR: Customer Overview (Last 7 Days) - /IMO/FIAR_M01_Q0002
FI-AR: Overdue (Real Time) - /IMO/FIAR_M01_Q0003
FI-AR: Payment History (Real Time) - /IMO/FIAR_M01_Q0004
FI-AR: Payment Reliability Trend (Real Time) - /IMO/FIAR_M01_Q00
FI-AR: Payment Forecast - /IMO/FIAR_M02_Q0001
FI-AR: Payment History - /IMO/FIAR_M03_Q0001
FI-AR: Payment Reliability Trend - /IMO/FIAR_M03_Q0002
FI-AR: Overdue - /IMO/FIAR_M03_Q0003
MultiProvider
FI Accounts Receivable - /IMO/FIAR_M01
FI-AR: Payment Forecast - /IMO/FIAR_M02
FI Accounts Receivable (BW Replicated) - /IMO/FIAR_M03
InfoCubes
FI-AR: Cleared Customer Line Items (SAP HANA Real Time) - /IMO/F
FI-AR: Open Customer Line Items (SAP HANA Real Time) - /IMO/FIAR
FI-AR: Payment Forecast (SAP HANA) - /IMO/FIAR_V03
DataStore Objects
FI-AR: Customer Line Items (1st Layer) - /IMO/FIAR_030
FI-AR: Customer Line Items - /IMO/FIAR_D30
InfoSources
FI-AR: Customer Line Items (0FI_AR_30) - /IMO/FIAR_IS30
Characteristics
Posting Key
Accounting Clerk
Customer Number Compounded with Company Code
SAP HANA Information Models
FI-AR: Customer Line Items: Cleared (for BW)
FI-AR: Customer Line Items: Open (for BW)
FI-AR: Customer Line Items: Payment Forecast (for BW)
Analytic View for BW DSO FI-AR: Customer Line Items
Financial Accounting: Accounts Payable (SAP HANA-Optimized)
Queries
FI-AP: Overdue Analysis - /IMO/FIAP_M01_Q0001
FI-AP: Vendor Due Date Analysis - /IMO/FIAP_M01_Q0002
MultiProvider
FI Accounts Payable - /IMO/FIAP_M01
DataStore Objects
FI-AP: Vendor Line Items - /IMO/FIAP_D30
InfoSource
FI-AP: Vendor Line Items (0FI_AP_30) - /IMO/FIAP_IS30
Financial Accounting: General Ledger (SAP HANA-Optimized)
Queries
FI-GL: Actuals: Balance and Flow Comparison - /IMO/FIGL_M01_Q000
FI-GL: Actuals/Plan/Budget: Balance and Flow Comparison - /IMO/F
FI-GL: New GL Actuals: Balance and Flow Comparison - /IMO/FIGL_M
FI-GL: New GL Actuals/Plan/Budget: Balance and Flow Comparison -
MultiProviders
General Ledger - /IMO/FIGL_M01
General Ledger (New) - /IMO/FIGL_M02
DataStore Objects
FI-GL: Line Items - /IMO/FIGL_D04
FI-GL: Balances - /IMO/FIGL_D06
FI-GL: New GL - Balances - /IMO/FIGL_D12
FI-GL: New GL - Line Items - /IMO/FIGL_D14
InfoSources
FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04
FI-GL: General Ledger: Balances (0FI_GL_6) - /IMO/FIGL_IS06
FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/FIGL_
FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIG
Enterprise Controlling: Profit Center Accounting (SAP HANA-Optim
Queries
EC-PCA: Actuals: Balance and Flow Comparison - /IMO/PCA_M01_Q000
EC-PCA: Actuals/Plan/Budget: Balance and Flow Comparison - /IMO/
EC-PCA: Statistical Key Figures - /IMO/PCA_M01_Q0003
MultiProviders
Profit Center Accounting - /IMO/PCA_M01
DataStore Objects
EC-PCA: Totals - /IMO/PCA_D01
EC-PCA: Statistical Key Figures - /IMO/PCA_D02
EC-PCA: Line Item - Actuals - /IMO/PCA_D03
EC-PCA: Line Items Periodic Transfer - Actuals - /IMO/PCA_D04
InfoSources
EC-PCA: Totals (0EC_PCA_1) - /IMO/PCA_IS01
EC-PCA: Statistical Key Figures (0EC_PCA_2) - /IMO/PCA_IS02
EC-PCA: Line Item - Actuals (0EC_PCA_3) - /IMO/PCA_IS03
EC-PCA: Line Items Periodic Transfer - Actuals (0EC_PCA_4) - /IM
Financial Accounting: Asset Accounting (SAP HANA-optimized)
DataStore Objects
FI-AA: Transactional and Annual Values - /IMO/FIAA_D11
FI-AA: Period Values - /IMO/FIAA_D12
InfoSources
FI-AA: Transactions (0FI_AA_11) - /IMO/FIAA_IS11
FI-AA: Posted Depreciations - Periodic Values (0FI_AA_12) - /IMO
MultiProvider
FIAA: Transactions, Annual and Period Values - /IMO/FIAA_M01
Queries
FI-AA: Asset History Sheet (per Period) - /IMO/FIAA_M01_Q0001
FI-AA: Transaction Data Report - /IMO/FIAA_M01_Q0002
FI-AA: Depreciations Posted - /IMO/FIAA_M01_Q0003
FI-AA: Comparison of Values - /IMO/FIAA_M01_Q0004