• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

JDE: Field Description for Table F43121

Dear Experts,

We are new to JDE Application, and need to know the description of all the Fields in Table F43121. Request you help us.

Regards
libran
 

eydeak

Reputable Poster
Open the table in design and do a print preview. It gives a nice listing with the Description, Type, Alias and Data Item as well as the indexes.
 

czarcasm

Active Member
You can also use Patwel's Object Browser for this purpose. It will allow you to batch export the various tables you wish to see. Another option is to head over to jdetables.com (I am not promoting this link, just stating its existence
)
 

CDsouza

Member
There is also an indirect way of getting this information if you do not have access to a development client. Prerequisite for this is that the XREF tables are up-to-date.

1) Open Application P980011 (or XREF) from fast path
2) Select the tab 'Tables' and then click on 'Data Items Used by a Table'
4) Enter the table name and click on FIND

You may export the data to a spreadsheet and then sort based on key sequence.
 

David Robertson

Reputable Poster
Try this:
SELECT TRIM(SIOBNM) AS Table_Name
, TRIM(SIMD) AS Table_Description
, TDPSEQ AS Ordinal_Position
, TRIM(TDSQLC) AS Column_Name
, (SELECT TRIM(FRDSCR) from DD910.F9202 WHERE FRDTAI=TDOBND AND FRLNGP=' ' and FRSYR=' ') AS JDE_Description
FROM OL910.F9860
LEFT OUTER JOIN PD910.F98711 ON TDOBNM=SIOBNM
WHERE SIOBNM='F43121'
ORDER BY SIOBNM, TDPSEQ
;
 
Top