Fields in the SQL table not available on SAP form

[Former Member]

Hi experts,

I've realised that there are some fields in SQL table corresponding to a SAP form but they are not available in the form.

e.g. if one runs the query:

SELECT empID,firstName,lastName, sex, CostCenter, CompanyNum, VacCurYear, VacPreYear
FROM OHEM

you get fields that are not available on the form (e.g. Cost Center, VacCurYear, VacPreYear)!!!!

These fields do not come on the form!!!!!!

How come?!!!

Can some explain to me why this happens?

Thanks in advance!

Kind Regards,

Victor

[jbrotto]

Some fields are for record keeping e.g time. Also other are just the primary key in a table entrynum. There are a few field not active regardless of localization. Depends on demands.

[Former Member]

Hi Victor,

Not all fields are used by all localizations. So that not all fields are available on the form.

Thanks,

Gordon