dluhut
Member
Hello JDE experts,
I'm a complete beginner with JDE, however I have a basic SQL knowledge.
I'm currently using Data Access Studio (DAS) to try and get a general idea of how JDE works. If I understand it correctly using my SQL/database knowledge, I'd assume that there'd be 3 tables in JDE database that's for 'Business Unit', 'Object' and 'Subsidiary'.
Using F0901, I was able to get the a detailed data. i.e. with values only [Business Unit] IN ('ALL', 'OTT') and [Obj Acct] IN ('1520', '1530'), it'll repeat the [Sub] and [Description] as many as the records will show, due to many-to-many relationship.
Now I'm wondering if there's a table that only gives me the distinct value of the [Sub] and [Description]?
Apologies if this is not the thread that I should be asking. If it's isn't, would appreciate if you could direct me to where I should have my questions asked.
Thank you!
I'm a complete beginner with JDE, however I have a basic SQL knowledge.
I'm currently using Data Access Studio (DAS) to try and get a general idea of how JDE works. If I understand it correctly using my SQL/database knowledge, I'd assume that there'd be 3 tables in JDE database that's for 'Business Unit', 'Object' and 'Subsidiary'.
Using F0901, I was able to get the a detailed data. i.e. with values only [Business Unit] IN ('ALL', 'OTT') and [Obj Acct] IN ('1520', '1530'), it'll repeat the [Sub] and [Description] as many as the records will show, due to many-to-many relationship.
Now I'm wondering if there's a table that only gives me the distinct value of the [Sub] and [Description]?
Apologies if this is not the thread that I should be asking. If it's isn't, would appreciate if you could direct me to where I should have my questions asked.
Thank you!