|
|
SQL Human Resources / Holiday Dates
API HLD1
HLD1 - Holiday Dates Table
Holiday Table OHLD SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | HldCode KEY UNIQUE | Holiday Code | nVarChar | 20 | OHLD Holiday Table | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| StrDate | Start Date | Date | 8 | |||||
| EndDate | End Date | Date | 8 | |||||
| Rmrks | Remarks | nVarChar | 50 |
SELECT statement
SELECT
HLD1.HldCode AS 'Holiday Code',
HLD1.StrDate AS 'Start Date',
HLD1.EndDate AS 'End Date',
HLD1.Rmrks AS 'Remarks'
FROM HLD1 AS HLD1
Related information
Holiday Table OHLD SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
