Sap Hierarchy Excel -

: Go to the Data tab > Get Data > From File > From Workbook/Text and select your SAP export.

Example: =LEN(A2)-LEN(TRIM(A2)) will tell you how many leading spaces exist, which usually corresponds to the hierarchy depth. Sap Hierarchy Excel

: When running the report in SAP (e.g., transaction KSR3 or OKP3 ), look for an export option called "Grids" or "ALV Layout" . These are much easier to work with in Excel than "Classic" SAP layouts. : Go to the Data tab > Get

: Often, SAP exports leave blank cells under a parent header. Select the hierarchy columns, right-click, and choose Transform > Fill > Down . transaction KSR3 or OKP3 )