How to download customer hierarchy in Excel sheet?

[Former Member]

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

[Former Member · Accepted solution]

hi,

in se16 using table knvh u can have the download.

saurabh

[Former Member · Accepted solution]

Hi Saurabh,

Thanks so much for your reply on my query. I have tried your suggestion below but it did not output the same data found in VDH2N. Do we have other option?

Thanks,

Lemily

[Former Member · Accepted solution]

hi,

i have never worked on this scenario and that was jus an offhand solution but if u can tell me the prblem u are facing wid the suggested sol. i will try to come up wid sumthing new.

saurabh

[Former Member · Accepted solution]

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

[Former Member]

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.

[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

[Former Member]

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.

[Former Member]

Hi Govind,

Thanks so much for your reply on my query. I was trying to run the transaction as suggested by you however, I do not see an option to where I can input the customer number. Please advise.

Thanks,

Lemily

[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