Adrian TH
Active Member
Hi guys,
I have a request from the user.
Been cracking my head but still could not come up with the solution.
Would really appreciate the help!
The user wants a report that shows where a specific Address Number has been used across JDE.
I have come up with the partial solution:
Find the Table using the Cross-Reference Facility based by the data item "AN8" and "SHAN".
Here, I would have the tables such as:
1. F0101
2. F4211
3. etc.
Then I'm stuck!
I want to check that these tables that I have obtained whether the "AN8" or "SHAN" has the Address Book value, exp: AN8 = "4343".
But I can't figure out how to use the fetch using a table name that is "non-static".
The only workaround for me is to pull out all these table, then retrieve it 1 at a time.
By the way, I still need to match the table if the record can be found in that specific table to obtain the Application Name using the Cross-Reference Facility.
Any ideas?
Regards,
Adrian.
Technical Consultant
World, OneWorld
I have a request from the user.
Been cracking my head but still could not come up with the solution.
Would really appreciate the help!
The user wants a report that shows where a specific Address Number has been used across JDE.
I have come up with the partial solution:
Find the Table using the Cross-Reference Facility based by the data item "AN8" and "SHAN".
Here, I would have the tables such as:
1. F0101
2. F4211
3. etc.
Then I'm stuck!
I want to check that these tables that I have obtained whether the "AN8" or "SHAN" has the Address Book value, exp: AN8 = "4343".
But I can't figure out how to use the fetch using a table name that is "non-static".
The only workaround for me is to pull out all these table, then retrieve it 1 at a time.
By the way, I still need to match the table if the record can be found in that specific table to obtain the Application Name using the Cross-Reference Facility.
Any ideas?
Regards,
Adrian.
Technical Consultant
World, OneWorld