HEADER_W_END

HEADER_W_END is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY CapacityInternalID CapacityInternalID 1
KEY ValidityEndDate ValidityEndDate 1
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn 1
AvailableCapacityType AvailableCapacityType 1
CapacityActiveVersion CapacityActiveVersion 1
CapacityBreakDuration CapacityBreakDuration 1
CapacityEndTime CapacityEndTime 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
CapacityStartTime CapacityStartTime 1
FactoryCalendar FactoryCalendar 1
HeaderValidityBeginDate HeaderValidityBeginDate 1
HeaderValidityEndDate HeaderValidityEndDate 1
IntervalValidityEndDate IntervalValidityEndDate 1
OperatingDurationInSeconds OperatingDurationInSeconds 1
Plant Plant 1
ShiftGroup ShiftGroup 1
StdAvailableCapacityIsValid StdAvailableCapacityIsValid 1
TotOperatingDurationInSeconds TotOperatingDurationInSeconds 1
WorkCenter WorkCenter 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 1
WorkDayRule WorkDayRule 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 HEADER_W_END (
    CAPACITYINTERNALID,
    VALIDITYENDDATE,
    AVAILABLECAPACITYINTERVALDURN,
    AVAILABLECAPACITYTYPE,
    CAPACITYACTIVEVERSION,
    CAPACITYBREAKDURATION,
    CAPACITYENDTIME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    CAPACITYSTARTTIME,
    FACTORYCALENDAR,
    HEADERVALIDITYBEGINDATE,
    HEADERVALIDITYENDDATE,
    INTERVALVALIDITYENDDATE,
    OPERATINGDURATIONINSECONDS,
    PLANT,
    SHIFTGROUP,
    STDAVAILABLECAPACITYISVALID,
    TOTOPERATINGDURATIONINSECONDS,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    WORKDAYRULE,
    PRIMARY KEY (CAPACITYINTERNALID, VALIDITYENDDATE)
);