biuan SAP® BUSINESS ONE SDK
SQL Human Resources / Employees / Savings Payments
DTW Human Resources / Employee Master Data / Savings Payments
API Employees Info / Employee Savings Payment Info
HEM7 - Savings Payments Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee No.Int
11OHEM
Employees		PRIMARYYes
lineRowInt
6
ConNameContract NamenVarChar
50
PmntNotesPayment DetailsnVarChar
50
ANEmployeeNum
20
AGEmployerNum
20
BankNameBank NamenVarChar
50
BankCodeBank CodenVarChar
20
BankAcctBank AccountnVarChar
20
LogInstancLog InstanceInt
11
0
ANCurrencyEmployee CurrencynVarChar
3
AGCurrencyEmployer CurrencynVarChar
3
SequenceFrequencyVarChar
B)
M) Monthly
Q) Quarterly
S) Semi-annually
Y) Yearly
1
M

SELECT statement

SELECT HEM7.empID AS 'Employee No.', HEM7.line AS 'Row', HEM7.ConName AS 'Contract Name', HEM7.PmntNotes AS 'Payment Details', HEM7.AN AS 'Employee', HEM7.AG AS 'Employer', HEM7.BankName AS 'Bank Name', HEM7.BankCode AS 'Bank Code', HEM7.BankAcct AS 'Bank Account', HEM7.LogInstanc AS 'Log Instance', HEM7.ANCurrency AS 'Employee Currency', HEM7.AGCurrency AS 'Employer Currency', HEM7.Sequence AS 'Frequency' FROM HEM7 AS HEM7

Related information


Employee Savings Payment Info EmployeeSavingsPaymentInfo Object· Table: HEM7
A child object of the EmployeesInfo object that represents the employee's capital formation savings payments. Source table: HEM7.
   Parent: Employees Info EmployeesInfo Object· Table: OHEM
Employees OHEM SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates