Implementing Attribute View with Company Code

IMPLEMENTING ATTRIBUTE VIEW WITH COMPANY CODE

Attribute view:

• Attribute views are dimensions, master data.
• 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.

• Go to remote desktop connection->start->click on SAP-HANA studio

• Right click on sub package->new->click on attribute view.

• Provide name as AT_COMPANY CODE ->provide label->click finish

• Click on plus icon add objects.

• Select T001 table.

• Select required output columns.

• Again Click plus icon->add TVKO table->click ok.

• Join T001-BUKRS to TVKO-BUKRS->join type as inner join ->select required output columns.

• Again click on plus icon->add TVKOT table->click ok

• Join TVKO-VKORG to join TVKOT-VKORG ->join type as text join->language as SPRAS->select VTEXT.

• Again click on plus icon->select TCURT table->click ok

• Join T001-WAERS to TCURT-WAERS->select the text->join type as text join->language as SPRAS.

• Click on semantics->select BUKRS as key column.

Provide descriptive 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.

• Click save and validate->click save and activate.
• Assign an object to change->click finish.

• Open data preview -> click on raw data.

Output in different language:

• Go to best system->right click on system->click on properties.

• Click additional properties->select locale->click apply->click ok

• Click save and validate->click save and activate->click on data preview->click on raw data.