How to relate F0005 table with other table to fetch the code description?

YuvaR86

Member
Hi All,
From ItemMaster (F4101) I need to fetch the Description for a code value which is stored in control table (F0005).
Can anyone help me out how are these two tables related?
 
Personally, I'd call X0005 or XS0005 passing the SY and RT that are related to the data item that you want to get the description for.

If you're not a fan of using the JDE code, you could chain to the F0005 record,
using SY, RT and the value that you are trying to get the description of.
You need to right justify that value into the 10 character KY.
 
He is right. Just want to give you sampel JDE

CLEARI0005U
MOVELS@XX #USY
MOVELR@XX #URT
MOVE IMXX #UKY
CALL 'X0005 ' 81
---- --------
PARM I0005U
#UERR IFNE '1'
CLEAR@UA
MOVEA#UDL01 @UA
Z-ADD25 #OUTLG
EXSR C9822
---- -----
MOVEA@UB VC0001

XX is your Data Item. Good Luck
 
Back
Top