Fields (44)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| AdjustmentType | AdjustmentType | 1 | |
| AverageDailyUsage | ProposedAverageDailyUsage | 1 | |
| AverageDailyUsageMode | AverageDailyUsageMode | 1 | |
| AverageDailyUsageModeDesc | AverageDailyUsageModeDesc | 1 | |
| AvgDailyUsageDeviationRate | AvgDailyUsageDeviationRate | 1 | |
| BOMExplosionDate | BOMExplosionDate | 1 | |
| BOMUsageCode | BOMUsageCode | 1 | |
| ConsumptionCode | ConsumptionCode | 1 | |
| DecoupledLeadTime | ProposedLeadTime | 1 | |
| HorizonDaysInFuture | HorizonDaysInFuture | 1 | |
| HorizonDaysInPast | HorizonDaysInPast | 1 | |
| IsInProcess | IsInProcess | 1 | |
| IsMinOrderQtyConsidered | IsMinOrderQtyConsidered | 1 | |
| IsProposalAdopted | IsProposalAdopted | 1 | |
| LeadTimeDeviationRate | LeadTimeDeviationRate | 1 | |
| LeadTimeDifference | LeadTimeDifference | 1 | |
| MaterialMaxStockLevelQuantity | MaterialMaxStockLevelQuantity,MatlCurrentMaxStock | 1 | |
| MatlProposedMaxStock | MatlProposedMaxStock | 1 | |
| MatlPrpslAdjmtFctrIsApplied | MatlPrpslAdjmtFctrIsApplied | 1 | |
| MaxStockDeviationRate | MaxStockDeviationRate | 1 | |
| MaxStockDifference | MaxStockDifference | 2 | |
| MinOrderQuantityHasChanged | MinOrderQuantityHasChanged | 1 | |
| MRPGroup | MRPGroup | 1 | |
| NormalizedCurrentGreenZone | NormalizedCurrentGreenZone | 1 | |
| NormalizedCurrentRedZone | NormalizedCurrentRedZone | 1 | |
| NormalizedCurrentYellowZone | NormalizedCurrentYellowZone | 1 | |
| NormalizedProposedGreenZone | NormalizedProposedGreenZone | 1 | |
| NormalizedProposedRedZone | NormalizedProposedRedZone | 1 | |
| NormalizedProposedYellowZone | NormalizedProposedYellowZone | 1 | |
| ProcurementType | ProcurementType | 1 | |
| ProductProfileChangeCategory | ProductProfileChangeCategory | 1 | |
| ProductProfileHasChanged | ProductProfileHasChanged | 1 | |
| ProposalMode | ProposalMode | 1 | |
| ProposalRunIsNotSuspended | ProposalRunIsNotSuspended | 1 | |
| ProposalRunIsSuspended | ProposalRunIsSuspended | 1 | |
| ProposalStatusChangeDate | ProposalStatusChangeDate | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| ReplenishmentLeadTimeCode | ReplenishmentLeadTimeCode | 1 | |
| ReplenishmentLeadTimeValue | ReplenishmentLeadTimeValue | 1 | |
| VariabilityCode | VariabilityCode | 1 | |
| VariabilityFactor | ProposedVariabilityFactor | 1 | |
| VariabilityFactorDeviationRate | VariabilityFactorDeviationRate | 1 | |
| VariabilityFactorDifference | VariabilityFactorDifference | 1 | |
| VariabilityQuantity | VariabilityQuantity | 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 _CALCFIELDS (
ADJUSTMENTTYPE,
AVERAGEDAILYUSAGE,
AVERAGEDAILYUSAGEMODE,
AVERAGEDAILYUSAGEMODEDESC,
AVGDAILYUSAGEDEVIATIONRATE,
BOMEXPLOSIONDATE,
BOMUSAGECODE,
CONSUMPTIONCODE,
DECOUPLEDLEADTIME,
HORIZONDAYSINFUTURE,
HORIZONDAYSINPAST,
ISINPROCESS,
ISMINORDERQTYCONSIDERED,
ISPROPOSALADOPTED,
LEADTIMEDEVIATIONRATE,
LEADTIMEDIFFERENCE,
MATERIALMAXSTOCKLEVELQUANTITY,
MATLPROPOSEDMAXSTOCK,
MATLPRPSLADJMTFCTRISAPPLIED,
MAXSTOCKDEVIATIONRATE,
MAXSTOCKDIFFERENCE,
MINORDERQUANTITYHASCHANGED,
MRPGROUP,
NORMALIZEDCURRENTGREENZONE,
NORMALIZEDCURRENTREDZONE,
NORMALIZEDCURRENTYELLOWZONE,
NORMALIZEDPROPOSEDGREENZONE,
NORMALIZEDPROPOSEDREDZONE,
NORMALIZEDPROPOSEDYELLOWZONE,
PROCUREMENTTYPE,
PRODUCTPROFILECHANGECATEGORY,
PRODUCTPROFILEHASCHANGED,
PROPOSALMODE,
PROPOSALRUNISNOTSUSPENDED,
PROPOSALRUNISSUSPENDED,
PROPOSALSTATUSCHANGEDATE,
PURCHASINGGROUP,
REPLENISHMENTLEADTIMECODE,
REPLENISHMENTLEADTIMEVALUE,
VARIABILITYCODE,
VARIABILITYFACTOR,
VARIABILITYFACTORDEVIATIONRATE,
VARIABILITYFACTORDIFFERENCE,
VARIABILITYQUANTITY
);
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