SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for SAP HANA and ABAP, HANA Database, SQLScript, SAP UI5, Screen Personas, Web Dynpro, Workflow


Display SAP Product Hierarchy using Table T179T VTEXT Field on cl_gui_alv_tree ABAP ALV Tree Object


In an ABAP report using SAP ALV Tree object cl_gui_alv_tree, I decided to display SAP product hierarchy levels and materials for each product hierachies.
To succeed in using product hierarchies in SAP ALV Tree cl_gui_alv_tree, I had to SELECT material from SAP MVKE table and read text for each product hierarchy level text from T179T SAP table.

ABAP developers can easily review the below ABAP code for MVKE selection task :

SELECT * FROM MVKE INTO TABLE lt_mvke
UP TO g_max ROWS
WHERE prodh LIKE 'TR1%'.
Code

I select a set of MVKE records with a number less than or equal to integer variable g_max.
Also the selected MVKE rows are items with product hierarchy codes starting with "TR1"
I keep the return result set of MVKE table in an local internal table lt_mvke.

Now it is important to code in ABAP for levels of product hierarchies and product hierarchy text and descriptions.
Within this ABAP tutorial, you will see how the text and descriptions of levels of product hierarchies can be obtained by simply selecting VTEXT from T179T SAP table.





The below ABAP code selects description of all levels of product hierarhies for the login language sy-langu and stores in a global variable internal table gt_t179t

FORM UF_READ_HIERARCHY_TEXT.

SELECT * FROM T179T
  INTO TABLE gt_t179t
  WHERE spras = sy-langu AND PRODH <> ''.

ENDFORM. " UF_READ_HIERARCHY_TEXT
Code

The following ABAP code, gets a product hierarchy code and returns the appropriate text VTEXT field from the internal table gt_t179t.
As you will remember gt_t179t contains product hierarchy text from SAP table T179T filtered for a specific language using SPRAS column.

FORM UF_GET_PRODUCT_HIERARCHY_TEXT
  USING
    P_PHLVL TYPE C
  CHANGING
    P_PHLVL_TEXT TYPE C.

  CLEAR gs_t179t.

  READ TABLE gt_t179t INTO gs_t179t WITH KEY PRODH = P_PHLVL.
  P_PHLVL_TEXT = gs_t179t-VTEXT.

ENDFORM. " UF_GET_PRODUCT_HIERARCHY_TEXT
Code

So by calling UF_READ_HIERARCHY_TEXT once at the beginning of the ABAP report and calling UF_GET_PRODUCT_HIERARCHY_TEXT for each product hierarchy level taking place in cl_gui_alv_tree SAP ALV Tree object, I could successfully display the materials according to their product hierarchies.
Here is the output of a SAP ALV Tree report as an example of ALV Tree example and ABAP example for reading product hierarchy text.

sap-product-hierarchy-table-output

You can also check the ABAP tutorial for reading SAP product hierarchy using rv_produkthierarchie_text_get function call.



SAP HANA and ABAP

Install SAP Free
CRM Companies List
Web Based CRM Software


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.