I_SCHEDCAPACITYRQMTITEMCAP

CDS View
20 Fields 7 CDS Views

Capacity Requirement Item Capacity

I_SCHEDCAPACITYRQMTITEMCAP is a CDS View in S/4HANA. Capacity Requirement Item Capacity. It contains 20 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_SchedProdnGetLogsOrdEndDate view_entity inner COMPOSITE Logistics order End date
I_SchedProdnGetPlndOrdEndDate view_entity inner COMPOSITE Planned order end date
P_EvaltCapWrkCtrCapOperations view_entity inner COMPOSITE Load day opr for manufacturing and planned order for Cap
P_Sched_Past_Operations view_entity inner COMPOSITE Past orders for Deallocate action
P_SchedFirstOperation_Vers_2 view_entity from COMPOSITE First Operations
P_SchedOperations_Version_2 view inner COMPOSITE Schedule Production Operations
P_WorkCenterCapPplineOp view inner COMPOSITE Load day opr for manufacturing and planned order for Cap

Fields (20)

KeyField CDS FieldsUsed in Views
KEY CapacityInternalID CapacityInternalID 3
KEY CapacityRequirement CapacityRequirement 4
KEY CapacityRequirementItem CapacityRequirementItem 4
KEY CapacityRqmtItemCapacity CapacityRqmtItemCapacity 2
KEY Operation Operation 2
KEY WorkCenterInternalID WorkCenterInternalID 1
BillOfOperationsSequence Sequence 2
LtstSchedldProcStrtDte OpLtstSchedldProcgStrtDte 3
LtstSchedldProcStrtTime OpLtstSchedldProcgStrtTme 3
LtstSchedldTrdwnStrtDte OpLtstSchedldTrdwnStrtDte 3
LtstSchedldTrdwnStrtTime OpLtstSchedldTrdwnStrtTme 3
OperationIsPhase OperationIsPhase 2
OperationLatestEndDate OperationLatestEndDate 4
OperationLatestEndTime OperationLatestEndTime 4
OperationLatestStartDate OperationLatestStartDate 4
OperationLatestStartTime OperationLatestStartTime 4
OrderInternalID OrderInternalID 3
OrderObjectInternalID OrderObjectInternalID 1
OrderOperationInternalID OrderOperationInternalID 1
PlannedOrder PlannedOrder 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.

-- Capacity Requirement Item Capacity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SCHEDCAPACITYRQMTITEMCAP (
    CAPACITYINTERNALID,
    CAPACITYREQUIREMENT,
    CAPACITYREQUIREMENTITEM,
    CAPACITYRQMTITEMCAPACITY,
    OPERATION,
    WORKCENTERINTERNALID,
    BILLOFOPERATIONSSEQUENCE,
    LTSTSCHEDLDPROCSTRTDTE,
    LTSTSCHEDLDPROCSTRTTIME,
    LTSTSCHEDLDTRDWNSTRTDTE,
    LTSTSCHEDLDTRDWNSTRTTIME,
    OPERATIONISPHASE,
    OPERATIONLATESTENDDATE,
    OPERATIONLATESTENDTIME,
    OPERATIONLATESTSTARTDATE,
    OPERATIONLATESTSTARTTIME,
    ORDERINTERNALID,
    ORDEROBJECTINTERNALID,
    ORDEROPERATIONINTERNALID,
    PLANNEDORDER,
    PRIMARY KEY (CAPACITYINTERNALID, CAPACITYREQUIREMENT, CAPACITYREQUIREMENTITEM, CAPACITYRQMTITEMCAPACITY, OPERATION, WORKCENTERINTERNALID)
);

Learn More