P_WORKCTRCAPWITHNIGHTSHIFT

CDS View
18 Fields 2 CDS Views

P_WORKCTRCAPWITHNIGHTSHIFT is a CDS View in S/4HANA. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_WrkCtrCapOpWithNights view inner COMPOSITE
P_WrkCtrShiftWithReq view from COMPOSITE

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 2
KEY CapacityActiveVersion CapacityActiveVersion 1
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 1
KEY ValidityBeginDate ValidityBeginDate 1
KEY ValidityEndDate ValidityEndDate 1
KEY WeekDay WeekDay 2
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn 2
CapacityEndTime CapacityEndTime 2
CapacityStartTime CapacityStartTime 2
FactoryCalendar FactoryCalendar 2
NightSplitDate NightSplitDate 2
OperatingDurationInSeconds OperatingDurationInSeconds 2
TotOperatingDurationInSeconds TotOperatingDurationInSeconds 2
WorkCenter WorkCenter 1
WorkDayRule WorkDayRule 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 P_WORKCTRCAPWITHNIGHTSHIFT (
    AVAILABLECAPACITYSHIFT,
    CAPACITYACTIVEVERSION,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    VALIDITYBEGINDATE,
    VALIDITYENDDATE,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    AVAILABLECAPACITYINTERVALDURN,
    CAPACITYENDTIME,
    CAPACITYSTARTTIME,
    FACTORYCALENDAR,
    NIGHTSPLITDATE,
    OPERATINGDURATIONINSECONDS,
    TOTOPERATINGDURATIONINSECONDS,
    WORKCENTER,
    WORKDAYRULE,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, CAPACITYACTIVEVERSION, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, VALIDITYBEGINDATE, VALIDITYENDDATE, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More