E9.2 Download all JDE DD Items in Excel

[coolkl]

Hello Everyone,

We have a request from client to download all the JDE DD Items in Excel. One option i see is to download F9200 & all related tables in excel. But this will be multiple excels not structured data.

Is there is a report which dumps in excel or any other way.

Your help is appreciated. We are on JDE E1 9.2

Thanks,

coolkl

 

[jdelisths]

You can join the following tables to get the information you need in one sheet: F9200, F9210, F9202, F9203

 

[Larry_Jones]

Hello Everyone,

We have a request from client to download all the JDE DD Items in Excel. One option i see is to download F9200 & all related tables in excel. But this will be multiple excels not structured data.

Is there is a report which dumps in excel or any other way.

Your help is appreciated. We are on JDE E1 9.2

Thanks,

coolkl

I have to ask ... Why?

 

[BOster]

I have to ask ... Why?

Kinda curious about that myself.

 

[Larry_Jones]

Kinda curious about that myself.

IU guess we're destined to be disappointed

 

[coolkl]

The client just wanted to dump. Not sure why.
Thanks for reply. I had planned to use the join view as suggested. Finally, I used R92400 Data Dictionary Items Report and downloaded it in Excel.

Thanks,
coolkl