CAPREQ

42 Fields

CAPREQ is an SAP database table in S/4HANA. It contains 42 fields.

Fields (42)

KeyField CDS FieldsUsed in Views
KEY CapacityRequirement CapacityRequirement 2
KEY CapacityRequirementItem CapacityRequirementItem 2
_Capacity _Capacity 2
_CapacityRequirement _CapacityRequirement 2
_CapacityRequirementConf _CapacityRequirementConf 2
_CapacityRequirementItem _CapacityRequirementItem 2
_StatusObject _StatusObject 1
_UnitOfMeasure _UnitOfMeasure 2
ActualEndDate ActualEndDate 2
ActualEndTime ActualEndTime 2
ActualNumberOfSplits ActualNumberOfSplits 1
ActualStartDate ActualStartDate 2
ActualStartTime ActualStartTime 2
CapacityInternalID CapacityInternalID 2
CapacityRequirementDistrKey CapacityRequirementDistrKey 2
CapacityRequirementSplit CapacityRequirementSplit 1
CapacityRequirementUnit CapacityRequirementUnit 2
CapacityRqmtConfirmation CapacityRqmtConfirmation 2
ErlstSchedldProcStrtDte ErlstSchedldProcStrtDte 2
ErlstSchedldProcStrtTime ErlstSchedldProcStrtTime 2
ErlstSchedldTrdwnStrtDte ErlstSchedldTrdwnStrtDte 2
ErlstSchedldTrdwnStrtTime ErlstSchedldTrdwnStrtTime 2
LtstSchedldProcStrtDte LtstSchedldProcStrtDte 2
LtstSchedldProcStrtTime LtstSchedldProcStrtTime 2
LtstSchedldTrdwnStrtDte LtstSchedldTrdwnStrtDte 2
LtstSchedldTrdwnStrtTime LtstSchedldTrdwnStrtTime 2
ObjectInternalID ObjectInternalID 1
OperationEarliestEndDate OperationEarliestEndDate 2
OperationEarliestEndTime OperationEarliestEndTime 2
OperationEarliestStartDate OperationEarliestStartDate 2
OperationEarliestStartTime OperationEarliestStartTime 2
OperationLatestEndDate OperationLatestEndDate 2
OperationLatestEndTime OperationLatestEndTime 2
OperationLatestStartDate OperationLatestStartDate 2
OperationLatestStartTime OperationLatestStartTime 2
RemainingCapReqOpSegProcgDurn RemainingCapReqOpSegProcgDurn 2
RemainingCapReqOpSegSetupDurn RemainingCapReqOpSegSetupDurn 1
RemainingCapReqOpSegTrdwnDurn RemainingCapReqOpSegTrdwnDurn 1
ScheduledCapReqOpSegProcgDurn ScheduledCapReqOpSegProcgDurn 2
ScheduledCapReqOpSegSetupDurn ScheduledCapReqOpSegSetupDurn 1
ScheduledCapReqOpSegTrdwnDurn ScheduledCapReqOpSegTrdwnDurn 1
SuperiorOperationInternalID SuperiorOperationInternalID 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 CAPREQ (
    CAPACITYREQUIREMENT,
    CAPACITYREQUIREMENTITEM,
    _CAPACITY,
    _CAPACITYREQUIREMENT,
    _CAPACITYREQUIREMENTCONF,
    _CAPACITYREQUIREMENTITEM,
    _STATUSOBJECT,
    _UNITOFMEASURE,
    ACTUALENDDATE,
    ACTUALENDTIME,
    ACTUALNUMBEROFSPLITS,
    ACTUALSTARTDATE,
    ACTUALSTARTTIME,
    CAPACITYINTERNALID,
    CAPACITYREQUIREMENTDISTRKEY,
    CAPACITYREQUIREMENTSPLIT,
    CAPACITYREQUIREMENTUNIT,
    CAPACITYRQMTCONFIRMATION,
    ERLSTSCHEDLDPROCSTRTDTE,
    ERLSTSCHEDLDPROCSTRTTIME,
    ERLSTSCHEDLDTRDWNSTRTDTE,
    ERLSTSCHEDLDTRDWNSTRTTIME,
    LTSTSCHEDLDPROCSTRTDTE,
    LTSTSCHEDLDPROCSTRTTIME,
    LTSTSCHEDLDTRDWNSTRTDTE,
    LTSTSCHEDLDTRDWNSTRTTIME,
    OBJECTINTERNALID,
    OPERATIONEARLIESTENDDATE,
    OPERATIONEARLIESTENDTIME,
    OPERATIONEARLIESTSTARTDATE,
    OPERATIONEARLIESTSTARTTIME,
    OPERATIONLATESTENDDATE,
    OPERATIONLATESTENDTIME,
    OPERATIONLATESTSTARTDATE,
    OPERATIONLATESTSTARTTIME,
    REMAININGCAPREQOPSEGPROCGDURN,
    REMAININGCAPREQOPSEGSETUPDURN,
    REMAININGCAPREQOPSEGTRDWNDURN,
    SCHEDULEDCAPREQOPSEGPROCGDURN,
    SCHEDULEDCAPREQOPSEGSETUPDURN,
    SCHEDULEDCAPREQOPSEGTRDWNDURN,
    SUPERIOROPERATIONINTERNALID,
    PRIMARY KEY (CAPACITYREQUIREMENT, CAPACITYREQUIREMENTITEM)
);

Learn More