_DATE

25 Fields

_DATE is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyUUID InsurPlcyUUID 1
_CalendarMonth _CalendarMonth 1
_CalendarQuarter _CalendarQuarter 1
_CalendarYear _CalendarYear 1
CalendarDate CalendarDate 2
CalendarDay CalendarDay 2
CalendarMonth CalendarMonth 7
CalendarQuarter CalendarQuarter 7
CalendarWeek CalendarWeek 6
CalendarYear CalendarYear,CalYear,NotificationCreationYear 11
content_short PaymentRunDate 1
DeliveryDataDeterminationInd DeliveryDataDeterminationInd 1
DeliveryDateTimeCategory DeliveryDateTimeCategory 1
DeliveryDateTimeType DeliveryDateTimeType 1
DeliveryDocumentCategory DeliveryDocumentCategory 1
DeliveryOrderItemUUID DeliveryOrderItemUUID 1
DeliveryRelatedEndDateTime DeliveryRelatedEndDateTime 1
DeliveryScheduleLineUUID DeliveryScheduleLineUUID 1
InsurClmCoverageTypeName InsurClmCoverageTypeName 1
TimeZoneName TimeZoneName 1
WeekDay WeekDay 2
YearDay YearDay 2
YearMonth CalendarYearMonth,CalMonth,YearMonth 5
YearQuarter CalendarYearQuarter,CalQuarter,YearQuarter 6
YearWeek CalendarYearWeek,CalWeek,YearWeek 5

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 _DATE (
    INSURPLCYUUID,
    _CALENDARMONTH,
    _CALENDARQUARTER,
    _CALENDARYEAR,
    CALENDARDATE,
    CALENDARDAY,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    CONTENT_SHORT,
    DELIVERYDATADETERMINATIONIND,
    DELIVERYDATETIMECATEGORY,
    DELIVERYDATETIMETYPE,
    DELIVERYDOCUMENTCATEGORY,
    DELIVERYORDERITEMUUID,
    DELIVERYRELATEDENDDATETIME,
    DELIVERYSCHEDULELINEUUID,
    INSURCLMCOVERAGETYPENAME,
    TIMEZONENAME,
    WEEKDAY,
    YEARDAY,
    YEARMONTH,
    YEARQUARTER,
    YEARWEEK,
    PRIMARY KEY (INSURPLCYUUID)
);

Learn More