_NOTIFICATION

_NOTIFICATION is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
_Plant _Plant 1
_Product _Product 1
Batch Batch 1
Customer Customer 1
InspectionLot InspectionLot 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 4
MainWorkCenterInternalID MainWorkCenterInternalID 1
MAINWORKCENTERPLANT MAINWORKCENTERPLANT 2
MATERIAL MATERIAL 4
MATERIALGROUP MATERIALGROUP 1
NOTIFICATIONORIGIN NOTIFICATIONORIGIN 1
NotificationReportingDate NotificationReportingDate 1
NotificationRequiredEndDate NotificationRequiredEndDate 1
NotificationRequiredStartDate NotificationRequiredStartDate 1
NotificationText MaintenanceNotificationText 1
NotificationType NotificationType 4
NotifProcessingPhase NotifProcessingPhase 2
Plant Plant 5
SitnDefPageVariantID SitnDefPageVariantID 2
Supplier Supplier 1
WorkCenterTypeCode WorkCenterTypeCode 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 _NOTIFICATION (
    _PLANT,
    _PRODUCT,
    BATCH,
    CUSTOMER,
    INSPECTIONLOT,
    ISBUSINESSPURPOSECOMPLETED,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MATERIAL,
    MATERIALGROUP,
    NOTIFICATIONORIGIN,
    NOTIFICATIONREPORTINGDATE,
    NOTIFICATIONREQUIREDENDDATE,
    NOTIFICATIONREQUIREDSTARTDATE,
    NOTIFICATIONTEXT,
    NOTIFICATIONTYPE,
    NOTIFPROCESSINGPHASE,
    PLANT,
    SITNDEFPAGEVARIANTID,
    SUPPLIER,
    WORKCENTERTYPECODE
);