78 / 577
78
PUBLIC
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ
❖
Business Scenario
：
Business Partner Report. This report includes Business Partner
Name, Node Key, BP Role, Company Name. Then based on BP Role’s value to judge this
is Customer or Supplier.
▪
Table
SNWD_BPA
: CLIENT, NODE_KEY, BP_ROLE, COMPANY_NAME, etc.
▪
Table
SNWD_BPA_CONTACT
: FIRST_NAME, LAST_NAME, etc.
▪
Join Condition: CLIENT, NODE_KEY=PARENT_KEY.
▪
Output: CLIENT, NODE_KEY, BP_ROLE, COMPANY_NAME, FIRST_NAME, LAST_NAME;
▪
Calculated Column: BP_ROLE_TEXT. Logic: BP_ROLE = 01-> Supplier, BP_ROLE = 02 -> Customer.
▪
Semantics: NODE_KEY as Key.
▪
Exercise: HANA Attribute View
▪
Name: AT_BUSINESS_PARTNER
HANA Modeling – Create an Attribute View
*Demo: 04_Create an Attribute View.exe; Exercise Details: Exercise 4.pptx