product. Program : RK_PKOSA_MULTI_CREATE. 18. ? Thanks. Global hierarchies are any characteristic hierarchies that are maintained centrally in the Fiori app Manage Global Hierarchies. Change the validity period of a customer for the hierarchy. "You can create work centre Hierachy by using T. In SAP it is possible to change the product hierarchy structure and to extend the maximum number of levels. Most important Transaction Codes for Check Product Hierarchy # TCODE Description Application; 1 : SE11: ABAP Dictionary Maintenance Basis - Dictionary. Platform - Dialog SAP-GUIThe categories are used to configure the scope of check for the product availability check. The code is specific to the classification system, but usually comprises two or more. BPH_DNLREP for Initial Download Account Hierarchy. Component : SAP_APPL. Then they use these values in COPA to further derive the detailed product characteristics. CLWO:Display MMS Material Group Hierarchy. You can create various catalogs for your products in the product. SAP Profit Center Hierarchy. MKH1N. In the latter case, the merchandise categories form the lowest level of the. BW09. It forms the control basis for planning costs, revenues, payments, scheduling, and budgeting. A product hierarchy models any number of strictly hierarchical product groups in a tree structure. Platform - Dialog SAP-GUI: 2 : CK11N: Create Material Cost Estimate CO - Product Cost Planning: 3 : COMM_HIERARCHYPlease give me a clue to solve the same. Number Ranges TCodes. What is the proceedure to use Product Hierarchy? Kindly help me why we use product hierarchy in COPA. description of product hierarchy (T179) SD - Material Maintenance. You also define control parameters for transaction. RSS Feed. Levels 1 and 2 have five characters each, and level 3 has. 1M task – Greasing. We can define a maintenance strategy as hierarchical or non-hierarchical or as a combination of both of them. With the line hierarchy you reproduce the structure of a production line in the system. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. TCODE Description Application; 1 : COMMPR01: product Workbench App. The SAP tcode COMM_HIERARCHY is available within SAP ECC, SAP S/4HANA On-premise and SAP S/4HANA Private Cloud. SAP Transaction Codes. Product Bundle is a new master data in S/4HANA Business Suite 1809 in customer management, With SAP S/4HANA for customer management, you can group multiple products (tangible products or services) and sell them together as a bundle. In SAP F&R, a product hierarchy is either a "true" product hierarchy. Understood. Display Product Hierarchy Report TCodes Most important Transaction Codes for Display Product Hierarchy Report # TCODE. SAP Help PortalSupported Device Types. A product hierarchy can consist of up to eighteen characters. TCODE Description Application; 1 : RSA3: Extractor Checker Basis - BW Service API: 2 : COMMPR01: product Workbench : App. List of Asset hierarchy transaction codes in SAP. With customer hierarchies you can reflect the structure of your customer organizations. In some instances, companies decide to put the structures in the material master material group field. #. It truncates the values since it should be 40 in length. Data Basis. You can use the Selection of Group IDs tab to search for existing customer hierarchies. Create Product Hierarchy Transaction Codes in SAP (25 TCodes)Here is a list of possible Product cost related transaction codes in SAP. Just wondering if someone could confirm that I'm on the right track; I'm assigned with the task of maintaining cost centre hierarchies, therefore I have been using the transaction code KSH2 and from there. The matchcode you use has the sales org as selection criteria on the screen. 5. The hierarchy graphic displays the hierarchy as a tree. Product hierarchy field is twice in material master, one at general data, and the other at sales org data. Program : RPHALPRH. I need to change the structure of product hierarchy: increase one hierarchy level and decrease de number of characters on the existing levels. So I wrote a simple report to retrieve hierarchy data from table T179 and display the data in a tree as below: REPORT zdisplay_hierarchy. Ex: Level 1 – A –> Level 2 – A –> Level 3 – B –> Level 4 – A –> Level 5 – A –> Level 6 – B (Incorrect Node) Ex Product: XXXX Age Defying Multivitamin. Platform - Dialog SAP-GUI: 3 : R3AS: Start Initial Load CRM - Middleware Adapter: 4 : SM30:In this example, we selected “country” as an attribute to create custom hierarchy type “Country Hierarchy”. Material Consumption Report TCodes. PRODH. This combination depends on whatever criteria best meet the needs of your company. In order to complete the hierarchical set up, the collective allocation (mask character) hierarchy must now be maintained with the appropriate aggregation factors. Here is a list of possible Product hierarchy related transaction codes in SAP. First you have to create your structure of product hierarchy. Package : RPHA. Product view Transaction Codes List. A hierarchy can be multilevel and used for control or informative purposes. A product hierarchy is an alphanumeric character string which consists of 18 characters at the most. SAP Customer Relationship Management all versions ; SAP. We’ll also list transaction codes not covered as well as useful programs and tables. Attached screenshots have more details. SAP Trade Management is an Integrated, holistic Trade Management solution that enables a coordinated business process for field sales to create account-specified plans aimed at maximizing profitability that fully integrates with S&OP, Supply Chain Management, Finance, etc. In the standard system, the product hierarchy consists of up to 3 levels. Table which shows product hierarchy level. A product hierarchy has a maximum of 18 characters value. Cost Center Hierarchy. Each material that is to be considered in allocation. Search. 1. Analyze the product hierarchies in your organization and define their representation in the SAP System. RSH1 (Edit hierarchy initial screen) TCode in SAP. KCH2. The matchcode you use has the sales org as selection criteria on the screen. Its features can be combined in various ways. To take an example, a product hierarchy could be 00010002000300040005. Grps for product costing: CO - Cost Object. SAP Transaction Code JPSEPRODCOMP (Series Product Hierarchy) - SAP TCodes - The Best Online SAP Transaction Code AnalyticsSap Product Hierarchy TCodes Most important Transaction Codes for Sap Product Hierarchy # TCODE Description Application; 1 : COMMPR01: product Workbench App. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. KCH6N is a transaction code in SAP EC application with the description — EC-PCA: Display Standard Hierarchy. This first blog post will give an overview of the SAP S/4HANA. With this app you can create and edit hierarchies and assign multiple levels of hierarchy nodes. BPH_DNL for Initial Download BP Group Hierarchy. See example below: Question 1: the category id search will only touch categories assigned to. Costing Sheet TCodes. Loaded 0%. Platform - Dialog SAP-GUI: 2 : RSA1: Modeling - DW Workbench BW - Data Warehousing Workbench: 3. Characteristic hierarchy. 3. Data Tiering in BW/4HANA. The sales and distribution areas permitted for hierarchies. Edit hierarchy initial screen BW - Data Basis: 40 :Cost Element Hierarchy Transaction Codes in SAP (25 TCodes) Login; Become a Premium Member; SAP TCodes; SAP Tables; SAP Table Fields;. You can display a hierarchy in work center maintenance or hierarchy maintenance as a list or a graphic. Definition. Definition. SAP Carbon Impact (EHS-CI) : Mirrors the corporate structure and supports both equity and control-based footprint roll-up. The term Organizational Hierarchy has different meanings depending on the context and Application. In the latter case, the merchandise categories form the. where T179 - PRODH = MVKE - PRODH. In the standard SAP system, a product hierarchy can be created with up to three levels, each with a specific number of characters. This blog explains how to display short Material Product Hierarchy level keys as shown below. Platform - Central Part of Product Master. Customers that are assigned to higher-level customers are known as dependent customers. V/76 - Displays the product hierarchy structure. Platform - Dialog SAP-GUI: 2 : CK11N: Create Material Cost Estimate CO - Product Cost Planning: 3 : PFCG: Role Maintenance Basis - ABAP Authorization and Role Management: 4 : COMM_HIERARCHY: Maintain Categories and Hierarchies App. Material Group TCodes. Follow RSS Feed Hello Experts, I couldn't find a way to check the loaded product hierarchy/category in the marketing system? Is there any way we can check this data on UI? How can I validate if the product hierarchy/category is uploaded correctly?. You will get more details about each transaction code by clicking on the tcode name. PRODH. TCODE Description Application; 1 : COMMPR01: product Workbench App. 3. In SAP each material can be assigned to a product hierarchy of a certain level. COMM_PRODUCT. T179T is a standard Basic Functions Transparent Table in SAP FI application, which stores Materials: Product hierarchies: Texts data. If you use product categories, you can achieve the following in SAP GBT: Using a product category as a selection criterion in searches for batches. The SAP S/4HANA. A product hierarchy models any number of strictly hierarchical product groups in a tree structure. Product hierarchy is an alphanumeric character string used for grouping materials. Order product hierarchy Transaction Codes List. Below are the steps. All features available for Global Hierarchies are available for this hierarchy. Tcode for BW20PI: Product Hierarchy for SAP BW Program : RPHALPRH Package : RPHA Component : SAP_APPL; BW10 Tcode for BW20PI: Log. Customers can centralize, enhance, automate, and improve the management of their entire system landscape (SAP and third party), thus reducing total cost of ownership. If you do not have an SAP ID, you can create. product Workbench App. Transparent Table. Select the controlling area used by your company and click on edit. Go to Implementation Guide (IMG) by typing in “SPRO” transaction code. Material TCodes. Table T179 has Hierarchy created but its not showing up in this table. 7 9 2,640. It also provides examples and best practices for different scenarios and industries. Structure: XXXXX (Hierarchy code) – Brand (Level 1) YYYYY (Hierarchy code) – Category (Level 2) ZZZZZ (Hierarchy code) – Subcategory (Level 3) Now create. To achieve multilevel hierarchy structure, below 4 standard partner functions have been introduced: 1A – Customer hierarchy 1 – 1st level hierarchy. VDH1N. To enable product allocation, you need to add a member in LIS via Tcod MC62. This blog post provides key. You can also manage the validity timeframes of the hierarchies. RSS Feed. Platform - Central Part of Product Master. With this app you can create and edit hierarchies and assign multiple levels of hierarchy nodes. The table below provides the description of the fields required to create a. I am trying to retive the parent /child relationship from CX17 trx. Most important Transaction Codes for Product Hierarchy. PraShra LLC. A product hierarchy enables the grouping of products and defines the relationship between products and groups at different hierarchy levels (for example, food – frozen food – pizza). Logistics Basic Data. It’s a good practice to remember or note down the transaction codes that we need to use in our regular work. The solution includes features such as diagnostics, testing, root cause analysis, and solution monitoring. A product hierarchy is an alphanumeric character string which consists of 18 characters at the most. By default, SAP has 3 level product hierarchy. In the hierarchy structure choose Create New Group. Sheet/P+L AcctsTCODE Description Application; 1 : CK11N: Create Material cost Estimate : CO - Product Cost Planning: 2 : SE11: ABAP Dictionary Maintenance Basis - Dictionary MaintenanceContact Information. I need to give logic that if position 14 and 15 =M6 , then we need to execute a further logic. Additional categories can be created for non-SAP systems. Product Hierarchy in Sales Analytics is a PDF document that explains how to use the product hierarchy feature in SAP S/4HANA Cloud for sales planning and reporting. Here is a list of possible Material product hierarchy related transaction codes in SAP. Set Types and Attributes: Set Types are the group of different attributes which are assigned to Product/Material and are available on Product Page in CRM. (MM02) When the material level hierarchy (MARA-PRDHA) is updated on the Basic Data 1 view of the material master, upon saving the system should find all the sales organisations (sales org 2 TAB)n material and update the product hierarchy (MVKE-PRODH). BW09. (MM02) When the material level hierarchy (MARA-PRDHA) is updated on the Basic Data 1 view of the material master, upon saving the system should find all the sales organisations (sales org 2 TAB)n material and update the product hierarchy (MVKE-PRODH). Features. Delete Product Hierarchy TCodes in SAP. WMATGRP01 (Create Article Hierarchy) TCode in SAP. Create Utilities Product Hierarchy : FrançaisIntroduction. Tcode for Create Multiple Product Cost Coll. Select VTEXT. A transaction is a change to an application or change option, which is executed online by a user, or in the background by the system, in a business process. KCH5N. Consumer Decision Tree (Article Hierarchy) WMATGRP01. regards. Its features can be combined in various ways. This can be changed for your convenience. Choose Find. n this appendix, we will present the configuration transaction codes relevant to the topics discussed in this book. Business requirment: My client is changing the prduct hierarchy values EG : currently it is 010010000100000001. Display Sales Document TCodes. Loaded 0%. controlling Flexible planning Planning create/change Planning type: COMMIT for SAP standard planning type ). Say you use only first 15 characters and they are divided into 4 levels each with 2, 4, 4, 5 characters respectively. Transaction Manager (FIN-FSCM-TRM-TM) : A classification of the financial instruments managed in the SAP system. To mark this page as a favorite, you need to log in with your SAP ID. The process of allocating volumes of extracted products (for example, crude oil and natural gas) to their originating well completions. How do I pull these 6 levels of product hierarchy in COPA. A customer-defined name used for classifying the inventory items in transferred inventory into logistic units. Product Hierarchy is used for Profitability Analysis and also in Sales Reporting based on PH. BW09. A product hierarchy models any number of strictly hierarchical product groups in a tree structure. T179T. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the. Sometimes, we need more than 3 levels of hierarchy. Product Hierarchy. Production Planning and Control. By default, SAP has 3 level product hierarchy. TCode Module (current) TCode Component; TCode Name; TCode Books; TCode Excels. CLW2: Display Material Group Hierarchy. MVKE. Thanks. It’s a good practice to remember or note down the transaction codes that we need to use in our regular work. Select cost center groups and click on the + button on the right hand side. The related Characteristics are PAPH1,PAPH2,PAPH3,PAPH4,PAPH5,PAPH6 included in my operating concern. Thanks. A customer hierarchy is a flexible structure consisting of customers. Here is a list of possible Product hierarchy related transaction codes in SAP. Can you please help me to look out for the exact t code of this screen. As we know it is being used in the SAP SD-MD (Master Data in SD) component which is coming under SD module (Sales & Distribution) . App. Material Consumption Report TCodes. Example: Hierarchy of cost centers that are assembled in cost center groups. A product hierarchy models any number of strictly hierarchical product groups in a tree structure. The maximum number of digits are 18 (Calles 5/5/8 Schema). SAP Knowledge Base Article - Preview. KKR0 for CO Summarization: Hierarchy Maintena. Example: A dishwasher can be described by product hierarchy 00010000200000002. 20. Project view selected. Though most manufacturing concerns have a product catalog, they may not have a well thought out product hierarchy. In SAP F&R, a product hierarchy is either a "true" product hierarchy. Product hierarchy Transaction Codes List. 16810 Views. Program : RV_VENDOR_HIERARCHY. BW Statistics and RSDDSTAT* views, tables. To create a new plant hierarchy, select a template suitable to the layout of your plant. The field PRODH in T179 is a 18character field and is divided into 3 levels of 5, 5, 8 characters each. V/76 tcode used for: Maintain Product Hierarchy in SAP; Module : CRM (Customer Relationship Management) Parent Module : CRM (Customer Relationship Management) Package : VS0C (Customizing R/3 Sales and Distribution. This bapi returns the text for the product hierarchy in text fields with a length of 20. Most important Transaction Codes for Mm Product Hierarchy # TCODE Description Application; 1 : MIGO: Goods Movement MM - Inventory Management: 2 :. Selected Planning hierarchy on menu path and click Revise. 5. Use The product hierarchy master data is used to support planning, logistics, modeling, forecasting, and reporting. These hierarchies are also referred to as Universal Hierarchies. Loaded 0%. To do this, you use the SAP S/4HANA migration cockpit. Standard Price TCodes. Product groups are the basis for entering the additional financial data for the group-internal inventory. Sales and Distribution. To Download Product Hierarchy TCodes Most important Transaction Codes for To Download Product Hierarchy # TCODE Description Application; 1 : COMMPR01: product Workbench App. Platform - Dialog SAP-GUI: 2 : CK11N: Create Material Cost Estimate CO - Product Cost Planning: 3 : COMM_HIERARCHYYou will get more details about each transaction code by clicking on the tcode name. planning product hierarchy Definition. Has SAP any standard table to maintain it. It provides a. n this appendix, we will present the configuration transaction codes relevant to the topics discussed in this book. Product hierarchy s4 Transaction Codes List. This series of characters states that. Nowadays I've implemented Flexible Planning with my own Info Strucrure, but I need your help in order to get a Planning Hierarchy Report that could display all upload levels , i. . To determine which organizational data is allowed in a hierarchy. Cost Center Transaction Codes in SAP (61 TCodes) Login; Become a Premium Member; SAP TCodes; SAP Tables; SAP Table Fields;. Choose the product hierarchy and then execute to get the list of materials. Platform - Dialog SAP-GUI: 3 : KEDR. Loaded 0%. SAP Product Hierarchy Tables : A148 - Product Hierarchy Tcode, WRF_MATGRP_PROD - Hierarchy-Product Assignment Table Tcode, TPHCNV - Data. It is the process of arranging PC Groups and PC Master Data. I want to update the product hierarchy in basic data view of material mast with some new product hierarchy. Product Cost Collector TCodes. Product hierarchy field is twice in material master, one at general data, and the other at sales org data. Process Chains. Here we have maintained the proportion as 100%, which can be modified as per the requirement. Platform - Dialog SAP-GUI: 2 : SE16:A product group combines other product groups and materials. Here are some reports: KKP4 - Display cost object hierarchy; you can enter the material there. In order to populate the hierarchy in the table, below mentioned steps shall be followed. Sales and Distribution. The main join is T179 – PRODH = MVKE – PRODH. This internal hierarchy view can be used in a query view. Product Category Hierarchy Definition. View V_TVPH, Attribute 1. Currently the hierarchy has 3 levels with 5/5/8 characters and I need to change it to 4 levels with 2/2/3/4. Hierarchy definition for characteristics. Pricing Product Hierarchy TCodes Most important Transaction Codes for Pricing Product Hierarchy # TCODE Description Application; 1 : VK11: Create Condition SD - Conditions: 2 : V/06: Condition Categories: SD pricing: SD - Conditions: 3 :The List of SAP Cost Center Transaction Codes for Basic Settings are: SAP CC TCODE BASIC SETTINGS; KS01: Creation of Cost Center: KSH1: Creation of Cost Center Group: F-02: Posting of Transactions in FI:. Important Tables in SAP BW 7. Three questions and answers regarding on product hierarchy, category and application. Program : RPHALPRH. Platform - Dialog SAP-GUI: 2 : CK11N: Create Material Cost Estimate CO - Product Cost Planning: 3 : COMM_HIERARCHY: Maintain Categories and HierarchiesThe categories are used to configure the scope of check for the product availability check. Here we would like to draw your attention to V/76 transaction code in SAP. Platform - Central Part of Product Master: 4 : SM59: RFC Destinations (Display/Maintain) Basis - RFC: 5 : PFCG: Role. Steps to create Product Hierarchy: Step1: Goto T. Tcode for BW20PI: Product Hierarchy for SAP BW Program : RPHALPRH Package : RPHA Component : SAP_APPL; BW10 Tcode for BW20PI: Log. Login; Become a Premium Member; SAP TCodes; SAP Tables; SAP Table Fields; SAP Glossary Search;. As a graphic. Hi All, Can anyone provide me the table name which stores the Product Hierarchies and its description (Text) in SAP CRM as we have Table T179T in ECC ? Regards, PradeepUse. Customer Hierarchy Transaction Codes in SAP (49 TCodes) Login; Become a Premium Member; SAP TCodes; SAP Tables;. Material Consumption Report TCodes. we have a product hierarchy = A037131A18LE4M6L62 assigned in material master. You create a line segment by inserting a work center from the system into the line hierarchy. But I don´t know what must to do in ECC to replicate the products categories herarchy to create the. BPH_DNL for Initial. Display Cost Element Hierarchy Transaction Codes in SAP (30 TCodes) Login; Become a Premium Member; SAP TCodes; SAP Tables; SAP Table Fields; SAP Glossary Search; SAP FMs; SAP ABAP Reports; SAP BW Datasources;. You will get more details about each transaction code by clicking on the tcode name. 19. There is a standard view (Master Data Product Hierarchy) which is based on table HPHRY but its not returning any value for Hierarchy ID. For example, you need the product master data to plan promotions or schedule demand modeling and forecasting processes. The path contains classes and characteristics. 1B – Customer hierarchy 2 – 2nd level hierarchy. The first four characters 0001 could indicate that the product. Characteristic values of a characteristic in a tree structure. Loaded 0%. Most important Transaction Codes for Sales Product Hierarchy # TCODE Description Application; 1 : VA01: Create sales Order SD - Sales: 2 : VA02: Change. The first level of all the class has one characteristic and gets its characteristic value from the product of the superior level. Product Costing TCodes. A product hierarchy can consist of up to Eighteen characters. Product Hierarchy change productive system. 1. Datasource : 0PROD_HIER_TEXT. The planning product hierarchy allows the key account manager to transfer the internal product hierarchy to the hierarchy and language of the customer. Follow. Project Structure. A product hierarchy is an alphanumeric character string which consists of 18 characters at the most. Categories which represent the MRP elements in the SAP R/3 system are delivered with the SAP APO system. This means that the hierarchy depends on various factors, such as authorizations, the database profile, user-defined selections, and filters set. Regards. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. LDB1. Here are the definitions by Application Component or Module. Here put Name of Hierarchy That You wants for grouping purpose. Enable Product Hierarchy in S4HANA. FS - Financial Condition (FS-AM-PR-PR) A way of describing a product that is entered in the attribute hierarchy of a product category. Product Group Transaction Codes in SAP (66 TCodes) Login; Become a Premium Member; SAP TCodes; SAP Tables;. A product hierarchy models any number of strictly hierarchical product groups in a tree structure. Using the product type, you control the structural characteristics (such as condition types and flow types) that are assigned to individual instruments in the SAP system. All of these three questions are raised regarding the customizing below via tcode COMM_PRAPPLCAT: Question1: Product search supports “search by category id”. This series of characters. I'm able to make additions and/or deletions (simple cursor on node, select same level or lower level and add or delete). If you generate a SAP HANA view for an InfoObject that has hierarchies, a SAP HANA view is generated for the hierarchies too. Work center hierarchy. Platform - Central Part of Product Master: 19 : SM59: RFC Destinations (Display/Maintain) Basis -. Hi Gurus. To determine which supplier account groups are allowed in a hierarchy. This is the 2nd blog in my blog post series on managing hierarchies in SAP S/4HANA. Favorite. Product hierarchy thus define the product and its composition. A multi-level hierarchical structure that is used in the planning process and is built using nodes of the ECC pricing hierarchy. With hierarchical task list maintenance, task lists have been enhanced to be able to reference other task lists. Table T179 has Hierarchy created but its not showing up in this table. In SAP F&R, a product hierarchy is either a "true" product hierarchy (analogous to the article hierarchy in an SAP Retail system) or a merchandise category hierarchy. Merchandise categories can be assigned to stores and store departments. Gl Account Master Tables. A148 is a standard Billing Transparent Table in SAP SD application, which stores Product Hierarchy data. This can be changed for your convenience. Now, i'm not getting any report from SD module which will be used for analysing the Product Hierarchy. Categorie Management Consumer Products: 48 : CMMATGRP01 Create Article. Transparent Table. Click on Hierarchies. COMM_HIERARCHY. com which the product hierarchy is used in a business document. TCODE Description Application; 1 : COMMPR01: product Workbench App. You can view the product hierarchy data for a sales document on the item level, including the product hierarchy ID, parent node, and the Valid From/To dates of the hierarchy timeframe, by displaying the Sales B tab page of a sales order from the Manage Sales Orders app. A product hierarchy models any number of strictly hierarchical product groups in a tree structure. Kindly find enclosed the snap shot from SAP. Material Table. Select cost center groups and click on the + button on the right hand side. LDB1 (Create Line Hierarchy) TCode in SAP. You can also group merchandise categories into hierarchies. Product cost Transaction Codes List. PRODH. BW09. product. Kishore. Unfortunately, it is not the case. Click on ‘X’ (In. But I am unable to find the exact t code of this snap shot. ”. RSS Feed. Its features can be combined in various ways. Characteristic hierarchies are stored in their own data tables. KKP4 for Display Cost Object Hierarchy. It is a long process. Standard Price TCodes. Hierarchies can be formed from the following master data object types: Location. Transport Product Hierarchy TCodes in SAP. In SAP, a product hierarchy is used for pricing. The organizational hierarchy is made up of organizational units. Remove customers, if required, from the hierarchy. Activate or deactivate hierarchies for runtime use. The classes used to define a multi-level. Definition. KCH3 is a transaction code in SAP EC application with the description — Display profit center hierarchy. I need to extract FS item data with all Parent /child (level details) .