CAPRQMTITMCAP

16 Fields

CAPRQMTITMCAP is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
KEY CapacityRequirementItem CapacityRequirementItem 2
KEY CapacityRqmtItemCapacity CapacityRqmtItemCapacity 2
KEY OrderCategory OrderCategory 1
KEY OrderID OrderID 1
IndustryType IndustryType 1
LastChangeDateTime LastChangeDateTime 1
LiveCacheActivityID LiveCacheActivityID 1
LiveCacheOrderID LiveCacheOrderID 1
LiveCachePlannedStatus LiveCachePlannedStatus 1
OperationIsPhase OperationIsPhase 1
OperationLatestEndDate OperationLatestEndDate,OriginallyScheduledEndDate 1
OperationLatestStartDate OperationLatestStartDate,OriginallyScheduledStartDate 1
OrderInternalID OrderInternalID 1
OrderOperationInternalID OrderOperationInternalID 1
SuperiorOperationInternalID SuperiorOperationInternalID 1
SupOperation SupOperation 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 CAPRQMTITMCAP (
    CAPACITYREQUIREMENTITEM,
    CAPACITYRQMTITEMCAPACITY,
    ORDERCATEGORY,
    ORDERID,
    INDUSTRYTYPE,
    LASTCHANGEDATETIME,
    LIVECACHEACTIVITYID,
    LIVECACHEORDERID,
    LIVECACHEPLANNEDSTATUS,
    OPERATIONISPHASE,
    OPERATIONLATESTENDDATE,
    OPERATIONLATESTSTARTDATE,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    SUPERIOROPERATIONINTERNALID,
    SUPOPERATION,
    PRIMARY KEY (CAPACITYREQUIREMENTITEM, CAPACITYRQMTITEMCAPACITY, ORDERCATEGORY, ORDERID)
);

Learn More