Scribd Logo
Upload

Welcome to Scribd!

  • 23 views

    9.implementing Calculated Column Inside Attribute View

    Uploaded by

    Om Prakash Dubey
    The document discusses how to create a calculated column inside an attribute view in SAP HANA by right clicking on a sub-package and selecting new attribute view, adding tables and joining them, then clicking on calculated columns to provide a name, label, and expression using existing column values and functions. Calculated columns are useful in SAP HANA as they allow results to be calculated at runtime based on existing columns and functions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    9.implementing Calculated Column Inside Attribute View

    Uploaded by

    Om Prakash Dubey
    23 views12 pages
    The document discusses how to create a calculated column inside an attribute view in SAP HANA by right clicking on a sub-package and selecting new attribute view, adding tables and joining them, then clicking on calculated columns to provide a name, label, and expression using existing column values and functions. Calculated columns are useful in SAP HANA as they allow results to be calculated at runtime based on existing columns and functions.

    Original Description:

    hana

    Original Title

    9.Implementing Calculated Column Inside Attribute View

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses how to create a calculated column inside an attribute view in SAP HANA by right clicking on a sub-package and selecting new attribute view, adding tables and joining them, then clicking on calculated columns to provide a name, label, and expression using existing column values and functions. Calculated columns are useful in SAP HANA as they allow results to be calculated at runtime based on existing columns and functions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    23 views12 pages

    9.implementing Calculated Column Inside Attribute View

    Uploaded by

    Om Prakash Dubey
    The document discusses how to create a calculated column inside an attribute view in SAP HANA by right clicking on a sub-package and selecting new attribute view, adding tables and joining them, then clicking on calculated columns to provide a name, label, and expression using existing column values and functions. Calculated columns are useful in SAP HANA as they allow results to be calculated at runtime based on existing columns and functions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 12

    IMPLEMENTINGCALCULATED COLUMN INSIDE A ATTRIBUTE VIEW

    Calculated Column:
    It is an additional column which can be created by us, the results of which are calculated at
    runtime based on the existing column and using functions, input parameters and constants.

    Go to remote desktop connection<start<click on saphana 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 LTEXT<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 a object to change<click finish

    Open data preview <click on raw data


    Right click on calculated columns<click new

    Provide name<provide label<provide length

    Enter expression<click on columns <select required columns


    Here we can see various functions available categorized into different sections like
     Conversion Functions
     String Functions
     Mathematical Functions
     Date Functions
     Misc Functions

    Click on validate syntax<click ok


    Click ok

    Save and validate<save and activate

    Click on data preview<click on raw data


    By this we can say that calculated columns are very useful in SAP HANA and has good amount
    of functions that can be used to build the same. If we need any help on the syntax of the function
    or how different functions works, we can use the symbol ‘’ in calculated column editor screen

    You might also like