_CALCDFIELD

_CALCDFIELD is an SAP database table in S/4HANA. It contains 39 fields.

Fields (39)

KeyField CDS FieldsUsed in Views
BaseUnit BaseUnit 1
CapacityEvaluationHorizonDate CapacityEvaluationHorizonDate,CapEvalStartDate 2
CapacityEvaluationOverdueDate CapacityEvaluationOverdueDate 1
CapacityEvaluationTimePeriod CapacityEvaluationTimePeriod 1
CapacityRequirementOrigin CapacityRequirementOrigin 2
CapEvalBucketType CapEvalBucketType 2
CapEvalStartDate CapEvalStartDate 2
Criticality Criticality 1
CurrentPlantDate CurrentPlantDate 2
HorizonEndDate HorizonEndDate 2
HorizonStartDate HorizonStartDate 2
OperationPlanningStatusCode OperationPlanningStatusCode 2
OrderStatusCode OrderStatusCode 2
PlantName PlantName 1
WorkCenterAvailableCapacity WorkCenterAvailableCapacity 2
WorkCenterAvgUtilznCriticality WorkCenterAvgUtilznCriticality 1
WorkCenterAvgUtilznInTimePerd WorkCenterAvgUtilznInTimePerd 1
WorkCenterCapacityBacklogInHrs WorkCenterCapacityBacklogInHrs 1
WorkCenterCapacityRequirement WorkCenterCapacityRequirement 1
WorkCenterCapacityUnit WorkCenterCapacityUnit 2
WorkCenterCapFirstCritlLoadDte WorkCenterCapFirstCritlLoadDte 1
WorkCenterCapFirstCritlLoadWk WorkCenterCapFirstCritlLoadWk 1
WorkCenterCapFirstOverLoadDte WorkCenterCapFirstOverLoadDte 1
WorkCenterCapFirstOverloadWk WorkCenterCapFirstOverloadWk 1
WorkCenterCapUnitText WorkCenterCapUnitText 1
WorkCenterCumltvLoadInHours WorkCenterCumltvLoadInHours 1
WorkCenterCumltvLoadInTmePerd WorkCenterCumltvLoadInTmePerd 2
WorkCenterEvaluationHorizon WorkCenterEvaluationHorizon 2
WorkCenterFltrCodeInTmePerd WorkCenterFltrCodeInTmePerd 1
WorkCenterGroup WorkCenterGroup 1
WorkCenterGroupDescription WorkCenterGroupDescription 1
WorkCenterGroupType WorkCenterGroupType 1
WorkCenterMaxUtilznInTimePerd WorkCenterMaxUtilznInTimePerd 1
WorkCenterMinUtilznInTmePeriod WorkCenterMinUtilznInTmePeriod 1
WorkCenterTotAvailCapInTmePerd WorkCenterTotAvailCapInTmePerd 1
WorkCenterTotCapInTimePeriod WorkCenterTotCapInTimePeriod 1
WorkCenterTotUtilznInTmePerd WorkCenterTotUtilznInTmePerd 1
WrkCtrIsUndrMaintInTmePerd WrkCtrIsUndrMaintInTmePerd 1
WrkCtrMaintOrdAvailabilityTxt WrkCtrMaintOrdAvailabilityTxt 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 _CALCDFIELD (
    BASEUNIT,
    CAPACITYEVALUATIONHORIZONDATE,
    CAPACITYEVALUATIONOVERDUEDATE,
    CAPACITYEVALUATIONTIMEPERIOD,
    CAPACITYREQUIREMENTORIGIN,
    CAPEVALBUCKETTYPE,
    CAPEVALSTARTDATE,
    CRITICALITY,
    CURRENTPLANTDATE,
    HORIZONENDDATE,
    HORIZONSTARTDATE,
    OPERATIONPLANNINGSTATUSCODE,
    ORDERSTATUSCODE,
    PLANTNAME,
    WORKCENTERAVAILABLECAPACITY,
    WORKCENTERAVGUTILZNCRITICALITY,
    WORKCENTERAVGUTILZNINTIMEPERD,
    WORKCENTERCAPACITYBACKLOGINHRS,
    WORKCENTERCAPACITYREQUIREMENT,
    WORKCENTERCAPACITYUNIT,
    WORKCENTERCAPFIRSTCRITLLOADDTE,
    WORKCENTERCAPFIRSTCRITLLOADWK,
    WORKCENTERCAPFIRSTOVERLOADDTE,
    WORKCENTERCAPFIRSTOVERLOADWK,
    WORKCENTERCAPUNITTEXT,
    WORKCENTERCUMLTVLOADINHOURS,
    WORKCENTERCUMLTVLOADINTMEPERD,
    WORKCENTEREVALUATIONHORIZON,
    WORKCENTERFLTRCODEINTMEPERD,
    WORKCENTERGROUP,
    WORKCENTERGROUPDESCRIPTION,
    WORKCENTERGROUPTYPE,
    WORKCENTERMAXUTILZNINTIMEPERD,
    WORKCENTERMINUTILZNINTMEPERIOD,
    WORKCENTERTOTAVAILCAPINTMEPERD,
    WORKCENTERTOTCAPINTIMEPERIOD,
    WORKCENTERTOTUTILZNINTMEPERD,
    WRKCTRISUNDRMAINTINTMEPERD,
    WRKCTRMAINTORDAVAILABILITYTXT
);