_SITEOPENINGHOURS

_SITEOPENINGHOURS is an SAP database table in S/4HANA. It contains 31 fields.

Fields (31)

KeyField CDS FieldsUsed in Views
FridayAfternoonClosingTime FridayAfternoonClosingTime 1
FridayAfternoonOpeningTime FridayAfternoonOpeningTime 1
FridayMorningClosingTime FridayMorningClosingTime 1
FridayMorningOpeningTime FridayMorningOpeningTime 1
MondayAfternoonClosingTime MondayAfternoonClosingTime 1
MondayAfternoonOpeningTime MondayAfternoonOpeningTime 1
MondayMorningClosingTime MondayMorningClosingTime 1
MondayMorningOpeningTime MondayMorningOpeningTime 1
SaturdayAfternoonClosingTime SaturdayAfternoonClosingTime 1
SaturdayAfternoonOpeningTime SaturdayAfternoonOpeningTime 1
SaturdayMorningClosingTime SaturdayMorningClosingTime 1
SaturdayMorningOpeningTime SaturdayMorningOpeningTime 1
SiteClosingDate SiteClosingDate 3
SiteGoodsReceivingHoursCode SiteGoodsReceivingHoursCode 2
SiteOpeningDate SiteOpeningDate 3
SundayAfternoonClosingTime SundayAfternoonClosingTime 1
SundayAfternoonOpeningTime SundayAfternoonOpeningTime 1
SundayMorningClosingTime SundayMorningClosingTime 1
SundayMorningOpeningTime SundayMorningOpeningTime 1
ThursdayAfternoonClosingTime ThursdayAfternoonClosingTime 1
ThursdayAfternoonOpeningTime ThursdayAfternoonOpeningTime 1
ThursdayMorningClosingTime ThursdayMorningClosingTime 1
ThursdayMorningOpeningTime ThursdayMorningOpeningTime 1
TuesdayAfternoonClosingTime TuesdayAfternoonClosingTime 1
TuesdayAfternoonOpeningTime TuesdayAfternoonOpeningTime 1
TuesdayMorningClosingTime TuesdayMorningClosingTime 1
TuesdayMorningOpeningTime TuesdayMorningOpeningTime 1
WednesdayAfternoonClosingTime WednesdayAfternoonClosingTime 1
WednesdayAfternoonOpeningTime WednesdayAfternoonOpeningTime 1
WednesdayMorningClosingTime WednesdayMorningClosingTime 1
WednesdayMorningOpeningTime WednesdayMorningOpeningTime 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 _SITEOPENINGHOURS (
    FRIDAYAFTERNOONCLOSINGTIME,
    FRIDAYAFTERNOONOPENINGTIME,
    FRIDAYMORNINGCLOSINGTIME,
    FRIDAYMORNINGOPENINGTIME,
    MONDAYAFTERNOONCLOSINGTIME,
    MONDAYAFTERNOONOPENINGTIME,
    MONDAYMORNINGCLOSINGTIME,
    MONDAYMORNINGOPENINGTIME,
    SATURDAYAFTERNOONCLOSINGTIME,
    SATURDAYAFTERNOONOPENINGTIME,
    SATURDAYMORNINGCLOSINGTIME,
    SATURDAYMORNINGOPENINGTIME,
    SITECLOSINGDATE,
    SITEGOODSRECEIVINGHOURSCODE,
    SITEOPENINGDATE,
    SUNDAYAFTERNOONCLOSINGTIME,
    SUNDAYAFTERNOONOPENINGTIME,
    SUNDAYMORNINGCLOSINGTIME,
    SUNDAYMORNINGOPENINGTIME,
    THURSDAYAFTERNOONCLOSINGTIME,
    THURSDAYAFTERNOONOPENINGTIME,
    THURSDAYMORNINGCLOSINGTIME,
    THURSDAYMORNINGOPENINGTIME,
    TUESDAYAFTERNOONCLOSINGTIME,
    TUESDAYAFTERNOONOPENINGTIME,
    TUESDAYMORNINGCLOSINGTIME,
    TUESDAYMORNINGOPENINGTIME,
    WEDNESDAYAFTERNOONCLOSINGTIME,
    WEDNESDAYAFTERNOONOPENINGTIME,
    WEDNESDAYMORNINGCLOSINGTIME,
    WEDNESDAYMORNINGOPENINGTIME
);