_DATE

20 Fields

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

Fields (20)

KeyField CDS FieldsUsed in Views
_CalendarMonth _CalendarMonth 1
_CalendarQuarter _CalendarQuarter 1
_CalendarYear _CalendarYear 1
CalendarMonth CalendarMonth 5
CalendarQuarter CalendarQuarter 5
CalendarWeek CalendarWeek 4
CalendarYear CalendarYear,NotificationCreationYear 8
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
YearMonth CalendarYearMonth 2
YearQuarter CalendarYearQuarter,YearQuarter 3
YearWeek CalendarYearWeek 2

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

Learn More