AVAILABILITY

9 Fields

AVAILABILITY is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY EmploymentInternalID EmploymentInternalID 1
AbsenceInHours AbsenceInHours 2
CalendarDate CalendarDate 1
EmployeeAvailableHours EmployeeAvailableHours 1
EmployeeFreeHours TotalEmployeeFreeHours 1
EmployeeStaffedHours EmployeeStaffedHours 1
IsNonWorkingDay IsNonWorkingDay 1
PlannedWorkingHours PlannedWorkingHours 1
PublicHolidayClass PublicHolidayClass 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AVAILABILITY (
    EMPLOYMENTINTERNALID,
    ABSENCEINHOURS,
    CALENDARDATE,
    EMPLOYEEAVAILABLEHOURS,
    EMPLOYEEFREEHOURS,
    EMPLOYEESTAFFEDHOURS,
    ISNONWORKINGDAY,
    PLANNEDWORKINGHOURS,
    PUBLICHOLIDAYCLASS,
    PRIMARY KEY (EMPLOYMENTINTERNALID)
);

Learn More