Skip to Content
avatar image
Former Member

How to download customer hierarchy in Excel sheet?

Hi,

Good day.

I was able to display the customer hierarchy via transaction VDH2N however, I would also like to download and save this hierarchies in Excel but there was no such option in that transaction. Can anyone tell me how and where I can download the customer hierarchy, please? I wanted to downloaded exact details found in VDH2N. Please help.

Thank you and have a good day.

Kindest regards,

Lemily

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 28, 2007 at 07:19 AM

    hi,

    in se16 using table knvh u can have the download.

    saurabh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Saurabh,

      Thanks for your immediate reply. The issue I have with SE16N is that it did not generate all complete and exact details for customer hierarchy that is found in transaction VDH2N. In VDH2N, I can see that there are 3 levels and other sub levels. But when I tried to use SE16N, it did not capture all levels, especially the sub levels. And I wanted to download or export all customer level that is found in VDH2N but this is not possible in SE16N.

      Thank you and have a nice day.

      Kindest regards,

      Lemily

  • avatar image
    Former Member
    Nov 28, 2007 at 07:32 AM

    Hi,

    Go to SE11, enter table KNVH-- Customer hierarchies and enter ur cusomer number. Then select execute u will get all the records. Select one record

    System > List . Save > Local file > Spread sheet

    Reward points pls.

    Regards,

    Govind.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Lemily,

      Go To SE16 and Give the Table Name KNVH and give Customer Number in the Field KUNNR.

      select Execute and go to system> List. Save> Local File--> Spread Sheet.

      Regards..

      Praveen Kumar.D

  • avatar image
    Former Member
    Nov 28, 2007 at 09:25 AM

    The program for the t-code VDH2N is RV_CUSTOMER_HIERARCHY.

    Copy this program and create a Z-program (ABAP report) and do the modification in the Z-program and create a new tcode for this report.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ashish,

      Thank you so much for the attention you've given on my query. However, creating a new report by copying the existing one and modify it is not an option right now since my requirement for the use of this tcode is only for this moment. And doing a new program might take long to finish and implement as this will undergo testing.

      Any other option, please?

      Thank you and good day.

      Regards,

      Lemily