86 / 577
86
PUBLIC
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ
❖
Business Scenario
：
Purchase Order Report. This report needs to contain info like PO
Gross Amount, Net Amount, BP Name, Product Price, etc.
▪
Table SNWD_PO
：
CLIENT, PO_ID, PARTNER_GUID;
▪
Table SNWD_PO_I
：
CLIENT, PO_ITEM_POS, PRODUCT_GUID, GROSS_AMOUNT, NET_AMOUNT;
▪
Join Condition: CLIENT, NODE_KEY=PARENT_KEY;
▪
Star Join: AT_BUSINESS_PARTNER, AT_PRODUCT to get detail info. Left Out Join, Cardinality:
（
n..1).
▪
Measure: GROSS_AMOUNT, NET_AMOUNT.
▪
Exercise: HANA Analytic View.
▪
Name: AN_PO
HANA Modeling – Create an Analytic View
*Demo: 05_Create an Analytic View.exe; Exercise Details: Exercise 5.pptx