To include a language independent descriptions in your grid you can call database function r5o7.o7get_desc on Oracle and dbo.r5o7_o7get_desc on SQL Server. The function requires the following inputs:
-
Language code
-
Entity code
-
Primary key of record
-
System Codes – Code for the Status, Type or Codes Entity
-
You can leave this field blank.
Some examples:
-
WO description: r5o7.o7get_desc(:parameter.language,'EVNT',evt_code,'','')
-
Object description: r5o7.o7get_desc(:parameter.language,'OBJ',obj_code||'#'||obj_org,'','')
-
WO status: r5o7.o7get_desc(:parameter.language,'UCOD',evt_status,'EVST','')
-
WO priority: r5o7.o7get_desc(:parameter.language,'UCOD',evt_priority,'JBPR','')
-
Trade: r5o7.o7get_desc(:parameter.language,'TRAD',act_trade,'','')
-
In SQL Server use null instead of ''.