| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Human Resources / Employee Master Data / Savings Payments API Employees Info / Employee Savings Payment Info | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HEM7 - Savings Payments Table SBO SQL database table details
SELECT statementSELECT
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 informationEmployee 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. ![]() 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 |