Sales and Distribution (SAP HANA-Optimized)
Prerequisites
Activating Data Extraction in Logistics Customizing Cockpit (SAP
Transfering Global Settings and Exchange Rates
Performing Setup: SD (SAP ERP)
Prerequisites: SD-DLV Backorders
Defining Schema Mapping
Assigning SQL Privileges for BW System Schema
Activating BW Content and Generating SAP HANA Data Models
Activating SAP HANA Information Models
DataStore Objects
SD: Sales Document Header Data - /IMO/SD_D10
SD: Sales Document Item Data - /IMO/SD_D11
SD: Order Condition Data - /IMO/SD_D14
SD: Sales-Shipping Allocation Item Data - /IMO/SD_D16
SD: Delivery Header Data - /IMO/SD_D20
SD: Delivery Item Data - /IMO/SD_D21
SD: Billing Document Header Data - /IMO/SD_D30
SD: Billing Document Item Data - /IMO/SD_D31
SD: Billing Condition Data - /IMO/SD_D34
SD-DLV: Order Items - /IMO/SD_D50
SD-DLV: Order Headers - /IMO/SD_D51
SD-DLV: Service Level Overview - /IMO/SD_D52
SD-DLV: Open Order Schedule Line - /IMO/SD_D53
InfoSources
SD: Sales Document Header Data (2LIS_11_VAHDR) - /IMO/SD_IS10
SD: Sales Document Item Data (2LIS_11_VAITM) - /IMO/SD_IS12
SD: Order Condition Data (2LIS_11_VAKON) - /IMO/SD_IS14
SD: Sales-Shipping Allocation Item Data (2LIS_11_V_ITM) - /IMO/S
SD-DLV: Sales Document: Order Delivery (2LIS_11_V_SSL) - /IMO/SD
SD-DLV: Sales Document: Header Status (2LIS_11_VASTH) - /IMO/SD_
SD: Delivery Header Data (2LIS_12_VCHDR) - /IMO/SD_IS20
SD: Delivery Item Data (2LIS_12_VCITM) - /IMO/SD_IS21
SD: Billing Document Header Data (2LIS_13_VDHDR) - /IMO/SD_IS30
SD: Billing Document Item Data (2LIS_13_VDITM) - /IMO/SD_IS31
SD: Billing Condition Data (2LIS_13_VDKON) - /IMO/SD_IS34
SD-DLV: Sales Item: Returns - /IMO/SD_IS111
MultiProvider
Sales Overview - /IMO/SD_M10
Delivery - /IMO/SD_M20
Billing - /IMO/SD_M30
Conditions - /IMO/SD_M40
Service Level - /IMO/SD_M50
SD-DLV: Backorders - /IMO/SD_M51
InfoCubes
SD-DLV: Backorders - /IMO/SD_V01
Queries
Incoming Orders - /IMO/SD_M10_Q0001
Open Orders - /IMO/SD_M10_Q0002
Sales Order and Sales Revenue Values - /IMO/SD_M10_Q0003
Order, Delivery and Billing Quantities - /IMO/SD_M10_Q0004
Expected Incoming Orders based on Open Quotations - /IMO/SD_M10_
Delivery Overview - /IMO/SD_M20_Q0001
Billing Overview - /IMO/SD_M30_Q0001
Credit Memo Ratio - /IMO/SD_M30_Q0002
Condition Value per Customer - /IMO/SD_M40_Q0001
Variance of Condition Rates: Sales Orders and Billing Documents
Delivery Performance - /IMO/SD_M50_Q0001
Returns - /IMO/SD_M50_Q0002
Perfect Order Fulfillment - /IMO/SD_M50_Q0003
Backorders: Overview - /IMO/SD_M51_Q0001
Backorders: Open Order Quantity - BWBCT_QR_IMO_SD_M51_Q0002
Key Figures
No. of Sales Order Documents
No. of Sales Order Items
No. of Delivery Documents
No. of Delivery Items
No. of Billing Documents
No. of Billing Items
SAP HANA Information Models
SD-DLV: Backorders
Analytic View for BW DSO SD-DLV: Order Items
Analytic View for BW DSO SD-DLV: Open Request Schedule Line