I_WRKCTRCAPSHIFTINTERVALTP

CDS View
16 Fields 1 CDS Views

Work Center Shift Interval

I_WRKCTRCAPSHIFTINTERVALTP is a CDS View in S/4HANA. Work Center Shift Interval. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_WrkCtrCapShiftIntervalTP view from CONSUMPTION Work Center Shift Interval : Consumption

Fields (16)

KeyField CDS FieldsUsed in Views
KEY CapacityActiveVersion CapacityActiveVersion 1
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 1
KEY ValidityEndDate ValidityEndDate 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
IntervalStatusCode IntervalStatusCode 1
IntervalStatusText IntervalStatusText 1
ShiftSequence ShiftSequence 1
StdAvailableCapacityIsValid StdAvailableCapacityIsValid 1
ValidityBeginDate ValidityBeginDate 1
ValidityEndDateForEdit ValidityEndDateForEdit 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.

-- Work Center Shift Interval
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WRKCTRCAPSHIFTINTERVALTP (
    CAPACITYACTIVEVERSION,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    VALIDITYENDDATE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    AVAILABLECAPACITYINTERVALDURN,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    INTERVALSTATUSCODE,
    INTERVALSTATUSTEXT,
    SHIFTSEQUENCE,
    STDAVAILABLECAPACITYISVALID,
    VALIDITYBEGINDATE,
    VALIDITYENDDATEFOREDIT,
    WORKDAYRULE,
    PRIMARY KEY (CAPACITYACTIVEVERSION, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, VALIDITYENDDATE, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More