Fields (39)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA