JDE: Field Description for Table F43121

libran5635

Member
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
 
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.
 
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
wink.gif
)
 
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.
 
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
;
 
Back
Top