P_WRKCTRAVAILABLECAPINTERVAL

CDS View
8 Fields 3 CDS Views

P_WRKCTRAVAILABLECAPINTERVAL is a CDS View in S/4HANA. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_WorkCenterCapacityInterval view left_outer COMPOSITE WorkCenter Capacity Intervals
P_CapacityInterval view from COMPOSITE
P_WrkCtrMntrSchedInterval view left_outer CONSUMPTION Work Center Intervals

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityType AvailableCapacityType 2
KEY CapacityInternalID CapacityInternalID 1
KEY ValidityEndDate ValidityEndDate 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
ShiftSequence ShiftSequence 1
StdAvailableCapacityIsValid StdAvailableCapacityIsValid 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 P_WRKCTRAVAILABLECAPINTERVAL (
    AVAILABLECAPACITYTYPE,
    CAPACITYINTERNALID,
    VALIDITYENDDATE,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    SHIFTSEQUENCE,
    STDAVAILABLECAPACITYISVALID,
    WORKDAYRULE,
    PRIMARY KEY (AVAILABLECAPACITYTYPE, CAPACITYINTERNALID, VALIDITYENDDATE)
);

Learn More