_CAPACITY

22 Fields

_CAPACITY is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
KEY YearMonth YearMonth 1
Capacity Capacity 3
CapacityActiveVersion CapacityActiveVersion 1
CapacityBreakDuration CapacityBreakDuration 1
CapacityCategoryCode CapacityCategoryCode 4
CapacityEndTime CapacityEndTime 1
CapacityInternalID CapacityInternalID 1
CapacityIsFinite CapacityIsFinite 1
CapacityIsPooled CapacityIsPooled 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
CapacityQuantityUnit CapacityQuantityUnit 1
CapacityResponsiblePlanner CapacityResponsiblePlanner 3
CapacityStartTime CapacityStartTime 1
EmployeeAvailableHours EmployeeAvailableHours 1
EmployeeStaffedHours EmployeeStaffedHours 1
FactoryCalendar FactoryCalendar 1
MonthlyUtilPercentage EmployeeUtilization 1
RsceStorageQuantityUnit RsceStorageQuantityUnit 1
ShiftGroup ShiftGroup 2
ValidityEndDate CapacityEndDate 1
ValidityStartDate CapacityStartDate 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 _CAPACITY (
    YEARMONTH,
    CAPACITY,
    CAPACITYACTIVEVERSION,
    CAPACITYBREAKDURATION,
    CAPACITYCATEGORYCODE,
    CAPACITYENDTIME,
    CAPACITYINTERNALID,
    CAPACITYISFINITE,
    CAPACITYISPOOLED,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    CAPACITYQUANTITYUNIT,
    CAPACITYRESPONSIBLEPLANNER,
    CAPACITYSTARTTIME,
    EMPLOYEEAVAILABLEHOURS,
    EMPLOYEESTAFFEDHOURS,
    FACTORYCALENDAR,
    MONTHLYUTILPERCENTAGE,
    RSCESTORAGEQUANTITYUNIT,
    SHIFTGROUP,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (YEARMONTH)
);

Learn More