Explain the difference between Translate & Prompt tables. What are the occasions when to use Translate values instead of Prompt table? What is the advantage of one over the other?
Translate tables (XLAT table) used for drop down of short values on the page ex: Status - A/I (Active/Inactive)
Condition for translate filed should be Character of lenght of 4
Prompt tables are used on the page for more number of values ex: STATE field on the page (more than 30)
No limitation on the field length.useful to validate values from other tables
Both are advantages and it depends on the requirement.
Please refer peoplebooks for more information