SAP BLOG Implementing attribute view with customer

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,437
Tepki puanı
7
Puanları
6
In this blog, I am sharing basic overview of Implementing attribute view with customer

Attribute view:

  • Attribute views are dimensions
  • Attribute views are used to join to a dimension or attribute view.
  • In most cases used to model master data like entities (like product, employee, business partner)
  • Highly re-used and shared in analytic- and calculation views

How to create attribute view with customer:

Go to remote desktop connection<start<click on Sap Hana studio

2021-03-17_16h29_13.png


How to create a package:

Expand best system<right click on content<new<click on package

2021-03-17_16h30_48.png


Provide name<provide description<click ok

2021-03-17_16h35_26.png


How to create a sub package:

Right click on package<new<click on package

2021-03-17_16h36_19.png


Provide name as SD <provide description <click ok

2021-03-17_16h37_04.png


How to create an attribute view:

Right click on sub package<new<click on attribute view

2021-03-17_16h37_57.png


Provide name AT_CUSTOMER<provide label<select subtype as standard <click finish

2021-03-17_16h38_37.png


Click on plus icon to add objects

2021-03-17_16h39_24.png


Search for table KNA1<click on table<click ok

2021-03-17_16h40_22.png


Select required output columns

2021-03-17_16h41_11.png


Again click on plus icon<enter table T005T<click ok

2021-03-17_16h41_54.png


Connect KNA1 LAND1 to T005T LAND1 to get output as LANDX <select LANDX as output coloumn

Join type as text join<language as SPRAS

Text Join: text join is used to fetch the description based on user’s session language. Once we implement the text join in Sap Hana, it automatically finds out user’s language and gives description in that language.

2021-03-17_16h43_01.png


Again click on plus object<select T005U table<click ok

2021-03-17_16h43_44.png


Join KNA1 LAND1 to T005U LAND1 because regions are specified with country

Join type as text join <language as SPRAS

2021-03-17_16h44_32.png


Join KNA1 REGIO to T005U BLAND<select output column as BEZEI

Join type as text join <language as SPRAS

2021-03-17_16h45_41.png


Click on semantics<select key attribute as KUNNR

Key attributes:

Key attribute is a kind of primary key for the attribute view. But, it doesn’t prevent the

Passage of duplicate values. It is basically needed to determine the join execution order

At the run time when multiple tables are used in an attribute view.

In attribute views there is one mandatory step. Whatever keys in the table one key?

We need to define inside an attribute view

2021-03-17_16h46_49.png


Provide label mapping

Label mapping:

We can choose to associate an attribute with another attribute description. Label

Mapping is also called as description mapping. For example if a1 has a label column

B1, then you can rename b1 to a1.description. The related columns appear side by

Side during data preview

2021-03-17_16h47_44.png


Click save and validate<click save and activate

2021-03-17_16h48_28.png


<assign an object<click finish

Use of assign object: in the select change dialog, either create a new id or select an existing change id that you want to use to assign your change

2021-03-17_16h49_12.png


Click on data preview

2021-03-17_16h49_54.png


Click raw data<to get output

2021-03-17_16h50_42.png


Output in different language:

Go to best system<right click on system<click on properties

2021-03-17_16h52_26.png


Click additional properties<select locale<click apply<click ok

2021-03-17_16h54_05.png


Click save and validate<click save and activate<click on data preview<click on raw data

2021-03-17_16h54_49.png


Hope it is useful for you to implement attribute view with customer. Thank You for reading this blog!

Okumaya devam et...
 
Üst