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


SAP Product Hierarchy - Example ABAP Program using rv_produkthierarchie_text_get Function

Hello ABAP developers, in SAP systems there are levels of product hierarchies as well as other SAP objects like customer hierarchies, price hierarchies, etc.
In this ABAP tutorial, I want to show how we can get the levels of product hierarchies and display defined text and descriptions for each sap product hierarchy using ABAP rv_produkthierarchie_text_get function call.
In an SAP system you can define the SAP product hierarchy as you wish.
In this ABAP example code, I will show how you can define each level in product hierarchy, get text for each levels of product hierarchy by using rv_produkthierarchie_text_get ABAP function call.

The product hierarchy is stored in a character field with 18 characters long.
Each product hierarchy has 3 letters or 3 characters long code in product hierarchy table.
So my sample sap product hierarchy has 6 levels of product hierarchies.





Here is the ABAP code which is used for getting product hierarchy descriptions using ABAP function rv_produkthierarchie_text_get.
The SAP product hierarchy code that I'll try to extract definitions of each level is "RU1101105102111230" and I keep it as a variable named prdh.
DATA : prdh(20) TYPE C VALUE 'RU1101105102111230'.

If you trace the following abap report or debug the abap program, you will see that I split the product hierarchy code into 3,6,9,... characters long pieces in the Abap WHILE block.
Again in the WHILE abap code fragment, I store each hierarchy of product in the internal table gt_str which is a table of type gty_str.
Actually an ABAP array that contains only one string field.

The second part of the below ABAP program is the section where I call function RV_PRODUKTHIERARCHIE_TEXT_GET for each entry in the internal table.
The ABAP function rv_produkthierarchie_text_get gets the text defined for the related product hierarchies.
The desired SAP product hierarchy should be set into a DISP_T179 table where in the below ABAP example code, they are passed to the rv_produkthierarchie_text_get function in the PRODH_TAB variable.
The is a table of the structure PRODH_DISP and you can set the product hierarchy code and the target SAP system.
Also you define the target language for translation while calling ABAP function rv_produkthierarchie_text_get using SPRAS parameter.

REPORT ZPRODH.
TYPES :
  BEGIN OF gty_str,
    prodh(20) TYPE C,
  END OF gty_str.

DATA: BEGIN OF PRODH_TAB OCCURS 10.
  INCLUDE STRUCTURE PRODH_DISP.
DATA: END OF PRODH_TAB.

DATA :
  gs_str TYPE gty_str,
  gt_str TYPE TABLE OF gty_str.
  i TYPE I VALUE 1,
  j TYPE I,
  prdh(20) TYPE C VALUE 'RU1101105102111230'.


WHILE i <= 6.
  j = i * 3.
  gs_str-prodh = prdh+0(j).
  APPEND gs_str TO gt_str.

  i = i + 1.
ENDWHILE.


LOOP AT gt_str INTO gs_str.
  CLEAR PRODH_TAB. REFRESH PRODH_TAB.
  PRODH_TAB-MANDT = SY-MANDT.
  PRODH_TAB-PRODH = gs_str-prodh.
  APPEND PRODH_TAB.

  CALL FUNCTION 'RV_PRODUKTHIERARCHIE_TEXT_GET'
    EXPORTING
      SPRAS = SY-LANGU
    TABLES
      DISP_T179 = PRODH_TAB.

  READ TABLE PRODH_TAB INDEX 1.
  WRITE :/ PRODH_TAB-VTEXT.
ENDLOOP.
Code

And here is the output of the above ABAP report.
You can see that the ABAP WRITE statement has displayed text of SAP product hierarchies in 6 separate lines.

SAP product hierarchy table output

It is also possible to read the SAP product hierarchies text and description for each level of product hierarchy by using ABAP codes that select data from T179T SAP tables.
You can visit and read the ABAP tutorial Display SAP Product Hierarchy using Table T179T VTEXT Field on cl_gui_alv_tree ABAP ALV Tree Object as an example.



SAP HANA and ABAP

Install SAP Free
CRM Companies List
Web Based CRM Software


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